Tempe Microbrewery in 2009, David Tucker quit his job at a large beer company to start his own brewery, Tempe Microbrewery (TM). His family supported his decision and invested in the business along with David TM began operations on January 10, 2010 and now produces four labels of specialty beers Saguaro pale Ale, Bisbee Bock, Ocotillo Amber Pilsner, and Sedona Stout). An explanation of the beer-making process is shown in Appendix A in much of the United Sates including Arizona), beer is sold in a three-tier system. Under this system, beer is manufactured by producers, sold to distributors, who then sell to retailers (such as liquor stores, drugstores, and grocery stores), David employs two salespeople who receive a fixed monthly salary, plus an 8 percent commission. All beer is said to beer distributors primarily in the Southwestern United States) In cases of 24 bottles. Product sales and cost information for 2013 are shown in Exhibiti with additional information in Exhibit 2. David rents a facility that is used to make the beer, a refrigeration area to store the beer, and a small office area. TM brewery has five machines with 9,500 total machine hours available per year to produce beer (assuming TM remains on one shift with some normal maintenance, breaks, etc.). While there is an empty space in the facility 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). As discussed in Appendix A, beers are aged in a refrigeration aren 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 erratic from 2010 to 2011, sales growth was over 45 percent, however, from 2012 to 2013, sales growth was only 12 percent). Thus keeping more beer on hand allows the company to meet the erratic demand without loss of sales. David has not taken a salary since the business started. While the business has been generating a small profit, David has been reinvesting the earnings in the business. He wants to grow the business to generate more profit for his family and himself. David has been considering increasing the price on Sedona Stout from $26.50 per case to 529,00 per case. He thinks that with this price increase, unit sales will decrease from 4,184 cases to 3,750 cases per year. However, this would only reduce total annual Stout revenues to $108,750 from $110,876. Alternatively, David could drop the price of Sedona Stout to $25 per case. This is much closer to the Bock price as well as the Pilsner. Based on this market research, he thinks that this will result in Stout sales increasing to 4,700 cases per year. He is leaning toward this alternative as this will increase Stout revenues from $110,876 to 5117,500 per year. While the company has some cash on hand, neither the company nor David'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, David has not been able to get a loan to expand the business. Instead, David wants to fully utilize the machines they already have. In 2013, they used a little under 8,500 machine hours (as shown in Exhibit 1) and the existing five machines have a total of 9,300 machine hours available during the year (assuming normal maintenance and some repairs needed during the year). Thus, the existing machines have approximately 800 additional hours available for use. David 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, David is not sure what beer product line to tell the sales people to emphasize in order to maximize his profits Finally, David and his family love root beer. Root beer follows a somewhat similar process to beer in that the ingredients are mixed together to form a "culture that then goes through fermenting, filtering. and fing Root beer would not need to be aged or stored in the refrigerator. There is an empty area in the current microbrewery facility that could be dedicated to makingroot beer. As a result, David has been talking with his family about producing and selling a line of specialty root beer. Root beer would be produced using different machinery rather than the existing five beer machines. David's sister knows someone who is getting out of the soda business and would be willing to sell the used machinery needed to make the root beer for $8,000. Based on market research he has done, David thinks that he could charge $16.50 per case of root beer. Based on the same market research, there is a lot of uncertainty in how many cases of root beer the company could sell David is less familiar with the root beer market and there is a wide range in sales of specialty root beer in the local groceries. Based on his understanding of the market, he thinks he could sell between 3,000 and 12,000 cases of root beer per year with likely sales of about 6,000 cases. Root beer could be sold to some of his current distributors. However, soda does not need to be sold through the three-tier system that is required for alcohol sales. Therefore, much of the root beer sales would be directly to upscale groceries such as La Grande Orange Grocery and Pizzeria in Phoenix and Whole Foods and Al's Fine Foods with locations throughout Arizona, David could produce the root beer in-house or out-source the production. David has talked with another company who could produce the root beer for TM using David's recipe and TM could sell it as their brand (this option is referred to as private label). It could be purchased from this other company for $13.05 per case. TM would still need to incur some variable handling costs and some minor fixed costs. Alternatively TM could produce the root beer in house. See Exhibit 3 for estimated cost information Exhibit 1 2015 Cost and Sales Information Panel A: Per Case Information Total Sales price Direct materials Direct labor Variable overhead Total variable cost Contribution margin Saguaro Pale Ale $21.00 2.75 3.75 5.90 12.40 $5.50 Bisbee Bock $24.50 2.90 3.75 6.18 12.83 $11 67 Ocotillo Amber Pilsner $23.50 3.15 3.00 6.10 12.25 $11.25 Sedona Stout $26.50 4.00 5.25 6.34 15.59 $10.91 12,593 7,126 6,827 4.184 30,730 0.25 0.25 0.20 0.35 Cases sold last year Direct labor hours per case Total direct labor hours last year Machine hours per case Total machine hours last year 3,148.25 0.20 1,781.50 0.40 7,759.55 1.365.40 0.30 1,464.40 0.25 2,518.60 2,850.40 2,048.10 1,046.00 8,463.10 Panel B. Contribution Margin Income Statement Sales Variable costs Contribution martin Direct fixed costs Seement margin Common fixed costs Operating income Taxes (35%) Net Income 264,453.00 156, 153.20 108,299.80 10,329.62 $97,970.18 5174,587.00 91,426.58 89.160.42 8,392.91 $74,767 51 $160,434.50 83,630.75 76,503.75 6,017,39 $70,786.36 $110,876.00 65,228.56 45,647.44 9,893.92 $35.753.52 $710,350.50 396,439.09 313,911.41 34,633.84 279,277.57 245,389.44 33,888.13 11,860.85 $22.02728 Exhibit 2 Additional Cost Information Panel A: Details of Total Variable Costs Direct materials Direct labor Production supplies Variable portion of maintenance Variable portion of utilities Variable office supplies Shipping costs 8% sales commission Total variable costs $ 93,537.20 116,393.25 26,064.41 40,892.55 27,610.57 3,493.88 31,619.19 56,828.04 S396,439.09 Panel B: Details of Total Fixed Costs (Direct and Indirect) Brew master quality control manager Receiving and shipping department expenses Depreciation Facility costs (rent, taxes, insurance, etc.) Advertising and marketing costs Fixed portion of maintenance Fixed portion of utilities (including refrigeration) Fixed portion of office supplies Fixed salary of salespeople Administrative staff to assist owner Total fixed costs 5 60,293.15 22,511.32 11,712.10 78,938.15 22,994.91 9,992.98 10,390.37 4,305.66 32,221.81 26,662.83 S280,023.28 Exhibit 3 Root Beer Cost Information Panel A: Alternative 1-produce in-house Direct materials per case Direct labor per case Variable overhead per case Total variable costs per Case $1.75 2.25 3.50 $7.50 Additional fixed costs per year - not including the initial purchase cost of the machine $37,640.00 Panel B: Alternative 2-out-source production Purchase price per case Variable overhead percase Total variable costs per case $13.05 0.25 $13.30 Additional flaxed costs per year $6,000.00 Appendix A Beer Making Process Beer is the overall generic term for fermented malt beverages. There are only two kinds of beer wie and Inger. Within those we broad categories there are many wyles, Major ale styles are pale ale, India Pale Ale (IPA), porter, sout, and barleywine. Among the major ager styles are planer, Martenbock, and dunkles dark inper). TM makes two ales Saguaro Pale Ale and Sedona Stout) and two lagers (Ocotillo Amber Pilsner and Bisbee Back It is the reast that is the significant difference between the ale and the lager. Ale veast coagulate Joosely at the top of the fermentation tank. Given the type of yeast, ses ferment best between 64 to 70 degrees Fahrenheit tager yeasts are more successful colder temperatures, typically 50 to 55 degrees Fahrenheit and coute closer to the bottom of the fermentation anklager yeasts also tend to ferment more aggressively, leaving behind less residual sweetness and flavor than ales. Direct Materiais - Beer primarily consists of four ingredients: water, barley, hops, and yeast. A clarifying agent is also used in the beer- making process. The different types of beer require different proportions of these ingredients and even slightly different ingredients (e. pale ale uses a pale maited barley while stout is made using a darker roasted barte) Brewing Process - Work in the brewery is typically divided into eight steps: mashing, trutering, boiling. fermenting and conditioning, fitering, filling and aging Mashing - Mashing is the first process in brewing. The barley grains are mixed with water in a large vessel. This mixture is heated with periodic breaks, or rests, at certain temperatures to allow enzymes in the maired grains to break down the starch in the grain into suger Lautering-Lavtering is when the math is separated into a liguld and the residual grain. There are two stages to lautering in the first stage called Wort Run-off, liquid (or extract) is separated in an undiluted form from the used grains. The second stage is called sparging. During sparing the extract that remains with the grains is rinsed off with hot water. The results of these two stages are combined and the result is a dark, sugary liquid called Wort. This is returned to the original mashing vessel Boling-Bolling the Wort in the vessel ensures that the mixture is sterile and prevents infection. During the boiling step, hops are added to the Wort. The hops contribute bitterness, aroma, and flavor compounds to the beer. The boiling must be continuous and intense trolling boil) and typically lasts between 0 and 120 minutes, depending on its intensity, when the hops are added and the amount of Wort expected to evaporate. The Wort is then cooled before the fermentation stage. Fermenting and conditioning - The cooled Wort is put into a fermentation tank and yeast is added which starts the fermentation process. This is also the point at which the product is first called beer. It is during this stage that fermentable sugars are metabolized into alcohol and carbon dioxide (the bubbles in beer). As noted above, fermentation temperatures are very different for ales versus lagers. Fermentation takes about a week. When the sugars in the fermenting beer have been almost completely digested, the fermentation slows down and the yeast cells will naturally start to die off and begin to settle to the bottom of the tank. At TM, the fermentation tanks are equipped with cooling jackets. Therefore, conditioning can take place in the same tank as fermentation Conditioning also called "maturation") is when beer is cooled in the tanks to allow the yeast to settle to the bottom of the tank. Conditioning allows the flavor of the beer to become smoother and as a natural filtration process fremoving cloudy material from the beer. Filtering - The beer that comes out of the fermentation tank must be filtered prior to bottling Filtering the beer stabilesflavor and gives beer its gloss or "shine. Filtering removes much of the yeast and any solids (e. c.haps and other gran particles that remain in the beer. Filing - The line process (also called Packaging") is putting the beer into bottles in which it will leave the brewery. At this point, carbon dioxide is added to the bottling process to increase the carbon dioxide in the beer. Case of beer consisting of 24 bottles) are then put into aging. Aging-Beer is stored (aged or "lagered in the refrigerator unit and the temperature and length of the aging will vary based on the type of beer. Ales are usually aged no more than a few weeks. The aging You have been hired as a consultant to help David win the business. Please address the following questions in preparation for your discussions with him Requirement 1: Ignore any current plans. Using last years actual data and sales mix, how many total cases would David need to sell in order to earn $80,000 before tau? How many cases of the four labels would TM need to produce? Alternative Alternative In-house production Dollar Outsourced Dollar Sale price per case Total Variable Cost Contribution Per case Sales Quantity Contribution Less: Additional feed cost Profits before takes Tax 35% Net Profits 16.50 6.25 2.75 5000.00 48750.00 35000.00 13750.00 14812.50 18937.50 Salepkepercase Total Variable Cost Contribution Sales Contribution Iless Profits before Tax 35 Net 13.75 2.75 5000.00 13750.00 6000.00 7750.00 2212.50 $5,038 Total contribution in 2013 Saturo Octillo Pilsner Stout $331,120 Ratio $99,574 $80,724 $70,991 $79,832 30.07 24.33 2141 24.11 374753 Additional cases required to be sold Total contribution 2013 Sapuaro Octile Pilsner Stout $374 753 Ratio $112,695 30.07 9136124.38 SO 146 21.44 50352 14.11 Conv/cate 8.35 1180 19.00 14.05 number of cases required 11.49 7742 18199 5431 2013 chies sold 11925 6941 7244 5642 ladditional required 1571 90. 1955 740 Requirement 2: in question 1. you identified the total number of cases the company needs to earn $80,000 before tax. Assume you did the calculations in Question 1 correctly. However before discussing your solution with the owner, identify and explain at least three issues related to your analysis and the assumptions employed in your analysis in question I discuss each concerns what it is any why is it is a concern; do not jus question general facts of the case such as why TM is charging a certain price for one product or how TM can reduce direct material cost. Question please answer step by step Tempe Microbrewery in 2009, David Tucker quit his job at a large beer company to start his own brewery, Tempe Microbrewery (TM). His family supported his decision and invested in the business along with David TM began operations on January 10, 2010 and now produces four labels of specialty beers Saguaro pale Ale, Bisbee Bock, Ocotillo Amber Pilsner, and Sedona Stout). An explanation of the beer-making process is shown in Appendix A in much of the United Sates including Arizona), beer is sold in a three-tier system. Under this system, beer is manufactured by producers, sold to distributors, who then sell to retailers (such as liquor stores, drugstores, and grocery stores), David employs two salespeople who receive a fixed monthly salary, plus an 8 percent commission. All beer is said to beer distributors primarily in the Southwestern United States) In cases of 24 bottles. Product sales and cost information for 2013 are shown in Exhibiti with additional information in Exhibit 2. David rents a facility that is used to make the beer, a refrigeration area to store the beer, and a small office area. TM brewery has five machines with 9,500 total machine hours available per year to produce beer (assuming TM remains on one shift with some normal maintenance, breaks, etc.). While there is an empty space in the facility 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). As discussed in Appendix A, beers are aged in a refrigeration aren 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 erratic from 2010 to 2011, sales growth was over 45 percent, however, from 2012 to 2013, sales growth was only 12 percent). Thus keeping more beer on hand allows the company to meet the erratic demand without loss of sales. David has not taken a salary since the business started. While the business has been generating a small profit, David has been reinvesting the earnings in the business. He wants to grow the business to generate more profit for his family and himself. David has been considering increasing the price on Sedona Stout from $26.50 per case to 529,00 per case. He thinks that with this price increase, unit sales will decrease from 4,184 cases to 3,750 cases per year. However, this would only reduce total annual Stout revenues to $108,750 from $110,876. Alternatively, David could drop the price of Sedona Stout to $25 per case. This is much closer to the Bock price as well as the Pilsner. Based on this market research, he thinks that this will result in Stout sales increasing to 4,700 cases per year. He is leaning toward this alternative as this will increase Stout revenues from $110,876 to 5117,500 per year. While the company has some cash on hand, neither the company nor David'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, David has not been able to get a loan to expand the business. Instead, David wants to fully utilize the machines they already have. In 2013, they used a little under 8,500 machine hours (as shown in Exhibit 1) and the existing five machines have a total of 9,300 machine hours available during the year (assuming normal maintenance and some repairs needed during the year). Thus, the existing machines have approximately 800 additional hours available for use. David 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, David is not sure what beer product line to tell the sales people to emphasize in order to maximize his profits Finally, David and his family love root beer. Root beer follows a somewhat similar process to beer in that the ingredients are mixed together to form a "culture that then goes through fermenting, filtering. and fing Root beer would not need to be aged or stored in the refrigerator. There is an empty area in the current microbrewery facility that could be dedicated to makingroot beer. As a result, David has been talking with his family about producing and selling a line of specialty root beer. Root beer would be produced using different machinery rather than the existing five beer machines. David's sister knows someone who is getting out of the soda business and would be willing to sell the used machinery needed to make the root beer for $8,000. Based on market research he has done, David thinks that he could charge $16.50 per case of root beer. Based on the same market research, there is a lot of uncertainty in how many cases of root beer the company could sell David is less familiar with the root beer market and there is a wide range in sales of specialty root beer in the local groceries. Based on his understanding of the market, he thinks he could sell between 3,000 and 12,000 cases of root beer per year with likely sales of about 6,000 cases. Root beer could be sold to some of his current distributors. However, soda does not need to be sold through the three-tier system that is required for alcohol sales. Therefore, much of the root beer sales would be directly to upscale groceries such as La Grande Orange Grocery and Pizzeria in Phoenix and Whole Foods and Al's Fine Foods with locations throughout Arizona, David could produce the root beer in-house or out-source the production. David has talked with another company who could produce the root beer for TM using David's recipe and TM could sell it as their brand (this option is referred to as private label). It could be purchased from this other company for $13.05 per case. TM would still need to incur some variable handling costs and some minor fixed costs. Alternatively TM could produce the root beer in house. See Exhibit 3 for estimated cost information Exhibit 1 2015 Cost and Sales Information Panel A: Per Case Information Total Sales price Direct materials Direct labor Variable overhead Total variable cost Contribution margin Saguaro Pale Ale $21.00 2.75 3.75 5.90 12.40 $5.50 Bisbee Bock $24.50 2.90 3.75 6.18 12.83 $11 67 Ocotillo Amber Pilsner $23.50 3.15 3.00 6.10 12.25 $11.25 Sedona Stout $26.50 4.00 5.25 6.34 15.59 $10.91 12,593 7,126 6,827 4.184 30,730 0.25 0.25 0.20 0.35 Cases sold last year Direct labor hours per case Total direct labor hours last year Machine hours per case Total machine hours last year 3,148.25 0.20 1,781.50 0.40 7,759.55 1.365.40 0.30 1,464.40 0.25 2,518.60 2,850.40 2,048.10 1,046.00 8,463.10 Panel B. Contribution Margin Income Statement Sales Variable costs Contribution martin Direct fixed costs Seement margin Common fixed costs Operating income Taxes (35%) Net Income 264,453.00 156, 153.20 108,299.80 10,329.62 $97,970.18 5174,587.00 91,426.58 89.160.42 8,392.91 $74,767 51 $160,434.50 83,630.75 76,503.75 6,017,39 $70,786.36 $110,876.00 65,228.56 45,647.44 9,893.92 $35.753.52 $710,350.50 396,439.09 313,911.41 34,633.84 279,277.57 245,389.44 33,888.13 11,860.85 $22.02728 Exhibit 2 Additional Cost Information Panel A: Details of Total Variable Costs Direct materials Direct labor Production supplies Variable portion of maintenance Variable portion of utilities Variable office supplies Shipping costs 8% sales commission Total variable costs $ 93,537.20 116,393.25 26,064.41 40,892.55 27,610.57 3,493.88 31,619.19 56,828.04 S396,439.09 Panel B: Details of Total Fixed Costs (Direct and Indirect) Brew master quality control manager Receiving and shipping department expenses Depreciation Facility costs (rent, taxes, insurance, etc.) Advertising and marketing costs Fixed portion of maintenance Fixed portion of utilities (including refrigeration) Fixed portion of office supplies Fixed salary of salespeople Administrative staff to assist owner Total fixed costs 5 60,293.15 22,511.32 11,712.10 78,938.15 22,994.91 9,992.98 10,390.37 4,305.66 32,221.81 26,662.83 S280,023.28 Exhibit 3 Root Beer Cost Information Panel A: Alternative 1-produce in-house Direct materials per case Direct labor per case Variable overhead per case Total variable costs per Case $1.75 2.25 3.50 $7.50 Additional fixed costs per year - not including the initial purchase cost of the machine $37,640.00 Panel B: Alternative 2-out-source production Purchase price per case Variable overhead percase Total variable costs per case $13.05 0.25 $13.30 Additional flaxed costs per year $6,000.00 Appendix A Beer Making Process Beer is the overall generic term for fermented malt beverages. There are only two kinds of beer wie and Inger. Within those we broad categories there are many wyles, Major ale styles are pale ale, India Pale Ale (IPA), porter, sout, and barleywine. Among the major ager styles are planer, Martenbock, and dunkles dark inper). TM makes two ales Saguaro Pale Ale and Sedona Stout) and two lagers (Ocotillo Amber Pilsner and Bisbee Back It is the reast that is the significant difference between the ale and the lager. Ale veast coagulate Joosely at the top of the fermentation tank. Given the type of yeast, ses ferment best between 64 to 70 degrees Fahrenheit tager yeasts are more successful colder temperatures, typically 50 to 55 degrees Fahrenheit and coute closer to the bottom of the fermentation anklager yeasts also tend to ferment more aggressively, leaving behind less residual sweetness and flavor than ales. Direct Materiais - Beer primarily consists of four ingredients: water, barley, hops, and yeast. A clarifying agent is also used in the beer- making process. The different types of beer require different proportions of these ingredients and even slightly different ingredients (e. pale ale uses a pale maited barley while stout is made using a darker roasted barte) Brewing Process - Work in the brewery is typically divided into eight steps: mashing, trutering, boiling. fermenting and conditioning, fitering, filling and aging Mashing - Mashing is the first process in brewing. The barley grains are mixed with water in a large vessel. This mixture is heated with periodic breaks, or rests, at certain temperatures to allow enzymes in the maired grains to break down the starch in the grain into suger Lautering-Lavtering is when the math is separated into a liguld and the residual grain. There are two stages to lautering in the first stage called Wort Run-off, liquid (or extract) is separated in an undiluted form from the used grains. The second stage is called sparging. During sparing the extract that remains with the grains is rinsed off with hot water. The results of these two stages are combined and the result is a dark, sugary liquid called Wort. This is returned to the original mashing vessel Boling-Bolling the Wort in the vessel ensures that the mixture is sterile and prevents infection. During the boiling step, hops are added to the Wort. The hops contribute bitterness, aroma, and flavor compounds to the beer. The boiling must be continuous and intense trolling boil) and typically lasts between 0 and 120 minutes, depending on its intensity, when the hops are added and the amount of Wort expected to evaporate. The Wort is then cooled before the fermentation stage. Fermenting and conditioning - The cooled Wort is put into a fermentation tank and yeast is added which starts the fermentation process. This is also the point at which the product is first called beer. It is during this stage that fermentable sugars are metabolized into alcohol and carbon dioxide (the bubbles in beer). As noted above, fermentation temperatures are very different for ales versus lagers. Fermentation takes about a week. When the sugars in the fermenting beer have been almost completely digested, the fermentation slows down and the yeast cells will naturally start to die off and begin to settle to the bottom of the tank. At TM, the fermentation tanks are equipped with cooling jackets. Therefore, conditioning can take place in the same tank as fermentation Conditioning also called "maturation") is when beer is cooled in the tanks to allow the yeast to settle to the bottom of the tank. Conditioning allows the flavor of the beer to become smoother and as a natural filtration process fremoving cloudy material from the beer. Filtering - The beer that comes out of the fermentation tank must be filtered prior to bottling Filtering the beer stabilesflavor and gives beer its gloss or "shine. Filtering removes much of the yeast and any solids (e. c.haps and other gran particles that remain in the beer. Filing - The line process (also called Packaging") is putting the beer into bottles in which it will leave the brewery. At this point, carbon dioxide is added to the bottling process to increase the carbon dioxide in the beer. Case of beer consisting of 24 bottles) are then put into aging. Aging-Beer is stored (aged or "lagered in the refrigerator unit and the temperature and length of the aging will vary based on the type of beer. Ales are usually aged no more than a few weeks. The aging You have been hired as a consultant to help David win the business. Please address the following questions in preparation for your discussions with him Requirement 1: Ignore any current plans. Using last years actual data and sales mix, how many total cases would David need to sell in order to earn $80,000 before tau? How many cases of the four labels would TM need to produce? Alternative Alternative In-house production Dollar Outsourced Dollar Sale price per case Total Variable Cost Contribution Per case Sales Quantity Contribution Less: Additional feed cost Profits before takes Tax 35% Net Profits 16.50 6.25 2.75 5000.00 48750.00 35000.00 13750.00 14812.50 18937.50 Salepkepercase Total Variable Cost Contribution Sales Contribution Iless Profits before Tax 35 Net 13.75 2.75 5000.00 13750.00 6000.00 7750.00 2212.50 $5,038 Total contribution in 2013 Saturo Octillo Pilsner Stout $331,120 Ratio $99,574 $80,724 $70,991 $79,832 30.07 24.33 2141 24.11 374753 Additional cases required to be sold Total contribution 2013 Sapuaro Octile Pilsner Stout $374 753 Ratio $112,695 30.07 9136124.38 SO 146 21.44 50352 14.11 Conv/cate 8.35 1180 19.00 14.05 number of cases required 11.49 7742 18199 5431 2013 chies sold 11925 6941 7244 5642 ladditional required 1571 90. 1955 740 Requirement 2: in question 1. you identified the total number of cases the company needs to earn $80,000 before tax. Assume you did the calculations in Question 1 correctly. However before discussing your solution with the owner, identify and explain at least three issues related to your analysis and the assumptions employed in your analysis in question I discuss each concerns what it is any why is it is a concern; do not jus question general facts of the case such as why TM is charging a certain price for one product or how TM can reduce direct material cost. Question please answer step by step