Question

Goal Programming

Your Company makes five types of metal casings for laptops, and you are in the process of replacing your current equipment with state-of-the-art stamping machines (the Robo I, Robo II, and Robo III). The machines cost $18,500, $25,000, and $35,000 respectively. Once you program each machine, it can stamp the following number of each type of casing per hour:

Machines	Type 1	Type 2	Type 3	Type 4	Type 5
I	100	130	140	210	80
II	265	235	170	220	120
III	200	160`	260	180	220

You have the following hourly production demands for each type of casing:

	Type 1	Type 2	Type 3	Type 4	Type 5
ProdGoal	3200	2500	3500	3000	2500

If your budget is capped at $400,000., what selection of machines will allow you to come closest to your goal in terms of having the smallest number of unmet demands?

Please show and explain using solver and show formula setups in excel

Answer 1

solver

end results