jagomart
digital resources
picture1_Excel Sample Sheet 33134 | Icas Initial Capacity Assessment Sheet 2010 12 09


 210x       Filetype XLS       File size 0.09 MB       Source: www.volvogroup.com


File: Excel Sample Sheet 33134 | Icas Initial Capacity Assessment Sheet 2010 12 09
sheet 1 initial capacity assessm sheet i key information a product b customer production supplier annual quoted volume rfq volume method date description site location production weeksyear at customer parma ...

icon picture XLS Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Initial Capacity Assessm. Sheet

I. Key Information A) Product


B) Customer Production








Supplier Annual quoted volume (RFQ volume)

Method Date Description



Site Location Production weeks/year (at customer)








Parma Code X Customer Demand / Week
-






Date of Study









Part # / Name




























II. Capacity Planning




















Operating pattern for the specific part
Process 1 Process 2 Process 3 Process 4 Process 5 Process 6 Process 7


Process description










Dedicated or Shared process (for shared process,
show only the operating pattern for the specific part)
2

A Shifts/day









B Total hours/shift









B1 Hours/shift used for this part number (shared prod)









C1 Personal breaks: lunch, breaks (minutes/shift)









C2 Planned Maintenance (minutes/shift)









D Days/week









E Net available time (production hours/week)
[A*(B1-(B1/B)*((C1+C2)/60))*D]
- - - - - - -













Projected Downtime for this part number










F Tool / Variant Changeover (minutes)









G Changeovers / shift









H Inspections of facilities / shift (minutes)









I Breakdowns / shift (unscheduled downtime) (minutes)









J Total projected downtime/week (hours) [((FxG+H+I)/60xAxD)*B1/B]
- - - - - - -













K Equipment Availability [(E-J)/E]
- - - - - - -













Projected Quality Rate (%)











Projected percent of parts scrapped and/or reworked
For linked processes, see notes.










L Projected Quality Rate (%)
- - - - - - -













Planned Cycle time / Capacity











Required Cycle time needed to cover exact customer demand (sec/part) [E*3600*K*L/ X]
- - - - - - -













M Net Planned Ideal Cycle Time (sec/part)
For multiple cavities in one tool, see notes.










Planned production capacity / week [(E-J)*3600*L/M] - - - - - - -




































0 DEDICATED









1 SHARED










The words contained in this file might help you see if this file matches what you are looking for:

...Sheet initial capacity assessm i key information a product b customer production supplier annual quoted volume rfq method date description site location weeksyear at parma code x demand week of study part name ii planning operating pattern for the specific process dedicated or shared show only shiftsday total hoursshift used this number prod c personal breaks lunch minutesshift planned maintenance d daysweek e net available time hoursweek projected downtime f tool variant changeover minutes g changeovers shift h inspections facilities breakdowns unscheduled j downtimeweek hours k equipment availability quality rate percent parts scrapped andor reworkedfor linked processes see notes l cycle required needed to cover exact secpart m ideal multiple cavities in one...

no reviews yet
Please Login to review.