Question: Enter your forecasts and how you arrived at your forecasts here. You have access to 4 years of sales data from Bama Burger Buggy, a
Enter your forecasts and how you arrived at your forecasts here. You have access to 4 years of sales data from Bama Burger Buggy, a local food truck operation. They need a sales forecast for the next three months for each item they sell. I would like to know how you came up with your forecast. That is the assignment. There is no wrong way to come up with the forecast but a more accurate forecast is worth more than an inaccurate one. Points will be earned based on the MSE derived from your forecast. Use the data file as you see fit. Put your answers here and submit. Date 456 1,253 1,968 1/1/18 2/1/18 3/1/18 4/1/18 5/1/18 6/1/18 7/1/18 8/1/18 9/1/18 10/1/18 11/1/18 12/1/18 1/1/19 2/1/19 3/1/19 4/1/19 5/1/19 6/1/19 7/1/19 8/1/19 9/1/19 10/1/19 11/1/19 12/1/19 1/1/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 1/1/21 2/1/21 3/1/21 4/1/21 5/1/21 6/1/21 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 1/1/22 2/1/22 3/1/22 Apr-22 May-22 Jun-22 Burgerz 1,492 1,191 1,290 1,208 1,332 845 709 842 1,174 1,308 1,341 1,335 2,044 1,687 1,707 1,736 1,822 1,041 906 1,042 1,657 1,844 1,795 1,889 1,175 950 970 997 938 716 601 644 951 1,012 1,018 1,063 1,547 1,411 1,594 1,465 1,388 987 726 892 1,440 1,466 1,569 1,673 2,492 2,160 2,338 ??? ??? ??? Units sold each month Cheese Burger Chicken Salad Fries 1,140 947 955 2,471 919 770 935 1,964 1,016 841 1,237 2,124 939 804 1,287 1,978 976 861 1,526 2,161 602 599 1,742 1,503 517 1,763 623 611 1,540 1,515 865 753 1,165 1,891 1,025 903 987 2,179 1,022 852 918 2,230 1,000 831 884 2,181 1,605 1,258 1,135 3,201 1,287 1,031 1,124 2,643 1,373 1,075 1,531 2,741 1,373 1,094 1,754 2,701 1,446 1,141 2,029 2,877 787 692 2,144 1,795 651 614 2,428 1,613 790 718 1,987 1,789 1,321 1,035 1,528 2,642 1,463 1,158 1,257 2,937 1,400 1,059 1,080 2,774 1,489 1,186 1,137 2,994 906 800 840 711 667 758 1,646 720 669 1,025 1,710 696 678 1,061 1,687 677 664 1,152 1,654 512 542 1,347 1,329 415 486 1,369 1,196 421 470 1,144 1,176 707 674 975 1,669 727 680 781 1,745 744 686 737 1,645 833 768 798 1,818 1,219 966 962 2,525 1,101 909 978 2,280 1,236 1,003 1,394 2,553 1,114 923 1,530 2,360 1,060 886 1,534 2,278 712 651 1,933 1,752 511 525 1,984 1,386 635 603 1,614 1,568 1,092 885 1,335 2,315 1,168 957 1,041 2,350 1,230 1,014 1,010 2,461 1,283 1,050 1,025 2,646 1,979 1,463 1,263 3,795 1,740 1,287 1,330 3,287 1,856 1,415 1,984 3,625 ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? Soda 1,954 1,747 2,234 2,299 2,456 2,639 3,249 3,974 1,997 2,403 1,726 1,519 2,609 2,326 2,936 3,287 3,389 3,451 4,653 5,499 2,873 3,160 2,221 2,004 1,584 1,390 1,735 1,851 1,868 2,095 2,494 2,781 1,745 1,807 1,324 1,312 2,150 2,024 2,656 2,794 2,625 3,071 3,827 4,470 2,526 2,584 1,966 1,774 3,034 2,886 3,920 ??? Coffee 1,642 1,374 1,495 1,348 1,456 952 699 938 1,298 1,517 1,503 1,493 2,348 1,908 1,949 1,999 2,083 1,181 1,034 1,196 1,925 2,071 2,015 2,179 1,288 1,056 1,110 1,084 1,064 747 572 640 1,050 1,146 1,092 1,223 1,764 1,561 1,745 1,599 1,508 1,078 817 967 1,564 1,625 1,776 1,871 2,788 2,425 2,655
