Student Work Area Required: Provide input into cels shaded in yelow in this template Use mathematical formulas wah cek references to the Problem or work area as indicated E8.13 - Using Excel to Allocate Constrained Resources PROBLEM Umbrela Co a considering the introduction of three new products. Per und sales and cost information are as follows A 3 C Sales price $ 3.00 55.00 5 16.00 Variable costs $ 1205 3.40 510.00 Fored costs $ 0.50 $ 1.00 $3.50 Labor hours per unit 0.75 1.25 2.00 Monthly demand in units 300 650 250 How many of each product should Umbrello Co produce and set to maximize its proft? A B C 118011160 1600 Contribution margin perunt Contribution margin per labor hour Preference ranking The company has only med direct labor hours available to commit to production of any new products 240 128 3.00 N2 43 #1 Labor hours available 1,500 Hours Allocation Ranking Product Units to Produce Used Hours Avabi 1,500 1000 31 250 500 A 800 5001 2 B 320 400