Consider the Bosch company problem statement and the excel spreadhseet screenshot. Construct production department constraint row 22 using dropdowns.

Drop down 2:

C5:E5, C6:E6, C12:E12, C3:E4, C4:E4, C11:E11, C3:E3, C13:E13, C7:E7

drop down 3:

C11:E11, C11:E12, C12:E12, C13:E13

RHS:

F3, C7, E7, D7, 0, F4

2 1 Paramaters 2 Angle Grinder Electric Drill Cutting Machine Hours Available 3 Production 0.3 0.3 0.4 20,000 4 Assembly 0.3 0.2 0.4 15,000 5 Production Cost $35 $42 $47 6 Purchasing Cost $43 $55 $62 7 Order Amt 20,000 40,000 35,000 8 9 Decision Variables 10 Angle Grinder Electric Drill Cutting Machine 11 Production Amt. 12 Purchasing Amt. 13 Total Amt 14 15 Order Amt 16 17 Objective 18 Total Cost 19 20 Constraints LHS RHS 21 22 23 Production Dep. Assembly LHS: SUMPRODUCT [ Select)