Question 2: To establish a driving education school, organizers must decide how
ID: 3195339 • Letter: Q
Question
Question 2:
To establish a driving education school, organizers must decide how many cars, instructors, and students to have. Costs are estimated as follows. Annual fixed costs to operate the school are $29,000. The annual cost per car is $3000. The annual cost per instructor is $11,000 and one instructor is needed for each car. Tuition for each student is $250. Let x be the number of cars and y be the number of students.
a.
Write an expression for total cost.
b.
Write an expression for total revenue.
c.
Write an expression for total profit.
d.
The school offers the course eight times each year. Each time the course is offered, there are two sessions. If they decide to operate five cars, and if four students can be assigned to each car, will they break even? In addition to algebraic solution, use excel Goal Seek function to find optimal point.
For part D if it can be done on EXCEL and shown steps on how to do it on excel. Thanks
a.
Write an expression for total cost.
b.
Write an expression for total revenue.
c.
Write an expression for total profit.
d.
The school offers the course eight times each year. Each time the course is offered, there are two sessions. If they decide to operate five cars, and if four students can be assigned to each car, will they break even? In addition to algebraic solution, use excel Goal Seek function to find optimal point.
Explanation / Answer
a. The total cost will be $ (29,000 + 3,000*x + 11,000*x)
b. The total revenue will be $ (250*y)
c. Total Profit = Total revenue - Total cost = $ [(250*y) - (29,000 + 3,000*x + 11,000*x)]
d. Number of cars = 5, Number of students = 4*5*2*8 = 320
=> Total Profit = $ [(250*320) - (29,000 + 3,000*5 + 11,000*5)] = -19,000 $
This means the school is not going to break even
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.