10 4 x fx 82 B C D E Assignment 2 of 3: How many workers do I need? 5 LAWNKING Aggregate Planning Refer to the Lawnk here. Use your BES assignment. Then, the last sheet. 6 7 B BASIC INPUT DATA DATE: 16-Feb 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 MONTHLY PROD. RATE (UNITS/WORKER/MONTE): BEGINNING INVENTORY (UNITS) BEGINNING NUMBER OF WORKERS: MIRING COST PER WORKER LAYOPP COST PER WORKER: COST OF PULLY ASSEMBLED PRODUCT (AVE 5) 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) 82 UNITS 1,225 UNITS 80 WORKERS $1,200 PER HIR $1,500 PER FIR $179 PER UNI 288 ANNUALE. $25.00 PER BACI $15.30 POR MORE $23.00 PER WORK 40 HOURS PE MONTHS: Jan Teb ME Apr Sales Forecast Number of Workers Units Produced: Ending Inventory: 1,225 1.225 1.225 1,225 1.22 25 26 27 20 29 30 31 32 33 34 SO 50 $0 8 90 56 Reg. Labor Coats Change in workers from last month Hiring Costi Layott Costi End-Inv. Hold. Cost End-Inv. short. Cost -30 50 $120,000 55,116 $0 8% $5.116 so 50 SO $5,115 $0 50 50 $5,115 90 50 50 55.116 50 36 35 38 39 MONTHLY TOTAL COSTE $125.116 15.116 55.11 55,216 55,116 40 $181,397 TOTAL COST OF THIS STRATEGY Chase strategy Lovol strategy Mixed strategy Compari do I need? anning Refer to the LawnKing Case study in Part Seven of the text, with th here. Use your BEST forecasted sales computed previously in Ass assignment. Then, compute all three options shown below. Finally the last sheet. TE: 16-Feb B2 UNITS 1,225 UNITS 80 WORKERS OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy year): RT) + $1,200 PER HIRE $1,500 PER FIRE $179 PER UNIT 28 ANNUALLY $25.00 PER BACKORDER PER MONTH $15.30 PER WORKER $23.00 PER WORKER 40 HOURS PER WEEK Notes on Chase - only make as end the year wit only full-time em Feb Mar Apr May Jun Jul Aug 1,225 1,225 1,225 1,225 1,225 1, 225 1, 225 $0 $0 $ $0 $0 $0 so $0 0 $0 $0 $5.116 $0 0 $0 $0 $5,116 SO 0 $0 $0 $5,116 $0 0 $0 $0 $5,116 $0 0 $0 $0 $5, 116 $0 $0 $0 $5,116 $0 $0 $0 $5,116 $0 SS 55,116 $5,116 $5, 116 $5,116 $5,116 $5,116 $5.116 $5 T OF THIS STRATEGY Number Inser Delel 2 Wrap Text Merge & Center $ % 98 Conditional Format Call Formatting as Table Styles It Form K L M N # 0 study in Part Seven of the text, with the updated data shown sted sales computed previously in Assignment 1 for this all three options shown below. Finally, compare them all on OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy Series "Actual" Point 17 (17, 14,366) DER PER MONTH Notes on Chase Strategy |-only make as many items as needed each month -end the year with the same number in inventory as you started only full-time employees allowed (le, whole-number of workers) WEEK Get Dec ANNUAL hy Jun Jul Aug 0 1.225 25 1,225 1.225 1.225 1,225 1, 225 1,225 50 50 $0 $0 50 $0 $0 $0 D $0 50 116 $0 0 $0 $0 $5,116 $0 0 $0 $0 $5,116 $0 0 $0 SO 55, 116 $0 0 $0 $0 55,116 $0 0 $0 $0 $5,116 $0 0 SO 50 55,116 50 0 $0 so 55,116 50 $5,216 $5,116 55,116 116 $5,116 $5,116 $5,116 $5,116 LAWNKING TEATS Aggregate Planning 36 ST LE SORRER TO 1,135 BER 1.500 PER IN TERY OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy . OUTER 18 OREGA 1 TORT THE COUT GRACE LOTION AS NOT SET UWOYATRI MILLY 25. re codes TE 11.10 13.FER WORKER Serwcu Part 1 Notes on Lewed States 17 16.66 ersten IVERY and the year with the outer rysy tartad Te Apr may TA Bales ter wy SE! 1.22 1.135 SELE . 1,23 - 10 * 07 10 13 . 11 . . . - 10 . 11 10 00 11 PO E BLO be . , 11.114 . 10 15.116 1. 11.11 15,114 11.16 10 1,114 16 LIE 3 1.116 10 31 1.118 5, 7. 3.1 1.11 1.11 19,114 19 $101,39 TOTAL COST OF THIS STRATEGY LANNKING Aggregate Planning MIE SM OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy TORT OF WORKERS NESCO CA O FILM NET VE 1 11.10 PER 11.104 TERE 1110 PER Serie Pony Note ti You can see the method BATAI 16M6) LY No: Wyou do here OLVER PILE OPTIONS MANAGE ADONG Crash BOLVER TOOLS OCTO S. MACROPIX The winter were the optimale rych yn worden per con 11. room 2 3 TRE 13 ies 1.28 1.22 1. 1.22 HE 1, 1. S' 38 30 30 13 14 36 31 10 19 wie LI 1 0.0 3. 1. LE 0.0 10 00 0 . 10 00 1 120,000 15.11 06 00 | GO do con at 30 te 35.114 15.11 55,116 9115 11.11 SIT 15,116 18 15.11 19.114 10 . 1 WERE AL 13.11 13.11 13, 35,11 15.116 11.116 15.11 83, 25.11 13.11 383.397 TOTAL COST OF THIS STRATEGY B D E LAWNKING Aggregate Planning BASIC INPUT DATA DATE 16-Feb 122 81 MONTHLY PROD. RATE (UNITS/WORKER/MONTE): BEGINNING INVENTORY (UNITS): BEGINNING NUMBER OF WORKERS: HIRING COST PER WORKER: LAYOFF COST PER WORKER: COST OP FULLY ASSEMBLED PRODUCT (AVE $) $1,200 $1,500 $179 INVENTORY HOLDING COST of value per year) 288 INVENTORY SHORTAGE COST (COST/UNIT SHORT) $25.00 $15.30 REGULAR HOURLY WAGE RATE OVERTINE HOURLY WAGE RATE: OPERATING TIME: (HOURS/WEEK) $23.00 1 40 E MONTHS: Feb MAT Apr o 0 Sales Torecast Number of Workers: Units Produced Ending Inventory: 1.225 1.225 1,225 1,225 50 50 30 50 26 27 2 Reg. Labor Coats Change in workers from last month Wiring Costi Layott coat End-Inv. old. Costs End-ny. Short. Costa -10.0 50 $320,000 $5,116 50 0.0 $0 50 55, 116 SO 0.0 $0 so 55, 116 50 0.0 50 50 $5,116 SO 30 31 33 HOWTILY TOTAL COST: $225,116 55,116 35,116 55.11 35 36 $181, 397 TOTAL COST OF THIS STRATEGY Chose strategy Lovol strategy Miced strategy Ready 1 J K L UNITS OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy UNITS WORKERS PER HIRE PER PIRE PER UNIT Note 1: You can see the solution method under DATA ANNUALLY Note 2: If you don't have SOLVER listed, add it under F Check the SOLVER TOOLS. PER BACKORDER PER MONTE PER WORKER Note 3: The optimal solution with fractional workers - 1 time or temporary workers). If needed, compare resulte PER WORKER or add an Integer constraint. 0 HOURS PER WEEK Pr May Jun Jul Aug Sep Oct o o o o 0 o 25 1.225 1,225 1,225 1,225 1,225 1.225 50 $0 $0 SO $0 $0 $0 0.0 $0 SO 116 30 0.0 50 $0 $5,126 50 0.0 50 50 $5,116 30 0.0 $0 $0 $5,116 50 0.0 $0 $0 $5,116 $0 0.0 50 $0 55, 116 50 0.0 $0 $0 $5,116 30 116 $5,116 $5,116 55,116 $5,116 $5.116 $5,116 > 000 Formatting as Table Styles K M N O TIONS: Chase Strategy Level Strategy Mixed Strategy Series "Actual Point 17 Ste 1: You can see the solution method under DATA(17, 14,366) for you! ote 2: If you don't have SOLVER listed, add it under FILE, OPTIONS, MANAGE ADD-INS. GO. Check the SOLVER TOOLS. 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. Jul Aug Sep Oet Nov Dec ANNUAL or o 0 0 . 1,225 1,225 1,225 1,225 1,225 1.225 0 $0 $0 50 $0 50 $0 0.0 SO 0.6 50 50 16 50 0.0 50 50 $5.116 50 0.0 $0 $0 $5,116 $0 0.0 30 $0 $5,116 SO 0.0 $0 $0 $5, 116 50 098 50 SO $5,116 $0 $5, 116 116 $5,116 $5,116 $5,116 55.116 $5, 116 $5,116 1 LAWNKING Aggregate Planning Write in Pro's and Con's, as related to each tople below. Method Coul of Method Inventory Policy Acording Soon Every Employment policy Workers Point of View Company Pontofview Chane $181.397 Level $181.397 Series Actual Part 12 (17. 14,366 3161367 Which method would you recommend 777 Wym 10 4 x fx 82 B C D E Assignment 2 of 3: How many workers do I need? 5 LAWNKING Aggregate Planning Refer to the Lawnk here. Use your BES assignment. Then, the last sheet. 6 7 B BASIC INPUT DATA DATE: 16-Feb 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 MONTHLY PROD. RATE (UNITS/WORKER/MONTE): BEGINNING INVENTORY (UNITS) BEGINNING NUMBER OF WORKERS: MIRING COST PER WORKER LAYOPP COST PER WORKER: COST OF PULLY ASSEMBLED PRODUCT (AVE 5) 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) 82 UNITS 1,225 UNITS 80 WORKERS $1,200 PER HIR $1,500 PER FIR $179 PER UNI 288 ANNUALE. $25.00 PER BACI $15.30 POR MORE $23.00 PER WORK 40 HOURS PE MONTHS: Jan Teb ME Apr Sales Forecast Number of Workers Units Produced: Ending Inventory: 1,225 1.225 1.225 1,225 1.22 25 26 27 20 29 30 31 32 33 34 SO 50 $0 8 90 56 Reg. Labor Coats Change in workers from last month Hiring Costi Layott Costi End-Inv. Hold. Cost End-Inv. short. Cost -30 50 $120,000 55,116 $0 8% $5.116 so 50 SO $5,115 $0 50 50 $5,115 90 50 50 55.116 50 36 35 38 39 MONTHLY TOTAL COSTE $125.116 15.116 55.11 55,216 55,116 40 $181,397 TOTAL COST OF THIS STRATEGY Chase strategy Lovol strategy Mixed strategy Compari do I need? anning Refer to the LawnKing Case study in Part Seven of the text, with th here. Use your BEST forecasted sales computed previously in Ass assignment. Then, compute all three options shown below. Finally the last sheet. TE: 16-Feb B2 UNITS 1,225 UNITS 80 WORKERS OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy year): RT) + $1,200 PER HIRE $1,500 PER FIRE $179 PER UNIT 28 ANNUALLY $25.00 PER BACKORDER PER MONTH $15.30 PER WORKER $23.00 PER WORKER 40 HOURS PER WEEK Notes on Chase - only make as end the year wit only full-time em Feb Mar Apr May Jun Jul Aug 1,225 1,225 1,225 1,225 1,225 1, 225 1, 225 $0 $0 $ $0 $0 $0 so $0 0 $0 $0 $5.116 $0 0 $0 $0 $5,116 SO 0 $0 $0 $5,116 $0 0 $0 $0 $5,116 $0 0 $0 $0 $5, 116 $0 $0 $0 $5,116 $0 $0 $0 $5,116 $0 SS 55,116 $5,116 $5, 116 $5,116 $5,116 $5,116 $5.116 $5 T OF THIS STRATEGY Number Inser Delel 2 Wrap Text Merge & Center $ % 98 Conditional Format Call Formatting as Table Styles It Form K L M N # 0 study in Part Seven of the text, with the updated data shown sted sales computed previously in Assignment 1 for this all three options shown below. Finally, compare them all on OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy Series "Actual" Point 17 (17, 14,366) DER PER MONTH Notes on Chase Strategy |-only make as many items as needed each month -end the year with the same number in inventory as you started only full-time employees allowed (le, whole-number of workers) WEEK Get Dec ANNUAL hy Jun Jul Aug 0 1.225 25 1,225 1.225 1.225 1,225 1, 225 1,225 50 50 $0 $0 50 $0 $0 $0 D $0 50 116 $0 0 $0 $0 $5,116 $0 0 $0 $0 $5,116 $0 0 $0 SO 55, 116 $0 0 $0 $0 55,116 $0 0 $0 $0 $5,116 $0 0 SO 50 55,116 50 0 $0 so 55,116 50 $5,216 $5,116 55,116 116 $5,116 $5,116 $5,116 $5,116 LAWNKING TEATS Aggregate Planning 36 ST LE SORRER TO 1,135 BER 1.500 PER IN TERY OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy . OUTER 18 OREGA 1 TORT THE COUT GRACE LOTION AS NOT SET UWOYATRI MILLY 25. re codes TE 11.10 13.FER WORKER Serwcu Part 1 Notes on Lewed States 17 16.66 ersten IVERY and the year with the outer rysy tartad Te Apr may TA Bales ter wy SE! 1.22 1.135 SELE . 1,23 - 10 * 07 10 13 . 11 . . . - 10 . 11 10 00 11 PO E BLO be . , 11.114 . 10 15.116 1. 11.11 15,114 11.16 10 1,114 16 LIE 3 1.116 10 31 1.118 5, 7. 3.1 1.11 1.11 19,114 19 $101,39 TOTAL COST OF THIS STRATEGY LANNKING Aggregate Planning MIE SM OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy TORT OF WORKERS NESCO CA O FILM NET VE 1 11.10 PER 11.104 TERE 1110 PER Serie Pony Note ti You can see the method BATAI 16M6) LY No: Wyou do here OLVER PILE OPTIONS MANAGE ADONG Crash BOLVER TOOLS OCTO S. MACROPIX The winter were the optimale rych yn worden per con 11. room 2 3 TRE 13 ies 1.28 1.22 1. 1.22 HE 1, 1. S' 38 30 30 13 14 36 31 10 19 wie LI 1 0.0 3. 1. LE 0.0 10 00 0 . 10 00 1 120,000 15.11 06 00 | GO do con at 30 te 35.114 15.11 55,116 9115 11.11 SIT 15,116 18 15.11 19.114 10 . 1 WERE AL 13.11 13.11 13, 35,11 15.116 11.116 15.11 83, 25.11 13.11 383.397 TOTAL COST OF THIS STRATEGY B D E LAWNKING Aggregate Planning BASIC INPUT DATA DATE 16-Feb 122 81 MONTHLY PROD. RATE (UNITS/WORKER/MONTE): BEGINNING INVENTORY (UNITS): BEGINNING NUMBER OF WORKERS: HIRING COST PER WORKER: LAYOFF COST PER WORKER: COST OP FULLY ASSEMBLED PRODUCT (AVE $) $1,200 $1,500 $179 INVENTORY HOLDING COST of value per year) 288 INVENTORY SHORTAGE COST (COST/UNIT SHORT) $25.00 $15.30 REGULAR HOURLY WAGE RATE OVERTINE HOURLY WAGE RATE: OPERATING TIME: (HOURS/WEEK) $23.00 1 40 E MONTHS: Feb MAT Apr o 0 Sales Torecast Number of Workers: Units Produced Ending Inventory: 1.225 1.225 1,225 1,225 50 50 30 50 26 27 2 Reg. Labor Coats Change in workers from last month Wiring Costi Layott coat End-Inv. old. Costs End-ny. Short. Costa -10.0 50 $320,000 $5,116 50 0.0 $0 50 55, 116 SO 0.0 $0 so 55, 116 50 0.0 50 50 $5,116 SO 30 31 33 HOWTILY TOTAL COST: $225,116 55,116 35,116 55.11 35 36 $181, 397 TOTAL COST OF THIS STRATEGY Chose strategy Lovol strategy Miced strategy Ready 1 J K L UNITS OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy UNITS WORKERS PER HIRE PER PIRE PER UNIT Note 1: You can see the solution method under DATA ANNUALLY Note 2: If you don't have SOLVER listed, add it under F Check the SOLVER TOOLS. PER BACKORDER PER MONTE PER WORKER Note 3: The optimal solution with fractional workers - 1 time or temporary workers). If needed, compare resulte PER WORKER or add an Integer constraint. 0 HOURS PER WEEK Pr May Jun Jul Aug Sep Oct o o o o 0 o 25 1.225 1,225 1,225 1,225 1,225 1.225 50 $0 $0 SO $0 $0 $0 0.0 $0 SO 116 30 0.0 50 $0 $5,126 50 0.0 50 50 $5,116 30 0.0 $0 $0 $5,116 50 0.0 $0 $0 $5,116 $0 0.0 50 $0 55, 116 50 0.0 $0 $0 $5,116 30 116 $5,116 $5,116 55,116 $5,116 $5.116 $5,116 > 000 Formatting as Table Styles K M N O TIONS: Chase Strategy Level Strategy Mixed Strategy Series "Actual Point 17 Ste 1: You can see the solution method under DATA(17, 14,366) for you! ote 2: If you don't have SOLVER listed, add it under FILE, OPTIONS, MANAGE ADD-INS. GO. Check the SOLVER TOOLS. 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. Jul Aug Sep Oet Nov Dec ANNUAL or o 0 0 . 1,225 1,225 1,225 1,225 1,225 1.225 0 $0 $0 50 $0 50 $0 0.0 SO 0.6 50 50 16 50 0.0 50 50 $5.116 50 0.0 $0 $0 $5,116 $0 0.0 30 $0 $5,116 SO 0.0 $0 $0 $5, 116 50 098 50 SO $5,116 $0 $5, 116 116 $5,116 $5,116 $5,116 55.116 $5, 116 $5,116 1 LAWNKING Aggregate Planning Write in Pro's and Con's, as related to each tople below. Method Coul of Method Inventory Policy Acording Soon Every Employment policy Workers Point of View Company Pontofview Chane $181.397 Level $181.397 Series Actual Part 12 (17. 14,366 3161367 Which method would you recommend 777 Wym