#2 #1: Current sales trend is +8.8% versus last year Project sales, stocks, MDs, shortage and purchases based on current sales trend Orange highlighted BOM stock and purchase numbers are given ONLY FILL IN YELLOW CELLS Calculate purchases, ensuring that stocks are ON PLAN Dec and Jan BOM Current sales trend is -2.1% versus last year Project sales, stocks, MDs, shortage and purchases based on current sales trend Orange highlighted BOM stock and purchase numbers are given DO NOT CHANGE ANY OF THE ORANGE CELLS! FILL IN ALL THE YELLOW Jan Oct Nov Dec Jan Sales Sales Projected % inc/dec Plan $ Plan % inc/dec LY Oct 1176 8.8% 1133 4.8% 1081) 3272 33321 3199 Nov Dec 1334 1454 8.8% 8.8% 1285 14001 4.8% 4.8% 12261336 Proj % inc/dec Plan % inc/dec 573 683 5.5% 647 793 5.5% 752 543 BOM ACT/ Proj 1316 1545 Plan | Stocks 3501 3361 3622| 3477 2800 2688 Proj Plan LY 1288 1250 1430 1388 1545 1500 1148 1115 LY MDs MDs Proj Plan $ Plan % 284 25.1% 270 322 25.1% 307 351 25.1% 334 Proj Plan $ Plan % | LY | | 130 19.0% 122| 151 19.0% 142 109 19.0% 103 LY LY Shortage Shortage Proj Plan $ Plan % LY 40 3.5% 41 45 3.5% 47 49 3.5% 51 Proj Plan $ Plan % LLY 19 2.8% 17 22 16 2.8% 2.8% 2014 1 Purchases | Purchases ACT/Proj Plan LY 1505 1626 1554) 1773 16961 978 932 Proj Plan 1 LY 1010 974 924 1081) 1026 341 301 275 L The department is overbought January BOM. How much? 99 43 154 111 82 62 23 86 #3: You need to cancel enough styles to reduce the overage from problem #2 JAN BOM. Assume all the below styles are on order for January Choose carefully - there are right and wrong answers here! Only cancel the styles you need to. You must add up to close to but not over the amount that you are overstocked on Jan 1 TOTAL RETAIL OF STD Unit CANCELLE This Week Sales-4 wks DON Description Cost Retail Sales of sales STD Sales $ On Hand On Order STD Sell-thru % WOS ORDER Peaches long sleeve tee. $ 9.03 $ 20.99 128 499 $ 9,097 1035 151 5 EZ Flex sport neckline scrub top. $ 11.61 $ 26.99 150 621 $ 14,639 1002 289 5 EZ Flex classic v-neck scrub top. $ 11.61 $ 26.99 113 447 $ 10,616 907 370 7 long sleeve burnout tee. $ 9.89 $ 22.99 14 53 $ 1,044 18 3 fleece zip front scrub jacket. $ 10.32 $ 23.99 22 82 $ 2,084 131 3 warm-up scrub jacket $ 13.76 $ 31.99 30 115 $ 3,186 542 Flutter Effect print v-neck scrub top. $ 10.56 $ 23.99 42 $ 898 196 1 Fall Mystique print scrub top. $ 10.56 $ 23.99 110 $ 2,354 2 Pacific Dreams print scrub top. $ 10.56 $ 23.99 27 103 $ 2,193 3 Textural Difference print scrub top. $ 10.56 $ 23.99 16 69 $ 1,523 132 Fall Mystique print scrub jacket. $ 10.56 $ 23.99 23 92 $ 2,698 88 5 EZ Flex scrub pants. $ 13.64 $ 30.99 309 1221 $ 33,983 2284 5 classic crossover scrub top. $ 10.56 $ 23.99 441 $ 9,402 527 7 drawstring scrub pants. $ 10.56 $ 23.99 315 1252 $ 26,549 5766 3 double crossover trim scrub top. $ 9.68 $ 21.99 10 48 $ 1,038 2 cargo pocket scrub pants. $ 10.12 $ 22.99 46 175 $ 3,914 190 Work-it flip down scrub pants. $ 10.56 $ 23.99 240 $ 5,587 181 1 Cords Crystal empire waist t scrub top. $ 9.24 $ 20.99 83 $ 1,521 140 2 Cords unisex v-neck scrub top. $ 8.80 $ 19.99 63 $ 1,079 3 Cords unisex cargo scrub pants. $ 9.24 $ 20.99 20 84 $ 1,571 159 Cords Karlie cargo scrub pants. $ 11.04 $ 23.99 439 $ 8,847 951 5 Cords Vickiv-neck scrub top. $ 6.44 $ 13.99 199 $ 3,590 914 5 Cords long sleeve tee. $ 6.44 $ 13.99 286 $ 4,874 676 252 Cords Emily V-neck button scrub top. $ 9.20 $ 19.99 111 $ 2,137 645 3 Cords Mercy Work nursing clogs. $ 18.40 $ 39.99 12 52 $ 1,999 110 Cords Paparazzi print v-neck scrub top. $ 7.36 $ 15.99 239 $ 5,116 181 100 Cords Miss Sony print v-neck button scrub top. $ 10.12 $ 21.99 50 $ 1,082 116 1 Nickolette nursing clogs. $ 69.00 $ 149.99 7 25 $ 3,675 117 2 Lindsey nursing clogs. $ 59.80 $ 129.99 11 40 $ 6,889 185 3 Xenia nursing clogs. $ 55.20 $ 119.99 5 20 $ 2,052 100 Hibiscus print nursing clogs. $ 59.80 $ 129.99 2 8 $ 975 5 Fandangle print nursing clogs. $ 62.10 $ 134.99 1 7 $ 796 5 Koi Pond print nursing clogs. 60.75 $ 134.99 24 $ 3,159 7 Pearl Patent nursing clogs. 00 $ 119.99 $ 2,292 3 long sleeve t-shirts. 6.75 $ 14.99 1367 $ 17,573 8718 GELL zip-front hooded scrub jacket. 15.75 $ 34.99 $ 1,617 242 GELL Med Flex 1l unisex drawstring waist scrub pants. 12.15 $ 26.99 98 $ 2,505 313 1 GELL Medflex Il scrub top. 11.70 $ 25.99 139 $ 3,131 655 2 GELL Med Flex Il unisex V-neck scrub top. 10.80 $ 23.99 $ 2,305 254 3 GELL Quattro scrub pants. $ 13.50 $ 29.99 $ 12,300 2666 GELL Quattro scrub top. $ 13.05 $ 28.99 412 $ 10,544 2168 5 GELL Medflex Il drawstring scrub pants. $ 11.25 $ 24.99 29 107 $ 2,490 494 5 GELL 5-pocket cargo scrub pants. $ 13.50 $ 29.99 12 54 $ 1,504 273 GELL double swirl scrub top. $ 9.90 $ 21.99 29 $ 610 726 3 TOTAL 257310180 $ 237,039 34340 8398 total STD Total WOS Total WEIGHTED CXL SS sel-thru % 51 21 63 239 59 22 Bu 49 103 JUULUU WRITE A BULLET POINT OUTLINING WHAT YOU THOUGHT PROCESS WAS IN CHOOSING WHICH STYLES TO CANCEL SPECIFICALLY ALSO REFERENCE THE STYLE YOU THINK IS MOST IMPORTANT TO ADDRESS POINTS: Problem 1 3 points Problem 2 3 points Cancelled styles 3 points Bullet 1 point Dmt in ammo #2 #1: Current sales trend is +8.8% versus last year Project sales, stocks, MDs, shortage and purchases based on current sales trend Orange highlighted BOM stock and purchase numbers are given ONLY FILL IN YELLOW CELLS Calculate purchases, ensuring that stocks are ON PLAN Dec and Jan BOM Current sales trend is -2.1% versus last year Project sales, stocks, MDs, shortage and purchases based on current sales trend Orange highlighted BOM stock and purchase numbers are given DO NOT CHANGE ANY OF THE ORANGE CELLS! FILL IN ALL THE YELLOW Jan Oct Nov Dec Jan Sales Sales Projected % inc/dec Plan $ Plan % inc/dec LY Oct 1176 8.8% 1133 4.8% 1081) 3272 33321 3199 Nov Dec 1334 1454 8.8% 8.8% 1285 14001 4.8% 4.8% 12261336 Proj % inc/dec Plan % inc/dec 573 683 5.5% 647 793 5.5% 752 543 BOM ACT/ Proj 1316 1545 Plan | Stocks 3501 3361 3622| 3477 2800 2688 Proj Plan LY 1288 1250 1430 1388 1545 1500 1148 1115 LY MDs MDs Proj Plan $ Plan % 284 25.1% 270 322 25.1% 307 351 25.1% 334 Proj Plan $ Plan % | LY | | 130 19.0% 122| 151 19.0% 142 109 19.0% 103 LY LY Shortage Shortage Proj Plan $ Plan % LY 40 3.5% 41 45 3.5% 47 49 3.5% 51 Proj Plan $ Plan % LLY 19 2.8% 17 22 16 2.8% 2.8% 2014 1 Purchases | Purchases ACT/Proj Plan LY 1505 1626 1554) 1773 16961 978 932 Proj Plan 1 LY 1010 974 924 1081) 1026 341 301 275 L The department is overbought January BOM. How much? 99 43 154 111 82 62 23 86 #3: You need to cancel enough styles to reduce the overage from problem #2 JAN BOM. Assume all the below styles are on order for January Choose carefully - there are right and wrong answers here! Only cancel the styles you need to. You must add up to close to but not over the amount that you are overstocked on Jan 1 TOTAL RETAIL OF STD Unit CANCELLE This Week Sales-4 wks DON Description Cost Retail Sales of sales STD Sales $ On Hand On Order STD Sell-thru % WOS ORDER Peaches long sleeve tee. $ 9.03 $ 20.99 128 499 $ 9,097 1035 151 5 EZ Flex sport neckline scrub top. $ 11.61 $ 26.99 150 621 $ 14,639 1002 289 5 EZ Flex classic v-neck scrub top. $ 11.61 $ 26.99 113 447 $ 10,616 907 370 7 long sleeve burnout tee. $ 9.89 $ 22.99 14 53 $ 1,044 18 3 fleece zip front scrub jacket. $ 10.32 $ 23.99 22 82 $ 2,084 131 3 warm-up scrub jacket $ 13.76 $ 31.99 30 115 $ 3,186 542 Flutter Effect print v-neck scrub top. $ 10.56 $ 23.99 42 $ 898 196 1 Fall Mystique print scrub top. $ 10.56 $ 23.99 110 $ 2,354 2 Pacific Dreams print scrub top. $ 10.56 $ 23.99 27 103 $ 2,193 3 Textural Difference print scrub top. $ 10.56 $ 23.99 16 69 $ 1,523 132 Fall Mystique print scrub jacket. $ 10.56 $ 23.99 23 92 $ 2,698 88 5 EZ Flex scrub pants. $ 13.64 $ 30.99 309 1221 $ 33,983 2284 5 classic crossover scrub top. $ 10.56 $ 23.99 441 $ 9,402 527 7 drawstring scrub pants. $ 10.56 $ 23.99 315 1252 $ 26,549 5766 3 double crossover trim scrub top. $ 9.68 $ 21.99 10 48 $ 1,038 2 cargo pocket scrub pants. $ 10.12 $ 22.99 46 175 $ 3,914 190 Work-it flip down scrub pants. $ 10.56 $ 23.99 240 $ 5,587 181 1 Cords Crystal empire waist t scrub top. $ 9.24 $ 20.99 83 $ 1,521 140 2 Cords unisex v-neck scrub top. $ 8.80 $ 19.99 63 $ 1,079 3 Cords unisex cargo scrub pants. $ 9.24 $ 20.99 20 84 $ 1,571 159 Cords Karlie cargo scrub pants. $ 11.04 $ 23.99 439 $ 8,847 951 5 Cords Vickiv-neck scrub top. $ 6.44 $ 13.99 199 $ 3,590 914 5 Cords long sleeve tee. $ 6.44 $ 13.99 286 $ 4,874 676 252 Cords Emily V-neck button scrub top. $ 9.20 $ 19.99 111 $ 2,137 645 3 Cords Mercy Work nursing clogs. $ 18.40 $ 39.99 12 52 $ 1,999 110 Cords Paparazzi print v-neck scrub top. $ 7.36 $ 15.99 239 $ 5,116 181 100 Cords Miss Sony print v-neck button scrub top. $ 10.12 $ 21.99 50 $ 1,082 116 1 Nickolette nursing clogs. $ 69.00 $ 149.99 7 25 $ 3,675 117 2 Lindsey nursing clogs. $ 59.80 $ 129.99 11 40 $ 6,889 185 3 Xenia nursing clogs. $ 55.20 $ 119.99 5 20 $ 2,052 100 Hibiscus print nursing clogs. $ 59.80 $ 129.99 2 8 $ 975 5 Fandangle print nursing clogs. $ 62.10 $ 134.99 1 7 $ 796 5 Koi Pond print nursing clogs. 60.75 $ 134.99 24 $ 3,159 7 Pearl Patent nursing clogs. 00 $ 119.99 $ 2,292 3 long sleeve t-shirts. 6.75 $ 14.99 1367 $ 17,573 8718 GELL zip-front hooded scrub jacket. 15.75 $ 34.99 $ 1,617 242 GELL Med Flex 1l unisex drawstring waist scrub pants. 12.15 $ 26.99 98 $ 2,505 313 1 GELL Medflex Il scrub top. 11.70 $ 25.99 139 $ 3,131 655 2 GELL Med Flex Il unisex V-neck scrub top. 10.80 $ 23.99 $ 2,305 254 3 GELL Quattro scrub pants. $ 13.50 $ 29.99 $ 12,300 2666 GELL Quattro scrub top. $ 13.05 $ 28.99 412 $ 10,544 2168 5 GELL Medflex Il drawstring scrub pants. $ 11.25 $ 24.99 29 107 $ 2,490 494 5 GELL 5-pocket cargo scrub pants. $ 13.50 $ 29.99 12 54 $ 1,504 273 GELL double swirl scrub top. $ 9.90 $ 21.99 29 $ 610 726 3 TOTAL 257310180 $ 237,039 34340 8398 total STD Total WOS Total WEIGHTED CXL SS sel-thru % 51 21 63 239 59 22 Bu 49 103 JUULUU WRITE A BULLET POINT OUTLINING WHAT YOU THOUGHT PROCESS WAS IN CHOOSING WHICH STYLES TO CANCEL SPECIFICALLY ALSO REFERENCE THE STYLE YOU THINK IS MOST IMPORTANT TO ADDRESS POINTS: Problem 1 3 points Problem 2 3 points Cancelled styles 3 points Bullet 1 point Dmt in ammo
