5SPC2

InputParametersSPC-InputParameterCost'sRawmateialcostper1000lbs10.00$Extruderfixedcostperquarter80,000.00$Hiringandtrainingcost/person2,000.00$Layoffcost/worker1,500.00$Regularwagecost/hour15.00$Overtimewagecost/hour22.50$Transportationcosttoandfromwarehouseper1000lbs2.00$Publicwarehouse:Materialhandlingchagesper1000lbs5.00$(between$4.00and$6.00)Publicwarehouse:Storagechargesatpublicwarehouseper1000lbs10.00$Privatwarehouse:Leaseratespersquarefootandyear4.00$Privatwarehouse:Variableoperatingcostper1000lbs3.00$Subcontractingcostper1000lbs100.00$ConstraintsOperatingdaysperquarter63Regularworkinghours8Maximumovetimeperworkerandquarter(inhours)60Extruders:Effectiveprocessingcapacitybyextruder(lbsperhour)2280Extruders:Staffingequirementsperextruder(workers)6Thermoforingpesses:Effectivecapacitybythermoforingpess(lbsperhour)2000Thermoforingpesses:StaffingEquirementsperthermoformingpress(workers)1Minimumleaseperiodforprivatewarehousing(quarters)12Floorspacerequiredtostore1000lbsinsquarefeet1:TheconditionsforAssumeLinearModelarenotsatisfied.Inthiscase,justrunSolveragain.Page1AggregatePlanDecisionVariablesSalesForecastHiring/FiringExtruderWarehouseThermoformingHtLtWtOtPEtCtItPTtConstraintsPeriodDemandBlackPlastic('000lbs)DemandClearPlastic('000lbs)Total#Hired#Laidoff#WorkforceOvertimeProduction('000lbs)Subcontract('000lbs)InventoryProduction('000lbs)WorkforceTotalInventoryDemandSatisfacionProductionOvertine01090=0=0=0=0=01999/16,6507,46214,11260115019,29705,18514,112000068851999/24,57618,25022,82600115017,6410022,826000068851999/36,2938,89415,187012103016,76601,57915,187000061571999/413,7774,06417,84100103016,2620017,841000061572000/17,5098,34915,858260129021,59705,73915,858000077102000/25,14920,35525,50400129019,7650025,504000077102000/37,0569,89116,947014114018,70801,76116,947000068702000/415,3994,50719,90600114018,1450019,906000068702001/18,3679,13517,502270142023,85706,35517,502000085162001/25,72122,46128,18200142021,8270028,182000085162001/37,81910,88918,708016126020,64901,94118,708000075832001/417,0214,95021,97100126020,0300021,97100007583MAD60878659420234,5440234,544AggregatePlanCostsPeriodHiringLayoffRegulartimeOvertimeMaterialSubcontractInventory1999/111,512$-$867,557$-$192,968$-$77,772$1999/2-$-$867,557$-$176,412$-$-$1999/3-$18,221$775,723$-$167,661$-$23,687$1999/4-$-$775,723$-$162,619$-$-$2000/151,783$-$971,463$-$215,974$-$86,091$2000/2-$-$971,463$-$197,646$-$-$2000/3-$21,012$865,561$-$187,076$-$26,409$2000/4-$-$865,561$-$181,454$-$-$2001/154,871$-$1,072,973$-$238,566$-$95,319$2001/2-$-$1,072,973$-$218,274$-$-$2001/3-$23,324$955,421$-$206,495$-$29,122$2001/4-$-$955,421$-$200,295$-$-$TotalCost=13,881,959$100%RawMaterial2,345,440$17%Subcontracting-$0%LaborHiring&Layoff180,723$1%RegularWage11,017,396$79%Overtime-$0%InventoryHolding338,400$2%05,00010,00015,00020,00025,00030,00012345678910111213Production('000lbs)Subcontract('000lbs)InventoryProduction('000lbs)CR-2019/9/3011:47Page21569831098156-BaseModelAggregatePlanDecisionVariablesSalesForecastExtruderWarehouseThermoformingHEtLEtWEtOEtPEtCtItHTtLTtWTtOTtPTtConstraintsPeriodDemandBlackPlastic('000lbs)DemandClearPlastic('000lbs)Total#Hired#Laidoff#WorkforceOvertimeProduction('000lbs)Subcontract('000lbs)Inventory#Hired#Laidoff#WorkforceOvertimeProduction('000lbs)ExtruderWorkforceThermoWorkforceTotalInventoryDemandSatisfacionExtruderProductionThermoProductionExtruderOvertineThermoOvertine084025=0=0=0=0=0=0=0=01999/16,6507,46214,11212096018,46904,35701114014,1120.00.00.00.00.0057868401999/24,57618,25022,8260096018,469009023022,8260.00.00.00.00.00578613591999/36,2938,89415,18701086016,51401,3270815015,1870.00.00.00.00.0051749041999/413,7774,06417,8410086016,514003018017,8410.00.00.00.00.00517410622000/17,5098,34915,858220108020,68104,8230216015,8580.00.00.00.00.0064799442000/25,14920,35525,50400108020,6810010025025,5040.00.00.00.00.00647915182000/37,0569,89116,94701296018,42701,4800817016,9470.00.00.00.00.00577310092000/415,3994,50719,9060096018,427003020019,9060.00.00.00.00.00577311852001/18,3679,13517,502230119022,84205,3400217017,5020.00.00.00.00.00715610422001/25,72122,46128,18200119022,8420011028028,1820.00.00.00.00.00715616782001/37,81910,88918,708013106020,34001,6320919018,7080.00.00.00.00.00637211142001/417,0214,95021,97100106020,340003022021,9710.00.00.00.00.0063721308MAD60878657350234,544038410234,544AggregatePlanCostsPeriodHiringLayoffRegulartimeOvertimeMaterialSubcontractInventoryHiringLayoffRegulartimeOvertime1999/124,868$-$729,039$-$184,690$-$65,355$-$16,500$105,840$-$1999/2-$-$729,039$-$184,690$-$-$17,290$-$171,195$-$1999/3-$15,312$651,868$-$165,140$-$19,905$-$11,368$113,903$-$1999/4-$-$651,868$-$165,140$-$-$5,266$-$133,808$-$2000/143,515$-$816,355$-$206,810$-$72,345$-$2,951$118,935$-$2000/2-$-$816,355$-$206,810$-$-$19,139$-$191,280$-$2000/3-$17,657$727,362$-$184,265$-$22,193$-$12,734$127,103$-$2000/4-$-$727,362$-$184,265$-$-$5,871$-$149,295