The Laser Computer Printer Company decides monthly what to produce during the subsequent month. They produce three types of printers, the Laser Rocket, the Alpha Laser, and the Laser Omega, which bring them profits of $310, $365, and $465, respectively. The Laser Rocket requires 3 hours of assembly time, and the company always produces at least 30 units per month. The Laser Omega requires 5 hours of assembly time, and the company would like to produce at least 25 of these printers. The Alpha Laser requires only 2.5 hours of assembly time. There are 400 hours of labour available for the month. What is the combination of printers Laser should produce to maximize their profits?
a) Set up this problem as an LP problem showing the data, the objective function and constraints (shown in class)
b) Create an Excel Spreadsheet that reflects your LP problem and solve.
c) Email the Excel model, i.e. the one with the sum product formula to the instructor.