Question

Problem 6-13 Sports of All Sorts produces, distributes, and sells high-quality skateboards. Its supply chain consists of thre

Build a model to minimize the transportation cost of a logistics system that will deliver skateboards from the factories to the distribution centers and from the distribution centers to the retailers. What is the optimal production strategy and shipping pattern for sports of All sorts?

Let Xi,j represents relation between factories to warehouses or relation between warehouses to retailers. If constant is "1", it must be entered in the box. Enter "0" if your answer is zero.

Min x1,4 + x1,5 + x1,6 + x1,7 + x2,4 + x2,5 + x2,6 + x2,7 + x3,4 + x3,5 + x3,6 + x3,7 + x4,8 + x4,9 + x4,10 + x5,8 + x5,9 + x5,10 + x6,8 + x6,9 + x6,10 + x7,8 + x7,9 + x7,10
subject to
x1,4 + x1,5 + x1,6 + x1,7
x2,4 + x2,5 + x2,6 + x2,7
x3,4 + x3,5 + x3,6 + x3,7
x1,4 + x2,4 + x3,4 + x4,8 + x4,9 + x4,10
x1,5 + x2,5 + x3,5 + x5,8 + x5,9 + x5,10
x1,6 + x2,6 + x3,6 + x6,8 + x6,9 + x6,10
x1,7 + x2,7 + x3,7 + x7,8 + x7,9 + x7,10
x1,4 + x2,4 + x3,4
x1,5 + x2,5 + x3,5
x1,6 + x2,6 + x3,6
x1,7 + x2,7 + x3,7
x4,8 + x5,8 + x6,8 + x7,8
x4,9 + x5,9 + x6,9 + x7,9
x4,10 + x5,10 + x6,10 + x7,10
xi,j   0 for all i and j


What is the minimum attainable transportation cost? If required, round your answer to the nearest dollar.

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

А O Maryland Idaho Arkansas 42.5 Maryland Arkansas 35 27.5 32.5 40 30 32.5 Maryland Idaho Arkansas From To lowa Detroit Los A

21 Constraints 22 =SUM(B11:E11) 23 =SUM(B12:E12) 24 =SUM(B13:E13) 25 =SUM(B11:B13) 26 =SUM(C11:C13) 27 =SUM(D11:013) 28 =SUM(

3 40 D Idaho 35 35 42.5 Idaho 35 40 32.5 E Arkansas 40 42.5 32.5 Arkansas 27.5 25 42.5 B C From To lowa Maryland Detroit 25 L

Constraints . 200 500 650

Helbs SS Solver Parameters Set Objective: SAS20 To: O Max Min value of: 0 By Changing Variable Cells: $B$11:$E$13,5B$15:$E$17

Idaho Arkansas 10 11 0 0 13 14 Idaho Decision Variables From To lowa Maryland Detroit 300 50 Los Angeles 1 350 0 Austin 0 To

Add a comment
Answer #2
DC Iowa is considering expanding capacity to 800 units per week. It is worth expanding Should the company expand the capacity of the Iowa Distribution Center (Iowa) to be able to distribute US $ 40,000 800 skateboards per week? (Assume 50 work weeks per year).
answered by: Marimabdelaziz
Add a comment
Know the answer?
Add Answer to:
Build a model to minimize the transportation cost of a logistics system that will deliver skateboards...
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
  • PLEASE POST IN STEP BY STEP EXCEL FORM! (POST EXCEL SPREADSHEET IF POSSIBLE) Problem 6-13 Sports ...

    PLEASE POST IN STEP BY STEP EXCEL FORM! (POST EXCEL SPREADSHEET IF POSSIBLE) Problem 6-13 Sports of All Sorts produces, distributes, and sells high-quality skateboards. Its supply chain consists of three factories (located in Detroit, Los Angeles, and Austin) that produce skateboards. The Detroit and Los Angeles facilities can produce 350 skateboards per week, but the Austin plant is larger and can produce up to 700 skateboards per week. Skateboards must be shipped from the factories to one of four...

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