Request clarification:
Expert:
We don't deal with spreadsheet we can only answer part 1
User:
Formulate the LP model for this problem.Answer:
3G + 3A ≤ 260Step-by-step explanation:
Let the No. of Alternators manufactured be A and No. of Generators be G
Total Profit = 275G + 190A
We have to maximize this profit Subject to constraints
LP model formula,
3G + 3A ≤ 260............Constraint for available wiring hours
2G + 3A ≤140 ............ Testing for available wiring hours