This assignment involves using linear programming to determine the optimal production quantities for two industrial electrical devices based on available resources and profitability.

The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each alternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period. Electrotech wants to find out how many of each device to produce to maximize profit.
a. Formulate an LP mathematical model (equation systems) for this problem
b. Implement your model in a spreadsheet and solve it
c. Report your optimal solution using plain English without technical terminologies
Please follow the format in the sample assignment files (attached) and submit one Word file AND one Excel file for this problem.