What is the Backlog quantity for Period 1?

What is the Number of Employees in Period 3?

What is the Overtime Production Quantity for Period 4?

What is the Production - Forecast quantity for Period 4?

What is the Beginning Inventory quantity for Period 2?

What is the Ending Inventory value for Period 5?

What is the Average Inventory for Period 3?

What is the Cost of Hire / Layoff in Period 4? (include two decimals)

What is the Cost of Regular Production in Period 5? (include two decimals)

What is the Inventory Cost in Period 5? (include two decimals)

AutoSave Off H e r Chapter 11a HW 3 - Excel Search 0 x Comments File Home Insert Page Layout Formulas Data Review View Help === 0 General 2 P2 E 3 EX Arial BIU LLA Taylor Coffman TC - Share 49 0 Insert Delete Format Sort & Find & Ideas Filter Select Editing Ideas 12A - A A - a Wrap Text Merge & Center - Paste $ % 88 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells P32 : x T U V W X Y Z AA AB + Management Instructions - Ending inventory target for Period 5 Backorder maximum if possible (after the first period) 2,000 Regular shift production per employee per period The company's production strategy keeps the regular shift fully utilized 2,000 Maximum overtime production per period if needed 500 Maximum subcontractor production per period if needed 8,850 Initial inventory - Use Overtime before Subcontractors 11 Aggregate Plan 5 14,500 13 Demand 15,200 1 15,900 14,900 Totals 76,055 15,555 15 Employees 17 Production 18 Regular 19 Overtime 20 Subcontractor 21 Production - Forecast 14,000 14,000 12.000 12.000 12,000 23 Inventory 24 Beginning 25 Ending 26 Average 27 Backlog 29 Costs 30 Regular $ 31 Overtime $ Subcontractor $ 33 Hire / Layoff $ 34 Inventory $ 35 Backlog $ 121 3.90 4.50 5.00 900.00 1.00 1.00 37 Total Costs HW 3 : DU - + + 50% AutoSave Off H e r Chapter 11a HW 3 - Excel Search 0 x Comments File Home Insert Page Layout Formulas Data Review View Help === 0 General 2 P2 E 3 EX Arial BIU LLA Taylor Coffman TC - Share 49 0 Insert Delete Format Sort & Find & Ideas Filter Select Editing Ideas 12A - A A - a Wrap Text Merge & Center - Paste $ % 88 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells P32 : x T U V W X Y Z AA AB + Management Instructions - Ending inventory target for Period 5 Backorder maximum if possible (after the first period) 2,000 Regular shift production per employee per period The company's production strategy keeps the regular shift fully utilized 2,000 Maximum overtime production per period if needed 500 Maximum subcontractor production per period if needed 8,850 Initial inventory - Use Overtime before Subcontractors 11 Aggregate Plan 5 14,500 13 Demand 15,200 1 15,900 14,900 Totals 76,055 15,555 15 Employees 17 Production 18 Regular 19 Overtime 20 Subcontractor 21 Production - Forecast 14,000 14,000 12.000 12.000 12,000 23 Inventory 24 Beginning 25 Ending 26 Average 27 Backlog 29 Costs 30 Regular $ 31 Overtime $ Subcontractor $ 33 Hire / Layoff $ 34 Inventory $ 35 Backlog $ 121 3.90 4.50 5.00 900.00 1.00 1.00 37 Total Costs HW 3 : DU - + + 50%