please use the excel sheet only , i have to use the excel sheet template. PLEASE USE THE SOLVER FOR THE EXCEL SHEET. i am only interested in the solver model using EXCEL.

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 of 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. ( please show all workings using excel , especially the optimal value . please use the excel template )

PLEASE INCLUDING DETAILED WORKINGS FOR EVERY NUMBER

SOLVER MODEL X1 X2