PLEASE HELP USE THE SOLVER MODEL SOLVE THIS QUESTION USING EXCEL AND THIS EXACT TEMPLATE . PLEASE INCLUDE EXCEL WORKINGS

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.