Scribd Logo
Upload

Welcome to Scribd!

  • 212 views

    Cool Wipes

    Uploaded by

    Rohit Sinha
    1. The document analyzes the optimal production network design for CoolWipes to produce wipes and ointment given plant costs and capacities, regional demand, and transportation costs. 2. It shows the production quantities that should be produced at each plant to satisfy demand in each region at the lowest total cost of $85,102.40. 3. The optimal solution has the Princeton, NJ and Atlanta plants open at full capacity while satisfying all demand and minimizing unused plant capacity and unsatisfied demand.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Cool Wipes

    Uploaded by

    Rohit Sinha
    212 views8 pages
    1. The document analyzes the optimal production network design for CoolWipes to produce wipes and ointment given plant costs and capacities, regional demand, and transportation costs. 2. It shows the production quantities that should be produced at each plant to satisfy demand in each region at the lowest total cost of $85,102.40. 3. The optimal solution has the Princeton, NJ and Atlanta plants open at full capacity while satisfying all demand and minimizing unused plant capacity and unsatisfied demand.

    Original Title

    CoolWipes.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document analyzes the optimal production network design for CoolWipes to produce wipes and ointment given plant costs and capacities, regional demand, and transportation costs. 2. It shows the production quantities that should be produced at each plant to satisfy demand in each region at the lowest total cost of $85,102.40. 3. The optimal solution has the Princeton, NJ and Atlanta plants open at full capacity while satisfying all demand and minimizing unused plant capacity and unsatisfied demand.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    212 views8 pages

    Cool Wipes

    Uploaded by

    Rohit Sinha
    1. The document analyzes the optimal production network design for CoolWipes to produce wipes and ointment given plant costs and capacities, regional demand, and transportation costs. 2. It shows the production quantities that should be produced at each plant to satisfy demand in each region at the lowest total cost of $85,102.40. 3. The optimal solution has the Princeton, NJ and Atlanta plants open at full capacity while satisfying all demand and minimizing unused plant capacity and unsatisfied demand.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 8

    Designing the Production Network at CoolWipes

    Plant Costs and Capacity


    Wipes Ointment
    Variable Variable
    Fixed Cost Capacity Fixed Cost
    Plant Cost/unit Cost/unit
    Chicago 5000 10 5000 1500 20
    Princeton, NJ 2200 10 2000 1500 20
    Atlanta 2200 10 2000 1500 20
    LA 2200 10 2000 1500 20

    Regional Demand by Product


    Northwest Southwest Upper midwest Lower Midwest Northeast
    Zone
    Wipes 500 700 900 800 1000
    Ointment 50 90 120 65 120

    Transportation Costs
    Northwest Southwest Upper Midwest Lower Midwest Northeast

    Chicago 6.32 6.32 3.68 4.04 5.76


    Princeton, NJ 6.60 6.60 5.76 5.92 3.68
    Atlanta 6.72 6.48 5.92 4.08 4.04
    LA 4.36 3.68 6.32 6.32 6.72

    Wipes Variables
    Northwest Southwest Upper Midwest Lower Midwest Northeast

    Chicago 0 0 0 0 0
    Princeton, NJ 0 0 900 0 1000
    Atlanta 0 0 0 800 0
    LA 500 700 0 0 0
    Unsatisfied 0 0 0 0 0
    Demand

    Ointment Variables
    Northwest southwest Upper Midwest Lower Midwest Northeast

    Chicago
    Princeton, NJ
    Atlanta
    LA
    Unsatisfied
    Demand
    twork at CoolWipes

    intment Total Cost 70,668.00

    Capacity

    1000
    1000
    1000
    1000

    t
    Southeast
    Total
    600 4500
    70 515

    Southeast
    5.96
    4.08
    3.64
    6.60

    bles
    Unutilized
    Total Plant Open
    Southeast Built
    Production (Yes/No)? Capacity
    0 0 0 0
    0 1900 1 100
    600 1400 1 600
    0 1200 1 800
    0

    ables
    Total Unutilized
    Southeast Production Plant Open Built
    (Yes/No)? Capacity
    Designing the Production Network at CoolWipes
    Plant Costs and Capacity
    Wipes Ointment
    Variable Variable
    Fixed Cost Capacity Fixed Cost
    Plant Cost/unit Cost/unit
    Chicago 5000 10 5000 1500 20
    Princeton, NJ 2200 10 2000 1500 20
    Atlanta 2200 10 2000 1500 20
    LA 2200 10 2000 1500 20

    Regional Demand by Product


    Northwest Southwest Upper midwest Lower Midwest Northeast
    Zone
    Wipes 500 700 900 800 1000
    Ointment 50 90 120 65 120

    Transportation Costs
    Northwest Southwest Upper Midwest Lower Midwest Northeast

    Chicago 6.32 6.32 3.68 4.04 5.76


    Princeton, NJ 6.60 6.60 5.76 5.92 3.68
    Atlanta 6.72 6.48 5.92 4.08 4.04
    LA 4.36 3.68 6.32 6.32 6.72

    Wipes Variables
    Northwest Southwest Upper Midwest Lower Midwest Northeast

    Chicago 0 0 0 0 0
    Princeton, NJ 0 0 900 0 1000
    Atlanta 0 0 0 800 0
    LA 500 700 0 0 0
    Unsatisfied 0 0 0 0 0
    Demand

    Ointment Variables
    Northwest southwest Upper Midwest Lower Midwest Northeast

    Chicago 0 0 0 0 0
    Princeton, NJ 0 0 0 0 0
    Atlanta 50 90 120 65 120
    LA 0 0 0 0 0
    Unsatisfied 0 0 0 0 0
    Demand
    twork at CoolWipes

    intment Total Cost 85,102.40

    Capacity

    1000
    1000
    1000
    1000

    t
    Southeast
    Total
    600 4500
    70 515

    Southeast
    5.96
    4.08
    3.64
    6.60

    bles
    Unutilized
    Total Plant Open
    Southeast Built
    Production (Yes/No)? Capacity
    0 0 0 0
    0 1900 1 100
    600 1400 1 600
    0 1200 1 800
    0

    ables
    Total Unutilized
    Southeast Production Plant Open Built
    (Yes/No)? Capacity
    0 0 0 0
    0 0 0 0
    70 515 1 485
    0 0 0 0
    0

    You might also like