5 3 Use Excel and or Computer Software QM XYZ, Ltd , has plants in three locations and is currently working on three major construction projects, each located at a different site The shipping cost per truckload of concrete, daily plant capacities, and daily project requirements are provided in the table below FROM TO Project A Project B Project C CAPACIT Y PLANT 1 $10 $4 $11 70 PLANT 2 12 5 8 50 PLANT 3 9 7 6 30 REQUIREMENT 40 50 60 REQUIRED (a) Formulate this problem as a linear program problem to determine the least cost way to meet the requirements (b) Then Solve the problem using any computer software, including Transportation Module from QM (and show the total cost) Specify exactly how the requirements were met

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

Question: 5-3. Use Excel and/or Computer Software/QM. XYZ, Ltd. , has plants in three locations and is currently working on three major construction projects, each located

5-3. Use Excel and/or Computer Software/QM.

XYZ, Ltd., has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of concrete, daily plant capacities, and daily project requirements are provided in the table below.


FROM\TO	Project A	Project B	Project C	CAPACITY
PLANT 1	$10	$4	$11	70
PLANT 2	12	5	8	50
PLANT 3	9	7	6	30
REQUIREMENT	40	50	60

REQUIRED: (a). Formulate this problem as a linear program problem to determine the least cost way to meet the requirements. (b). Then Solve the problem using any computer software, including Transportation Module from QM (and show the total cost). Specify exactly how the requirements were met.

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!

5-3. Use Excel and/or Computer Software/QM. XYZ, Ltd. , has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping...

5-3. Use Excel and/or Computer Software/QM. XYZ, Ltd., has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost...

Use Excel and/or Computer Software/QM. XYZ, Ltd. , has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost per...

please answer all question require , and use computer writing not hand writing . 1. XYZ company has plants in three locations and is currently working on three major construction projects, each...

PART C ONLY!! without using the U-V method 1. XYZ company has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping...

Use U-V Method to optimize the basic feasible solution to evaluate each unused shipping route by computing all improvement indices. Is this solution optimal? The management has decided to increase...

XYZ , Inc. has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of concrete, daily plant...

Question 2 6 XYZ , Inc., has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of concrete,...

XYZ, Inc. has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of concrete, daily plant...

Question 2 6 XYZ , Inc . , has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of concrete,...

The frame of a greenhouse is constructed from uniform aluminum channels. Locate the center of gravity of the portion of the frame shown. 15 m 09 m 0.6 m

For the current year, Accord Company decided to switch from the indirect method to the direct method for reporting cash flows from operating activities on the statement of cash flows. Will the change...

does a decrease in accounts payable belong on the cash flow statement

Explain how to compute 16-19 NNNN 15) 17) 13) 19) Equilibrium Price and Quantity (12 points] Pf = a + Qx P; = it + (SQ): Equilibrium Condition: Pf = P' X For the demand and supply equations above and...