B5 H E F G 1 Break-Even Analysis 2 Enter data only in yellow cells C D Cengage Learning. Not for commercial use. Technology Choice Decision Outsourcing Decision Quantity 11.000 12.000 Quantity 10,000 Quantity 4 Profitability Analysis 5 Spr 6 7 Cost Option A Produce In-House Fixed cost Unit cost $200,000.00 $10.60 d cal wildl Fixed cost $250,000.00 Un cont $20.00 Fixed cost Unit cost $100,000.00 $12.00 Options Outsource car10 The si 11 32 Revenue Fixed cost Unit cost Fixed cost UNE cost $100,000.00 $2100 $35.00 wash 13 Unit revenue $20.00 xes o 14 The 15 Total Cost Total Revenue Net Profit Profit or loss $220,000.00 $200.000.00 $20,000.00 Loss 16 ttoo 17 the a 18 Total Cost Option A Total Cost Options Cost difference (Option A- Option B) Economical Decision Total In-House Production Cost 5490,000.00 Total Outsourced cost $420,000.00 Cost difference (In-House - Outsourced) $70,000.00 Economical Decision Outsource 5404,600.00 $331,000.00 $73.600.00 Option coans 19 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 $18 per vehicle. The fixed cost for two wash lines is $28,000 per month or $336,000 per year, and the variable cost to operate two lines is $16 per vehicle because some wash crews can work both lines. The price of the average interior and exterior car wash is $28. Use the Excel template Break-Even in Mind Tap 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 15,000 to 30,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 "O". Use a minus sign to enter loss, if any. One wash line Two wash lines 15,000 vehicles $ $ 22,500 vehicles $ $ $ 30,000 vehicles $