PLEASE USE THE EXCEL SHEET FOR THE SOLVER CALC. please include workings and answer if you are referencing the sheet

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 3 hours of wiring and 2 hour oi testing and can be sold for a $275 profit. Each alternator requires 3 hours of wiring and 3 hours of testing and can be sold for a $190 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period and Electrotech wants to maximize profit.

Create the spreadsheet model and use Solver to solve the problem.