Question: Humber Distribution Centre (HDC) is launching a new Distribution Centre and must buy material handling equipment. It needs to choose between 4 different options,

Humber Distribution Centre (HDC) is launching a new Distribution Centre and must buy material handling 

Humber Distribution Centre (HDC) is launching a new Distribution Centre and must buy material handling equipment. It needs to choose between 4 different options, or a combination of the 4 options. It's objective is to maximize the capacity of the plant, which is measured in number of pallets moved per hour. The equipment that is being considered and capacity is as below. Calculate the capacity in Cell F5. Walkies, 10 pallets per hour. Counterbalance Forklifts (CBFL), 50 pallets per hour 2 Deep Forklifts (2DFL), 85 pallets per hour Autonomous Pallet Carrier (APC), 200 pallets per hour Constraints Budget HDC has $1,500,000 for the capital budget to buy equipment. Walkies cost $50,000 each, CBFL cost $70,000 each, 2DFL cost $85,000 each, and APC cost $200,000 each. Operators. HDC does not want to exceed 20 operators on staff. Walkies need 1 operator, CBFL need 1, 2DFL need 2, and APC need no operators. Maintenance. Maintenance can maintain 30 Walkies. CBFL and 2DFL require twice as much maintenance as Walkies, and APC require 4 times more maintenance as Walkies. Management has decided that to move specific products, it needs at least 4 Walkies, at least 4 CBFL, at least 2 2DFL, and at least 2 APC. The solution should be integers. Use solver to find the combination of equipment that maximizes capacity while meeting all constraints. Use Simplex LP. Keep the Answer report. Answer the 2 questions that start in J22. Enter the first answer in the Green, Accent 6 filled cell 022. Fill the correct answer for question 2 with Green, Accent 6.

Step by Step Solution

3.37 Rating (147 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To solve the optimization problem described we need to use Microsoft Excels Solver addin Here are th... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!