Part 3 0.0/0.5 points (graded) In addition to the volatility, you also propose to analyze the fast moving items. You believe that the fast moving, highly volatile SKUs should be managed separately with more time spent on improving the forecasting capabilities. You select the criteria for fast moving to be selling 31 or more units per week and the criteria for highly volatile as having a CV greater than or equal to 0.51. (Note: When calculating the CV of each item, please do not round it.) Edit nent of Wis Feb 11 ar 26 Apr 2 What percentage of the total profit is contributed by these Fast Moving and Highly Volatile SKUs (both criteria satisfied)? Just enter a value and do not include the % sign. For example, if you think the value is 35.54%, just enter 35.5 (round to nearest 1 decimal place) ment ers se broces with ter mu prog he wo yos, hicroso acts Submit You have used 0 of 2 attempts t tin Eilitate singt juntos, Green Wuorescent protein many within short timescales en les axeleration of results Excel File Edit View Insert Format 10OIS Data Help Insert Home Formulas Data Page Layout View Review Cut Calibri (Body) 11 A. A Wrap Copy Paste B I Merg Format J28 X & fx F 1 B D E H G Dev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 SKU J50711 J60012 J10013 J22314 J22315 J37316 J20917 J94618 J87919 J95120 J33421 J70322 J32023 J13224 J79425 J76726 J28927 J86228 J28629 J77330 J85331 J78532 J23533 J49634 J83135 J61636 190237 J47238 J51839 J80840 149041 196742 J38343 Cost 15.26 12.68 13.56 28.59 18.84 12.61 19.13 23.05 17.11 7.41 25.36 10.45 13.1 24.91 18.85 27.76 16.52 21.27 18.93 24.34 26.7 25.86 9.56 12.72 6.48 28.29 6.41 14.75 18.81 5.94 27.46 7.31 10.03 Data on SKUS Price 26.09 47.13 43.53 48.15 30.92 40.24 48.41 45.71 39.32 45.29 47.2 37.04 38.93 40.32 32.79 47.01 56.51 33.64 57.48 52.16 64.66 46.76 40.49 38.8 36.45 51.11 43.78 30.11 42.68 24.61 66.49 21.27 32.51 Sales 28.2 29.4 6.2 45.5 45.3 83.5 28.1 78.8 50.2 8.7 6.1 52.6 5.2 9.6 18.6 68.4 37.2 15.9 31.3 73.2 59.7 72.2 81.1 53.8 33.6 52.8 72.5 4.1 55.2 78.5 37.6 18.4 41.8 5.8 24.5 5.4 14.1 10.5 9.5 4.9 75.7 18.8 6.1 2.2 17 0.9 7.1 3.8 38.4 6.1 9.5 13.3 18.4 10.2 51.4 45.3 13.3 10.2 18.3 27.5 3.1 24.2. 37.3 23.8 10.1 23.1 26 27 28 29 30 31 32 33 34 35 Data + Ready JAT HT Excel Edit File View Insert Format Data Tools Window Help Home Page Layout Formulas Data Review View 11 Calibri (Body) | Insert X cut Copy Format | A- A+ - Wrap Text Paste B I U- EE ilul Merge & Center J28 x fx A 8 D G E H F 27.46 7.31 10.03 10.38 21.41 23.09 37.6 18.4 41.8 52.9 40.7 15 5 23.8 10.1 23.1 31.2 31.8 4.3 33 34 35 36 37 38 39 40 41 42 43 44 189 169 45 46 47 48 49 J49041 J96742 38343 J26244 J62045 J14046 J38947 354548 J65149 J30650 J80951 J64752 J28953 JBO854 J10755 J70956 J63157 J70658 J53859 J20860 J39061 177662 J68563 J68464 J30865 J98166 J46067 J57468 J70469 J87470 27.59 14.22 27.36 7.78 19.3 185 9.21 18.46 22.06 24.77 8.52 6.95 28.51 19.65 13.73 66.49 21.27 32.51 44.32 31.46 47.32 32.8 58.63 44.67 40.12 40.71 $6.97 38.84 29.92 42.12 34.99 38.05 46.93 29.7 55.52 44.85 41.12 19.7 38.66 39.07 33.3 49.98 25.45 43.12 58.42 50 51 76.5 60.2 59.1 52.5 11.5 22.9 29.3 28.3 69.8 31.6 55.7 9.7 63.3 29 35.7 70.2 69.9 132 25.6 4.7 80.5 25.2 11.5 19.3 41.3 29.1 43.8 9.1 68 17.7 9.7 15.3 27.7 47.7 7 18.7 13.8 30.2 9.5 60.8 9.7 22.7 2.2 21.9 17.6 9.4 52 53 54 SS 56 57 8.69 19.33 6.69 58 59 60 61 62 63 26.73 8.7 29.87 22.26 64 Data on SKUS Threshold for Threshold for Threshold for Threshold for 02 Q3 Q4 05 051 31 15 65 66 Data + Ready SEP WP D 1 20 Part 3 0.0/0.5 points (graded) In addition to the volatility, you also propose to analyze the fast moving items. You believe that the fast moving, highly volatile SKUs should be managed separately with more time spent on improving the forecasting capabilities. You select the criteria for fast moving to be selling 31 or more units per week and the criteria for highly volatile as having a CV greater than or equal to 0.51. (Note: When calculating the CV of each item, please do not round it.) Edit nent of Wis Feb 11 ar 26 Apr 2 What percentage of the total profit is contributed by these Fast Moving and Highly Volatile SKUs (both criteria satisfied)? Just enter a value and do not include the % sign. For example, if you think the value is 35.54%, just enter 35.5 (round to nearest 1 decimal place) ment ers se broces with ter mu prog he wo yos, hicroso acts Submit You have used 0 of 2 attempts t tin Eilitate singt juntos, Green Wuorescent protein many within short timescales en les axeleration of results Excel File Edit View Insert Format 10OIS Data Help Insert Home Formulas Data Page Layout View Review Cut Calibri (Body) 11 A. A Wrap Copy Paste B I Merg Format J28 X & fx F 1 B D E H G Dev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 SKU J50711 J60012 J10013 J22314 J22315 J37316 J20917 J94618 J87919 J95120 J33421 J70322 J32023 J13224 J79425 J76726 J28927 J86228 J28629 J77330 J85331 J78532 J23533 J49634 J83135 J61636 190237 J47238 J51839 J80840 149041 196742 J38343 Cost 15.26 12.68 13.56 28.59 18.84 12.61 19.13 23.05 17.11 7.41 25.36 10.45 13.1 24.91 18.85 27.76 16.52 21.27 18.93 24.34 26.7 25.86 9.56 12.72 6.48 28.29 6.41 14.75 18.81 5.94 27.46 7.31 10.03 Data on SKUS Price 26.09 47.13 43.53 48.15 30.92 40.24 48.41 45.71 39.32 45.29 47.2 37.04 38.93 40.32 32.79 47.01 56.51 33.64 57.48 52.16 64.66 46.76 40.49 38.8 36.45 51.11 43.78 30.11 42.68 24.61 66.49 21.27 32.51 Sales 28.2 29.4 6.2 45.5 45.3 83.5 28.1 78.8 50.2 8.7 6.1 52.6 5.2 9.6 18.6 68.4 37.2 15.9 31.3 73.2 59.7 72.2 81.1 53.8 33.6 52.8 72.5 4.1 55.2 78.5 37.6 18.4 41.8 5.8 24.5 5.4 14.1 10.5 9.5 4.9 75.7 18.8 6.1 2.2 17 0.9 7.1 3.8 38.4 6.1 9.5 13.3 18.4 10.2 51.4 45.3 13.3 10.2 18.3 27.5 3.1 24.2. 37.3 23.8 10.1 23.1 26 27 28 29 30 31 32 33 34 35 Data + Ready JAT HT Excel Edit File View Insert Format Data Tools Window Help Home Page Layout Formulas Data Review View 11 Calibri (Body) | Insert X cut Copy Format | A- A+ - Wrap Text Paste B I U- EE ilul Merge & Center J28 x fx A 8 D G E H F 27.46 7.31 10.03 10.38 21.41 23.09 37.6 18.4 41.8 52.9 40.7 15 5 23.8 10.1 23.1 31.2 31.8 4.3 33 34 35 36 37 38 39 40 41 42 43 44 189 169 45 46 47 48 49 J49041 J96742 38343 J26244 J62045 J14046 J38947 354548 J65149 J30650 J80951 J64752 J28953 JBO854 J10755 J70956 J63157 J70658 J53859 J20860 J39061 177662 J68563 J68464 J30865 J98166 J46067 J57468 J70469 J87470 27.59 14.22 27.36 7.78 19.3 185 9.21 18.46 22.06 24.77 8.52 6.95 28.51 19.65 13.73 66.49 21.27 32.51 44.32 31.46 47.32 32.8 58.63 44.67 40.12 40.71 $6.97 38.84 29.92 42.12 34.99 38.05 46.93 29.7 55.52 44.85 41.12 19.7 38.66 39.07 33.3 49.98 25.45 43.12 58.42 50 51 76.5 60.2 59.1 52.5 11.5 22.9 29.3 28.3 69.8 31.6 55.7 9.7 63.3 29 35.7 70.2 69.9 132 25.6 4.7 80.5 25.2 11.5 19.3 41.3 29.1 43.8 9.1 68 17.7 9.7 15.3 27.7 47.7 7 18.7 13.8 30.2 9.5 60.8 9.7 22.7 2.2 21.9 17.6 9.4 52 53 54 SS 56 57 8.69 19.33 6.69 58 59 60 61 62 63 26.73 8.7 29.87 22.26 64 Data on SKUS Threshold for Threshold for Threshold for Threshold for 02 Q3 Q4 05 051 31 15 65 66 Data + Ready SEP WP D 1 20