Question: Please write the model and solve it using Excel Solver Thank you will upvote :) A company involved in the assembly and distribution of printers
Please write the model and solve it using Excel "Solver" Thank you will upvote :)
A company involved in the assembly and distribution of printers in concerned with two types - laser and inkjet. Assembly of each laser printer takes two hours, while each inkjet printer takes one hour to assemble, and the staff can provide a total of 40 person-hours of assembly time per day. In addition, warehouse space must be available for the assembly and distribution of the printers, 1 square meter for each laser printer and 3 square meters for each inkjet printer; the company has a total of 45 square meters of storage space available for assembled printers each day. Laser printers can be sold for a profit of 35 per unit and inkjet printers earn a profit of 25 each, but the market in which the company is operating can absorb a maximum of 12 laser printers per day. (There is no such limitation on the market for inkjet printers). Formulate this as a linear programming problem in order to maximize daily profit.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
