capacity_management_tool V13

CAMA GUIDELINES & RULES V13

Use of CAMA:

- CAMA is intended to be used to analyze product line capacity based on the capacity at the bottleneck.Demand Analysis:

- All capacity analysis must rely first on historic information and the best forecast information possible. - It is equally important to be honest about the accuracy of the forecast information and consider

that accuracy (variability) in the capacity analysis.

Available Work Days / Available Work Hours:

- It is not Schneider's intent to run production 7 days per week, 24 hours per day. (An exception to

this may be some molding operations) Doing this allows absolutely no time for flexibility to respond to changes in customer demand, supplier shortages or breakdown. Therefore, some general

guidelines exist for determining the available work days, available work hours and Plant Operating Time (PO Manual Assembly = 4000 hours max (ex: 8 hours per shift / 2 shifts per day / 5 days per week / 50 wee Automated Assembly = 6000 hours max (ex: 8 hours per shift / 3 shifts per day / 5 days per week / 50 Results analysis:

Load ratio with the recommended organization < 100%

You can deliver the customer and sustain the growth.100% < Load ratio with recommended organization < 120%

You use the 20% buffer and you can't react if the actual Load ratio with recommended organization > 120%You can't deliver during the high saisonnality = OTDM o

Completing the CAMA Spreadsheet

Cell ID

J4Enter the the month and year of the current year in cell and the rest of the date information will automatically fill.

Col K Enter the available work days per month in column , do not

include planned overtime.

Col L Enter the historical demand data for past months and the

forecast demand data for future months in column

By entering this data, certain information will automatically

populate the CAMA worksheet.

Going to the CAMA worksheet, fill in data, only in the yellow

colored cells, enter: the Name of the Plant, Name of the

Production Line, Type of Production Line (Manual, Semi-Auto,

Automated) the process bottleneck, the days during the year

the plant is formally planned to be closed.

G6H6Enter the available work hours. Do not consider overtime hours

or additional shifts as Available Work Hours.This short-term flexibility is useful only to manage short-term variation and should not be taken into account on a monthly

basis

G8H8Enter the production throughput rate at the bottleneck in units per hour. This could be a whole number or a fractional (less than 1) number depending on the product.20406080100120

140160

Jan Feb Mar Apr M

G9 H9Enter either the NEE or the KE (efficiency) for both the current and next year.

G15 H15The worksheet will now have automatically calculated your Load Ratio, comparing current and next year.

G16

H16

… and with recommended organization

e (POT).0 weeks per year)k / 50 weeks per year)in the growth.react i

f the actual is over the forecast.nnality = OTDM or inventory risk. You need to increase the capacity.May Jun Jul Au

g Sep Oct Nov Dec

Actual capacity

#REF!