Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given Data Formula: Printer Cost x 25% Forecast (Formula: Simple Linear Regression or trend function in excel) Forecast Error (Formula SLR w/ Seasonality -
Given Data Formula: Printer Cost x 25% Forecast (Formula: Simple Linear Regression or trend function in excel) Forecast Error (Formula SLR w/ Seasonality - Given Data) Country UAE Oman Kuwait KSA Bahrain DC (Formula: total of all demand) Country UAE Oman Kuwait KSA Bahrain DC Country UAE Oman Kuwait KSA Bahrain DC 1 1175 113 446 4826 1182 7742 1 1749 748 469 5942 791 9699 1 -213 -22 -3 -224 55 -606 2 2815 997 535 5572 1047 10966 2 1820 780 470 5994 785 9848 2 -417 -158 -3 -212 40 -702 3 1945 786 458 8496 554 12239 3 1890 813 470 6047 778 9998 3 -224 -97 -2 -251 16 -609 4 1810 1117 427 8176 203 11733 4 1960 845 471 6100 772 10147 4 -149 -98 -1 -173 4 -417 5 1533 1093 294 3623 1080 7623 5 2031 878 471 6152 766 10297 5 -76 -58 0 -46 14 -163 6 2606 1270 569 4145 424 9014 6 2101 910 472 6205 759 10447 6 -43 -22 0 -18 2 -64 7 1685 744 514 7290 343 10576 7 2171 943 472 6257 753 10596 7 28 13 0 31 -1 75 8 2422 982 540 5442 853 10239 8 2241 976 473 6310 746 10746 8 120 52 1 69 -11 218 9 2046 1058 462 8964 887 13417 9 2312 1008 473 6363 740 10896 9 168 93 1 189 -19 477 10 2174 1032 653 5769 836 10464 10 2382 1041 474 6415 733 11045 10 250 127 2 171 -25 521 11 2896 1125 376 6169 1161 11727 11 2452 1073 474 6468 727 11195 11 429 178 2 234 -44 750 12 2525 804 387 6301 501 10518 12 2523 1106 475 6521 721 11344 12 457 156 2 293 -23 823 Average 2136.00 926.75 471.75 6231.08 755.92 Total 331 164 0 64 8 304 Seasonality Index (Formula: Period Amount/Average of all periods) Forecast: Simple Linear Regression w/Seasonality (Formula: SLR Forecast x Seasonality Index) Holding Holding Possible Inventory Inventory Cost/Unit Cost (AED) 1 0.55 0.12 0.95 0.77 1.56 0.74 2 4 2 1.32 1.08 1.13 0.89 1.39 1.04 12 1 962 91 443 4602 1237 7136 Grand Total (without DC): 566 50 28311.654 2398 839 532 5360 1087 10264 Formula: sum of all the total per country 3 0.91 0.85 0.97 1.36 0.73 1.16 3 1721 689 456 8245 570 11630 4 0.85 1.21 0.91 1.31 0.27 1.12 4 1661 1019 426 8003 207 11316 Grand Total (with DC): 304 50 15211.81 5 0.72 1.18 0.62 0.58 1.43 0.72 5 1457 1035 294 3577 1094 7460 Formula: DC Total 10 07820 6 1.22 1.37 1.21 0.67 0.56 0.86 6 2563 1248 569 4127 426 8950 0.79 0.80 1.09 1.17 0.45 1.01 7 1713 757 514 7321 342 10651 Savings: AED 13,100 1.13 1.06 1.14 0.87 1.13 0.97 8 2542 1034 541 5511 842 9 0.96 1.14 0.98 1.44 1.17 1.28 9 2214 1151 463 9153 868 1.02 1.11 1.38 0.93 1.11 0.99 10 2424 1159 655 5940 811 10457 13894 10985 Formula: Grand Total (without DC) Holding Cost - Grand Total (with DC) Holding cost 11 1.36 1.21 0.80 0.99 1.54 1.11 11 3325 1303 378 6403 1117 12477 12 1.18 0.87 0.82 1.01 0.66 1.00 12 2982 960 389 6594 478 11341 Holding cost per unit Formula: Printer Cost x 25%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started