Question: Given the data in table below: Pennsylvania $30 $16 $25 Virginia Distribution North Centers Carolina South Carolina NY Georgia Ohio Demand $19 $19 $21 25,400

Given the data in table below: Pennsylvania $30 $16 $25 Virginia Distribution North Centers Carolina South Carolina NY Georgia Ohio Demand $19 $19 $21 25,400 DC $10 $13 $22 $23 $12 $26 32,000 Stores Charlotte Philadelphia Chicago $24 $30 $21 $29 $17 $28 24,500 a) Find the fesible solution using the north west strategy. The number of shipments made from Pennsylvania to NY is $24 $22 $10 $22 $23 $17 25,000 $25 $10 $20 $13 $11 $13 18,500 Boston $21 $24 $11 $26 $22 $26 19,500 Capacity 21,000 28,000 19,000 24,000 28,000 25,000 The number of shipments made from South Carolina to Philadelphia is The total cost of the feasible plan is b) Using the solver in Excel with the optimal cost, the optimal plan is 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!

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...

Given the data in table below: Stores Charlotte NY DC Philadelphia Chicago Boston Capacity $10 $13 $22 $24 $30 $21 S24 S22 $10 $25 $10 $20 $21 $24 $11 21,000 28,000 19,000 Pennsylvania $30 Virginia...

Stores Charlotte NY DC Philadelphia Chicago Boston Capacity $10 $13 $22 $24 $30 $21 $24 $22 $10 $25 $10 $20 $21 $24 $11 21,000 28,000 19,000 Distribution Centers Pennsylvania $30 Virginia $16 North...

PLEASE only answer questions 7a and 7b at the TOP of this page, the rest of the information below is merely context. PLEASE ANSWER: 7a) Your client asked you to determine the capacity utilization...

Use the data and the Excel Solver model to answer this question. a) (4 points) Your client asked you to determine the capacity utilization level of the existing distribution system. Compute the...

Help please. I need as much help as possible. In the excel file are all the questions. The first sheet has all the instructions. The sources are also attached. If I could have answers before...

Hello, would you be able to help me analyze the below financial statements and answer requirements 1-6? It is Kohls financial statements for 2014-2015 UNITED STATES SECURITIES AND EXCHANGE COMMISSION...

Hello, I need help with Requirements 1-6. Attached are both financial statements for Kohl's. Is there any way it could be done by tomorrow? UNITED STATES SECURITIES AND EXCHANGE COMMISSION...

Help please. I need as much help as possible. In the excel file are all the questions. The first sheet has all the instructions. The sources are also attached. If I could have answers before...

The atomic mass of element X is 33.42 amu. A 27.22-g sample of X combines with 84.10 g of another element Y to form a compound XY. Calculate the atomic mass of Y.

What are the functions of a Skeleton system?

3 - 3 When a parent - subsidiary relationship exists, consolidated financial statements are prepared in recognition of the accounting concept of Reliablity. Materiality. Legal entity. Economic entity.

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...