Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 developed. The second line allows for some economies of scale in total cost. The monthly feed cost of one wash line is 515,500 per month or $156,000 per year. This incides the mortgage payment, taxes on the building, and wash equipment. The variable cost for this single line is 514 per vehicle. The fixed cost for two wash lines is $25,500 per month of $300,000 per year, and the variable cost to operate two lines is 511 per vehicle because some wash crews can work both lines. The price of the average interior and exterior car washs 529. 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 me vehicles per year For two wash lines vehides per year b. Annual forecasts of demand for this site ranges from 12,000 to 24,800 per year. Calculate the net profit/loss of the site in each of the following situations. Round your answers to the nearest dollac. If your answer is zero, enter"O". Use a minus sign to enter loss, if any. One Two wash lines wash line $ 5 12,400 vehicles 18,600 vehicles 24,800 vehides 5 $ $ 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Payroll Accounting 2022

Authors: Jeanette Landin

8th Edition

126072879X, 9781260728798

More Books

Students also viewed these Accounting questions