Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3 Enter forecast F1 for July 2020; must be a whole number. Question 4 1 pts 1 pts Enter forecast F1 absolute % error for
3 Enter forecast F1 for July 2020; must be a whole number. Question 4 1 pts 1 pts Enter forecast F1 absolute % error for July 2020; round to 2 decimals. Do not use the % sign. S-month weighted porent moving vers mench average with smoothin moving 1/6 and 1 with weigher 15 alpha Actual Forecast Forecast forecast forecast Entry Year M Sales 11) 252) 410 Year Manth Actual Demand Forecast Abs. Forecast %als forecast Abd. error Nab 2F2) 0220 % sbs. Forecast 4 Ab arror F3 errer error F4 arar 14 1 2013 J 53212 50000 2020 Jan 9644 2 2013 Feb 45417 50482 2020 Feb 2013 Ma 41714 50322 2020 Mar 4 2013 Apr 38035 48781 46375 49531 2020 Apr 2013 May 45606 43722 47617 2020 May 2013 Jun 52087 42452 43146 47312 2020 Jun 2013 62300 45243 43540 4738 48015 2020 Jul 2013 Aug 55328 53467 58829 57813 50245 2020 Aug 92013 Sep 47589 56641 64752 $700 50977 2020 Sep 30 2013 O 11 43711 2013 Nov 36573 12 2013 Det 55142 60580 51369 41209 41586 46016 50449 2020 Oct 43435 2020 Nov 42724 35740 1999 47568 2020 Dec 13 2014 J 51132 14 2014 Feb 15 2014 Mar 47467 41983 42048 36436 42842 44555 47285 2021 Jan 42525 48059 50926 47839 2021 Feb 47800 Enter Mean Enter Enter MAD Enter MAD MAFE M Enter Enter MAE Mean Exter Exter MAD MAPE MAD MAPE dimas round to round 16 2014 Apr 17 2014 May 14 2014 Jun 192014 34535 46856 43006 41997 10013 40777 60334 4936 40756 39264 33422 41443 41822 44545 46928 45369 12953 $1853 36507 48025 21 2014 Sep 123014 Oct 15 2014 Nov 14 2014 Dec 45734 54406 42197 54845 48764 52967 38191 252015 36 2015 Feb 27 35418 46884 44756 44201 47359 43931 41000 35392 45566 48032 40112 34572 40583 45172 44600 42127 31875 45240 45401 30450 45100 47365 4146) 45452 282013 Apr 2015 May 102015 Jun 31 2015 34335 44033 Acces 44553 41146 30457 38580 Have 43000 47038 4330 35468 34046 42343 56604 40640 35303 41054 32 2015 Aug 4976) 48243 53001 53104 45366 33 2015 Sep 42364 M450 51541 46006 34 2015 Oct 39456 49777 54686 46344 45567 35015 Nov 36 2015 De 37 2016 32016 Feb 33264 44061 3655 38568 33167 M104 42045 40892 36432 30792 15864 41987 37977 36911 42556 44650 2016 Mar 2016 Apr 35H 36475 18429 34305 41346 29235 37068 38023 35639 40058 35046 33002 32025 4 2016 May 31459 38469 22 [2016] 40031 4 2016 44 2016 Aug 32615 29941 48189 MIL 33463 436 41019 45207 37916 33154 37456 18267 39755 4 36583 2016 Sep 2016 Oct 33591 2016 Nov 43529 48762 40147 42382 4156) 39483 39613 37556 31411 35368 18710 303 HULLES 46 2016 Oct 33591 42382 46563 47 2016 Nov 28337 37516 39483 39613 35811 35368 38710 48 2016 Dec 26681 32839 28242 30738 37154 49 2017 Jan 29832 29536 24261 27869 35583 50 2017 Feb 27707 28283 24315 28737 34720 51 2017 Mar $2 2017 Apr 21335 24509 28073 25877 28242 33668 27349 26298 26001 32294 53 2017 May 25566 24517 22768 22924 30650 54 2017 Jun 29208 23803 21844 24191 29887 55 2017 Jul 35154 25370 24417 27328 29785 56 2017 Aug 30913 29976 32979 32411 30590 57 2017 Sep 26714 31758 36305 32015 30638 58 2017 Oct 24506 30927 33980 28818 30049 59 2017 Nov 20674 27378 26137 25809 29218 60 2017 Dec 16056 23965 20613 22428 27936 61 2018 Jan 17932 20412 16231 18285 26154 62 2018 Feb 16657 18221 14562 17643 24921 63 2018 Mar 14734 16882 13954 16979 23681 64 2018 Apr 12835 16441 14669 15631 22339 65 2018 May 15366 14742 13186 13787 20913 66 2018 Jun 17563 14312 13133 14544 20081 67 2018 Jul 21129 15255 14684 16431 19703 68 2018 Aug 18588 18019 19822 19483 19917 69 2018 Sep 16089 19093 21826 19248 19718 70 2018 Oct 14731 18602 20441 17343 19174 71 2018 Nov 72 2018 Dec 73 2019 Jan 12429 16469 15729 15524 18508 9306 10372 74 2019 Feb 9637 10702 14416 12404 12155 9608 8431 13486 17596 10785 16353 10258 15456 75 2019 Mar 8524 9772 2895 9824 14583 76 2019 Apr 7435 9511 8350 9043 13674 77 2019 May 8886 8532 7569 7982 12738 78 2019 Jun 10165 8282 7598 8415 12160 79 2019 Jul 80 2019 Aug 12219 8829 8500 9508 11861 10758 81 2019 Sep 9339 10423 11463 11047 12628 11137 11270 11915 82 2019 Oct 8521 10772 11840 11741 10053 11381 83 2019 Nov 7191 9539 9117 8990 10952 84 2019 Dec 5431 8350 7189 7805 10388 85 2020 Jan 6032 5575 9644 86 2020 Feb 5607 4907 27 2020 Mar 4959 4612 2020 Apr 4335 89 2020 May 5166 90 2020 Jun 5918 91 2020 Jul 7104 92 2020 Aug 6263 93 2020 Sep 5464 94 2020 Oct 4956 95 2020 Nov 4184 56 2020 Dec 3181 97 2021 Jan 3512 98 2021 Feb 3267 3-month weighted Caponent moving -month average oothin moving with 3/6 Javerage rend weights 15 alpha Actual Fore-cast Fore-cast Fore-cast Forecast Entry Year Mo Sales 2(3) 3(930 4(74) Year Manth Actual Forecast Als Demand Forecast Als error 1 2013 53212 50000 2020 Jan 2 2013 Feb 45417 50482 2020 Feb 2013 Mar 43714 50322 2020 Mar 2013 Apr 38035 S 2015 May 45606 48761 46175 49331 2020 Apr 43722 40677 47637 2020 May 2013 Jun 52007 42452 43146 47332 2020 Jun 72013 62709 45243 43540 45736 48045 2020 Jul 10 11 2013 Aug 55128 2013 Sept 47589 2013 Oct 43711 2013 Nov 36873 12 2013 Dec 53467 58829 56641 55142 57812 50245 64752 57098 50977 60580 51363 30460 2020 Aug 2020 Sep 2020 Oct 45681 48809 46586 46016 49455 42724 36740 39996 47568 2020 Nov 2020 Dec 13 2014 51112 42068 36438 40042 47295 2021 Jan 14 15 2014 Feb 2014 Mar 47467 41909 44555 42525 48059 47859 48087 50926 48382 47800 2021 Feb 36 2014 Apr 36535 37 2014 May 43806 18 2014 un 50013 37422 19 2014 M 60234 41833 46815 46856 49364 44545 46928 41997 40756 33264 45369 40777 45135 45470 42443 20 2014 Au 2959 $1357 56503 44025 21 2014 Sep 45714 54406 64197 22 3014 O 41586 54845 53969 54393 49336 48764 48307 23 2014 Nov 34 2014 D 25 [2015] an 26 35438 42931 48032 2015 Feb 44607 27 2015 Mar 35450 26 2015 Apr 34335 29 2015 May 41166 2015 $1 2015 M 46884 44750 44301 47159 45039 35292 36418 45568 40513 34572 40583 45172 42123 30875 45240 45601 45190 47345 45467 44033 MORS 41861 44553 19467 38180 36459 41020 47018 38320 35148 30346 42743 56604 40840 35303 43994 12 2015 Aug 49763 48263 53301 52104 41366 3 2015 Sep 42964 14450 51543 460N 34 2015 Oct 35456 3 2015 Nov 33284 44061 SIGN 42056 4636 45547 41539 44650 16 2015 O 36556 38568 33167 36104 42945 37 2016 40852 36432 30792 41987 3 2016 Feb 37377 1911 31655 18830 41823 as 2016 Mar 33504 38475 36429 34700 4124 40 2016 Apr 29235 378 1023 15639 40094 41 2016 May 35046 316002 32025 31417 L 2016 40031 32425 29943 33158 37956 43 2016 Ju BIRD 3477 37456 33463 34263 44 2016 Ad 42364 450 45207 44437 39755 45 2016 Sep 36585 43529 45762 AUBEL 4047 4 2016 Oct 33595 42383 46563 79613 47 B016 Nov 28335 37554 3535368 30/30 44 2016 Dec 26681 37254 Forecast Abs. Xabs. Forecast 4 error 72 3(3) error 3 emer F 9644 Ab Nal error 14 error Fa MAD Enter Enter MAPE M Enter MAD Enter Exter MAPE Mean Enter MAD Enter Mean Exter Enter MAPE MAD MAPE round to abov above, dec above, above, round to above e round to round to dec round to dec round to dec 1 dec 1 40 2016 Apr 29235 37488 38023 35639 40096 41 2016 May 35046 42 2016 Jun 40031 43 2016 Jul 48189 44 2016 Aug 42368 45 2016 Sep 36589 33602 32625 29941 33158 37956 34771 33463 37456 38257 41089 45207 44427 39755 43529 32025 31417 38469 49762 43881 40147 46 2016 Oct 33591 42382 46563 39483 39613 47 2016 Nov 28337 37516 35811 35368 38710 48 2016 Dec 26681 32839 28242 30738 37154 49 2017 Jan 29832 29536 24261 27869 35583 50 2017 Feb 27707 28283 24315 28737 34720 51 2017 Mar 24509 28073 25877 28242 33668 52 2017 Apr 21335 27349 26298 53 2017 May 25566 24517 22768 54 2017 Jun 29208 23803 21844 25001 32294 22924 30650 24191 29887 $5 2017 Jul 35154 25370 24417 27328 29785 56 2017 Aug 30913 29976 32979 32411 30590 57 2017 Sep 26714 31758 36305 32015 30638 58 2017 Oct 24506 30927 33980 28818 30049 59 2017 Nov 20674 27378 26137 25809 29218 60 2017 Dec 16056 23965 20613 22428 27936 61 2018 Jan 17932 20412 16231 18286 26154 62 2018 Feb 16657 18221 14562 17643 24921 63 2018 Mar 14734 16882 13954 16979 23681 64 2018 Apr 12835 16441 14669 15631 22339 65 2018 May 15366 14742 13186 13787 20913 66 2018 Jun 17563 14312 13133 14544 20081 67 2018 Jul 21129 15255 14684 16431 19703 68 2018 Aug 18588 18019 19822 19483 19917 69 2018 Sep 16089 19093 21826 19248 19718 70 2018 Oct 14731 18602 20441 17343 19174 71 2018 Nov 12429 16469 15729 15524 18508 72 73 2019 Jan 74 2019 Feb 2018 Dec 9306 14416 12404 13486 17596 10372 12155 9608 10785 16353 9637 10702 8431 10258 15456 75 2019 Mar 8524 9772 7895 9824 14583 76 2019 Apr 7435 9511 8350 9043 13674 77 2019 May 8886 8532 7569 7982 12738 78 2019 Jun 10165 8282 7598 8415 12160 79 2019 Jul 12219 8829 8500 9508 11861 80 2019 Aug 10758 10423 11463 21270 11915 81 2019 Sep 9339 11047 12628 11137 11741 82 2019 Oct 8521 10772 11840 10053 11381 2019 Nov 7191 84 2019 Dec 5431 85 2020 Jan 6032 9539 9117 8350 7189 7805 8990 10952 10388 $575 9644 86 2020 Feb 5607 4907 87 2020 Mar 4959 4612 88 2020 Apr 4335 89 2020 May 5166 90 2020 Jun 5918 91 2020 Jul 7104 92 2020 Aug 6263 93 2020 Sep 5464 94 2020 Oct 4956 95 2020 Nov 4184 96 2020 Dec 3181 97 2021 Jan 3512 98 2021 Feb 3267
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