LAWNKING Aggregate Planning BASIC INPUT DATA DATE 18-May MONTHLY PROD. RATE (UNITS/WORKER/MONTH): BEGINNING INVENTORY (UNITS) BEGINNING NUMBER OF WORKERS $ $ $ HIRING COST PER WORKER: LAYOFF COST PER WORKER COST OF FULLY ASSEMBLED PRODUCT (AVE $) INVENTORY HOLDING COST (% of value per year): INVENTORY SHORTAGE COST (COST/UNIT SHORT) : REGULAR HOURLY WAGE RATE: OVERTIME HOURLY WAGE RATE: OPERATING TIME: (HOURS/WEEK) OPTIONS: 82 UNITS 1) Chase Strategy 1,225 UNITS 2) Level Strategy 80 WORKERS 3) Mixed Strategy 1,200 PER HIRE 1,500 PER FIRE 179 PER UNIT 28% ANNUALLY Notes on Level Strategy 25.00 PER BACKORDER PER MONTH - workers must be the same EVERY month 15.30 PER WORKER |-end the year with the same number in inventory as you started 23.00 PER WORKER -only full-time employees allowed (i.e. whole-number of workers) 40 HOURS PER WEEK $ $ $ MONTHS: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ANNUAL 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales Forecast: Number of Workers: Units Produced: Ending Inventory 0 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Reg. Labor Costs: Change in # workers from last month: Hiring Cost: Layoff Cost: End-Inv. Hold. Cost: End-Inv. Short. Cost: -80 $ $0 $120,000 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5,116 $0 0 $0 $0 $5.116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5,116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5,116 $0 MONTHLY TOTAL COST: $125, 116 $5, 116 $5,116 $5, 116 $5,116 $5,116 $5,116 $5, 116 $5, 116 $5, 116 $5, 116 $5,116 $181,397 TOTAL COST OF THIS STRATEGY LAWNKING Aggregate Planning BASIC INPUT DATA DATE 18-May MONTHLY PROD. RATE (UNITS/WORKER/MONTH): BEGINNING INVENTORY (UNITS) BEGINNING NUMBER OF WORKERS $ $ $ HIRING COST PER WORKER: LAYOFF COST PER WORKER COST OF FULLY ASSEMBLED PRODUCT (AVE $) INVENTORY HOLDING COST (% of value per year): INVENTORY SHORTAGE COST (COST/UNIT SHORT) : REGULAR HOURLY WAGE RATE: OVERTIME HOURLY WAGE RATE: OPERATING TIME: (HOURS/WEEK) OPTIONS: 82 UNITS 1) Chase Strategy 1,225 UNITS 2) Level Strategy 80 WORKERS 3) Mixed Strategy 1,200 PER HIRE 1,500 PER FIRE 179 PER UNIT 28% ANNUALLY Notes on Level Strategy 25.00 PER BACKORDER PER MONTH - workers must be the same EVERY month 15.30 PER WORKER |-end the year with the same number in inventory as you started 23.00 PER WORKER -only full-time employees allowed (i.e. whole-number of workers) 40 HOURS PER WEEK $ $ $ MONTHS: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ANNUAL 0 0 0 0 0 0 0 0 0 0 0 0 0 Sales Forecast: Number of Workers: Units Produced: Ending Inventory 0 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 1, 225 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Reg. Labor Costs: Change in # workers from last month: Hiring Cost: Layoff Cost: End-Inv. Hold. Cost: End-Inv. Short. Cost: -80 $ $0 $120,000 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5,116 $0 0 $0 $0 $5.116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5,116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5, 116 $0 0 $0 $0 $5,116 $0 MONTHLY TOTAL COST: $125, 116 $5, 116 $5,116 $5, 116 $5,116 $5,116 $5,116 $5, 116 $5, 116 $5, 116 $5, 116 $5,116 $181,397 TOTAL COST OF THIS STRATEGY