tutor14_2_levelprod3E

# tutor14_2_levelprod3E - Excel Tutor 14.2 Level Production...

This preview shows pages 1–2. Sign up to view the full content.

Excel Tutor 14.2 Level Production Aggregate Planning NOTE: This spreadsheet is protected to prevent accidental overwriting of a formula. Only those cell a red background can be changed. Indicates explanation, instruction, or a label. Indicates the results of a formula. Indicates an input value. Input values can be changed to explore the effects on the o The level production aggregate plan seeks to level the production in each period, to minimize hiring and firin plan requires that inventory be built up during low demand periods to help meet demand during periods with demand. The first step in creating the level production aggregate plan is to determine how many units must each period to meet demand. This is accomplished by computing the total demand for the year and dividing of work days in the year to give the amount of production required each day, and rounding up since fraction produced. Monthly outputs are calculated by multiplying the number of work days in the month by the num produced per day. Total number of units per year

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

tutor14_2_levelprod3E - Excel Tutor 14.2 Level Production...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online