tutor14_1_3 - Excel Tutor 14.1 Demand Chase Aggregate...

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

View Full Document Right Arrow Icon
Excel Tutor 14.1 Demand Chase Aggregate Planning NOTE: This spreadsheet is protected to prevent accidental overwriting of a formula. Only those cells with 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 outcom Hours per unit 1.2 Input values with red background Hiring cost $475 can be changed to perform Layoff cost $400 "What if?" analysis. Labor Hours 40 Available per week The demand chase approach to aggregate planning requires an adjustment to the capacity (hiring and firing) eac in order to match capacity to demand. Labor hours required per period is computed by multiplying the forecast de for each period by the hours per unit. The number of workers required is computed by dividing the total amount o hours needed in the period by 160 (hours per worker per period), and rounding up, since a fractional worker can't This logic is duplicated below. Period
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/13/2010 for the course BUS BUS 335 taught by Professor Griffin during the Fall '07 term at Peru State.

Page1 / 2

tutor14_1_3 - Excel Tutor 14.1 Demand Chase Aggregate...

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