Save & Exit Suomet 1 Check my work Thet entrepreneurs were looking to start a new brewpub near Sacramento con called Roseviewing Company Brewpubs provide two products to customersfood from the restaurant segment and fresh bred beer from the beer production segment. Both segments are typically in the same building, which allows customers to see the beer brewing process After months of research, the owners created a financial model that showed the following projections for the first year of operations 100 Dome er sales od tale the sales Total sale Le cost of als Lets wating and strative $. 999,00 226,400 000 111.30 17.20 S. In the processo Spalth private investors and financial institution Rawis approached with severo The following represents a sample of the more common questions asked . What is the even point What sales dolls will be required to make $290,000? To moke S580.000 . is the product mixersonable leer tends to have a higher contribution margin to the food and therefore product assumptions are critical to profit projection) What happens to operating profit if the product mix shit? How will changesprike atfect operating profil How much does a pint of beer cost to produce D PRE Check my work 1 It became clear to the owners of RBC that the initial financial model was not adequate for answering these types of questions. After further research RBC created another financial model that provided the following information for the first year of operations 100 point siped $816,000 999.00 226,00 $2,000,000 Door Prit $122,400 319,072 67,320 420,400 40,300 1,600 20,400 References Sales Beer sales of total sales) Food sales (49% of total sales) other sales (11% of total sales) Total sales Variable costs Beer (153 of beer sales) Fool of food sales) Other (30% of other sales) Wages of employees (23% of sales) Supplies (23 of wales) Utilities (4x of sales) Other credit cards (1% of alus) Total variable costs Contribution in Fixed Costs Salaries anger, het brew Maintenance Advertising ther cleanine. , wise Insurance and accounting Property tas Depreciation Detit service interest debt Total Fixed costs Operating profit $1,000 399,200 $131,000 29.000 12.00 33,00 34.000 14.000 36,00 5.466.00 $493,20 Operating profit 100 points Soeu Required: Perform a sensitivity analysis by answering the following questions: a. What is the break even point in sales dollars for RBC? b. What is the margin of safety for RBC? c. What sales dollars would be required to achieve an operating profit of $290.0007 $580,000? Complete this question by entering your answers in the tabs below. etoon Required A Required Required What is the break-even point in sales dollars for RDC? (Round intermediate calculations to decimat places and your final answer to the nearest whole dollar) Relerence Ben pont Required B > 493,20 100 points Skipped Required: Perform a sensitivity analysis by answering the following questions a. What is the break even point in sales dollars for REC? b. What is the margin of safety for RBC? c. What sales dollars would be required to achieve an operating profit of $290.000? $580,000? Complete this question by entering your answers in the tabs below. Book Pint Required A Required B Required References What is the margin of safety for RBC7 (Round intermediate calculations to 3 decimal places and your final answer to the nearest whole dollar) Margin of salty Help Save En Check 1 100 points Required: Perform a sensitivity analysis by answering the following questions: a. What is the break-even point in sales dollars for RBC? b. What is the margin of safety for RBC? c. What sales dollars would be required to achieve an operating profit of $290,000 $580,000? Complete this question by entering your answers in the tabs below. Skipped Book Required A Required B Required Paint What sales dollars would be required to achieve an operating profit of $290,0007 $550,0002 (Round intermediate calculations to 3 decimal places and your final answers to the nearest whole dollar) Sales Dollars References Operating profit of $200,000 Operating profit of $580,000 493,20 100 points Skipped Required: Perform a sensitivity analysis by answering the following questions a. What is the break even point in sales dollars for REC? b. What is the margin of safety for RBC? c. What sales dollars would be required to achieve an operating profit of $290.000? $580,000? Complete this question by entering your answers in the tabs below. Book Pint Required A Required B Required References What is the margin of safety for RBC7 (Round intermediate calculations to 3 decimal places and your final answer to the nearest whole dollar) Margin of salty Help Save En Check 1 100 points Required: Perform a sensitivity analysis by answering the following questions: a. What is the break-even point in sales dollars for RBC? b. What is the margin of safety for RBC? c. What sales dollars would be required to achieve an operating profit of $290,000 $580,000? Complete this question by entering your answers in the tabs below. Skipped Book Required A Required B Required Paint What sales dollars would be required to achieve an operating profit of $290,0007 $550,0002 (Round intermediate calculations to 3 decimal places and your final answers to the nearest whole dollar) Sales Dollars References Operating profit of $200,000 Operating profit of $580,000