Question

The Magnetron Company manufactures and markets microwave ovens. Currently, the company

produces two models: full-size and compact. Production is limited by the amount of labor

available in the general assembly and electronic assembly departments, as well as by the demand

for each model. Each full-size oven requires 2 hours of general assembly and 2 hours of

electronic assembly, whereas each compact oven requires 1 hour of general assembly and 3

hours of electronic assembly. In the current production period, there are 500 hours of general

assembly labor available and 800 hours of electronic assembly labor available.

In addition, the company estimates that it can sell at most 220 full-size ovens and 180 compact

ovens in the current production period. The earnings contribution per oven is $120 for a full-size

oven and $130 for a compact oven. The company would like to find an earnings-maximizing

production plan for the current production period.

Formulate the above problem as a linear optimization model and solve via Excel’s solver. Please

turn in both a written formulation and an Excel file with the solution.

PLEASE SHOW ME WHAT TO PUT IN LHS AND SOLVER AS IN WHAT FORMULAS???

I have the following so far but I DONT KNOW HOW TO SOLVE FOR LHS AND WHAT TO PUT IN SOLVER IN EXCEL:

	Let the number of full size oven to be produced be F and number of compact size oven produced be C
	The objective function is:
									Full size oven	Compact size oven
	Maximize: 120F + 130C								2	3
	subject to:
	1. 2 F + C <= 500; Hours of general assembly
	2. 2F + 3C <=800 ; Hours of electronic assembly
	3. F <= 220; Number of full size ovens that can be sold
	4. C <= 180; Number of compact size ovens that can be sold
	Full oven	Compact oven
Optimal no to be made	1	1
Contribution	120	130
Total contribution	250	maximize
			Constraints	LHS	RHS
			General Assembly	3	500
			Electronic Assembly	5	800
			Demand of full ovens	1	220
			Number of compact ovens	1	180

Answer 1

The following formulation format can be used.

Final solution

	Full	Compact
No. of	175	150
Profit	$120	$130	$40,500
Subject to,
General assembly	2	1	500	<=	500
Electronic assembly	2	3	800	<=	800
Demand for Full	1	0	175	<=	220
Demand for Compact	0	1	150	<=	180