Question

VISIO PLUS, Inc, is producing for the next summer season two models of sunglasses, the Tiger and thePanther. Both models are produced using the same numerically controlled machine.The machine can be operated for a maximum of 40hours a week to produce these models.Due to the different shape of these products, the machine can produce 50 units of the Tiger model per hour, or 25 units of Panther model per hour. It is possible to sell weekly 1 000 units of the Tiger, and 800 units of the Panther .The raw material used in production, cellulose acetate, is currently hard to find. The supply of 2/5cellulose acetate is limited to 3.5 kilograms a week, at least for the next few weeks. In order to produce one unit of Tiger 30 grams of cellulose acetate are needed.For one unit of Panther, 20 grams are enough.The profit contribution of a pair of Tiger is 24 €.For a pair of Panther, the profit contribution is 30 €.The problem is to maximize the profit, by sharing the production capacity between the two models.1) Formulate the problem as a Linear programming problem.2) Using the Excel Solver, find the optimal production program.3) If the « optimal » production program is implemented, Would the company use up the whole weekly supply of cellulose acetate? Would the machine be operated to full capacity? Would it be possible to sell more Tiger sunglasses? more Panther sunglasses? (PS please do the exercise on excel)

Answer 1

ANSWER :

PLEASE LEAVE A THUMBS UP IF THIS ANSWER HELPS YOU.

THANK YOU:)