can you please use excel to solve for this problem?

E8.13 - Using Excel to Allocate Constrained Resources PROBLEM Umbrella Co. is considering the introduction of three new products. Per unit sales and cost information are as follows: Sales price Variable costs Fixed costs Labor hours per unit Monthly demand in units A B $ 3.00 $ 5.00 $ 16.00 $ 1.20 $ 3.40 $ 10.00 $ 0.50 $ 1.00 $ 3.50 0.75 1.25 2.00 800 650 250 The company has only limited direct labor hours available to commit to production of any new products. Labor hours available 1,500 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. How many of each product should Umbrella Co. produce and sell to maximize its profit? Contribution margin per unit A $ 1.80 B $ 1.60 C $ 6.00 Contribution margin per labor hour 2.40 1.28 3.00 Preference ranking #2 #3 #1 Allocation Ranking Units to Produce Product Hours Used Hours Availabl 1,500 1000 #1 C 250 500 #2 A 800 600 188 #3 B 320 400