Please show calculations
Chapter 12: Channel Strategy and Channel Markup PROMPT: The post-Prohibition "three-tier system" requires the separation of the production, distribution, and retailing of alcohol in most states. That wasn't much of an issue for craft brewers during the explosive growth years between 2011 and 2015, when craft beers doubled their percentage of the beer market and could hardly keep up with demand. However, craft beer volume through the three-tier system is now slowing down, growing less than 2 percent per year, causing craft brewers to turn to direct distribution for growth. Adding direct distribution, mainly through operating taprooms and brewpubs, resulted in 24 percent volume growth. Taprooms are located in working breweries where consumers can buy beer, and brewpubs are restaurants with a brewery. Such establishments now account for almost 10 percent of all U.S. bar traffic and for as much as 35 percent of traffic in Denver and San Diego. Some independent craft beer bar chains are closing locations in states like Texas because of lost sales following a 2013 law that relaxed the three-tier system and allowed breweries to sell 5,000 barrels a year for onsite consumption. Small craft brewers are excited about this trend-they make higher margins selling direct compared to using an indirect channel of distributors and bars. A brewer's average cost per keg of craft beer is $60, and a keg sells to distributors for $90. The distributor then resells the keg to a bar for $120. Each keg serves more than one hundred 14.5-ounce glasses, the amount typically poured into a 16-ounce glass at a bar to accommodate a foam head. A bar's cost per glass of craft beer poured is $0.88 per glass. The standard in the bar industry is to have 20 percent liquor cost, meaning 20 percent of the price to consumers represents the bar's cost of goods sold, leaving 80 percent for the bar's margin. QUESTION 1: Calculate the price at which a bar will sell one 14.5-ounce glass of craft beer if the desired 80 percent margin is based on selling price (Cell C14). What is the bar's dollar markup on a glass of craft beer? (Cell D14) QUESTION 2: Determine the brewer's cost per 14.5-ounce serving (one glass) in Cell A17. What price would a brewer sell that glass of beer for to achieve an 80 percent margin based on its selling price at its own taproom or brewpub (Cell C17)? What is the brewer's dollar markup on a glass of craft beer (Cell D17)? What dollar and percentage margin would a brewer realize if the glass of beer was sold for the same price as it is sold in bars (Cells B18 and D18)? Is the brewer better off using the direct channel compared to the "three-tiered system" indirect channel? Explain. (Cell A25) Cost per Keg $60 Brewer Distributor Bar $90 $120 Bar's cost of beer $0.88 Beer margin (%) 80% Beer price ($) Markup ($) Markup ($) Brewer's cost per glass Beer margin (%) Beer price ($) 80% $0.00 Key Formulas Markup (S) = Selling Price - Cost Margin (%) = (Selling Price - Cost) / Selling Price OR Margin(%) = 1 - (Cost / Selling Price)
