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 to Set Up Product Run	Variable Cost per Hose	Capacity
1	750	1.25	6000
2	500	1.50	7500
3	1000	1.00	4000
4	300	2.0	5000

The company wants to minimize total cost. Clearly define the decision variables for this problem. Give the objective function and the constraints for the problem and solve the problem.

A) What is the minimized cost? What is the optimal value of each decision variable?(hint: there are 8 decision variables: 4 continuous variables on how much to produce, and another 4 binary variables on which machines to use)

B) Write the new constraint and solve the problem: if machine 3 is used, machine 1 cannot be and vice versa

**Please do this in excel with detailed explanations