供应链管理英文原书第6版数据公式表Exerci.xlsx

供应链管理英文原书第6版数据公式表Exerci.xlsx

《供应链管理英文原书第6版数据公式表Exerci.xlsx》由会员分享，可在线阅读，更多相关《供应链管理英文原书第6版数据公式表Exerci.xlsx（8页珍藏版）》请在冰豆网上搜索。

InputData（Demand）InputData（Costsetc.）MonthDemandItemCostJanuary1,000Materialscost/unit20.0February1,100Inventoryholdingcost/unit/month3.0March1,000Marginalcostofstockout/unit/monthApril1,200Hiringandtrainingcost/worker800.0May1,500Layoffcost/worker1,200.0June1,600Laborhoursrequired/unit0.1667July1,600Regulartimecost/hour20.0August900Overtimecost/hour30.0September1,100Marginalsubcontractingcost/unitOctober800November1,400InitialWorkforcesize1200December1,700Maximumovertimeperworkerpermonth20Startinginventory（000s）50Endinginventory（000s）50TemporaryPool100AggregatePlanDecisionVariables（demand,inventory,productionin000s）HtLtTtWtOtItPeriod#Hired#Laidoff#Temp#WorkforceOvertimeInventory00001,3000501-310-9900.00.02156-1,1460.00.03154-1,3006000.0284.040-1,30026000.0488.05（0）-1,30026000.0392.060-1,30026000.0196.07-1,30026000.00.08-363-9380.00.09208-1,1460.00.01044-1,1900.0342.011110-1,30026000.0346.012-0-1,30026000.050.0CostsPeriodHiringLayoffTempRegulartimeOvertimeInventory10372,50003,166,667002125,000003,666,667003123,333004,160,000180,000852,00040004,160,000780,0001,464,00050004,160,000780,0001,176,00060004,160,000780,000588,00070004,160,000780,000080435,00003,000,000009166,667003,666,667001035,000003,806,66701,026,0001188,333004,160,000780,0001,038,000120004,160,000780,000150,000Totalcost=$356,926,500ConstraintsStCtPtStockoutSubcontractProductionDemandInventory00000.09501,0000000.011001,1000000.012841,0000000.014041,2000000.014041,500200000.014041,600200000.014041,600200000.09009000000.011001,1000000.011428000000.014041,4000000.014041,70000StockoutSubcontractMaterial0019,000,000#Temp0022,000,000500025,680,00000028,080,00000028,080,000500028,080,000500028,080,000500018,000,000500022,000,000500022,840,00000028,080,00000028,080,0000298,000,0005050OvertimeProductionWorkforceOTProduction19791.6666700022916.666670002000000360001560001560001560001561875000022916.6666700023791.66667000000156000156Wt#Permanent#Workforce1,2501,3009909901,1461,1461,2501,3001,2501,3001,2501,3001,2501,3001,2501,3009389381,1461,1461,1901,1901,2501,3001,2501,300ProductionPlanforYear1234567891011120.0200.0400.0600.0800.01000.01200.01400.01600.01800.0MonthInventoryTotalProductionDemandOvertimeProductionSubcontractHtLtTtWtPtHtLtTt#Hired#Laidoff#Temp#WorkforceProduction#Hired#Laidoff#Temp0001,25000000-1,2509500-（0）-1,25011000-0-1,2501200-0100-1001,250132650-50-1001,25014580-500-1001,2501458-50-01001,2501458-050-100-1,250900-50-（0）-1,2501100-（0）-1,2501200（0）-96-961,250129250-504-1001,25014580-50WtPtHtLtTtWtWt#WorkforceProduction#Hired#Laidoff#Temp#Permanent#workforce1,250000501,2501,3001,250950-31009909901,2501184156-01,1461,1461,2501200154-501,2501,3001,2501404-501,2501,3001,2501404-501,2501,3001,2501404-501,2501,3001,2501404-501,2501,3001,250900-36309389381,2501100208-01,1461,1461,250120044-01,1901,1901,2501346110-501,2501,3001,25014040-501,2501,300PtProduction09501100128414041404140414049001100114214041404