供应商质量能力分析.xlsVIP

Instructions

WorksheetbyShift

ConstraintCapacityEstimate

Date:

Completedby:

Annual

Daily

SupplierName

Part(s)Name

Part(s)Number

#

ContractedCapacity

MinutesPerShift

GrossMinAvail/day

NetAvailableMinutes/day

NetMinutesAvailable/dayforStudyParts

Timeallocatedforothercustomers(minutes)

UnscheduledDowntime(minutes)

PlannedMaintenance(minutes)

%Scrap

EstimatedThroughputforstudypartsperday

%Utilization

RESULT:MarkXforpossibleconstraintoperation(90%)

Run@RateActualOKpartsproduced

Run@RateActualScrap(partcount)

AvailableCapacityContractedCapacity?

YES/NO

RUN@RATESTUDYRESULTS

IncreasedContractedCapacity

ScheduledBreak/Lunch(minutes)

Changeovers/ToolChanges(minutes)

NEWCONTRACTEDpartsperday

5.Toviewthecomment,pointthemouseatthecell(ortheredmark).

DescriptionofeachINPUTDATAfieldinthiscapacityestimationtool:

SupplierName:inputthenamelocationofthesupplier.

Part(s)Name:inputthepartnamebasedonthepartcontract.Whenthesheetappliestomultipleparts,specifynameofalltheparts.

ContractedCapacity:inputtheCONTRACTEDyearlyanddailycapacity.

IncreasedContractedCapacity:inputtheincreasedCONTRACTEDyearlyanddailycapacity.

NEWCONTRACTEDparts/day:inputNEWLYcontractedpartsPERDAYwhichincludesservicepartsrequirement.

SystemConstraint:PlaceanXmarkinthecolumnfortheproductionline(s)withutilizationabove90%.

Run@RateStudyResults

Run@RateActualOKpartsproduced:inputthenumberofOKpartsproducedduringtherun@ratestudy.

AvailableCapacityContractedCapacity:Iftheavailablecapacityofthesystemisgreaterthanthecontractedcapacity,inputYES,otherwiseinputNO.

Run@RateActualScrap:inputthenumberofpartsscrappedduringtherun@ratestudy.

Run@RateActualDowntime(minutes)

Run@RateActualDowntime:inputthedowntimeinminutesduringtherun@ratestudy.

4.Somecolumn