Question

04. A supplied to four markets C. D, E, and F. the manufacturer wants to know the pattern shipment from each production plant

continuation of the question:-

From origin 2 to Destination 4 = 4
Solve the problem using transportation method and determine the total transportation costs associated with the optimal schedule.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The model is shown below

SUMPRODUCT(B2:E3,B8:E9) Destination 1 Destination 2 Destination 3 Destination 4 Capacity 2 Origin 1 3 Origin 2 6 10 300 1000

The formulas used is shown below

A1 Destination 1 Destination 2 Destination 3 Destination 4 Capacity Origin 1 Origin 2 10 300 1000 1200 1700 Destination 1 Ass

The solver parameters are shown below

Solver Parameters | X﹀fz -SUMPRODUCT(B2:E3,B8E9) Set Objective: To: Mak Ey Changing Variable Cells: Destination 1 Destination

The result is shown below. It is highlighted in yellow.

SUMPRODUCT (B2:E3,B8:E9 Destination 1 Destination 2 Destination 3 Destination 4 Capacity 2Origin 1 Origin 2 6 3000 10 1000 12

Add a comment
Know the answer?
Add Answer to:
continuation of the question:- From origin 2 to Destination 4 = 4 Solve the problem using...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT