=pter 07 Homework: Process Selection, Design, and Improvement Search this course 6. 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 vehide 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,000 per month or $144,000 per year. This indudes Ule mortgage payment, taxes on the building, and wash equipment. The variable cost for this single line is $11 per vehide. The fixed cost for two wash lines is $24,500 per month or $294,000 per year, and the variable cost to operate two lines is $9 per vehicle because some wash crews can work both lines. The price of the average interior and exterior car wash is $29. Use the Excel template Broak-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: vehides per year by b. Annual forecasts of demand for this site ranges from 8,000 to 16,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 8,000 vehides $ $ 10+ $ $ 12,000 vehides 16,000 vehicles $ 5