Explore BrainMass

QM for windows or excel format of following problem

The Westfall Company has a contract to produce 10,000 garden hoses for a large discount chain. Westfall has four different machines that can produce this kind of hose. Because these machines are from different manufacturers and use differing technologies, their specifications are not the same.

Machine Fixed Cost 2 Set Up Production Run Variable Cost p/h Capacity
1 750 1.25 6000
2 500 1.50 7500
3 1000 1.00 4000
4 300 2.00 5000

a. This problem requires two different kinds of decision variables. Clearly define each kind.
b. The company wants to minimize total cost. Give the objective function.
c. Give the constraints for the problem.
d. Write a constraint to ensure that if machine 4 is used, machine 1 cannot be.

I need step by step guidance on how to set up this problem in QM for windows or in excel please.

Solution Summary

Each variable for the problem is defined. This allows for the company to minimize the total cost for the function.