Question

Assembly Line Equipment

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 RoboI, RoboII, and RoboIII). 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:

	Casings Stamped per hour
Machines	Type1	Type2	Type3	Type4	Type5
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:

	Type1	Type2	Type3	Type4	Type5
ProdGoal	3200	2500	3500	3000	2500

In order to most efficiently meet your production needs, how many of each type of machine should you buy, and what is the total cost?

Please show and explain using solver

Answer 1

Below is the screenshot of the LP table -

Below is the screenshot of the formula applied -

Below is the screenshot of the solver -

Below is the screenshot of the result -

From above -

Machine 1 = 8

Machine 2 = 5

Machine 3 = 6

Total Cost = 483000