Question

QUESTION 1

Consider the following revenue and cost data for Shannon’s Brewery in Keller, Texas. Shannon’s sells 35% of its craft beer production through its own on-premise taproom. The bulk of its sales (65%) are made off-premise via various retail outlets including supermarkets, bars, and restaurants. 40% of its of sales (on-premise and off-premise) consists of package sales (bottles and cans). Of this 40%, beer sold in cans accounts for 80% with sales of bottled beer accounting for the remaining 20%. Finally, the bulk of Shannon’s craft beer sales (60%) occurs in kegs (31 gallons per keg).

The costs incurred by Shannon’s for producing and selling its craft beers are as follows:

Beer sold in kegs. Includes the direct costs of ingredients and packaging.

Beer sold in bottles and cans. Includes the direct costs of ingredients and packaging.

Shrinkage and WIP loss. Losses from theft, damage, deterioration.

Direct Labor. Hourly labor costs for production and brew house operations.

Contract Labor. Hourly costs of contract labor hired during periods of peak demand.

Shipping. Shipping and handling costs to the wholesaler.

Consumer Advertising. Advertising in local cable TV and print media.

Digital Media Promotion. Costs of promotion in social media and website maintenance.

Sales Promotion. Brochures, give-away items (specialty items), gifts not considered to be volume sensitive.

Salaries and Benefits.  Cost of management salaries, retirement, and healthcare benefits.

For each cost listed below from the above discussion, identify whether that cost is fixed or variable in nature.

-       A.       B.	Beer in kegs.
-       A.       B.	Beer in bottles and cans.
-       A.       B.	Shrinkage and WIP.
-       A.       B.	Direct Labor.
-       A.       B.	Contract Labor.
-       A.       B.	Shipping.
-       A.       B.	Consumer Advertising.
-       A.       B.	Digital Media Promotion.
-       A.       B.	Sales Promotion.,
-       A.       B.	Salaries & Benefits.

A.	Variable
B.	Fixed.

5 points   

QUESTION 2

Consider the following revenue and cost data for Shannon’s Brewery in Keller, Texas. Shannon’s sells 35% of its craft beer production through its own on-premise taproom. The bulk of its sales (65%) are made off-premise via various retail outlets including supermarkets, bars, and restaurants. 40% of its of sales (on-premise and off-premise) consists of package sales (bottles and cans). Of this 40%, beer sold in cans accounts for 80% with sales of bottled beer accounting for the remaining 20%. Finally, the bulk of Shannon’s craft beer sales (60%) occurs in kegs (31 gallons per keg). Assume that overall sales for FY 2015 are expected to be $1,045,518. Given the proportions of beer sold in kegs, bottles, and cans, what will be the predicted dollar sales of beer sold in kegs?

5 points   

QUESTION 3

Assume the following costs in each of the categories identified in question one are:

Packaged (Cans & Bottles)	$143,906
Kegs	$74,010
Shrinkage/WIP Loss	$42,000
Contract Labor	$9,000
Direct Labor	$240,000
Freight	$18,000
Consumer Advertising	$30,000
Trade Promotion	$30,000
Sales Promotion	$18,000
Salaries & Benefits	$180,000

What is Shannon's cost of goods sold?

10 points   

QUESTION 4

Assume that projected revenue for 2015 is 1,263,806. Also assume the following projected 2015 costs in each of the cost categories from question one:

Packaged (Cans & Bottles)	$160,972
Kegs	$60,368
Shrinkage/WIP Loss	$42,000
Contract Labor	$9,000
Direct Labor	$240,000
Freight	$18,000
Consumer Advertising	$30,000
Trade Promotion	$30,000
Sales Promotion	$18,000
Salaries & Benefits	$180,000

Given these costs, compute Shannon’s projected contribution margin in dollars.

10 points   

QUESTION 5

Assume that total sales revenue for 2015 is projected to be $1,342,972. Assume also the following costs for Shannon’s Brewery:

Packaged (Cans & Bottles)	$120,084
Kegs	$61,795
Shrinkage/WIP Loss	$42,000
Contract Labor	$9,000
Direct Labor	$240,000
Freight	$18,000
Consumer Advertising	$30,000
Trade Promotion	$30,000
Sales Promotion	$18,000
Salaries & Benefits	$180,000

Compute Shannon’s %NMC. Round your answer to the nearest percent. For example, if your computed answer is 99.4% your answer rounds down to 99%. If your computed answer is 99.5% you should round up to 100%. DO NOT INCLUDE THE % SIGN IN YOUR ANSWER.

Answer 1

1. A, A, A, A, A, A, B,B, B, B

2. Predicted dollar sales of Beer sold in kegs is 1045518*60% = $ 627,311

3. Cost of goods sold refers to the costs attributable to bringing the goods to their present condition.

COGS = 143906+74010+42000+9000+240000 = 508916

4. Contribution = Sales - Variable costs

= 1263806 - (160972+60368+42000+9000+240000+18000)

= 1263806 - 530340

= 733466

5. Please clarify about NMC. Please leave a comment so I can get back to you on that.