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 Alpha Laser requires only 2.5 hours of assembly time.
The Laser Omega requires 5 hours of assembly time, and the company would like to produce at least 25 of these printers.
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 above data, the objective function and constraints
b) Solve it by using Excel