Chapter 11: Capacity Planning Assignment 2 of How many workers do I need? LAWNKING Aggregate Planning Refer to the Lwin Case Huy in Part seves of the best with the updated data shown here Using your forecasted sales computad piously, compute all three options shown how, then compare them on the fact that C INPUT BATA 10 STAT 1 KONTALTO, ATSITORS TWENTORY WIN SERER WORE MINERO ET PERERE LAVUT CORT TE WORTE COST OF FLY MEDLED PRODUCT INES INVENTORY HOLDINOT of valve year INVESTIRAGE COV / GST ULAR BOURLY WE HAVE ITULY MORATE FERATING THE HOUSE/MEETI OPTIONS: 1) Chase Strategy 2) Level Strategy 5) Mixed Strategy 11.799 PER SIRE 11.101 PER PINE 517 PRIT ANWALLY Nech ROY 5. PER BACHONIER PER MONTH only as many kerranded each month HISPER WEER and they were in very as you 133.69 EUR LOS PER VEER 2 Fee HAF Apr may TR Sep Det ANUAL I TE Tales Portal We of worker With Produced ne taventory IT 1.225 1,23 1.215 1,235 1,231 1.210 1.235 1. 1.32 1,235 01 01 10 38 90 1 10 13 - . e 3 D Reg. Labor Costa Change in where from last month LIN Lapot tidade Shar. 10 03 01 09 SP 30 1 13 08 39 119,010 55, 116 30 30 35,16 10 10 59,014 10 05 911 ST it 911 10 30 95.1 30 311'5$ 33, 136 SD 15.114 13.114 15.118 sa 20 16 TEST TOTAL COST $5.916 45,516 $. IL 15.116 33,114 35,116 1125, 115 SIT'S 15.118 FIX $281,397 TOTAL COST OF THIS STRATEGY Level seu Meted trategy Comparison + Format Cand Farmer Powe . 021 . X U H LAWNKING Aggregate Planning MADDE ENFOR BATA BUITE 1.31 UTO WER OPTIONS: 1) Chase Strategy 2) Level Strategy Mixed Strategy MONTHLY PROD. KATE UNITS/R/NOTES MINT VENTORY RTR WDER OF MORE WIRE CONT FER WORK LAVOR CONT PERMORRER COST OF PULLY ASHLED PRODUCT CAVE 11 VENTORY BOLO CIT valus year TORT HOT DOGT WITT BARBOURLY RATE: VERTIR HOURLY WE HAVE PIATI HUSE 1.210 PER HERR 3.500 PER PER 119 PENIT . RALLY 5. PER MARIRE PER TE 15. PRI 13. PER WORREN Notes on Les workers must be the more er with the same rubory your met wedle whole . . 11 BUS PER WEER Pab mar Sale or Weber or workers United weg tento 1.22 12 1,25 1.225 1.220 1,233 LEIE 1.231 1,313 23 LE! 8 10 07 H 01 10 H 48 . . 3 31 O 08 08 30 00 10 01 se Change in. We tra Care Layout ter, det End-taw. Shart Casti 00 01 11 0120.000 5.116 O 91153 10 05.116 se F 3,114 30 15,114 13.18 80 #5,114 10 4 11.11 35,116 10 3,114 10 *11* 00 13 01 se st 10 3) MONTALT TOTAL COETE 35,114 125.11 15.11 13.110 15, 114 35.110 3,116 34 16 $161,397 TOTAL COST OF THIS STRATEGY & Center DTH Ondor Form Femei Toletes Format AWNKING Aggregate Planning Write in Pro's and Con's, as related to each tople below taventory Policy Avoiding Soon Employment policy Workers Point of View Company Point of View Method Cost of Metod Cha 518137 Level $181.397 Mixed 3101.397 Which method would you recommend??? Why 7777 C24 D 5 LAWNKING Aggregate Planning Refer to the LawnKing Case study in Part Seven of the text, with the updated data shown here. Using your forecasted sales computed previously, compute all three options shown below, then compare them all on the last sheet. BASIC INPUT DATA DATE 10 Jun 0 1 2 3 4 MONTHLY PROD RATE (UNITS/WORKERMONTH) BEGINNING INVENTORY (UNITS) BEGINNING NUMBER OF WORKERS HIRING COST PER WORKER LAYOFF COST PER WORKER COST OF FULLY ASSEMBLED PRODUCT CAVE S INVENTORY HOLDING COAT ( of value per year) INVENTORY SHORTAGE COST (COSTUNIT SHORT) REGULAR HOURLY WAGE RATE OVERTIME HOURLY WAGE RATE OPERATING TIME: THONS/WEEK) OPTIONS: 02 UNITS 1) Chase Strategy 1.225 UNITS 2) Level Strategy O WORKERS 3) Mixed Strategy $1,200 PER HRE $1,500 PER FRE 5179 PER UNIT 231 ANNUALLY Notes on Chase Strategy 525.00 PER BACKORDER PER MONTH only make as many toms as needed each month 515.30 PER WORKER ond the year with the same number in inventory as you started $23.00 PER WORKER only full-time employees slowed. whole number of workers 40 HOURS PER WEEK 5 6 Z 8 0 31 2 23 MONTHS: Jan Pab| Mas May Jul Au Oct Nov 05 Sales Forecast Number of Workers Units Produced 26 Chase strategy Level strategy Mixed strategy Comparison Type here to search O NS: se Strategy el Strategy ed Strategy 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 i.e. whole-number of workers) Jul Aug Sep Oct Nov Dec ANNUA TAN only as many sed com and they will be as you started THEOROLOMOV WOW SHORTAGE COSTCOSTUME HORT) HEGULARLY WAGE RATE OVERTUE HOURLY WADE RATE PENTING THE HERBACKORDER PER MONTH 115.1 PERWORKER 133.0 PER WORKER 40 HOURS PER WEEK MORE Aug E AU TW Prodent gy 12 12 125 1:25 1220 an 30 LO 30 30 SO 30 10 SO 0 0 0 DO 10 Chwa Both HC Layout En Cost Indic 10 0 130 1120.000 TH 0 10 10 5611 90 0 SO 50 3510 10 50 10 110 50 50 5.11 30 10 SO 11 so 10 10 5510 10 151 35110 10 35110 30 10 SO 50 15.10 35.110 11 15116 55 15 51,11 110 MONTHLY TOTALCO 55 15110 111 40 $181,397 TOTAL COST OF THIS STRATEGY Chase strategy Level strategy Med strategy Comparison UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to dose some apps Update now 021 f LAWNKING Aggregate Planning BASIC PUT DATA DATE 10. H l 1 4 7 HOO WHAI, 041 9 MH1 H10 HP) EOMMENTORY UNITI GEORO NUMBER OF WORRIES HCOST PER WORKER 10 LAYOFF COST PER WORKER TO PLAY DOCT E) 12 TO HOLOOT Iau pe A) INVENTORY SHORTAGE COSTCOSTAINT SHORT) REGRAR HOURLY WAGE RATE OVERTILE HOURLY WAGE RATE 10 ODERATE TEE OPTIONS: UNTS 1) Chase Strategy 1.22UNTS 2) Level Strategy DO WORKERS 3) Mixed Strategy 1,300 PERRE $1.500 PER FRE 179 PERUNT 2 MILIALLY Notes on Level Strate $ 25,00 PERLACKORDER PER MONTH workers must be the same EVERY month 5. 13.30 PER WORKER end the year with the same number inventory as you started $23.00 PER WORKER only me employees a lowedle who umber of worker 10 HOURS PER WEEK 11 HAI Jui 19 Rug tes Oct TAL T*** MENTORY SHORTAGE COSTCOSTUNT SHOR) REGUUR HOURY WAGE RATE OVERTE HOURLY WAGE RATE CETING NLY 25.00 PER ACKORDER PER MONTH 13.3 PER WORKER 25. PER WORKER HOURS PER WEEK Notes on Level Strategy workers must be the EVERY month end the year with the number invertory as you started Menengoes we woonber of workers Hey A MO DER . 9 0 . 12 1.22 1225 1225 1225 1225 1.225 1225 Se Force Number of Wors tushadice Energy Hey are Claw um Cou La Cost Ende End-In Shot 30 10 So 30 50 SO 0 $0 3120000 110 30 0 SO 0 so 30 35116 50 0 10 30 35110 30 0 50 50 so 1616 50 0 59 30 $9.116 30 9 50 90 5510 30 O so so 55100 10 SSIN $0 35110 36110 10 10 15.10 50 30 MONTHLY TOTA.COSI $5.96 35116 $5115 35110 35,116 55110 SS 55110 35116 156 $191, 397 TOTAL COST OF THIS STRATEGY D E H LAWNKING Aggregate Planning AUT DIATA DATE 10. WORTHY PRO MATEWORRONTO OR TOYOTA ORIGIN OF WORK COST PER WORKER LAYOFT COST PER WORKER DOT OF MY HAVE OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy DU WORKERS 03. PERI 11. PERFRE IT PERUNS an 11 Note 1: You can we the solution method under DATA , SOLVER. I ready for you! * ANNUALLY WENTORY SHORTAGE COSTCOSTUNT SHORTY REGULAR HOURLY WAGE RATE Note 2 you don't have SOLVER sted, and it under PILL OPTIONS MANAGE ADD-INS GO Check the SOLVER TOOLS 1. PER BACKORDER PER NO S. PER WORKER Note 2 The optimal solution with fractional workers-leave this as the optimale considers part-time or temporary workers needed, compare results to eat of only time workers by 530 PER WORKER rounding or add an integer constraint 4 HOURS PER WEEX GVERINE HOURLY WAGE RATE SERTIM TE INSERT Her Hey Det RE 19 TEGULAR HOURLY WAGERATE PER WORKER Note: The optimal solution with fractional workers leave this is the optimale condens part time or temporary workers needed. compare results to that of only come worlans by rounding or add an integer constraint OVERTLEHOORLY WAGE RATE 12.00 PER WORKER 4 HOURS PER WEEK 11 1H TH Rab My Jun D 0 0 0 umber Work Produced Ening 12:26 1225 122 20 1221 1725 to 50 10 10 10 30 w 10 10 10 Go Chang homh Hing Layout wodu Endow short 300 10 $120.000 35116 30 00 50 SO $5,110 00 10 10 15.10 so 00 30 30 36,116 10 $a SO 16.10 SD 80 50 30 35110 10 00 30 10 55.196 10 00 30 SO 35116 10 30 50 00 90 30 361 $ 00 10 50 15110 30 00 90 50 $50 30 55.11 MONTHLY TOTAL COST 1125.110 15110 55.110 55.10 55110 35116 35,116 3511 351 3516 $5. ERRER $181 397 TOTAL COST OF THIS STRATEGY Chase strategy Level strategy Mixed strategy Comparison Chapter 11: Capacity Planning Assignment 2 of How many workers do I need? LAWNKING Aggregate Planning Refer to the Lwin Case Huy in Part seves of the best with the updated data shown here Using your forecasted sales computad piously, compute all three options shown how, then compare them on the fact that C INPUT BATA 10 STAT 1 KONTALTO, ATSITORS TWENTORY WIN SERER WORE MINERO ET PERERE LAVUT CORT TE WORTE COST OF FLY MEDLED PRODUCT INES INVENTORY HOLDINOT of valve year INVESTIRAGE COV / GST ULAR BOURLY WE HAVE ITULY MORATE FERATING THE HOUSE/MEETI OPTIONS: 1) Chase Strategy 2) Level Strategy 5) Mixed Strategy 11.799 PER SIRE 11.101 PER PINE 517 PRIT ANWALLY Nech ROY 5. PER BACHONIER PER MONTH only as many kerranded each month HISPER WEER and they were in very as you 133.69 EUR LOS PER VEER 2 Fee HAF Apr may TR Sep Det ANUAL I TE Tales Portal We of worker With Produced ne taventory IT 1.225 1,23 1.215 1,235 1,231 1.210 1.235 1. 1.32 1,235 01 01 10 38 90 1 10 13 - . e 3 D Reg. Labor Costa Change in where from last month LIN Lapot tidade Shar. 10 03 01 09 SP 30 1 13 08 39 119,010 55, 116 30 30 35,16 10 10 59,014 10 05 911 ST it 911 10 30 95.1 30 311'5$ 33, 136 SD 15.114 13.114 15.118 sa 20 16 TEST TOTAL COST $5.916 45,516 $. IL 15.116 33,114 35,116 1125, 115 SIT'S 15.118 FIX $281,397 TOTAL COST OF THIS STRATEGY Level seu Meted trategy Comparison + Format Cand Farmer Powe . 021 . X U H LAWNKING Aggregate Planning MADDE ENFOR BATA BUITE 1.31 UTO WER OPTIONS: 1) Chase Strategy 2) Level Strategy Mixed Strategy MONTHLY PROD. KATE UNITS/R/NOTES MINT VENTORY RTR WDER OF MORE WIRE CONT FER WORK LAVOR CONT PERMORRER COST OF PULLY ASHLED PRODUCT CAVE 11 VENTORY BOLO CIT valus year TORT HOT DOGT WITT BARBOURLY RATE: VERTIR HOURLY WE HAVE PIATI HUSE 1.210 PER HERR 3.500 PER PER 119 PENIT . RALLY 5. PER MARIRE PER TE 15. PRI 13. PER WORREN Notes on Les workers must be the more er with the same rubory your met wedle whole . . 11 BUS PER WEER Pab mar Sale or Weber or workers United weg tento 1.22 12 1,25 1.225 1.220 1,233 LEIE 1.231 1,313 23 LE! 8 10 07 H 01 10 H 48 . . 3 31 O 08 08 30 00 10 01 se Change in. We tra Care Layout ter, det End-taw. Shart Casti 00 01 11 0120.000 5.116 O 91153 10 05.116 se F 3,114 30 15,114 13.18 80 #5,114 10 4 11.11 35,116 10 3,114 10 *11* 00 13 01 se st 10 3) MONTALT TOTAL COETE 35,114 125.11 15.11 13.110 15, 114 35.110 3,116 34 16 $161,397 TOTAL COST OF THIS STRATEGY & Center DTH Ondor Form Femei Toletes Format AWNKING Aggregate Planning Write in Pro's and Con's, as related to each tople below taventory Policy Avoiding Soon Employment policy Workers Point of View Company Point of View Method Cost of Metod Cha 518137 Level $181.397 Mixed 3101.397 Which method would you recommend??? Why 7777 C24 D 5 LAWNKING Aggregate Planning Refer to the LawnKing Case study in Part Seven of the text, with the updated data shown here. Using your forecasted sales computed previously, compute all three options shown below, then compare them all on the last sheet. BASIC INPUT DATA DATE 10 Jun 0 1 2 3 4 MONTHLY PROD RATE (UNITS/WORKERMONTH) BEGINNING INVENTORY (UNITS) BEGINNING NUMBER OF WORKERS HIRING COST PER WORKER LAYOFF COST PER WORKER COST OF FULLY ASSEMBLED PRODUCT CAVE S INVENTORY HOLDING COAT ( of value per year) INVENTORY SHORTAGE COST (COSTUNIT SHORT) REGULAR HOURLY WAGE RATE OVERTIME HOURLY WAGE RATE OPERATING TIME: THONS/WEEK) OPTIONS: 02 UNITS 1) Chase Strategy 1.225 UNITS 2) Level Strategy O WORKERS 3) Mixed Strategy $1,200 PER HRE $1,500 PER FRE 5179 PER UNIT 231 ANNUALLY Notes on Chase Strategy 525.00 PER BACKORDER PER MONTH only make as many toms as needed each month 515.30 PER WORKER ond the year with the same number in inventory as you started $23.00 PER WORKER only full-time employees slowed. whole number of workers 40 HOURS PER WEEK 5 6 Z 8 0 31 2 23 MONTHS: Jan Pab| Mas May Jul Au Oct Nov 05 Sales Forecast Number of Workers Units Produced 26 Chase strategy Level strategy Mixed strategy Comparison Type here to search O NS: se Strategy el Strategy ed Strategy 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 i.e. whole-number of workers) Jul Aug Sep Oct Nov Dec ANNUA TAN only as many sed com and they will be as you started THEOROLOMOV WOW SHORTAGE COSTCOSTUME HORT) HEGULARLY WAGE RATE OVERTUE HOURLY WADE RATE PENTING THE HERBACKORDER PER MONTH 115.1 PERWORKER 133.0 PER WORKER 40 HOURS PER WEEK MORE Aug E AU TW Prodent gy 12 12 125 1:25 1220 an 30 LO 30 30 SO 30 10 SO 0 0 0 DO 10 Chwa Both HC Layout En Cost Indic 10 0 130 1120.000 TH 0 10 10 5611 90 0 SO 50 3510 10 50 10 110 50 50 5.11 30 10 SO 11 so 10 10 5510 10 151 35110 10 35110 30 10 SO 50 15.10 35.110 11 15116 55 15 51,11 110 MONTHLY TOTALCO 55 15110 111 40 $181,397 TOTAL COST OF THIS STRATEGY Chase strategy Level strategy Med strategy Comparison UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to dose some apps Update now 021 f LAWNKING Aggregate Planning BASIC PUT DATA DATE 10. H l 1 4 7 HOO WHAI, 041 9 MH1 H10 HP) EOMMENTORY UNITI GEORO NUMBER OF WORRIES HCOST PER WORKER 10 LAYOFF COST PER WORKER TO PLAY DOCT E) 12 TO HOLOOT Iau pe A) INVENTORY SHORTAGE COSTCOSTAINT SHORT) REGRAR HOURLY WAGE RATE OVERTILE HOURLY WAGE RATE 10 ODERATE TEE OPTIONS: UNTS 1) Chase Strategy 1.22UNTS 2) Level Strategy DO WORKERS 3) Mixed Strategy 1,300 PERRE $1.500 PER FRE 179 PERUNT 2 MILIALLY Notes on Level Strate $ 25,00 PERLACKORDER PER MONTH workers must be the same EVERY month 5. 13.30 PER WORKER end the year with the same number inventory as you started $23.00 PER WORKER only me employees a lowedle who umber of worker 10 HOURS PER WEEK 11 HAI Jui 19 Rug tes Oct TAL T*** MENTORY SHORTAGE COSTCOSTUNT SHOR) REGUUR HOURY WAGE RATE OVERTE HOURLY WAGE RATE CETING NLY 25.00 PER ACKORDER PER MONTH 13.3 PER WORKER 25. PER WORKER HOURS PER WEEK Notes on Level Strategy workers must be the EVERY month end the year with the number invertory as you started Menengoes we woonber of workers Hey A MO DER . 9 0 . 12 1.22 1225 1225 1225 1225 1.225 1225 Se Force Number of Wors tushadice Energy Hey are Claw um Cou La Cost Ende End-In Shot 30 10 So 30 50 SO 0 $0 3120000 110 30 0 SO 0 so 30 35116 50 0 10 30 35110 30 0 50 50 so 1616 50 0 59 30 $9.116 30 9 50 90 5510 30 O so so 55100 10 SSIN $0 35110 36110 10 10 15.10 50 30 MONTHLY TOTA.COSI $5.96 35116 $5115 35110 35,116 55110 SS 55110 35116 156 $191, 397 TOTAL COST OF THIS STRATEGY D E H LAWNKING Aggregate Planning AUT DIATA DATE 10. WORTHY PRO MATEWORRONTO OR TOYOTA ORIGIN OF WORK COST PER WORKER LAYOFT COST PER WORKER DOT OF MY HAVE OPTIONS: 1) Chase Strategy 2) Level Strategy 3) Mixed Strategy DU WORKERS 03. PERI 11. PERFRE IT PERUNS an 11 Note 1: You can we the solution method under DATA , SOLVER. I ready for you! * ANNUALLY WENTORY SHORTAGE COSTCOSTUNT SHORTY REGULAR HOURLY WAGE RATE Note 2 you don't have SOLVER sted, and it under PILL OPTIONS MANAGE ADD-INS GO Check the SOLVER TOOLS 1. PER BACKORDER PER NO S. PER WORKER Note 2 The optimal solution with fractional workers-leave this as the optimale considers part-time or temporary workers needed, compare results to eat of only time workers by 530 PER WORKER rounding or add an integer constraint 4 HOURS PER WEEX GVERINE HOURLY WAGE RATE SERTIM TE INSERT Her Hey Det RE 19 TEGULAR HOURLY WAGERATE PER WORKER Note: The optimal solution with fractional workers leave this is the optimale condens part time or temporary workers needed. compare results to that of only come worlans by rounding or add an integer constraint OVERTLEHOORLY WAGE RATE 12.00 PER WORKER 4 HOURS PER WEEK 11 1H TH Rab My Jun D 0 0 0 umber Work Produced Ening 12:26 1225 122 20 1221 1725 to 50 10 10 10 30 w 10 10 10 Go Chang homh Hing Layout wodu Endow short 300 10 $120.000 35116 30 00 50 SO $5,110 00 10 10 15.10 so 00 30 30 36,116 10 $a SO 16.10 SD 80 50 30 35110 10 00 30 10 55.196 10 00 30 SO 35116 10 30 50 00 90 30 361 $ 00 10 50 15110 30 00 90 50 $50 30 55.11 MONTHLY TOTAL COST 1125.110 15110 55.110 55.10 55110 35116 35,116 3511 351 3516 $5. ERRER $181 397 TOTAL COST OF THIS STRATEGY Chase strategy Level strategy Mixed strategy Comparison