OEE Capacity_Analysis_Report

CapacityAnalysisReportFordMotorCompanyI.KeyInformation:A)ProductB)CustomerProductionC)CapacityRevisionRecord(e.g.RunatRate)SiteLocationXCust.Demand/Week(withoutServiceParts)VendorCodeYNumberofdayscustomer/supplierworks/weekDateofStudyZCustomerDemandperDay(DPV)-PartNamePartNumberServicePartsAnnualVolumeII.CapacityPlanningOperatingpatternforthespecificpartProcess1Process2Process3Process4Process5Process6Process7ProcessdescriptionTurningdrillborewashingassemblyassemblyIIassemblyIII2111111A.Shifts/dayB.Totalhours/shiftCPersonalbreaks:lunch,breaks(minutes/shift)PlannedMaintenance(minutes/shift)DDays/weekENetavailabletime(productionhours/week)[A*(B-(C/60))*D]0.000.000.000.000.000.000.00ProjectedDowntimeFTool/Variant/ConsumableToolschangeover(minutes)GChangeoverspershiftHInspectionsoffacilitiespershift(minutes)IBreakdownspershift(unscheduleddowntime)(minutes)JTotalprojecteddowntime/week(hours)[(FxG+H)/60xAxD]0.000.000.000.000.000.000.00KEquipmentAvailability[(E-J)/E]-------ProjectedQualityRate(%)ProjectedpercentofpartsscrappedandreworkedForlinkedprocesses,pleaseseenoteintrainingmaterialLProjectedQualityRate(%)-------PlannedCycletime/CapacityRequiredCycletimeneededtocoverexactcustomerdemand(sec/part)[E*3600*K/X*L]-------MPlannedidealcycletime(takenwithwatch)(sec/part)Formultiplecavitiesinonetool,seenoteintrainingmaterialPlannedproductioncapacity/week[(E-J)*3600/M*L]-Plannedproductioncapacity/day[(E-J)*3600/M*L/D]-III.ProductionRun(ticktheappropiatebox)Run-at-RateCapacitOthere.g.TrialRunDurationdataofproductionrun(Phase0)NTotaldurationofproductionrun(min)O1Totalplanneddowntime(lunch,breaks,maint.)(min)O2(changeovers,inspections)(min)PTotalunplanneddowntime(i.e.breakdowns,unscheduledadjustments,unscheduledsetups,etc.)(min)ReasonsforbreakdownPartquantitydataofproductionrunQTotalpartsrunRTotalrejectedpartsSTotalpartsreworked,retestedorrepairedofflineTTotalgoodparts(firsttimethroughonly-donotincludepartsthatwererejected,re-processedorreworked)-------ReasonsforrejectedpartsUProcesstotalactualcycletime(sec/part)[(N-O1-O2-P)x60/Q]-------IV.CapacityCalculationVWeeklyPartsAvailableforShipment[E*3600/((N-O)*60/T)]-------WDailyPartsAvailableforShipment[V/Y]-------ZDPV-------AAPercentabove/belowDPV[W/Z]-------V.OverallEquipmentEffectivenessEquipmentAvailability[(N-O1-O2-P)/(N-O1)]-------PerformanceEfficiency[(M*Q)/(N-O1)]-------QualityRate[T/Q]-------OEE-------DEDICATEDVII.SUPPLIEROPERATIONMANAGEMENTAPPROVALFORCUSTOMERUSEONLYSTAReviewResults:TitlePhoneNumberFAXNumberCustomerNameSupplierNameSupplierAuthorizedSignatureDateCustomerSignatureDate%aboveDPV:Verification(Phase0.00%SHAREDVI.ManufacturingBottleneckProcess#DedicatedorSharedprocess(bysharedprocess,showonlyoperatingpatternforthespecificpart)00000000.00%0.00%0.00%0.00%0.00%0.00%0.00%00000111111Process1Process2Process3Process4Process5Process6Process7DPVcomparisonActualdailypartsavailablePercentabove/belowDPVcustomerDPVRun-at-Rate(Phase0)CapacityVerification(Phase3)ApprovedRejectedFileChampion:VDomdeiSWalshPage1of6Revisionlevel#17Revisiondate:01.July.2005CapacityAnalysisSheetFordMotorCompanyI.KeyInformationA)ProductB)CustomerProductionC)CapacityAnalysisReport-RevisionRecordSupplierXCustDemand/Week(exclserviceparts)5000CapacityDateDescriptionSiteLocationYNumberofdayscustomerworksperweek5OriginalsubmissionVendorCodeZCustomerDemandperDay(DPV)1000DateofStudyPartNameServicePartsAnnualVolumePartNumberDEDICATEDII.CapacityPlanningSHAREDOperatingpatternforthespecificpartProcess1Process2Process3Process4Process5Process6Process7ProcessdescriptionTurningdrillborewashingassemblyassemblyIIassemblyIII1116611A.Shifts/day3.003.003.001.003.003.003.00B.Totalhours/shift8.008.008.003.008.008.008.00CPersonalbreaks:lunch,breaks(minutes/shift)30.0030.0030.000.0030.0030.0025.00PlannedMaintenance(minutes/shift)15.0030.0030.0030.0030.0030.000.00DDays/week2.005.005.005.005.005.005.00ENetavailabletime(productionhours/week)[A*(B-(C/60))*D]43.50112.50112.5015.00112.50112.50113.75CapacityVerificationTheCapacityAnalysisReportconsistsoftwoelements,CapacityPlanning(verificationofproductionreadiness)andPerformanceofCapacityVerification.TheCapacityAnaysisReportisthoughdividedinto7areasforeaseofuse.Eachareahasaheadingatthetopofthebox.Theheadingsare:·KeyInformation-Product/CustomerProduction/CapacityRevisionRecord·CapacityPlanning·ProductionRun·CapacityCalculation·OriginalEquipmentEffectiveness(OEE)·ManufacturingBottleneck·SupplierOperationManagementApprovalDatainputTheCapacityAnalysisReportworksheethasbeendividedintoanumberofeasytoidentifyinformationboxes.Eachboxhasamainheadingtoalloweasyrecognition.Withineachboxtheuserisrequiredtoinputavarietyofdataforms.Thismanualwillexplainhowtocompleteeachsectioninturn.Input&CalculationCells:Datacanonlybeinputintotheworkbookinthecellsoneachsheetthatrequiredata.Thisensuresthattheheadings,orotherinformationcannotbeaccidentallyerasedormodified.Thesecells(inputcells)areclearlyidentifiedaswhiteincolourandwithasolidoutlinearoundthebox.Cellsthataregreyincolourarecalculationcells.Theuse