CAN YOU PLEASE SOLVE IN EXCEL AND SHOW PROCESS SOLVE IN EXCEL PLEASE Q4 (20 pts) 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 Production Run Variable Cost per Hose Capacity 1 750 1 25 6000 2 500 1 50 7500 3 1000 1 00 4000 4 300 2 00 5000 a 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 What is the minimized cost What is the optimal value of each decision variable (hint there are 8 decision variables, 4 continuous and 4 binary) b Write the new constraint and solve the problem if machine 3 is used, machine 1 cannot be and vice versa

The Answer is in the image, click to view ...

Question: CAN YOU PLEASE SOLVE IN EXCEL AND SHOW PROCESS. SOLVE IN EXCEL PLEASE !!!!!!!!!!!!!!!!!! Q4 (20 pts) . Westfall Company has a contract to produce

CAN YOU PLEASE SOLVE IN EXCEL AND SHOW PROCESS.

SOLVE IN EXCEL PLEASE !!!!!!!!!!!!!!!!!!

Q4 (20 pts). 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 Production Run	Variable Cost per Hose	Capacity
1	750	1.25	6000
2	500	1.50	7500
3	1000	1.00	4000
4	300	2.00	5000

a.	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. What is the minimized cost? What is the optimal value of each decision variable?(hint: there are 8 decision variables, 4 continuous and 4 binary)
b.	Write the new constraint and solve the problem: if machine 3 is used, machine 1 cannot be and vice versa.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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!

Q4 (20 pts) . 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...

Q4 (20 pts). 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...

Please solve with Excel solver, show excel tables with explanations The Spring family has owned and operated a garden tool and implements manufacturing company since 1 9 5 2 . The company sells...

please solve using EXCEL AND SHOW ALL STEPS/EQUATIONS Mintendo Game Girl It is late June, and Sandra Hachim, head of operations a TABLE 9-8 Costs for Mintendo We R Toys Mintendo, and Bill Smith, head...

When George Terrell died in 1996, he left his business to his three daughters, none of whom was active in the company. Louis Palombo was acting as president of Terrell at that time. For nearly a...

MGMT 3115 EXAM 1 Cal State East Bay By completing and submitting the answer to the exam, the student fully understands the university's policy on academic dishonesty and agree to abide by this...

Solve the following linear programming question using Excel. ( 2 0 Pts ) . A company is involved in the production of two items ( x and Y ) . The resources need to produce x and Y are twofold, namely...

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...

I need help with completing the attached, can you help? FINAL PROJECT TO BE COMPLETED WEEK BY WEEK, COMMENTS REVIEWED, THEN COMPILED IN WEEK 8 FOR GRADING This first intro page (1) can be deleted...

Suppose that you have just retired at the age of 65 with a retirement account that has the net asset value of $ 10 million. Assuming that you will live until the age of 100 (35 years more!). How much...

Let s, t, r be non-zero complex numbers and L be the set of solutions z = x+iy (x, y R, i = -1) of the equation sz +tz+r=0, where Z=x-iy. Then, which of the following statement(s) is (are) TRUE? (A)...

Which three statements are valid reasons for making adjusting journal entries. ( Choose 3 ) To ensure that Accounts Receivable matches Accounts Payable. To record depreciation. To recognize unpaid...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...