Question

Novacook Ltd makes two types of cooker, one electric and one gas. There are four stages in the production of each of these, with the following features: Manufacturing Time Need (hours per unit) Electric

Manufacturing Stage	Time Needed(hours per unit)		Total time available (hours a week
	Electric	Gas
Forming	4	2	3457
Machine Shop	10	8	11954
Assembly	6	4	5437
Testing	2	2	2106

Each electric cooker has a variable cost of $200 and a selling price of $300, and each gas cooker has a variable cost of $160 and a selling price of $240. Fixed overheads are $60,000 a week and the company works a 50-week year. The marketing department suggest maximum sales of 800 electric and 1,250 gas cookers a week.

a). Formulate this as a linear program (b). find the optimal solution to the problem

• State the Objective function mathematically.
• State the constraints mathematically.
• Setup the model in Excel and use Solver to determine the optimized solution.

Answer 1

Answer: