Question 1 10 pts 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 2018 are expected to be $1,040,260. Given the proportions of beer sold in kegs, bottles, and cans, what will be the predicted dollar sales of beer sold in kegs? Round your answer to the nearest one dollar. Question 2 10 pts Assume the following costs in each of the categories identified in question one are: Packaged (Cans & Bottles) Kegs Shrinkage/WIP Loss Contract Labor Direct Labor Freight Consumer Advertising Trade Promotion Sales Promotion Salaries & Benefits $143,152 $69,493 $42,000 $9,000 $240,000 $18,000 $30,000 $30,000 $18,000 $180,000 What is Shannon's cost of goods sold? Question 3 10 pt Assume that projected revenue for 2018 is 1,048,666. Also assume the following projected 2018 costs in each of the cost categories from question one: Packaged (Cans & Bottles) Kegs Shrinkage/WIP Loss Contract Labor Direct Labor Freight Consumer Advertising Trade Promotion Sales Promotion Salaries & Benefits $121,872 $70,802 $42,000 $9,000 $240,000 $18,000 $30,000 $30,000 $18,000 $180,000 Given these costs, compute Shannon's projected contribution in dollars. Question 4 10 pts Assume that total sales revenue for 2018 is projected to be $1,236,531. Assume also the following costs for Shannon's Brewery: Packaged (Cans & Bottles) Kegs Shrinkage/WIP Loss Contract Labor Direct Labor Freight Consumer Advertising Trade Promotion Sales Promotion Salaries & Benefits $150,000 $80,000 $42,000 $9,000 $240,000 $18,000 $29,104 $28,493 $18,000 $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. Question 1 10 pts 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 2018 are expected to be $1,040,260. Given the proportions of beer sold in kegs, bottles, and cans, what will be the predicted dollar sales of beer sold in kegs? Round your answer to the nearest one dollar. Question 2 10 pts Assume the following costs in each of the categories identified in question one are: Packaged (Cans & Bottles) Kegs Shrinkage/WIP Loss Contract Labor Direct Labor Freight Consumer Advertising Trade Promotion Sales Promotion Salaries & Benefits $143,152 $69,493 $42,000 $9,000 $240,000 $18,000 $30,000 $30,000 $18,000 $180,000 What is Shannon's cost of goods sold? Question 3 10 pt Assume that projected revenue for 2018 is 1,048,666. Also assume the following projected 2018 costs in each of the cost categories from question one: Packaged (Cans & Bottles) Kegs Shrinkage/WIP Loss Contract Labor Direct Labor Freight Consumer Advertising Trade Promotion Sales Promotion Salaries & Benefits $121,872 $70,802 $42,000 $9,000 $240,000 $18,000 $30,000 $30,000 $18,000 $180,000 Given these costs, compute Shannon's projected contribution in dollars. Question 4 10 pts Assume that total sales revenue for 2018 is projected to be $1,236,531. Assume also the following costs for Shannon's Brewery: Packaged (Cans & Bottles) Kegs Shrinkage/WIP Loss Contract Labor Direct Labor Freight Consumer Advertising Trade Promotion Sales Promotion Salaries & Benefits $150,000 $80,000 $42,000 $9,000 $240,000 $18,000 $29,104 $28,493 $18,000 $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
