供应链管理英文 Coolwipes Case

ThetotalcosttoservetheentirenationfromChicagois$32,661.40asillustratedbelow:PlantCostsandCapacityWipesOintmentPlantFixedCostVariableCost/unitCapacityFixedCostVariableCost/unitCapacrtyChicago500010533015002C1000Princeton,NJ22001020001500201000Atlanta22001020001500201000LA22001020001500201000RegionalDemandbyProductZoneNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTotalWipes500700S3：80010006004500Ointment50901206512070515TransportationCostsNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTranspor1tcostMultiplie|Chicago6.326.323.684.045.765.96JPrinceton,NJ6.606.605.765.923.684.08Atlanta6.726.485.924.084.043.64LA4.363.686.326.326.726.60WipesVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago500700S3：80010006001500Princeton,NJ00C0C000Atlanta00c0c000LA00c0c000Demand00c0c0OintmentVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago509012065120701485Princeton,NJ0000二000Atlanta00000000LA0000c000Demand0000c0TotalCost32661.4Baseduponareductionintotalcoststo$29,189,wewouldrecommendbuildingaplantPrinceton,AtlantaandLA.AllplantswouldofferboththeWipesandOintmentproductline,withtheirproductionquantitiesasoutlinedbelow:WipesOintmentPlantFixedCostVariableCost/unitCapacityFixedCostVariableCost/unitCapacityChicago50001050001500201000Princeton,NJ22001020001500201000Atlanta22001020001500201000LA22001020001500201000RegionalDemandbyProductZoneNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTotalWipes50070090080010006004500Ointment50901206512070515TransportationCostsNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTransportcostMultipleChicago6.326.323.684.045.765.96Princeton,NJ6.606.605.765.923.684.08Atlanta6.726.485.924.084.043.64LA4.363.686.326.326.726.60WipesVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago00900SOO0013300Princeton,NJ0000100000.5-2.3E-O9Atlanta01.776E-150-3.553E-1506000.30LA50070000000.61.74E-08Demand04.485E-07-IE-07000OintmentVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago0012065001815Princeton,NJ000012000.120Atlanta00000700.070LA509000000.140Demand000000TotalCoSt29188.8Therecommendationwouldremainthesametobuildalltheadditionalplants,butwithdifferentproductionquantitiesifthetransportationcostswerehalftheircurrentamountastheresultingtotalcostwouldnowbe$16,948asillustratedbelow:

WipesOintmentPlantFixedCostVariableCost/unitCapacityFixedCostVariableCost/unitCapacityChicago50001050001500201000Princeton,NJ22001020001500201000Atlanta22001020001500201000LA22001020001500201000RegionalDemandbyProductZoneNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTotalWipes50070090080010006004500Ointment50901206512070515TransportationCostsNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTranspor1tcost0WChicago3.163.161.842.022.882.98Princeton,NJ3.303.302.882.961.842.04Atlanta3.363.242.962.042.021.82LA2.181.843.163.163.363.30WipesVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago148.3937196.58816264.565234.148546270.3321168.919078213717.053Princeton,NJ115.8152165.81522212.283187.675122245.4469145.05434890.536040Atlanta115.5797166.05073211.969191.286233244.7403145.91787550.537770LA120.2114171.54589211.184186.890098239.4807140.10869740.534710Demand000000OintmentVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago45.2536253.50844878.985559.818838759.7524145.839365011656.8418Princeton,NJ0.17512210.17512314.14250.7850251722.306769.4142536280.0570Atlanta010.4106313.82854.3961361221.6002410.277779260.060510LA4.57125615.90579913.0435016.340584.4686021020.054330Demand000000TotalCost16947.88Iftransportationcostsweredoubletheircurrentlevels,therecommendationwouldbetostaywiththeChicagofacilityservicingtheentirenationasthetotalcostswouldriseto$86,530.

WipesOintmentPlantFixedCostVariableCost/unitCapacityFixedCostVariableCost/unitCapacityChicago50001050001500201000Princeton,NJ22001020001500201000Atlanta22001020001500201000LA22001020001500201000RegionalDemandbyProductZoneNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTotalWipes50070090080010006004500Ointment50901206512070515TransportationCostsNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTranspor1tcostMultipliJ21Chicago12.6412.647.368.0811.5211.92Princeton,NJ13.2013.2011.5211.847.368.16Atlanta13.4412.9611.848.168.087.28LA8.727.3612.6412.6413.4413.20WipesVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago009008000013300Princeton,NJ0000100000.5-1.3E-12Atlanta000006000.3-9.1E-13LA50070000000.61.82E-12Demand1.32E-O7-5.6E-073.9E-081.6614E-0700OintmentVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago0012065001815Princeton,NJ000012000.120Atlanta00000700.070LA509000000.140Demand000000TotalCost86530.2Asillustratedbelowinthethreespreadsheets,therecommendationswouldbeexactlyasaboveforcurrentcosts,transportationcostsathalftheircurrentlevelandwithtransportationcostsatdoubletheircurrentcosts.Theonlydifferenceintherecommendationswouldinvolvetheproductionquantitiesateachfacility.WipesOintmentPlantFixedCostVariableCost/unitCapacityFixedCostVariableCost/unitCapacityChicago50001050001500201000Princeton,NJ22001020001500201000Atlanta22001020001500201000LA22001020001500201000RegionalDemandbyProductZoneNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTotalWipes500700900SOO10006004500Ointment50901206512070515TransportationCostsNorthwestsouthwestNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastChicago6.326.323.684.045.765.96Princeton,NJ6.606.605.765.923.684.08Atlanta6.726.485.924.084.043.64LA4.363.686.326.326.726.60TransportcostMultiplieWipesVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago110.8526147.57128329.807264.962732213.3321102.93810710.233890Princeton,NJ119.5143169.51426193.529171.416398278.5836175.69637020.554130Atlanta117.7819171.2466191.219197.978938273.3866182.04828040.566830LA151.8513211.66785185.445165.641932234.6977139.31724230.544310Demand000000OintmentVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago0012049.3274491000.16933-1.2E-09Princeton,NJ06.84134470065.1392936.906517060.108890Atlanta7.89491221.368701015.672550946.7748133.093482940.12480LA42.1050961.789955008.085900.111987.26E-O9Demand000000WipesOintmentPlantFixedCostVariableCost/unitCapacityFixedCostVariableCost/unitCapacityChicago50001050001500201000Princeton,NJ22001020001500201000Atlanta22001020001500201000LA22001020001500201000RegionalDemandbyProductZoneNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTotalWipes50070090080010006004500Ointment50901206512070515TransportationCostsNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastTranspor1tcost0.51Chicago3.163.161.842.022.882.981Princeton,NJ3.303.302.882.961.842.04Atlanta3.363.242.962.042.021.82LA2.181.843.163.163.363.30WipesVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago123.8451160.56383342.799277.955261226.3247115.93066090.249480Princeton,NJ115.1834165.18342189.198167.085556274.2527171.36551690.541130Atlanta113.4511166.91575186.889193.648091269.0557177.71742510.5538-0LA147.5204207.337181.114161.311092230.3668134.9863970.531320Demand000000OintmentVariablesNorthwestsouthwestUppermidwestlowermidwestnortheastsoutheastFixedCapacityChicago0012049.3274463000.169335.69E-08Princeton,NJ06.84135870065.1392836.90651774D.1C8890Atlanta7.89492321.368698015.672553746.7748133.093482260.12480LA42.1050861.789943008.08590700.111987.26E-O9Demand000000TotalCost11948.86WipesOintmentPlantFixedCostVariableCost/unitCapacityFixedCostVariableCost/unitCapacityChicago50001050001500201000Princeton,NJ22001020001500