in the quantities shown in the table. The super assembly facility would ship to distribution centers located in Seattle, Lubbock, Nashville, and Philadelphia. The locations of all of these cities on an x - y grid, transportation costs on a ton per mile basis, and total tonnage are all contained in the table. \ begin { tabular } { | l | l | l | l | l | } \ hline Sources / Markets & Transportation Cost \ $ / ton mile ( Fn ) & Quantity in Tons ( Dn ) & Xn & Yn \ \ \ hline Supply & & & & \ \ \ hline North Haverbrook & 1 . 1 & 6 5 0 & 7 0 0 & 1 2 0 0 \ \ \ hline Ogden & 1 . 2 & 4 5 0 & 2 5 0 & 6 0 0 \ \ \ hline Springfield & 1 . 4 & 4 0 0 & 2 2 5 & 8 2 5 \ \ \ hline Market & & & & \ \ \ hline Seattle & 2 . 2 5 & 3 0 0 & 5 0 & 1 2 0 0 \ \ \ hline Lubbock & 2 . 2 5 & 2 0 0 & 4 5 0 & 3 0 0 \ \ \ hline Nashville & 2 . 2 5 & 5 0 0 & 8 0 0 & 2 5 0 \ \ \ hline Philadelphia & 2 . 2 5 & 5 0 0 & 9 5 0 & 1 1 0 0 \ \ \ hline \ end { tabular } This question include multiple subquestions, in order to earn full credit, answer all subquestions. Show your calculation or Excel output. a ) What is the distance between Ogden and Lobbock locations? ( 1 0 points ) b ) What is the cost to transport 4 0 0 tons of material between the Springfild and Seattle location? ( 1 0 points ) c ) What is the optimal location for the Super Assembly Center? ( 1 0 points ) d ) What is the minimized shipping cost that satisfies all market demand? ( 1 0 points )
Question:
in the quantities shown in the table. The super assembly facility would ship to distribution centers located in Seattle, Lubbock, Nashville, and Philadelphia. The locations of all of these cities on an x - y grid, transportation costs on a ton per mile basis, and total tonnage are all contained in the table. \ begin { tabular } { | l | l | l | l | l | } \ hline Sources / Markets & Transportation Cost \ $ / ton mile ( Fn ) & Quantity in Tons ( Dn ) & Xn & Yn \ \ \ hline Supply & & & & \ \ \ hline North Haverbrook & 1 . 1 & 6 5 0 & 7 0 0 & 1 2 0 0 \ \ \ hline Ogden & 1 . 2 & 4 5 0 & 2 5 0 & 6 0 0 \ \ \ hline Springfield & 1 . 4 & 4 0 0 & 2 2 5 & 8 2 5 \ \ \ hline Market & & & & \ \ \ hline Seattle & 2 . 2 5 & 3 0 0 & 5 0 & 1 2 0 0 \ \ \ hline Lubbock & 2 . 2 5 & 2 0 0 & 4 5 0 & 3 0 0 \ \ \ hline Nashville & 2 . 2 5 & 5 0 0 & 8 0 0 & 2 5 0 \ \ \ hline Philadelphia & 2 . 2 5 & 5 0 0 & 9 5 0 & 1 1 0 0 \ \ \ hline \ end { tabular } This question include multiple subquestions, in order to earn full credit, answer all subquestions. Show your calculation or Excel output. a ) What is the distance between Ogden and Lobbock locations? ( 1 0 points ) b ) What is the cost to transport 4 0 0 tons of material between the Springfild and Seattle location? ( 1 0 points ) c ) What is the optimal location for the Super Assembly Center? ( 1 0 points ) d ) What is the minimized shipping cost that satisfies all market demand? ( 1 0 points )
Asked by: Test User 100000
Created at: 2025-09-17 13:35:09
Final Answer:
📢 Instructions:
- Ask anything relatd to above question only.
- For new Question goto :
VIPSolutions