粗产能RCCP计算模板-计划产能与实际产能模板

SheetsinthisFileSheet1:ProcessDataThissheetincludespartnumberandcorrespondingcapacityunitsrequiredtoproducethepartnumber.Sheet2:AvailabileCapacityThissheethascellsthatcanbechangedtoreflectyourconstraintmachinesplanned,maximumanddemonstratedcapacity.Choosenumberofdays,shifts/dayandhours/shifttheconstraintmachinewilloperate.Also,enterpercentageofcapacitythatwillbeallocatedforCaterpillarDemand.LoadFactorshouldbecalculatedfromSheet3.Sheet3:LoadFactorCalculationSheet3hasatemplatetocalculateloadfactor.Pleasefillthehistoricaldataincludingidletimepershiftandovertime.StandardcapacityunitsshouldbereflectedfromSheet4.Sheet4:DemonstratedCapacityDemonstratedcapacitysheetprovidesatemplatetoinputthedataforpartnumbersandtheirrespectivecapacityunitsrequiredtoproduceeachpartandhistorialnumberofpartsproduced.Thissheetisusedtocalculatestandardunitsproduced.--------------------------------DefinitionCapacityUnits:CapacityunitisUnitofMeasurefortheprocessdata.Itcouldbeintermsoftime(seconds,minutesorhours),mass(kilograms,tonnesorpounds)oranyotherunitofmeasurethatisrelevanttoyouroperation.August-12September-12October-12November-12dayspermonth21202527overtimedayspermonthnumberofresources2222hourspershift7.25777shiftsperday1222(LoadFactor)efficiencyfactor85.0%62.0%62.0%62.0%%capacityforCAT100.0%67.0%67.0%67.0%dailycapacity12.32511.631211.631211.6312monthlycapacity258.825232.624290.78314.0424August-12September-12October-12November-12dayspermonth21252527overtimedayspermonthnumberofresources2222hourspershift7.25777shiftsperday1222(LoadFactor)efficiencyfactor85.0%62.0%62.0%62.0%%capacityforCAT100.0%67.0%67.0%67.0%dailycapacity12.32511.631211.631211.6312monthlycapacity258.825290.78290.78314.0424August-12September-12October-12November-12dayspermonth21252527overtimedayspermonthnumberofresources2222hourspershift7.25777shiftsperday3333(LoadFactor)efficiencyfactor85.0%62.0%62.0%62.0%%capacityforCAT100.0%67.0%67.0%67.0%dailycapacity36.97517.446817.446817.4468monthlycapacity776.475436.17436.17471.0636DemonstratedCapacityPlannedCapacityMaximumCapacityDecember-12January-13February-13March-13April-13May-13June-132327242225242422222227777777222222262.0%62.0%62.0%62.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%11.631211.631211.631211.631211.631211.631211.6312267.5176314.0424279.1488255.8864290.78279.1488279.1488December-12January-13February-13March-13April-13May-13June-132327242225242422222227777777222222262.0%62.0%62.0%62.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%11.631211.631211.631211.631211.631211.631211.6312267.5176314.0424279.1488255.8864290.78279.1488279.1488December-12January-13February-13March-13April-13May-13June-132327242225242422222227777777333333362.0%62.0%62.0%62.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%17.446817.446817.446817.446817.446817.446817.4468401.2764471.0636418.7232383.8296436.17418.7232418.7232DemonstratedCapacityPlannedCapacityMaximumCapacityJuly-13###########################################February-14March-1426262426262427232322222222277777777722222222262.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%11.631211.631211.631211.63111.631211.63111.631211.631211.6312302.4112302.4112279.149302.41302.411279.15314.0424267.5176267.5176July-13###########################################February-14March-1426262426262427232322222222277777777722222222262.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%11.631211.631211.631211.63111.631211.63111.631211.631211.6312302.4112302.4112279.149302.41302.411279.15314.0424267.5176267.5176July-13###########################################February-14March-1426262426262427232322222222277777777733333333362.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%67.0%17.446817.446817.446817.44717.446817.44717.446817.446817.4468453.6168453.6168418.723453.62453.617418.72471.0636401.2764401.2764April-14May-14June-14July-142524252622227777222262.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%11.631211.631211.631211.6312290.78279.1488290.78302.4112April-14May-14June-14July-142524252622227777222262.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%11.631211.631211.631211.6312290.78279.1488290.78302.4112April-14May-14June-14July-142524252622227777333362.0%62.0%62.0%62.0%67.0%67.0%67.0%67.0%17.446817.446817.446817.4468436.17418.7232436.17453.6168PleasenoteanyassumptionsorcommentsthatyoumayhavePleasenoteanyassumptionsorcommentsthatyou