Problem 2 Cost-Volume Analysis - All analysis and calculations and report must be done in a single (ONE) Excel file. - Put your name at the top of the worksheet. - Make Excel do all of the calculations. . (Instructor must be able to see your cell-reference formulas.) - Include graph interpretation below the graph. Make sure it is clear, complete, and easy to find. 2. 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. a. 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. b. Find the break-even quantity for each option c. Graph the Total profit for each option vs Quantity (both lines on one graph) Show Quantity from 0 to 50,000 d. Write an interpretation of your graph