"product mix" problem can be solved quite easily by hand, as long as there is only one constraint (i.e. one resource in which demand > capacity). However, when there are multiple constraints it becomes quite complex.

Set up a model based on finding the optimal product mix for the problem in the above spreadsheet . What was the resulting total profit?

		less than $35,000
		between $35,000 and $35,250
		between $35,250 and $35,500
		between $35,500 and $35,750
		between $35,750 and $36,000
		more than $36,000

A B F 1.55 2 0.8 Product D E Doo-hickey 1.05 2.46 3.6 1.79 0.65 Time required on Simegma 0.58 1.3 2.05 1.5 0.98 each workstation Thing-a-ma-jig 0.82 1.7 1.95 1.99 (minutes required per 1.01 unit of production) Whatchamacallit 0.88 2.14 3.05 2.58 1.55 Prototon 2000 1.04 1.24 1.15 3.07 1.04 Forecast demand per week 250 280 280 210 160 Profit margin per unit $ 14.00 $ 33.00 $ 45.00 $ 38.00 $ 16.00 $ * assume that each machine has 40 hours/week of capacity (2,400 minutes) *assume that production of a specific product should not exceed demand for that product *add a constraint that all production quantities must be integers *use the "Simplex LP"Solving Method in Solver 1.2 2.2 110 28.00