Hello! I need assistance with parts D ans E

You are the operations manager over a production line that manufactures, assembles, and packages three types of products: A, Band C. The specifications are illustrated in the following table: Specification Product A Product B Volume produced and sold items) 7500 4500 Unit sales price($/item) 3 7.5 Total Variable Expenses ($) 11250 13950 The total fixed costs are $6,000. Product C has doubled costs than that of A or B. Product C 1500 16.5 16950 Obtain the following information using Excel. Then, perform an analysis to the results obtained. a. The Break-even point of production and sales of each product b. The profit for each product type. C. Plot the profit graphs for all of the products using 'what-if' sensitivity analysis algorithm in Excel d. Determine and interpret the gross margin rate Determine and interpret the critical turnover (in $) e Volume Unit Sales R Total VC FC V Per unit Product A 7500 S 3.00 S 11,250.00 S 1,500.00 S 1.50 Volume_Q Unit Sales_R Total VC FC v per unit Product B 4500 $ 7.50 $ 13,950.00 $ 1,500.00 $ 3.10 Volume_Q Unit Sales R Total VC FC v per unit Product C 1500 $ 16.50 $ 16,950.00 $ 3,000.00 $ 11.30 BEP 1000 BEP 340.9090909 BEP 576.9230769 Profit S 9.750.00 Profit $ 18,300.00 Profit $ 4.800.00 Q P Q P O S P $ 0 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 5500 6000 6500 7000 7500 8000 8500 9000 9500 10000 10500 9,750.00 -1500 -750 0 750 1500 2250 3000 3750 4500 5250 6000 6750 7500 8250 9000 9750 10500 11250 12000 12750 13500 14250 $ 0 5001 1000 1500 2000 25001 3000 3500 4000 4500 5000 5500 6000 6500 7000 7500 8000 8500 90001 9500 10000 105001 18,300.00 - 1500 700 2900 5100 7300 9500 11700 13900 16100 183001 205001 22700 24900 27100 29300 31500 337001 359001 38100 403001 42500 44700 500 1000 1500 2000 2500 3000 3500 40001 4500 5000 5500 6000 6500 7000 7500 8000 8500 9000 9500 10000 10500 4.800.00 -3000 -400 2200 4800 7400 10000 12600 15200 17800 20400 23000 25600 28200 30800 33400 36000 38600 41200 43800 46400 49000 51600