1 Break-Even Analysis 2 Enter data only in yellow cells. 3 4 Profitability Analysis 5 6 7 Cost 8 2 10 HEREHERE 12 Revenue 13 14 15 16 17 18 Quantity Fixed cost Unit cost Unit revenue Total Cost Total Revenue Net Profit Profit or Loss OCengage Learning. Not for commercial use. Outsourcing Decision 10,000 Quantity 12,000 Produce In-House Fixed cost $250,000.00 $100,000.00 $12.00 Unit cost $20.00 Outsource Fixed cost $20.00 Unit cost $35.00 $220,000.00 $200,000.00 -$20,000.00 Loss Total In-House Production Cost $490,000.00 Total Outsourced Cost $420,000.00 Cost difference (In-House - Outsourced) $70,000.00 Outsource Economical Decision Technology Choice Decision Quantity Option A Fixed cost Unit cost Option B Fixed cost Unit cost Total Cost Option A Total Cost Option B Cost difference (Option A- Option B) Economical Decision 11,000 $200,000.00 $18.60 $100,000.00 $21.00 $404,600.00 $331,000.00 $73,600.00 Option 8 O E Spreadsheet An automated car wash called Jet Express outside a large Texas city on the beltway is deciding whether to build and install one dedicated vehicle wash line or have two parallel wash lines. There are no other car washes at this intersection and there will be none because all the land is developed. The second line allows for some economies of scale in total cost. The monthly fixed cost of one wash line is $12,500 per month or $150,000 per year. This includes the mortgage payment, taxes on the building, and wash equipment. The variable cost for this single line is $10 per vehicle. The fixed cost for two wash lines is $25,000 per month or $300,000 per year, and the variable cost to operate two lines is $7 per vehicle because some wash crews can work both lines. The price of the average interior and exterior car wash is $22. Use the Excel template Break-Even in MindTap to answer the following questions: a. What is the break-even quantity for one and two automated wash line? Round your answers to the nearest whole number. For one wash line: vehicles per year For two wash lines: vehicles per year b. Annual forecasts of demand for this site ranges from 12,500 to 25,000 per year. Calculate the net profit/loss of the site in each of the following situations. Round your answers to the nearest dollar. If your answer is zero, enter "0". Use a minus sign to enter loss, if any. One Two wash line wash lines 12,500 vehicles $ 18,750 vehicles $ 25,000 vehicles $ $ $ S 1 Break-Even Analysis 2 Enter data only in yellow cells. 3 4 Profitability Analysis 5 6 7 Cost 8 2 10 HEREHERE 12 Revenue 13 14 15 16 17 18 Quantity Fixed cost Unit cost Unit revenue Total Cost Total Revenue Net Profit Profit or Loss OCengage Learning. Not for commercial use. Outsourcing Decision 10,000 Quantity 12,000 Produce In-House Fixed cost $250,000.00 $100,000.00 $12.00 Unit cost $20.00 Outsource Fixed cost $20.00 Unit cost $35.00 $220,000.00 $200,000.00 -$20,000.00 Loss Total In-House Production Cost $490,000.00 Total Outsourced Cost $420,000.00 Cost difference (In-House - Outsourced) $70,000.00 Outsource Economical Decision Technology Choice Decision Quantity Option A Fixed cost Unit cost Option B Fixed cost Unit cost Total Cost Option A Total Cost Option B Cost difference (Option A- Option B) Economical Decision 11,000 $200,000.00 $18.60 $100,000.00 $21.00 $404,600.00 $331,000.00 $73,600.00 Option 8 O E Spreadsheet An automated car wash called Jet Express outside a large Texas city on the beltway is deciding whether to build and install one dedicated vehicle wash line or have two parallel wash lines. There are no other car washes at this intersection and there will be none because all the land is developed. The second line allows for some economies of scale in total cost. The monthly fixed cost of one wash line is $12,500 per month or $150,000 per year. This includes the mortgage payment, taxes on the building, and wash equipment. The variable cost for this single line is $10 per vehicle. The fixed cost for two wash lines is $25,000 per month or $300,000 per year, and the variable cost to operate two lines is $7 per vehicle because some wash crews can work both lines. The price of the average interior and exterior car wash is $22. Use the Excel template Break-Even in MindTap to answer the following questions: a. What is the break-even quantity for one and two automated wash line? Round your answers to the nearest whole number. For one wash line: vehicles per year For two wash lines: vehicles per year b. Annual forecasts of demand for this site ranges from 12,500 to 25,000 per year. Calculate the net profit/loss of the site in each of the following situations. Round your answers to the nearest dollar. If your answer is zero, enter "0". Use a minus sign to enter loss, if any. One Two wash line wash lines 12,500 vehicles $ 18,750 vehicles $ 25,000 vehicles $ $ $ S