Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
11:07 Safari .01 5GEO Forecast Bonus Fall 2022 2 AD Q . . . B C G H K M Units sold each month Date
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668ab199f3e67_465668ab199d37e0.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668ab19a6c65a_466668ab19a3ee62.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668ab19ae1034_466668ab19ac3964.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668ab19b4a909_467668ab19b312a9.jpg)
11:07 Safari .01 5GEO Forecast Bonus Fall 2022 2 AD Q . . . B C G H K M Units sold each month Date Burgerz Cheese Burger Chicken Salad Fries Soda Coffee 1/1/18 1,474 L,154 955 921 Use this page for any additional /1/18 3,030 1,962 1,195 1,620 929 766 383 2,516 1,715 work you want to do. 3/1/18 1,373 1,296 ,014 868 1,262 4/1/18 2,630 2,276 1,481 1,194 934 783 1,273 Think of it as Excel Scratch Paper. 2,464 /1/18 2,286 1,299 1,370 991 860 1,555 2,572 2,449 1,444 6/1/18 819 519 582 1,696 1,807 2,628 7/1/18 691 945 473 513 1,767 1,402 3,240 704 /1/18 869 24 651 1,560 1,739 9/1/18 3,996 977 1,168 878 736 1,129 2,314 10/1/18 2,085 1,314 1,292 1,020 896 998 13 2,720 2,399 1/1/18 1,514 1,373 L,026 860 908 2,822 1,728 2/1/18 1,340 1,508 1,015 826 884 2,705 L.576 1,493 /1/19 2,052 1,600 1,245 16 1,121 4,061 2,614 2,341 2/1/19 1,680 1,294 1,006 1,148 17 3/1/19 3,361 2,300 1,889 1,74 1,376 1,10 18 1,559 3,452 2,958 4/1/19 1,948 1,750 1,380 19 1,108 1,745 5/1/19 3,538 1,806 3,262 1,972 1.449 1,130 2,027 3.631 3,432 20 2.054 6/1/19 1,054 801 707 21 2,145 2,168 1,167 7/1/19 884 3,439 645 618 22 2,459 1,900 4,657 982 8/1/19 1,056 787 730 1,955 2,158 23 5,502 1,210 9/1/19 1,647 1,329 24 1,055 1,530 10/1/19 3,314 2,948 1,880 ,850 1,447 1,134 1,269 25 3,642 3,183 11/1/19 2,077 1,788 1.387 1,062 1,034 26 3.564 2,214 2/1/19 2.010 1,863 1,498 1,132 1.135 27 3,784 2,039 2,195 1/1/20 1,176 887 824 823 28 2,300 1,608 1,310 2/1/20 940 711 668 749 29 /1/20 1,951 1,363 1,000 1,073 730 651 30 1,012 2,115 1,712 /1/20 949 1,125 706 665 1,041 31 2,041 5/1/20 ,875 1,102 958 599 32 638 1,172 1,964 1,824 5/1/20 736 1,060 507 525 1,341 33 1,521 2,080 7/1/20 596 753 109 492 1,416 34 1,285 /1/20 593 2,444 578 445 472 1,129 35 1,342 2,745 9/1/20 966 621 712 651 980 36 1,950 10/1/20 1,733 1,078 1,007 733 37 678 839 2,100 11/1/20 1,816 1,149 1,020 760 683 788 38 2/1/20 2,005 1,298 1,123 1,099 825 771 786 2,308 39 1,370 1,226 1/1/21 1,599 1,214 933 930 3,179 2,146 2/1/21 1,759 1,404 1,121 883 41 970 2,866 3/1/21 1,986 1,586 1,587 1.249 1,004 1,380 42 3,147 2,639 4/1/21 1,751 1,461 1,140 929 1,468 43 2,925 2,787 1,582 5/1/21 1,366 1,058 881 44 1,591 2,789 2,643 6/1/21 1,498 977 703 669 1,919 2,052 45 7/1/21 3,103 1,109 730 515 526 46 1,975 1,640 3,780 808 8/1/21 895 532 618 1,595 47 1,807 4,445 979 9/1/21 1,412 1.086 894 1,347 48 2,875 2.569 1,568 10/1/21 1,167 970 49 994 2,921 11/1/21 2,566 1,554 1,628 1,223 980 957 50 3,160 12/1/21 1,950 1,754 1,675 1,272 1,040 991 51 3.418 1,822 1,849 4/1/22 2,163 1,741 1,511 52 1,327 3,797 2,788 2,951 2/1/22 1,934 1,562 53 1,267 1,489 3,312 2,591 2,527 3/1/22 2,096 1,730 54 1,389 2,162 3,625 3,525 /1/22 1,899 2,740 ,513 1,273 2,253 55 3,386 3,612 5/1/22 2,520 1,975 1,577 1,330 2,696 56 3,531 6/1/22 1,257 3,716 2,607 976 57 877 3,227 2,368 4,209 7/1/22 927 1,638 691 688 58 3,137 1,704 4,987 3/1/22 1,170 1,183 902 856 59 2,753 2,204 9/1/22 6,503 1,944 1,518 1.574 1,341 2,095 60 3,508 3,463 10/1/22 2,632 61 11/1/22 62 12/1/22 63 64 65 66 67 68 69 70 71 72 73 74 fx Enter text or formula here Monthly Sales Data... Burger Analy +2:54 Today 12:32 AM Alpha 4 Month Weighted MA Exp. Smoothing Actual 4 Month MA Deviation Absoluted Deviation Forecast Deviation Absoluted Deviation Deliver one m Date Coffee Forecast Deviation Absoluted Deviation Weights Forecast Jan-18 1620 0.1 0.15 Feb-18 1373 Mar-18 1481 0.25 0.50 Apr-18 1370 May-18 1444 Jun-18 945 Jul-18 704 Aug-18 977 Sep-18 1292 Oct. 18 1514 Nov-18 1508 Dec-18 1493 Jan- 19 2341 Feb-19 1889 Mar-19 1948 Apr-19 1972 May-19 2054 Jun-19 1167 Jul-19 982 Aug-19 1210 Sep-19 1880 Oct-19 2077 Nov-19 2010 Dec-19 2195 Jan-20 1310 Feb-20 1073 Mar-20 1125 Apr-20 1102 May-2 1060 Jun-20 753 Jul-20 578 Aug-20 621 Sep-20 1078 Oct-20 1149 Nov-20 1123 Dec-20 1226 Jan-21 1759 Feb-21 1587 Mar-21 1751 Apr-21 1582 May-21 1498 Jun-21 1109 Jul-21 808 Aug-21 979 Sep-21 1568 Oct-21 1628 Nov-21 1754 Dec-21 1849 Jan-22 2951 Feb-22 2527 Mar-22 2740 Apr-22 2520 May-22 2607 Jun-22 1638 Jul-22 1170 Minimum Aug-22 1518 Sep-22 2632 MAD MAD MAD Delete Recover2:54 Today 12:32 AM alpha Actual 4 Month MA 4 Month Weighted MA Exp. Smoothing te Hamburger n Absoluted Deviat Weights Forecast Deviation Hamburger Deviation Absoluted Deviation Deliver one mean 0.1 below Feb-18 1195 Mar-18 1296 0.25 Apr-18 1194 0.50 May-18 1299 Jun-18 819 Jul-18 691 Aug-18 869 Sep-18 1168 Oct-18 1314 Nov-18 1373 Dec-18 1340 Jan-19 2052 Feb-19 1680 Mar-19 1747 Apr-19 1750 May-19 1806 Jun-19 1054 Jul-19 884 1056 Sep-19 1647 Oct- 19 1850 1788 Dec-19 1863 1176 Feb-20 940 Mar-20 1000 pr-20 949 tay-20 un-20 Jul-20 WUR -20 Oct.20 1007 Nov-20 1020 Jee-20 1099 an- 21 1599 1404 Mar-21 1586 Apr- 21 1461 May-21 1366 Jun-21 977 Jul-21 730 Aug-21 895 1412 oct-21 1472 Nov-21 1554 Dec-21 1675 Jan-22 2163 Feb.22 1934 Mar-22 Apr-22 2096 1899 May-22 1975 Jun-22 1257 Jul-22 927 Aug.22 1183 Sep-22 1944 MAD Delete Recover2:55 Today K 1:34 AM C D E G H A B Name: Type your name here Section: Enter your sectic My forecast for Cheese Burger Soda Coffee Burgerz Chicken Salad Fries Oct-22 Nov-22 Dec-22 How did you arrive at your forecast (or what tool did you use)? 11 12 13 14 16 20 62% 33 34 35 36 37 38 39 40 41 42 43 44 My forecast Delete Recover
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668ab199f3e67_465668ab199d37e0.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668ab19a6c65a_466668ab19a3ee62.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668ab19ae1034_466668ab19ac3964.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668ab19b4a909_467668ab19b312a9.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started