Please use Excel to complete this assignment. There is an introductory video in the course documents for this unit that describes how to set-up your excel to use the Solver for this. Dr. Gurzick owns a computer store and is looking to determine an optimal amount of inventory. He sells laptops, pcs, and tablets. . each laptop uses 1 processor, 1 hard drive, 3 sticks of ram, and 1 power supply. they sell for 300. each pc uses 2 processor, 2 hard drive, 3 sticks of ram, and 1 power supply. they sell for 500. each tablet uses 1 processor, o hard drives, 2 sticks of ram, and 1 power supply. they sell for 200. on hand I have 500 processors, 300 hard drives, 1000 sticks of ram, and 500 power supplies. Develop a linear programming model for this problem indicating what inventory should be selected to maximize profit. Upload your spreadsheet as your submission