A B C D E F H 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 Table 2 Inventory list with Corresponding Category, Vendor, Price, and Lead Time. Lead time SKU # Category Vendor Price (months) SKU101 Fast Movers MAA (HLW) 1,987 4 SKU102 Fast Movers Scan 161 1 SKU103 Fast Movers MAA (MLW) 234 3 SKU104 Fast Movers MAA (MLW) 1,944 3 SKU105 Fast Movers KPLI 1,725 1 SKU106 Fast Movers KPLI 892 1 SKU107 Fast Movers KPLI 1,987 1 SKU108 Fast Movers Scan 1,898 1 SKU109 Fast Movers KPLI 462 1 SKU110 Fast Movers KPLI 1,098 1 SKU111 Medium Movers MAA (MLW) 433 3 SKU112 Medium Movers KPLI 2,801 1 SKU116 Medium Movers KPLI 127 1 SKU118 Slow Movers KPLI 3,062 1 SKU121 Very Slow Movers MAA (MLW) 3,211 3 SKU122 Medium Movers KPLI 2,388 1 SKU126 Very Slow Movers KPLI 9,921 1 SKU131 Slow Movers KPLI 7,796 1 SKU132 Medium Movers KPLI 1,732 1 SKU133 Slow Movers KPLI 4,883 1 SKU137 Very Slow Movers MAA (HLW) 49,121 4 SKU166 Slow Movers MAA (MLW) 8,769 3 SKU166 Very Slow Movers KPLI 7,771 1 SKU222 Slow Movers KPLI 22,844 1 SKU321 Medium Movers MAA (MLW) 4,208 3 SKU343 Very Slow Movers KPLI 4,323 1 SKU573 Very Slow Movers KPLI 6,543 1 SKU645 Slow Movers KPLI 3,546 1 DM102 Medium Movers MAA (HLW) 3,321 4 DM109 Very Slow Movers KPLI 1,322 1 DM115 Very Slow Movers Scan 5,023 1 DM124 Medium Movers KPLI 1,517 1 DM234 Medium Movers KPLI 1,656 1 DM245 Slow Movers KPLI 10,176 1 DM333 Medium Movers KPLI 3,178 1 Gr100 Very Slow Movers KPLI 5,437 1 Gr114 Slow Movers KPLI 11,936 1 Slow Movers MAA (HLW) 3,189 4 Gr355 Very Slow Movers KPLI 71,200 1 Gr365 Slow Movers KPLI 13,349 1 Gr122 Task: Forecast using the best forecasting methods applicable to this data stating your objective and interpreting your result. Make 53 use of Excel. 54 55 56 57 A B C D E F H 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 Table 2 Inventory list with Corresponding Category, Vendor, Price, and Lead Time. Lead time SKU # Category Vendor Price (months) SKU101 Fast Movers MAA (HLW) 1,987 4 SKU102 Fast Movers Scan 161 1 SKU103 Fast Movers MAA (MLW) 234 3 SKU104 Fast Movers MAA (MLW) 1,944 3 SKU105 Fast Movers KPLI 1,725 1 SKU106 Fast Movers KPLI 892 1 SKU107 Fast Movers KPLI 1,987 1 SKU108 Fast Movers Scan 1,898 1 SKU109 Fast Movers KPLI 462 1 SKU110 Fast Movers KPLI 1,098 1 SKU111 Medium Movers MAA (MLW) 433 3 SKU112 Medium Movers KPLI 2,801 1 SKU116 Medium Movers KPLI 127 1 SKU118 Slow Movers KPLI 3,062 1 SKU121 Very Slow Movers MAA (MLW) 3,211 3 SKU122 Medium Movers KPLI 2,388 1 SKU126 Very Slow Movers KPLI 9,921 1 SKU131 Slow Movers KPLI 7,796 1 SKU132 Medium Movers KPLI 1,732 1 SKU133 Slow Movers KPLI 4,883 1 SKU137 Very Slow Movers MAA (HLW) 49,121 4 SKU166 Slow Movers MAA (MLW) 8,769 3 SKU166 Very Slow Movers KPLI 7,771 1 SKU222 Slow Movers KPLI 22,844 1 SKU321 Medium Movers MAA (MLW) 4,208 3 SKU343 Very Slow Movers KPLI 4,323 1 SKU573 Very Slow Movers KPLI 6,543 1 SKU645 Slow Movers KPLI 3,546 1 DM102 Medium Movers MAA (HLW) 3,321 4 DM109 Very Slow Movers KPLI 1,322 1 DM115 Very Slow Movers Scan 5,023 1 DM124 Medium Movers KPLI 1,517 1 DM234 Medium Movers KPLI 1,656 1 DM245 Slow Movers KPLI 10,176 1 DM333 Medium Movers KPLI 3,178 1 Gr100 Very Slow Movers KPLI 5,437 1 Gr114 Slow Movers KPLI 11,936 1 Slow Movers MAA (HLW) 3,189 4 Gr355 Very Slow Movers KPLI 71,200 1 Gr365 Slow Movers KPLI 13,349 1 Gr122 Task: Forecast using the best forecasting methods applicable to this data stating your objective and interpreting your result. Make 53 use of Excel. 54 55 56 57
