The operations manager for an auto supply company is evaluating the potential purchase of a new machine for the production of a transmission component. Current manufacturing costs are fixed costs of $11,000 and a variable cost of $0.50 per unit. The new machine would have fixed cost of $4,000 and a variable cost of $0.75 per unit. Each component is sold for $1.50 per unit. (use a excel file to show all calculations) 1.Develop two separate models in your spreadsheet to calculate Total Profit for each option.The models must be flexible and able to calculate Total profit for any Quantity produced. 2.Find the break-even quantity for each option 3. Graph the Total profit for each option vs Quantity (both lines on one graph) Show Quantity from 0 to 50,000 4.Write an interpretation of your graph
The operations manager for an auto supply company is evaluating the potential purchase of a new machine for the production of a transmission component. Current
1.Develop two separate models in your spreadsheet to calculate Total Profit for each option.The models must be flexible and able to calculate Total profit for any Quantity produced.
2.Find the break-even quantity for each option
3. Graph the Total profit for each option vs Quantity (both lines on one graph) Show Quantity from 0 to 50,000
4.Write an interpretation of your graph
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images
