BASIC INPUT DATA DATE: 18-May 82 UNITS MONTHLY PROD. RATE (UNITS/WORKER/MONTH): BEGINNING INVENTORY (UNITS) OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy 1225 UNITS BEGINNING NUMBER OF WORKERS: 80 WORKERS HIRING COST PER WORKER LAYOFF COST PER WORKER COST OF FULLY ASSEMBLED PRODUCT (AVE $) $1,200 PER HIRE $1,500 PER FIRE $179 PER UNIT Note 1: You can see the solution method under DATA tab, SOLVER. It's all ready for you! INVENTORY HOLDING COST (% of value per year) 28% ANNUALLY INVENTORY SHORTAGE COST (COST/UNIT SHORT) : REGULAR HOURLY WAGE RATE: Note 2: If you don't have SOLVER listed, add it under FILE, OPTIONS, MANAGE ADD-INS. GO. Check the SOLVER TOOLS. $ $25.00 PER BACKORDER PER MONTH $15.30 PER WORKER Note 3: The optimal solution with fractional workers -- leave this as the optimal (e.g. considers part- time or temporary workers). If needed, compare results to that of only full-time workers by rounding or add an Integer constraint. $23.00 PER WORKER 40 HOURS PER WEEK OVERTIME HOURLY WAGE RATE: OPERATING TIME: (HOURS 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 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 $0 $120.000 $5,116 $0 $ 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $ $5,116 $0 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $5, 116 $0 0.0 $0 $0 $5,116 $0 0 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $ $5, 116 $0 0.0 $0 $0 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $5,116 $0 $5,116 $0 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 BASIC INPUT DATA DATE: 18-May 82 UNITS MONTHLY PROD. RATE (UNITS/WORKER/MONTH): BEGINNING INVENTORY (UNITS) OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy 1225 UNITS BEGINNING NUMBER OF WORKERS: 80 WORKERS HIRING COST PER WORKER LAYOFF COST PER WORKER COST OF FULLY ASSEMBLED PRODUCT (AVE $) $1,200 PER HIRE $1,500 PER FIRE $179 PER UNIT Note 1: You can see the solution method under DATA tab, SOLVER. It's all ready for you! INVENTORY HOLDING COST (% of value per year) 28% ANNUALLY INVENTORY SHORTAGE COST (COST/UNIT SHORT) : REGULAR HOURLY WAGE RATE: Note 2: If you don't have SOLVER listed, add it under FILE, OPTIONS, MANAGE ADD-INS. GO. Check the SOLVER TOOLS. $ $25.00 PER BACKORDER PER MONTH $15.30 PER WORKER Note 3: The optimal solution with fractional workers -- leave this as the optimal (e.g. considers part- time or temporary workers). If needed, compare results to that of only full-time workers by rounding or add an Integer constraint. $23.00 PER WORKER 40 HOURS PER WEEK OVERTIME HOURLY WAGE RATE: OPERATING TIME: (HOURS 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 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 $0 $120.000 $5,116 $0 $ 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $ $5,116 $0 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $5, 116 $0 0.0 $0 $0 $5,116 $0 0 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $ $5, 116 $0 0.0 $0 $0 0.0 $0 $0 $5,116 $0 0.0 $0 $0 $5,116 $0 $5,116 $0 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