Instructions Nuttelman Energy Innovations is a fine producer of geothermal systems. The company makes only two types of systems: System A and System B. Both systems use the same pump and the company is capable of selling all systems in the calendar year. The user should be able to enter the Constraints (Total hours of labor, Feet of tubing, and/or Total no. pumps) in the second table below as well as change the Profit of either system in cells D5 and D6. Installation hours and Tubing requirements of the two systems are outlined in the top table. E A B C D 1 Assignment 4 2 3 *Do NOT change location of any of the cells below! Installation Tubing System hours required (ft) Profit 5 A 9 12 $3,500 6 B 6 $3,000 16 ON 00 8 Constraints 9 1566 Total hours of labor 10 2880 Feet of tubing 11 2/discussion Prompt/Jeniu/assignment-4-discussion GRADE 200 Total no. pumps MacBook Pro LUIISLIOTBILS 9 GRADE 10 1566 Total hours of labor 2880 Feet of tubing 200 Total no. pumps 11 12 13 14 15 16 No. A No. B Your goal is to use the Solver tool to determine the number of System A (No. A, cell C14) and System B (No. B, cell C15) to install during the calendar year to maximize total profit. You may use other areas of the worksheet for intermediate calculations as long as No.A and No. show up in cells C14 and C15, respectively. When you feel that everything is set up correctly and you have run the Solver correctly to calculate No. A and No. B, you can click on the GRADE button. If you are correct, the completion code will be presented to you, which you can enter into the Assignment 4 submission quiz on the Coursera site. HINTS: Remember, what you are trying to maximize is the TOTAL PROFIT-a big hint is to come up with a single equation for profit as a function of No. A and No.B. The total number of systems A vs. B will be constrained by the Total hours of labor and the Feet of tubing, as well as the Total no. pumps NOTE: The grader file relies on your previous Solver attempt (it just reopens and re-runs the Solver tool with your previous results stored within it). So, make sure that you've already run the Solver tool prior to clicking on the GRADE button. part-2/discussion Prompt/Jeniufassignment-4-discussion