tutor14_2_levelprod3Eq2

tutor14_2_levelprod3Eq2 - Excel Tutor 14.2 Level Production...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 2

tutor14_2_levelprod3Eq2 - Excel Tutor 14.2 Level Production...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online