This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Excel Tutor 14.2 Level Production Aggregate Planning NOTE: This spreadsheet is protected to prevent accidental overwriting of a formula. Only those cells w 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 outc The level production aggregate plan seeks to level the production in each period, to minimize hiring and firing c plan requires that inventory be built up during low demand periods to help meet demand during periods with hi demand. The first step in creating the level production aggregate plan is to determine how many units must be each period to meet demand. This is accomplished by computing the total demand for the year and dividing by of work days in the year to give the amount of production required each day, and rounding up since fractional u produced. Monthly outputs are calculated by multiplying the number of work days in the month by the number...
View Full Document
- Fall '07