Assignment:
Maxell manufacturing makes three models of pens: Ballpoint pen. fountain pen and roller-ball pen. One lot of ballpoint pen sells for $740. and uses 3120 worth of raw materials and $35 worth of labor cost. One lot of fountain pen sells for $835, and ores $160 worth of raw materials and $11 worth of labor oast. One lot of rollerhall pen sells for $975, and uses $210 worth of raw materials and $.54 worth of labor cost.
Requirenwnt for each lot of pens are given below:
Each month, Maxell has 32 Us. of plastic, 51.25 ft oz. of ink, and 44 labor hours.
Demand for ballpoint and fountain pens are unlimited, but at mast 12 lots of rollerball pens can he numufitct tired each month.
a) Formulate a linear programming model that can be used to determine the number of lots of each model that should be produced in order to give Maxell highest possible monthly profit (Write the complete model for the problem. Make sure to give clear definitions of your decision turiables).
b) Solve the problem by using Excel Solver (Hand-in both the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printouts.