Question: Given the data in table below: Stores NY DC Charlotte Philadelphia Chicago Boston Capacity Pennsylvania $30 $10 $24 $24 $25 $21 21,000 Virginia $16 $13

Given the data in table below:

Stores

NY

DC

Charlotte

Philadelphia

Chicago

Boston

Capacity

Pennsylvania

$30

$10

$24

$24

$25

$21

21,000

Virginia

$16

$13

$30

$22

$10

$24

28,000

Distribution

Centers

North Carolina

$25

$22

$21

$10

$20

$11

19,000

South Carolina

$19

$23

$29

$22

$13

$26

24,000

Georgia

$19

$12

$17

$23

$11

$22

28,000

Ohio

$21

$26

$28

$17

$13

$26

25,000

Demand

25,400

32,000

24,500

25,000

18,500

19,500

a) Find the fesible solution using the north west strategy.

The number of shipments made from Pennsylvania to NY is

enter your response here.

The number of shipments made from South Carolina to Philadelphia is

enter your response here.

The total cost of the feasible plan is

enter your response here.

b) Using the solver in Excel with the optimal cost, the optimal plan is

enter your response here

cheaper than the feasible plan obtained using the north west strategy above.

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!