Question: i only need part b mework: Process Selection, Design, and Improvement Spreadsheet An automated car wash called Jet Express outside a large Texas city on

i only need part b mework: Process Selection,i only need part b
mework: Process Selection, Design, and Improvement 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 $ 16,000 per month or $192,000 per year. This includes the mortgage payment, taxes on the building, and wash equipment. The variable cost for this single line is $11 per vehicle. The fixed cost for two wash lines is $23,500 per month or $282,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 $27. 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: 12000 vehicles per year For two wash lines: 14100 vehicles per year b. Annual forecasts of demand for this site ranges from 12,000 to 24,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 Two wash line wash lines $ $ 12,000 vehicles 18,000 vehicles 24,000 vehicles $ $ $

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!