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 2017. The labor (installation hours), tubing requirements, and profit of the two systems are outlined in the following table. Using the Solver tool in Excel, determine the number of A vs. B systems that the company should plan to sell in 2017 in order to maximize total profit. The company estimates that it can provide 1566 hours of labor and 2880 feet of tubing throughout the entire year. Furthermore, the company has 200 pumps for the entire year. Document your work in Excel by adding text boxes with comments and also take a screen shot (Start menu rightarrow Snipping Tool or similar) of the completed Solver box and paste this image onto your spreadsheet. 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 2017. The labor (installation hours), tubing requirements, and profit of the two systems are outlined in the following table. Using the Solver tool in Excel, determine the number of A vs. B systems that the company should plan to sell in 2017 in order to maximize total profit. The company estimates that it can provide 1566 hours of labor and 2880 feet of tubing throughout the entire year. Furthermore, the company has 200 pumps for the entire year. Document your work in Excel by adding text boxes with comments and also take a screen shot (Start menu rightarrow Snipping Tool or similar) of the completed Solver box and paste this image onto your spreadsheet