Peaches are to be transported from three orchard regions to two canneries. Intermediate stops at a consolidation station are possible.  Orchard Supply  Station   Cannery Capacity Riverside 1200 Waterford Sanderson 2500 Sunny Slope 1500 Northside Millville 3000 Old Farm 4000         Shipment costs are shown in the table below.  Where no cost is given, shipments are not possible.  Where costs are shown, shipments are possible in either direction.                                         R SS OF W N S M Riverside        5       Sunny Side       4 5     Old Farm       6 3     Waterford           2 4 Northside           5 9 Sanderson               Millville                 Solve the network model for this problem, indicating how much product should move across each route. use spreadsheet as your answer.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

 

  1.  

    Peaches are to be transported from three orchard regions to two canneries. Intermediate stops at a consolidation station are possible. 

    Orchard

    Supply

     Station

      Cannery

    Capacity

    Riverside

    1200

    Waterford

    Sanderson

    2500

    Sunny Slope

    1500

    Northside

    Millville

    3000

    Old Farm

    4000

     

     

     

     

    Shipment costs are shown in the table below.  Where no cost is given, shipments are not possible.  Where costs are shown, shipments are possible in either direction.  
                                       

     

    R

    SS

    OF

    W

    N

    S

    M

    Riverside 

     

     

     

    5

     

     

     

    Sunny Side

     

     

     

    4

    5

     

     

    Old Farm

     

     

     

    6

    3

     

     

    Waterford

     

     

     

     

     

    2

    4

    Northside

     

     

     

     

     

    5

    9

    Sanderson

     

     

     

     

     

     

     

    Millville

     

     

     

     

     

     

     

     

    Solve the network model for this problem, indicating how much product should move across each route. use spreadsheet as your answer.

     

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.