Even if you can one answer question 1, any help would be greatly greatly appreciated!! and if you could show your work so I can understand it would be really helpful!!! Thank You!!!

D G H G8212 CASE SPRING 2021 In 2015, Alex Montella quit his job at a large beer company to start his own brewery, Siena Brewery, Inc. (SI). His family supported his decision and invested in the business along with Alex. Siena Brewery doesn't pay income taxes. The company began operations on January 7, 2016 and now produces four Labels of specialty beers (Perone Pale Ale, Moretti Bock, Nastro Blue Pilsner, and Menabrea Stout). In much of the United States, beer is sold in a 'three-tier" system. Under this system, beer is manufactured by producers, sold to distributors, and then sold to retailers (such as liquor stores, drug stores, and grocery stores). Alex employs two salespeople who receive a fixed monthly salary plus a 8 percent commission. All beer is sold to beer distributors in cases of 24 bottles. Product sales and cost information for 2019 are shown in Exhibit 1 with additional information in Exhibit 2. Alex rents a facility that is used to make the beer, a refrigeration area to store the beer, and a small office area. SI Brewery has five machines with 9,000 total machine hours available per year to produce beer (assuming Sl keeps its machines running on one shift with some normal maintenance, breaks, etc.). While there is an empty space in the Yacility that could be used to expand the beer operations, the company would need to purchase an additional grain hopper and brew house for about $100,000 (the current water system and process control system could be expanded to handle the new machine). Beers are aged in a refrigeration area prior to sale. The current refrigeration unit allows for different temperatures in different areas of the unit and the unit is usually running about 80 percent full. Keeping the refrigeration unit somewhat full helps reduce refrigeration costs. Additionally, since the company is so new, sales have been growing but erratically (from 2016 to 2017, sales growth was over 45 percent; however, from 2018 to 2019, sales growth was only 15 percent). Thus, keeping more beer on hand allows the company to meet the erratic demand without loss of sales. Alex has not taken a salary since the business started. While the business has been generating a small profit, Alex has been reinvesting the earnings in the business. He wants to grow the business to generate more profit for his family and himself. Alex has been considering increasing the price on Menebrea Stout from $25.50 per case to $28.00 per case. He thinks that, with this price increase, unit sales will decrease from 4,155 cases to 3,725 cases per year. Alternatively, Alex could drop the price of Menebrea Stout to $23.75 per case. This is much closer to the Moretti Bock price as well as the Nastro Blue Pilsner. Based on his market research, he thinks that this wil result in Menebrea Stout sales increasing to 4,720 Cases per year, While the company has some cash on hand, neither the company nor Alex's family have another $100,000 to invest in the business right now for a new grain hopper and brew house. Since the business is new and has been showing only small profits, Alex has not been able to get a loan to expand the business. Instead, Alex wants to fully utilize the machines they already have. In 2019, they used around 8,000 machine hours (as shown in Exhibitd) and the existing five machines have a total of 9,000 machine hours available during the year (assuming normal maintenance and some repairs needed during the year). Thus, the existing machines have around 1,000 additional hours available for use. Alex wants to keep producing and selling all four of his product lines because many of the beer distributors like buying from breweries that offer several different beers. However, he wants to direct the salespeople to emphasize a certain product when they are out talking to the beer distributors. Given the current machine availability, Alex is not sure what beer product line to tell the salespeople to emphasize in order to maximize his profits. SIGN Ethics Statement Instruction REQUIREMENTS You have been hired as a consultant to help Alex with the business. Please address the following questions in preparation for your discussions with him. 1. Ignore any current plans. Using the data and sales mix provided for 2019 answer the following questions: a. How many total cases would Alex need to sell in order to earn $77,000 operating income? b. What is the percentage increase in the total cases over the 2019 data if the desired operating income is $77,000? c. How many of these cases would be Nastro Blue Pilsner (assume that sales mix remains the same)? to 2 In Question 1, you identified the total number of cases the company needs to sell to earn $77,000 operating income and how many cases of Nastro Blue Pilsner). Assume you did the calculations in Question 1 correctly However, before discussing your solution with the owner you need to address the following a. Think back to the CVP assumptions and consider how those assumptions (refer to CVP materials from dass) might create potentia issues with your analysis. Identify and explain at least three issues related to your analysis and the assumptions employed in your analysis in Question 1. Discuss each concern: what it is and why it is a concern, do not just question general facts of the case such as why St is charging a certain price for one product or how si can reduce direct material cost. b. Consider production capacity and how that might affect this analysis. c. Alex is not paying himself a salary, Long-term, this is not a viable way for Alex to run the business. An entrepreneur starting a business should make sure he/she factors some type of salary reasonable amount) for himself/herself into the CVP model. What will happen to the company's overall breakeven point if Alex starts to pay himself a yearly salary of $35,000? 3. Ignore the desire to earn $77,000 in operating income and refer to the original data. Alex has a few options regarding Menabrea Stout pricing: Option 1: keep the sales price the same (no change). Option 2: increase the sales price Option 3. decrease the sales price a. What would you recommend he do and why? b. Provide both quantitative and qualitative analysis Next, ignoring the Menabrea Stout information in question 3, consider Alex's question regarding what product line the salespeople should emphasize. Alex wants their sales efforts to maximize profits and utilize the company's current capacity. You need to take into consideration that Si has to deal with constrained resources and that you are only provided with dear data for machine hours. a. What would you tell him? Explain your rationale from a quantitative perspective. b. list and explain two qualitative factors that Alex should considered in this decision Sd ro 4. S. Consider the original cost information data. In 2019, Si has been contacted by two international companies regarding special orders. Leopold Corporation, a Canadian company, would like to order 1500 cases of Merette Bock at an average price of $16.50 Geox Corporation, an Australian company, would like to order 1.000 cases of Perne Pale Ale at an average price of $15.(Assume Sl doesn't pay soles commission on special orders). Based on a quantitative analysis only should si accept one or both special orders: what is the support for your decision? b. State two qualitative issues, one internal to the company and one external to the company that should also be considered 1 Siena Brewery, Inc. 2 Exhibit 1 3 Cost & Sales information for 2019 (yearly) Perone Pale Nastro Blue Menabrea Ale Moretti Bock Pilsner Stout $ 20.00 $ 23.50 $ 22.75$ 25.50 Total $ S $ 2.50 $ 3.45 $ 5.75 $ 11.70 8.30 $ 2.40 $ 3.45 $ 5.68 $ 11.53 11.97 $ 2.65 $ 3.00 $ 5.80 $ 11.45 11.30 $ 3.25 4.95 6.34 14.54 10.96 $ 4 5 Sales Price per case 6 7 Direct Materials per case 8 Direct Labor per case 9 Other Variable Costs per case 10 Total Variable costs per case 11 Contribution Margin per Case 12 13 14 Number of cases sold 15 16 Direct Labor Hours (DLH) per case 17 Total DLH B 9 Machine Hours (MH) per case 0 Total MH 12,725 7,240 6,930 4,155 31,050 0.23 2,926.75 0.23 1,665.20 0.20 1,386.00 0.33 1,371.15 7,349.10 0.20 2,545.00 0.37 2,678.80 0.25 1,732.50 0.28 1,163.40 8,119.70 2 4 Contribution Margin Income Statement: 5 6 7 Total Sales Revenue 8 Total Variable Costs 9 Contribution Margin Direct Fixed Costs 1 Segment Margin 2 Common Fixed Costs Operating Income Perone Pale Nastro Blue Menabrea Ale Moretti Bock Pilsner Stout Total $ 254,500.00 $ 170,140.00 $ 157,657.50 $ 105,952.50 $ 688,250.00 148,882.50 83,477.20 79,348.50 60,413.70 372,121.90 105,617.50 86,662.80 78,309.00 45,538.80 316,128.10 10,329.62 8,392.91 6,017.39 9,893.92 34,633.84 $ 95,287.88 $ 78,269.89 $ 72,291.61 $ 35,644.88 $ 281,494.26 $ 245,389.44 $ 36,104.82 5 Exhibits 2 5 Additional Cost Information for 2019 Total Detail of Total Variable Costs Direct Material Direct Labor Production Supplies $ 81,056.75 $ 110,236.50 $ 26,064.41 Roan Data Common Fixed Costs Operating Income Exhibits 2 Additional Cost Information for 2019 Total Detail of Total Variable Costs Direct Material Direct Labor Production Supplies Variable Portion of Maintenance Variable Portion of Utilities Variable Office Supplies (sales forms, etc) Shipping costs 8% Sales Commission $ 81,056.75 $ 110,236.50 $ 26,064.41 $ 39,292.55 $ 26,310.57 $ 3,490.03 $ 30,611.09 $ 55,060.00 $ 372,121.90 Detail of Total Fixed Costs (Direct + Indirect) Brew Master / Quality Control manager $ 60,293.15 Receiving and Shipping department expenses $ 22,511.32 Depreciation $ 11,712.10 Facility costs (rent, taxes, insurance, etc) $ 78,938.15 Advertising & Marketing costs $ 22,994.91 Fixed portion of Maintenance (including IT su $ 9,992.98 Fixed portion of Utilities (including refrigeratic $ 10,390.37 Fixed portion of Office Supplies $ 4,305.66 Fixed Salary of Salespeople $ 32,221.81 Administrative staff to assist owner $ 26,662.83 Total Fixed Costs $ 280,023.28 D G H G8212 CASE SPRING 2021 In 2015, Alex Montella quit his job at a large beer company to start his own brewery, Siena Brewery, Inc. (SI). His family supported his decision and invested in the business along with Alex. Siena Brewery doesn't pay income taxes. The company began operations on January 7, 2016 and now produces four Labels of specialty beers (Perone Pale Ale, Moretti Bock, Nastro Blue Pilsner, and Menabrea Stout). In much of the United States, beer is sold in a 'three-tier" system. Under this system, beer is manufactured by producers, sold to distributors, and then sold to retailers (such as liquor stores, drug stores, and grocery stores). Alex employs two salespeople who receive a fixed monthly salary plus a 8 percent commission. All beer is sold to beer distributors in cases of 24 bottles. Product sales and cost information for 2019 are shown in Exhibit 1 with additional information in Exhibit 2. Alex rents a facility that is used to make the beer, a refrigeration area to store the beer, and a small office area. SI Brewery has five machines with 9,000 total machine hours available per year to produce beer (assuming Sl keeps its machines running on one shift with some normal maintenance, breaks, etc.). While there is an empty space in the Yacility that could be used to expand the beer operations, the company would need to purchase an additional grain hopper and brew house for about $100,000 (the current water system and process control system could be expanded to handle the new machine). Beers are aged in a refrigeration area prior to sale. The current refrigeration unit allows for different temperatures in different areas of the unit and the unit is usually running about 80 percent full. Keeping the refrigeration unit somewhat full helps reduce refrigeration costs. Additionally, since the company is so new, sales have been growing but erratically (from 2016 to 2017, sales growth was over 45 percent; however, from 2018 to 2019, sales growth was only 15 percent). Thus, keeping more beer on hand allows the company to meet the erratic demand without loss of sales. Alex has not taken a salary since the business started. While the business has been generating a small profit, Alex has been reinvesting the earnings in the business. He wants to grow the business to generate more profit for his family and himself. Alex has been considering increasing the price on Menebrea Stout from $25.50 per case to $28.00 per case. He thinks that, with this price increase, unit sales will decrease from 4,155 cases to 3,725 cases per year. Alternatively, Alex could drop the price of Menebrea Stout to $23.75 per case. This is much closer to the Moretti Bock price as well as the Nastro Blue Pilsner. Based on his market research, he thinks that this wil result in Menebrea Stout sales increasing to 4,720 Cases per year, While the company has some cash on hand, neither the company nor Alex's family have another $100,000 to invest in the business right now for a new grain hopper and brew house. Since the business is new and has been showing only small profits, Alex has not been able to get a loan to expand the business. Instead, Alex wants to fully utilize the machines they already have. In 2019, they used around 8,000 machine hours (as shown in Exhibitd) and the existing five machines have a total of 9,000 machine hours available during the year (assuming normal maintenance and some repairs needed during the year). Thus, the existing machines have around 1,000 additional hours available for use. Alex wants to keep producing and selling all four of his product lines because many of the beer distributors like buying from breweries that offer several different beers. However, he wants to direct the salespeople to emphasize a certain product when they are out talking to the beer distributors. Given the current machine availability, Alex is not sure what beer product line to tell the salespeople to emphasize in order to maximize his profits. SIGN Ethics Statement Instruction REQUIREMENTS You have been hired as a consultant to help Alex with the business. Please address the following questions in preparation for your discussions with him. 1. Ignore any current plans. Using the data and sales mix provided for 2019 answer the following questions: a. How many total cases would Alex need to sell in order to earn $77,000 operating income? b. What is the percentage increase in the total cases over the 2019 data if the desired operating income is $77,000? c. How many of these cases would be Nastro Blue Pilsner (assume that sales mix remains the same)? to 2 In Question 1, you identified the total number of cases the company needs to sell to earn $77,000 operating income and how many cases of Nastro Blue Pilsner). Assume you did the calculations in Question 1 correctly However, before discussing your solution with the owner you need to address the following a. Think back to the CVP assumptions and consider how those assumptions (refer to CVP materials from dass) might create potentia issues with your analysis. Identify and explain at least three issues related to your analysis and the assumptions employed in your analysis in Question 1. Discuss each concern: what it is and why it is a concern, do not just question general facts of the case such as why St is charging a certain price for one product or how si can reduce direct material cost. b. Consider production capacity and how that might affect this analysis. c. Alex is not paying himself a salary, Long-term, this is not a viable way for Alex to run the business. An entrepreneur starting a business should make sure he/she factors some type of salary reasonable amount) for himself/herself into the CVP model. What will happen to the company's overall breakeven point if Alex starts to pay himself a yearly salary of $35,000? 3. Ignore the desire to earn $77,000 in operating income and refer to the original data. Alex has a few options regarding Menabrea Stout pricing: Option 1: keep the sales price the same (no change). Option 2: increase the sales price Option 3. decrease the sales price a. What would you recommend he do and why? b. Provide both quantitative and qualitative analysis Next, ignoring the Menabrea Stout information in question 3, consider Alex's question regarding what product line the salespeople should emphasize. Alex wants their sales efforts to maximize profits and utilize the company's current capacity. You need to take into consideration that Si has to deal with constrained resources and that you are only provided with dear data for machine hours. a. What would you tell him? Explain your rationale from a quantitative perspective. b. list and explain two qualitative factors that Alex should considered in this decision Sd ro 4. S. Consider the original cost information data. In 2019, Si has been contacted by two international companies regarding special orders. Leopold Corporation, a Canadian company, would like to order 1500 cases of Merette Bock at an average price of $16.50 Geox Corporation, an Australian company, would like to order 1.000 cases of Perne Pale Ale at an average price of $15.(Assume Sl doesn't pay soles commission on special orders). Based on a quantitative analysis only should si accept one or both special orders: what is the support for your decision? b. State two qualitative issues, one internal to the company and one external to the company that should also be considered 1 Siena Brewery, Inc. 2 Exhibit 1 3 Cost & Sales information for 2019 (yearly) Perone Pale Nastro Blue Menabrea Ale Moretti Bock Pilsner Stout $ 20.00 $ 23.50 $ 22.75$ 25.50 Total $ S $ 2.50 $ 3.45 $ 5.75 $ 11.70 8.30 $ 2.40 $ 3.45 $ 5.68 $ 11.53 11.97 $ 2.65 $ 3.00 $ 5.80 $ 11.45 11.30 $ 3.25 4.95 6.34 14.54 10.96 $ 4 5 Sales Price per case 6 7 Direct Materials per case 8 Direct Labor per case 9 Other Variable Costs per case 10 Total Variable costs per case 11 Contribution Margin per Case 12 13 14 Number of cases sold 15 16 Direct Labor Hours (DLH) per case 17 Total DLH B 9 Machine Hours (MH) per case 0 Total MH 12,725 7,240 6,930 4,155 31,050 0.23 2,926.75 0.23 1,665.20 0.20 1,386.00 0.33 1,371.15 7,349.10 0.20 2,545.00 0.37 2,678.80 0.25 1,732.50 0.28 1,163.40 8,119.70 2 4 Contribution Margin Income Statement: 5 6 7 Total Sales Revenue 8 Total Variable Costs 9 Contribution Margin Direct Fixed Costs 1 Segment Margin 2 Common Fixed Costs Operating Income Perone Pale Nastro Blue Menabrea Ale Moretti Bock Pilsner Stout Total $ 254,500.00 $ 170,140.00 $ 157,657.50 $ 105,952.50 $ 688,250.00 148,882.50 83,477.20 79,348.50 60,413.70 372,121.90 105,617.50 86,662.80 78,309.00 45,538.80 316,128.10 10,329.62 8,392.91 6,017.39 9,893.92 34,633.84 $ 95,287.88 $ 78,269.89 $ 72,291.61 $ 35,644.88 $ 281,494.26 $ 245,389.44 $ 36,104.82 5 Exhibits 2 5 Additional Cost Information for 2019 Total Detail of Total Variable Costs Direct Material Direct Labor Production Supplies $ 81,056.75 $ 110,236.50 $ 26,064.41 Roan Data Common Fixed Costs Operating Income Exhibits 2 Additional Cost Information for 2019 Total Detail of Total Variable Costs Direct Material Direct Labor Production Supplies Variable Portion of Maintenance Variable Portion of Utilities Variable Office Supplies (sales forms, etc) Shipping costs 8% Sales Commission $ 81,056.75 $ 110,236.50 $ 26,064.41 $ 39,292.55 $ 26,310.57 $ 3,490.03 $ 30,611.09 $ 55,060.00 $ 372,121.90 Detail of Total Fixed Costs (Direct + Indirect) Brew Master / Quality Control manager $ 60,293.15 Receiving and Shipping department expenses $ 22,511.32 Depreciation $ 11,712.10 Facility costs (rent, taxes, insurance, etc) $ 78,938.15 Advertising & Marketing costs $ 22,994.91 Fixed portion of Maintenance (including IT su $ 9,992.98 Fixed portion of Utilities (including refrigeratic $ 10,390.37 Fixed portion of Office Supplies $ 4,305.66 Fixed Salary of Salespeople $ 32,221.81 Administrative staff to assist owner $ 26,662.83 Total Fixed Costs $ 280,023.28