1. Consider Electo-Poly problem statement and the excel spreadsheet screenshot above. Construct "Total Cost" (Cell C22) using dropdowns.

Total Cost: [ Select ] ( ["=(", "=SUM(", "=PRODUCT(", "=SUMPRODUCT("] )

[ Select ] ["C5:E6", "C9:E9", "C6:E6", "C8:E9", "C8:E8", "C17:E17", "C5:E5", "C11:E11", "C16:E16", "C15:E15"]

[ Select ] [", C15:E15)", ", C17:E17)", ", C15:E16)", ", C16:E16)"]

Choose 1 of each answer choices above to make the equation.

2. Consider Electo-Poly problem statement and the excel spreadsheet screenshot above. Construct "Wiring" constraint (Row 25) using dropdowns.

LHS: [ Select ] ["=(", "=PRODUCT(", "=SUMPRODUCT(", "=SUM("]

[ Select ] ["C6:E6", "C8:E8", "C5:E5", "C9:E9", "C15:E15", "C11:E11", "C17:E17", "C16:E16"]

[ Select ] [", C16:E16)", ", C15:E15)", ", C17:E17)"]

Relation: [ Select ] ["=", ">"]

RHS: [ Select ] ["C11", "E11", "D11", "F6", "0", "F5", "C22"]

Choose 1 of each answer choices above.

3. Consider Electo-Poly problem statement and the excel spreadsheet screenshot above. Construct "Harnessing" constraint (Row 26) using dropdowns.

LHS: [ Select ] ["=(", "=SUM(", "=SUMPRODUCT(", "=PRODUCT("]

[ Select ] ["C16:E16", "C11:E11", "C9:E9", "C17:E17", "C15:E15", "C5:E5", "C6:E6", "C8:E8"]

[ Select ] [", C17:E17)", ", C16:E16)", ", C15:E15)"]

Relation: [ Select ] [">=", ">", "

RHS: [ Select ] ["E11", "C22", "C11", "0", "F6", "F5", "D11"]

Choose 1 of each answer choices above.

1 Input parameters 2 3 Total Model 3 Available 4 Model 1 Model 2 5 2 1.5 3 10000 Wiring Harnessing 1 2 1 5000 7 Production Cost Procurement Cost $50 $61 $83 $97 $130 $145 0 000 OEM Demand 3,000 2,000 900 13 Decision Variables 14 Model 1 Model 2 Model 3 15 16 17 # of units Produced # of units procured Total units 18 19 Demand 20 21 Objective 22 Total Cost 23 24 Subject to LHS 25 Wiring 26 Harnessing RHS