An electronics company makes generators and alternators. Both products require wiring and testing during their assembly processes. Each generator requires 2 hours of wiring and 1 hour of testing, while each alternator requires 3 hours of wiring and 2 hours of testing. Each generator has a profit of $250, and each alternator has a profit of $150. The company has 260 hours of wiring time and 140 hours of testing time available in the next production period, and they want to select the product mix that will maximize their profit. a. (5 points) Create a worksheet called Electronics. Use a textbox to define your variables, and write out an algebraic LP formulation for this problem. b. (10 points) On the Electronics worksheet, create a spreadsheet model for this problem and run Solver to find the optimal solution. c. (5 points) When running Solver, ask for a Sensitivity Report, and name that worksheet Electronics Sensitivity. d. (5 points) On the Electronics worksheet, indicate how much (if any) unused wiring and testing capacity exists. e. (5 points) Use shadow prices to predict the new optimal profit if 10 additional hours of wiring capacity are obtained. Put your answer and reasoning on the Electronics worksheet