MKTG 462AA8 – Basics of Forecasting In Excel – 100 pointsNOTE FOR EXPERT:· Please watch ‘Lecture Video.mp4 (Click Here)’where professor goes over this assignment and see how the solution by...

1 answer below »
Please follow the instructions directed in the 'AA8 - Forecasting Basics Task.docx'. Simply answer the questions with screenshots. Additionally, there is a link to a 'Lecture_Video.mp4' within the AA8 - Forecasting Basics Task.docxwhere the professor goes over this assignment. Please watch to understand what the solution should look like. Please reach out if you have any questions, thank you!


MKTG 462 AA8 – Basics of Forecasting In Excel – 100 points NOTE FOR EXPERT: · Please watch ‘Lecture Video.mp4 (Click Here)’where professor goes over this assignment and see how the solution by answering the following questions with any appropriate screenshots. · Please have solution in American-English spelling The data you have access to is the weekly sales across all the department of a single WalMart store over little more than 2 years. Use the Excel sheet “Walmart_Store_1_Data – POST.xlsx” to answer the following questions. Question 1 (20 pts) Q1a. Calculate and report the sum, mean and standard deviation of weekly sales for department 79, 72, and 35 in a single table and report it below. Q1b. Plot a line graph for the weekly sales over time for departments 79, 72, and 35, one plot per department on the same Excel sheet as its data. Label each plot and copy/paste each into the space below. [PLOTS HERE] Question 2 (20 pts) Create a forecast ending 7/5/2013 for departments 79, 72, and 35, one forecast per department. Label each forecasted Excel sheet and corresponding forecast plot, then copy/paste each into the space below, and briefly answer the following questions. · What patterns (“seasonality”) do you notice for each department? · What type of products do you think are sold in each department? (hint: look at how sales dip or spike at certain times of the year) [RESPONSES HERE] [PLOTS HERE] Question 3 (20 pts) Create a NEW forecast for Department 35 ending on 8/1/2014, label and copy/paste the new line plot into the space below. Describe what happens to the “confidence intervals” of the forecast as time goes on. What does this reflect? [RESPONSES HERE] [PLOT HERE] Question 4 (20 pts) Pick ANOTHER department of your choice (e.g. not 12, 79, 72, or 35), and do the following · Create a forecast ending 7/5/2013 · Copy/paste the labeled line plot below · Describe what you see. What do you think might be sold in this department? How accurate does the forecast appear, for how long into the future, and why? [RESPONSES HERE] [PLOT HERE] Question 5 (20 pts) Pick ANOTHER department of your choice (e.g. not 12, 79, 72, 35, or the one you just chose), and do the following · Create a forecast ending 7/5/2013 · Copy/paste the labeled line plot below · Describe what you see. What do you think might be sold in this department? How accurate does the forecast appear, for how long into the future, and why? · Compare this new department to the one in you chose in Question 4. Describe any similarities or differences. · Presume you get to pick one of these departments to have a job where you bonus is tied to how well the department does. Which one would you rather be “the boss?” Why? [RESPONSES HERE] [PLOT HERE] Store 1 All Store_NmDateWeekly SalesTypeSizeDeptNumber of RecordsMarkDown1MarkDown2MarkDown3MarkDown4MarkDown5CPITemperatureUnemploymentFuel PriceIs Holiday 12/5/1024924.5A15131511NANANANANA211.09642.318.1062.5720 12/12/1046039.49A15131511NANANANANA211.24238.518.1062.5481 12/19/1041595.55A15131511NANANANANA211.28939.938.1062.5140 12/26/1019403.54A15131511NANANANANA211.3246.638.1062.5610 13/5/1021827.9A15131511NANANANANA211.3546.58.1062.6250 13/12/1021043.39A15131511NANANANANA211.38157.798.1062.6670 13/19/1022136.64A15131511NANANANANA211.21654.588.1062.720 13/26/1026229.21A15131511NANANANANA211.01851.458.1062.7320 14/2/1057258.43A15131511NANANANANA210.8262.277.8082.7190 14/9/1042960.91A15131511NANANANANA210.62365.867.8082.770 14/16/1017596.96A15131511NANANANANA210.48966.327.8082.8080 14/23/1016145.35A15131511NANANANANA210.43964.847.8082.7950 14/30/1016555.11A15131511NANANANANA210.3967.417.8082.780 15/7/1017413.94A15131511NANANANANA210.3472.557.8082.8350 15/14/1018926.74A15131511NANANANANA210.33774.787.8082.8540 15/21/1014773.04A15131511NANANANANA210.61776.447.8082.8260 15/28/1015580.43A15131511NANANANANA210.89780.447.8082.7590 16/4/1017558.09A15131511NANANANANA211.17680.697.8082.7050 16/11/1016637.62A15131511NANANANANA211.45680.437.8082.6680 16/18/1016216.27A15131511NANANANANA211.45484.117.8082.6370 16/25/1016328.72A15131511NANANANANA211.33984.347.8082.6530 17/2/1016333.14A15131511NANANANANA211.22480.917.7872.6690 17/9/1017688.76A15131511NANANANANA211.10880.487.7872.6420 17/16/1017150.84A15131511NANANANANA211.183.157.7872.6230 17/23/1015360.45A15131511NANANANANA211.23583.367.7872.6080 17/30/1015381.82A15131511NANANANANA211.3781.847.7872.640 18/6/1017508.41A15131511NANANANANA211.50587.167.7872.6270 18/13/1015536.4A15131511NANANANANA211.639877.7872.6920 18/20/1015740.13A15131511NANANANANA211.60386.657.7872.6640 18/27/1015793.87A15131511NANANANANA211.56785.227.7872.6190 19/3/1016241.78A15131511NANANANANA211.53181.217.7872.5770 19/10/1018194.74A15131511NANANANANA211.49578.697.7872.5651 19/17/1019354.23A15131511NANANANANA211.52282.117.7872.5820 19/24/1018122.52A15131511NANANANANA211.59780.947.7872.6240 110/1/1020094.19A15131511NANANANANA211.67271.897.8382.6030 110/8/1023388.03A15131511NANANANANA211.74763.937.8382.6330 110/15/1026978.34A15131511NANANANANA211.81467.187.8382.720 110/22/1025543.04A15131511NANANANANA211.86169.867.8382.7250 110/29/1038640.93A15131511NANANANANA211.90969.647.8382.7160 111/5/1034238.88A15131511NANANANANA211.95658.747.8382.6890 111/12/1019549.39A15131511NANANANANA212.00459.617.8382.7280 111/19/1019552.84A15131511NANANANANA211.8951.417.8382.7710 111/26/1018820.29A15131511NANANANANA211.74864.527.8382.7351 112/3/1022517.56A15131511NANANANANA211.60749.277.8382.7080 112/10/1031497.65A15131511NANANANANA211.46646.337.8382.8430 112/17/1044912.86A15131511NANANANANA211.40549.847.8382.8690 112/24/1055931.23A15131511NANANANANA211.40552.337.8382.8860 112/31/1019124.58A15131511NANANANANA211.40548.437.8382.9431 11/7/1115984.24A15131511NANANANANA211.40548.277.7422.9760 11/14/1117359.7A15131511NANANANANA211.45735.47.7422.9830 11/21/1117341.47A15131511NANANANANA211.82744.047.7423.0160 11/28/1118461.18A15131511NANANANANA212.19743.837.7423.010 12/4/1121665.76A15131511NANANANANA212.56742.277.7422.9890 12/11/1137887.17A15131511NANANANANA212.93736.397.7423.0221 12/18/1146845.87A15131511NANANANANA213.24857.367.7423.0450 12/25/1119363.83A15131511NANANANANA213.53662.97.7423.0650 13/4/1120327.61A15131511NANANANANA213.82359.587.7423.2880 13/11/1121280.4A15131511NANANANANA214.11153.567.7423.4590 13/18/1120334.23A15131511NANANANANA214.36362.767.7423.4880 13/25/1120881.1A15131511NANANANANA214.669.977.7423.4730 14/1/1120398.09A15131511NANANANANA214.83759.177.6823.5240 14/8/1123873.79A15131511NANANANANA215.07467.847.6823.6220 14/15/1128762.37A15131511NANANANANA215.29271.277.6823.7430 14/22/1150510.31A15131511NANANANANA215.4672.997.6823.8070 14/29/1141512.39A15131511NANANANANA215.62872.037.6823.810 15/6/1120138.19A15131511NANANANANA215.79664.617.6823.9060 15/13/1117235.15A15131511NANANANANA215.96475.647.6823.8990 15/20/1115136.78A15131511NANANANANA215.73467.637.6823.9070 15/27/1115741.6A15131511NANANANANA215.50477.727.6823.7860 16/3/1116434.15A15131511NANANANANA215.274837.6823.6990 16/10/1115883.52A15131511NANANANANA215.04483.137.6823.6480 16/17/1114978.09A15131511NANANANANA214.99886.417.6823.6370 16/24/1115682.81A15131511NANANANANA215.09183.587.6823.5940 17/1/1115363.5A15131511NANANANANA215.18485.557.9623.5240 17/8/1116148.87A15131511NANANANANA215.27785.837.9623.480 17/15/1115654.85A15131511NANANANANA215.36188.547.9623.5750 17/22/1115766.6A15131511NANANANANA215.42285.777.9623.6510 17/29/1115922.41A15131511NANANANANA215.48386.837.9623.6820 18/5/1115295.55A15131511NANANANANA215.54591.657.9623.6840 18/12/1114539.79A15131511NANANANANA215.60690.767.9623.6380 18/19/1114689.24A15131511NANANANANA215.66989.947.9623.5540 18/26/1114537.37A15131511NANANANANA215.73387.967.9623.5230 19/2/1115277.27A15131511NANANANANA215.79787.837.9623.5330 19/9/1117746.68A15131511NANANANANA215.861767.9623.5461 19/16/1118535.48A15131511NANANANANA216.04179.947.9623.5260 19/23/1117859.3A15131511NANANANANA216.37675.87.9623.4670 19/30/1118337.68A15131511NANANANANA216.71179.697.9623.3550 110/7/1120797.58A15131511NANANANANA217.04569.317.8663.2850 110/14/1123077.55A15131511NANANANANA217.35571.747.8663.2740 110/21/1123351.8A15131511NANANANANA217.51663.717.8663.3530 110/28/1131579.9A15131511NANANANANA217.67766.577.8663.3720 111/4/1139886.06A15131511NANANANANA217.83754.987.8663.3320 111/11/1118689.54A1513151110382.96115.67215.072406.626551.42217.99859.117.8663.2970 111/18/1119050.66A151315116074.12254.3951.98427.395988.57218.22162.257.8663.3080 111/25/1120911.25A15131511410.319855805.58554.92218.46860.147.8663.2361 112/2/1125293.49A151315115629.51681398.112084.6420475.3218.71548.917.8663.1720 112/9/1133305.92A151315114640.6519105.023639.4214461.8218.96243.937.8663.1580 112/16/1145773.03A151315115011.3267347.37225.794011.37219.17951.637.8663.1590 112/23/1146788.75A151315112725.3640.48634.724.92739.43219.35847.967.8663.1120 112/30/1123350.88A151315115762.146011.4260.36983.654735.78219.53644.557.8663.1291 11/6/1216567.69A151315116277.3921813.2143.11450.138483219.71449.017.3483.1570 11/13/1216894.4A151315115183.298025.8742.24453.083719.38219.89348.537.3483.2610 11/20/1218365.1A151315114139.872807.1933.88500.623400.21219.98654.117.3483.2680 11/27/1218378.16A151315111164.461082.7444111222.19220.07954.267.3483.290 12/3/1223510.49A1513151134577.13579.21160.5332403.95630.4220.17256.557.3483.360 12/10/1236988.49A1513151113925.16927.23101.648471.886886.04220.26548.027.3483.4091 12/17/1254060.1A151315119873.3311062.39.88409.313402.66220.42645.327.3483.510 12/24/1220124.22A151315119349.617556.013.21219.928143.59220.63757.257.3483.5550 13/2/1220113.03A1513151115441.4156910.825390.98067.61220.84860.967.3483.630 13/9/1221140.07A1513151110331151.886671.435509.84221.05958.767.3483.6690 13/16/1222366.88A151315114298.167.52.022724.652017.69221.21264.747.3483.7340 13/23/1222107.7A151315116118.569.484.97426.723657.22221.28665.937.3483.7870 13/30/1228952.86A1513151110309.60.510.251654.172642.78221.36167.617.3483.8450 14/6/1257592.12A1513151110122NA77.983750.594510.72221.43670.437.1433.8910 14/13/1234684.21A151315116186.193288.6917.071822.551063.78221.5169.077.1433.8910 14/20/1216976.19A151315112230.8612.0219.75275.135747.1221.56466.767.1433.8770 14/27/1216347.6A151315113221.25NA35.49577.146222.25221.61867.237.1433.8140 15/4/1217147.44A1513151121290.1NA69.894977.353261.04221.67275.557.1433.7490 15/11/1218164.2A151315118351.4NA10.522443.143127.88221.72673.777.1433.6880 15/18/1218517.79A151315116154.14NA45.111675.495508.18221.74370.337.1433.630 15/25/1216963.55A151315114039.39NA745.191429.963631.13221.74577.227.1433.5610 16/1/1216065.49A151315116086.2112370.51148.753690.85221.74777.957.1433.5010 16/8/1217666A151315118813.81116.864.552652.047161.91221.74978.37.1433.4520 16/15/1217558.82A151315115621.99109.60.252420.283083.26221.76379.357.1433.3930 16/22/1216633.41A151315118624.56171.253.052524.077063.68221.80378.397.1433.3460 16/29/1215722.82A151315113965.73161.6NA435.994212.97221.84384.887.1433.2860 17/6/1217823.37A1513151112218.894.4192.834066.016149.04221.88481.576.9083.2270 17/13/1216566.18A151315117218.1345.236.243909.382596.37221.92477.126.9083.2560 17/20/1216348.06A151315113213313.729.532262.023228.19221.93380.426.9083.3110 17/27/1215731.18A151315117146.9389.021.5910267.54325.19221.94182.666.9083.4070 18/3/1216628.31A1513151127584.8119.9830.23120074661.71221.9586.116.9083.4170 18/10/1216119.92A1513151111436.22456.856964.264836.22221.95885.056.9083.4940 18/17/1217330.7A151315113662.06137.864.842752.23446.15222.03884.856.9083.5710 18/24/1216286.4A151315116237.83260.062.973463.037988.25222.17277.666.9083.620 18/31/1216680.24A1513151121442.7102.3221.713209.63032.96222.30580.496.9083.6380 19/7/1218322.37A151315115204.6835.7450.944120.322737.17222.43983.966.9083.731 19/14/1219616.22A1513151117212.5718.791523.117992.72222.58274.976.9083.7170 19/21/1219251.5A151315116352.37.644.691010.066456.71222.78269.876.9083.7210 19/28/1218947.81A151315113666.277.641.651417.964744.28222.98276.086.9083.6660 110/5/1221904.47A151315118077.89NA18.223617.433626.14223.18168.556.5733.6170 110/12/1222764.01A151315112086.18NA8.11602.365926.45223.38162.996.5733.6010 110/19/1224185.27A15131511950.33NA4.9380.252312.85223.42667.976.5733.5940 110/26/1227390.81A151315112585.8531.7561057.161305.01223.44469.166.5733.5060 12/5/1050605.27A15131521NANANANANA211.09642.318.1062.5720 12/12/1044682.74A15131521NANANANANA211.24238.518.1062.5481 12/19/1047928.89A15131521NANANANANA211.28939.938.1062.5140 12/26/1044292.87A15131521NANANANANA211.3246.638.1062.5610 13/5/1048397.98A15131521NANANANANA211.3546.58.1062.6250 13/12/1043751.94A15131521NANANANANA211.38157.798.1062.6670 13/19/1043615.49A15131521NANANANANA211.21654.588.1062.720 13/26/1041892.55A15131521NANANANANA211.01851.458.1062.7320 14/2/1047450.5A15131521NANANANANA210.8262.277.8082.7190 14/9/1046549.73A15131521NANANANANA210.62365.867.8082.770 14/16/1045025.02A15131521NANANANANA210.48966.327.8082.8080 14/23/1044418.11A15131521NANANANANA210.43964.847.8082.7950 14/30/1045971.3A15131521NANANANANA210.3967.417.8082.780 15/7/1047903.01A15131521NANANANANA210.3472.557.8082.8350 15/14/1043675.61A15131521NANANANANA210.33774.787.8082.8540 15/21/1044319.15A15131521NANANANANA210.61776.447.8082.8260 15/28/1044619.52A15131521NANANANANA210.89780.447.8082.7590 16/4/1048754.47A15131521NANANANANA211.17680.697.8082.7050 16/11/1047089.54A15131521NANANANANA211.45680.437.8082.6680 16/18/1044428.71A15131521NANANANANA211.45484.117.8082.6370 16/25/1045299.92A15131521NANANANANA211.33984.347.8082.6530 17/2/1047077.72A15131521NANANANANA211.22480.917.7872.6690 17/9/1046752.12A15131521NANANANANA211.10880.487.7872.6420 17/16/1044339.2A15131521NANANANANA211.183.157.7872.6230 17/23/1044763.33A15131521NANANANANA211.23583.367.7872.6080 17/30/1045833.77A15131521NANANANANA211.3781.847.7872.640 18/6/1050031.73A15131521NANANANANA211.50587.167.7872.6270 18/13/1045475.69A15131521NANANANANA211.639877.7872.6920 18/20/1049754.17A15131521NANANANANA211.60386.657.7872.6640 18/27/1049623.53A15131521NANANANANA211.56785.227.7872.6190 19/3/1049015.05A15131521NANANANANA211.53181.217.7872.5770 19/10/1045182.5A15131521NANANANANA211.49578.697.7872.5651 19/17/1044681.64A15131521NANANANANA211.52282.117.7872.5820 19/24/1042477.49A15131521NANANANANA211.59780.947.7872.6240 110/1/1045829.02A15131521NANANANANA211.67271.897.8382.6030 110/8/1046387.54A15131521NANANANANA211.74763.937.8382.6330 110/15/1043110.79A15131521NANANANANA211.81467.187.8382.720 110/22/1042371.48A15131521NANANANANA211.86169.867.8382.7250 110/29/1044081.33A15131521NANANANANA211.90969.647.8382.7160 111/5/1046381.43A15131521NANANANANA211.95658.747.8382.6890 111/12/1043194.49A15131521NANANANANA212.00459.617.8382.7280 111/19/1041443.25A15131521NANANANANA211.8951.417.8382.7710 111/26/1045681.98A15131521NANANANANA211.74864.527.8382.7351 112/3/1044405.02A15131521NANANANANA211.60749.277.8382.7080 112/10/1046955.82A15131521NANANANANA211.46646.337.8382.8430 112/17/1049303.28A15131521NANANANANA211.40549.847.8382.8690 112/24/1059889.32A15131521NANANANANA211.40552.337.8382.8860 112/31/1035819.83A15131521NANANANANA211.40548.437.8382.9431 11/7/1143202.29A15131521NANANANANA211.40548.277.7422.9760 11/14/1139857.4A15131521NANANANANA211.45735.47.7422.9830 11/21/1141596.99A15131521NANANANANA211.82744.047.7423.0160 11/28/1141651.01A15131521NANANANANA212.19743.837.7423.010 12/4/1146829.12A15131521NANANANANA212.56742.277.7422.9890 12/11/1147595.35A15131521NANANANANA212.93736.397.7423.0221 12/18/1149202.06A15131521NANANANANA213.24857.367.7423.0450 12/25/1146165.25A15131521NANANANANA213.53662.97.7423.0650 13/4/1153035.54A15131521NANANANANA213.82359.587.7423.2880 13/11/1148465.72A15131521NANANANANA214.11153.567.7423.4590 13/18/1145222.3A15131521NANANANANA214.36362.767.7423.4880 13/25/1144293.54A15131521NANANANANA214.669.977.7423.4730 14/1/1146991.58A15131521NANANANANA214.83759.177.6823.5240 14/8/1148501.79A15131521NANANANANA215.07467.847.6823.6220 14/15/1144464.74A15131521NANANANANA215.29271.277.6823.7430 14/22/1146544.56A15131521NANANANANA215.4672.997.6823.8070 14/29/1143682.41A15131521NANANANANA215.62872.037.6823.810 15/6/1150139.92A15131521NANANANANA215.79664.617.6823.9060 15/13/1144274.15A15131521NANANANANA215.96475.647.6823.8990 15/20/1144302.11A15131521NANANANANA215.73467.637.6823.9070 15/27/1145072.11A15131521NANANANANA215.50477.727.6823.7860 16/3/1147844.27A15131521NANANANANA215.274837.6823.6990 16/10/1146363.93A15131521NANANANANA215.04483.137.6823.6480 16/17/1142939.63A15131521NANANANANA214.99886.417.6823.6370 16/24/1142415.81A15131521NANANANANA215.09183.587.6823.5940 17/1/1145247.74A15131521NANANANANA215.18485.557.9623.5240 17/8/1144623.23A15131521NANANANANA215.27785.837.9623.480 17/15/1143260.96A15131521NANANANANA215.36188.547.9623.5750 17/22/1145113.56A15131521NANANANANA215.42285.777.9623.6510 17/29/1143191.02A15131521NANANANANA215.48386.837.9623.6820 18/5/1149359.75A15131521NANANANANA215.54591.657.9623.6840 18/12/1145341.92A15131521NANANANANA215.60690.767.9623.6380 18/19/1146391.12A15131521NANANANANA215.66989.947.9623.5540 18/26/1147659.93A15131521NANANANANA215.73387.967.9623.5230 19/2/1149419.75A15131521NANANANANA215.79787.837.9623.5330 19/9/1143315.85A15131521NANANANANA215.861767.9623.5461 19/16/1142963.96A15131521NANANANANA216.04179.947.9623.5260 19/23/1143390.94A15131521NANANANANA216.37675.87.9623.4670 19/30/1146045.09A15131521NANANANANA216.71179.697.9623.3550 110/7/1149880.69A15131521NANANANANA217.04569.317.8663.2850 110/14/1143306.38A15131521NANANANANA217.35571.747.8663.2740 110/21/1142487.67A15131521NANANANANA217.51663.717.8663.3530 110/28/1141682.4A15131521NANANANANA217.67766.577.8663.3720 111/4/1147313.62A15131521NANANANANA217.83754.987.8663.3320 111/11/1144936.47A1513152110382.96115.67215.072406.626551.42217.99859.117.8663.2970 111/18/1143997.78A151315216074.12254.3951.98427.395988.57218.22162.257.8663.3080 111/25/1144259.59A15131521410.319855805.58554.92218.46860.147.8663.2361 112/2/1145928.14A151315215629.51681398.112084.6420475.3218.71548.917.8663.1720 112/9/1149357.43A151315214640.6519105.023639.4214461.8218.96243.937.8663.1580 112/16/1151137.42A151315215011.3267347.37225.794011.37219.17951.637.8663.1590 112/23/1165615.36A151315212725.3640.48634.724.92739.43219.35847.967.8663.1120 112/30/1143539.94A151315215762.146011.4260.36983.654735.78219.53644.557.8663.1291 11/6/1244481.38A151315216277.3921813.2143.11450.138483219.71449.017.3483.1570 11/13/1243353.09A151315215183.298025.8742.24453.083719.38219.89348.537.3483.2610 11/20/1243753.43A151315214139.872807.1933.88500.623400.21219.98654.117.3483.2680 11/27/1241556.23A151315211164.461082.7444111222.19220.07954.267.3483.290 12/3/1254322.24A1513152134577.13579.21160.5332403.95630.4220.17256.557.3483.360 12/10/1250581.06A1513152113925.16927.23101.648471.886886.04220.26548.027.3483.4091 12/17/1246085.47A151315219873.3311062.39.88409.313402.66220.42645.327.3483.510 12/24/1247080.12A151315219349.617556.013.21219.928143.59220.63757.257.3483.5550 13/2/1252608.51A1513152115441.4156910.825390.98067.61220.84860.967.3483.630 13/9/1248563.69A1513152110331151.886671.435509.84221.05958.767.3483.6690 13/16/1247346.32A151315214298.167.52.022724.652017.69221.21264.747.3483.7340 13/23/1244796.03A151315216118.569.484.97426.723657.22221.28665.937.3483.7870 13/30/1246529.68A1513152110309.60.510.251654.172642.78221.36167.617.3483.8450 14/6/1251805.88A1513152110122NA77.983750.594510.72221.43670.437.1433.8910 14/13/1243991.18A151315216186.193288.6917.071822.551063.78221.5169.077.1433.8910 14/20/1245561.85A151315212230.8612.0219.75275.135747.1221.56466.767.1433.8770 14/27/1245456.23A151315213221.25NA35.49577.146222.25221.61867.237.1433.8140 15/4/1250501.3A1513152121290.1NA69.894977.353261.04221.67275.557.1433.7490 15/11/1246717.76A151315218351.4NA10.522443.143127.88221.72673.777.1433.6880 15/18/1244411.23A151315216154.14NA45.111675.495508.18221.74370.337.1433.630 15/25/1245817.07A151315214039.39NA745.191429.963631.13221.74577.227.1433.5610 16/1/1247425.29A151315216086.2112370.51148.753690.85221.74777.957.1433.5010 16/8/1249439.58A151315218813.81116.864.552652.047161.91221.74978.37.1433.4520 16/15/1246637.48A151315215621.99109.60.252420.283083.26221.76379.357
Answered Same DayNov 25, 2022

Answer To: MKTG 462AA8 – Basics of Forecasting In Excel – 100 pointsNOTE FOR EXPERT:· Please watch...

Rochak answered on Nov 26 2022
9 Votes
MKTG 462
AA8 – Basics of Forecasting In Excel – 100 points
    NOTE FOR EXPERT:
· Please watch ‘Lecture Video.mp4 (Click Here)’where professor goes over this assignment and see how the solution by answering the following questions with any appropriate screenshots.
· Please have solution in American-English spelling
The data you have access to is the weekly sales across all the department of a single WalMart store over little more than 2 years. Use the Excel sheet “Walmart_Store_1_Data – POST.xlsx” to answer the following questions.
Question 1 (20 pts)
Q1a. Calculate and report the sum, mean and standard deviation of weekly sales for department 79, 72, and 35 in a single table and report it below.
    
    Department 79
    Department 72
    Department 35
    Sum
     48,58,395.39
     67,76,862.22
     3,62,609.52
    Mean
     33,974.79
     47,390.64
     2,535.73
    Standard Deviation
     6,611.64
     12,605.78
     586.83
Q1b. Plot a line graph for the weekly sales over time for departments 79, 72, and 35, one plot per department on the same Excel sheet as its data. Label each plot and copy/paste each into the space below.
Question 2 (20 pts)
Create a forecast ending 7/5/2013 for departments 79, 72, and 35, one forecast per department. Label each forecasted Excel sheet and corresponding forecast plot, then copy/paste each into the space below, and briefly answer the following questions.
· What patterns (“seasonality”) do you notice for each department?
· What type of products do you think are sold in eac
h department? (hint: look at how sales dip or spike at certain times of the year)
The patterns (“seasonality”) that can be noticed for each department are:
· Department 79: Weekly Seasonality
· Department 72: Annual Seasonality
· Department 35: Monthly Seasonality
Types of products sold
· Department 79: Perishable products
· Department 72: Cold products
· Department 35: Warm products
Question 3 (20 pts)
Create a NEW forecast for Department 35 ending on 8/1/2014, label and copy/paste the new line plot into the space below. Describe what happens to the “confidence intervals” of the forecast as time goes on. What does this reflect?
The confidence intervals, i.e., the lower limit goes below 0. This reflects that the sales can be 0 too at some time point in the future.
Question 4 (20 pts)
Pick ANOTHER department of your choice (e.g. not 12, 79, 72, or 35), and do the following
· Create a forecast ending 7/5/2013
· Copy/paste the labeled line plot below
· Describe what you see. What do you think might be sold in this department? How accurate does the forecast appear, for how long into the future, and why?
The department must be selling seasonal products. The forecast according to me does not seem accurate because of the volatility it has.
Question 5 (20 pts)
Pick ANOTHER department of your choice (e.g. not 12, 79, 72, 35, or the one you just chose), and do the following
· Create a forecast ending 7/5/2013
· Copy/paste the labeled line plot below
· Describe what you see. What do you think might be sold in this department? How accurate does the forecast appear, for how long into the future, and why?
· Compare this new department to the one in you chose in Question 4. Describe any similarities or differences.
· Presume you get to pick one of these departments to have a job where you bonus is tied to how well the department does. Which one would you rather be “the boss?” Why?
· The department must be selling essential products and that is the reason there is no volatility. Also, the forecast appears to be accurate.
· The difference is that department 1 sales were very volatile while department 2 has fairly consistent sales
· I will choose Department 2 as here the bonus will be consistent
Department 79
Weekly Sales
Weekly Sales    40214    40221    40228    40235    40242    40249    40256    40263    40270    40277    40284    40291    40298    40305    40312    40319    40326    40333    40340    40347    40354    40361    40368    40375    40382    40389    40396    40403    40410    40417    40424    40431    40438    40445    40452    40459    40466    40473    40480    40487    40494    40501    40508    40515    40522    40529    40536    40543    40550    40557    40564    40571    40578    40585    40592    40599    40606    40613    40620    40627    40634    40641    40648    40655    40662    40669    40676    40683    40690    40697    40704    40711    40718    40725    40732    40739    40746    40753    40760    40767    40774    40781    40788    40795    40802    40809    40816    40823    40830    40837    40844    40851    40858    40865    40872    40879    40886    40893    40900    40907    40914    40921    40928    40935    40942    40949    40956    40963    40970    40977    40984    40991    40998    41005    41012    41019    41026    41033    41040    41047    41054    41061    41068    41075    41082    41089    41096    41103    41110    41117    41124    41131    41138    41145    41152    41159    41166    41173    41180    41187    41194    41201    41208    46729.77    36080.86    34141.620000000003    33309.85    42931.77    31669.24    32604.49    29223.39    40910.94    37815.5    32135.69    28230.720000000001    30450.45    44039.92    30719.18    30190.720000000001    28195.06    42732.59    34564.68    29943.17    29521.94    37745.99    35320.410000000003    30200.62    29353.14    29275.56    43224.38    30376.79    28801.37    28990.87    39538.080000000002    34512.69    31291.01    27292.080000000002    31074.81    37770.25    29799.61    28439.7    25548.97    39589.08    29531.38    28073.27    29147.200000000001    32861.33    33269.22    31340.51    33497.1    24738.86    39984.6    30646.95    28181.68    27962.54    42065.78    36163.65    32462.04    30624.720000000001    45717.53    35519.370000000003    32251.01    28503.22    35814.980000000003    38752    31150.62    30833.66    28255.73    44271.49    33007.29    29087.29    28296.720000000001    42896.37    35023.199999999997    29656.36    29394.35    35335.800000000003    36448.879999999997    29505.119999999999    28530.68    28715.75    45837.83    29878.13    32156.49    29392.95    40331.25    34786.75    32427.96    29161.56    28876.959999999999    45059.56    30011.57    30190.3    28364.34    42665.35    31898.63    30928.23    33533.15    38806.559999999998    37340.339999999997    33041.49    34196.74    27676.43    42842.53    31338.33    31186    28937.93    47522.61    39360.339999999997    36855.68    31907.99    47896.34    39196.18    32723.279999999999    30097.93    30834.51    45342.21    30752.29    32581.33    30866.19    47342.76    34432.74    33905.440000000002    29874.35    37942.129999999997    41003.18    34184.660000000003    30684.35    30442.57    47794.94    32163.5    30048.55    29295.119999999999    45517.07    35436.11    32431.81    29424.5    30371.45    46501.08    33317.120000000003    29389.5    28492.34    48373.55    34139.980000000003    27982.85    29294.29    Week
Sales
Department 72
Weekly Sales
Weekly Sales    40214    40221    40228    40235    40242    40249    40256    40263    40270    40277    40284    40291    40298    40305    40312    40319    40326    40333    40340    40347    40354    40361    40368    40375    40382    40389    40396    40403    40410    40417    40424    40431    40438    40445    40452    40459    40466    40473    40480    40487    40494    40501    40508    40515    40522    40529    40536    40543    40550    40557    40564    40571    40578    40585    40592    40599    40606    40613    40620    40627    40634    40641    40648    40655    40662    40669    40676    40683    40690    40697    40704    40711    40718    40725    40732    40739    40746    40753    40760    40767    40774    40781    40788    40795    40802    40809    40816    40823    40830    40837    40844    40851    40858    40865    40872    40879    40886    40893    40900    40907    40914    40921    40928    40935    40942    40949    40956    40963    40970    40977    40984    40991    40998    41005    41012    41019    41026    41033    41040    41047    41054    41061    41068    41075    41082    41089    41096    41103    41110    41117    41124    41131    41138    41145    41152    41159    41166    41173    41180    41187    41194    41201    41208    98499.12    79636.320000000007    72377.789999999994    55590.73    65525.74    45046.81    41069.550000000003    40796.33    50079.67    43346.92    38711.22    42222.53    38131.53    39104.1    35355.339999999997    30922.75    31378.880000000001    38638.6    41297.839999999997    43244.02    42363.96    36242.120000000003    34523.839999999997    32796.050000000003    33638.519999999997    36106.410000000003    39070.699999999997    42051.15    44878.45    36690.76    43630.1    44555.16    43582.89    39528.86    39017.879999999997    30051.47    32775.14    34301.019999999997    34596.86    38960.78    44777.94    32072.93    196810.42    54268.03    44605.69    67832.13    121470.12    47448.91    42581.15    35873.69    41051.86    39918.870000000003    62891.35    71013.56    67900.899999999994    50577.46    54450.94    43535.72    43128.73    42627.73    36258.07    36512.94    39638.92    41104.42    33941.57    43167.81    41898.67    32615.01    34073.97    34638.69    30561.01    36041.85    36991.99    37493.58    32577.03    37570.26    35464.49    36132.57    41315.33    39234.129999999997    42481.55    49944.34    47054.71    38861.379999999997    44656.76    33809.019999999997    39319.17    38528.36    44370.76    56909.42    47743.78    63620.54    42060.480000000003    43050.78    203670.47    55188.08    60494.84    62424.9    94243.47    59732.61    39235.39    37248.54    37526.800000000003    43660.6    62524.58    98104.8    81287.05    57718.19    57117.62    48275.27    57135.91    44132.05    45350.26    40174.720000000001    40241.21    43176.95    33229.49    36683.629999999997    39483.03    35718.85    39801.69    39791.94    42900.32    44313.56    43726.7    37125.370000000003    38528.400000000001    44166.9    32363.17    34394.82    40143.72    40663.949999999997    40176.269999999997    39729.78    39515.269999999997    40231.040000000001    40346.480000000003    61883.75    50209.37    54480.13    42221.07    36267.08    35282.730000000003    Week
Sales
Department 35
Weekly Sales
Weekly Sales    40214    40221    40228    40235    40242    40249    40256    40263    40270    40277    40284    40291    40298    40305    40312    40319    40326    40333    40340    40347    40354    40361    40368    40375    40382    40389    40396    40403    40410    40417    40424    40431    40438    40445    40452    40459    40466    40473    40480    40487    40494    40501    40508    40515    40522    40529    40536    40543    40550    40557    40564    40571    40578    40585    40592    40599    40606    40613    40620    40627    40634    40641    40648    40655    40662    40669    40676    40683    40690    40697    40704    40711    40718    40725    40732    40739    40746    40753    40760    40767    40774    40781    40788    40795    40802    40809    40816    40823    40830    40837    40844    40851    40858    40865    40872    40879    40886    40893    40900    40907    40914    40921    40928    40935    40942    40949    40956    40963    40970    40977    40984    40991    40998    41005    41012    41019    41026    41033    41040    41047    41054    41061    41068    41075    41082    41089    41096    41103    41110    41117    41124    41131    41138    41145    41152    41159    41166    41173    41180    41187    41194    41201    41208    2770    2420    2176    2029.9    2752    2926    2861    1939    2275    3942    3204    3047    2454    3639    4173    2713    2932    3409    2798.5    2324    2873    2799.04    2788.5    2134    2742    1999    2639    2079    2449    2135    2273    1751    1842    2375    1816    3287    1874    2312    2483    3199    2229    2605    2870    3023    2735    3670    4279    1957.5    2029.75    1865    1828.57    1937    3111.97    3080.82    2901.88    2338.8200000000002    2709.82    2724.85    2936.44    3231.41    2610    2631.94    2859    3208.5    3631    3533.94    4090    2928.85    2780    2335.9699999999998    2970.4    2035.54    2143    2535.58    2552.52    2332.9499999999998    2523.9899999999998    1879.13    2590.31    1806.76    2666.68    2285.84    2081.31    2216.89    1771.64    2165.59    2210.41    1928.39    1953.39    2882.4    2179.0300000000002    2848.99    2576.34    2635.81    3126.99    2450.12    3023.41    3045.08    3532.72    2631.24    2013.82    2018.5    1852.48    1410.49    2571.73    3367.66    2394.5100000000002    2557.91    2801.79    2268.29    2934.74    2513.16    3174.24    3737.76    3320.38    2311.41    2578.9699999999998    2763.83    2768.22    2818.63    2473.4699999999998    3356.38    2727.51    2686.18    2293.3200000000002    2773.38    2531.92    1874.74    2044.01    2118.15    2138.88    2018.51    1842.08    1894.91    1623.92    1578.57    1547.07    1341.83    1773.32    1658.09    2228.94    1555.93    1459.47    Week
Sales
Department 79 Weekly Sales Forecast to 7/5/2013
Department 79 Weekly Sales    40214    40221    40228    40235    40242    40249    40256    40263    40270    40277    40284    40291    40298    40305    40312    40319    40326    40333    40340    40347    40354    40361    40368    40375    40382    40389    40396    40403    40410    40417    40424    40431    40438    40445    40452    40459    40466    40473    40480    40487    40494    40501    40508    40515    40522    40529    40536    40543    40550    40557    40564    40571    40578    40585    40592    40599    40606    40613    40620    40627    40634    40641    40648    40655    40662    40669    40676    40683    40690    40697    40704    40711    40718    40725    40732    40739    40746    40753    40760    40767    40774    40781    40788    40795    40802    40809    40816    40823    40830    40837    40844    40851    40858    40865    40872    40879    40886    40893    40900    40907    40914    40921    40928    40935    40942    40949    40956    40963    40970    40977    40984    40991    40998    41005    41012    41019    41026    41033    41040    41047    41054    41061    41068    41075    41082    41089    41096    41103    41110    41117    41124    41131    41138    41145    41152    41159    41166    41173    41180    41187    41194    41201    41208    41215    41222    41229    41236    41243    41250    41257    41264    41271    41278    41285    41292    41299    41306    41313    41320    41327    41334    41341    41348    41355    41362    41369    41376    41383    41390    41397    41404    41411    41418    41425    41432    41439    41446    41453    41460    46729.77    36080.86    34141.620000000003    33309.85    42931.77    31669.24    32604.49    29223.39    40910.94    37815.5    32135.69    28230.720000000001    30450.45    44039.92    30719.18    30190.720000000001    28195.06    42732.59    34564.68    29943.17    29521.94    37745.99    35320.410000000003    30200.62    29353.14    29275.56    43224.38    30376.79    28801.37    28990.87    39538.080000000002    34512.69    31291.01    27292.080000000002    31074.81    37770.25    29799.61    28439.7    25548.97    39589.08    29531.38    28073.27    29147.200000000001    32861.33    33269.22    31340.51    33497.1    24738.86    39984.6    30646.95    28181.68    27962.54    42065.78    36163.65    32462.04    30624.720000000001    45717.53    35519.370000000003    32251.01    28503.22    35814.980000000003    38752    31150.62    30833.66    28255.73    44271.49    33007.29    29087.29    28296.720000000001    42896.37    35023.199999999997    29656.36    29394.35    35335.800000000003    36448.879999999997    29505.119999999999    28530.68    28715.75    45837.83    29878.13    32156.49    29392.95    40331.25    34786.75    32427.96    29161.56    28876.959999999999    45059.56    30011.57    30190.3    28364.34    42665.35    31898.63    30928.23    33533.15    38806.559999999998    37340.339999999997    33041.49    34196.74    27676.43    42842.53    31338.33    31186    28937.93    47522.61    39360.339999999997    36855.68    31907.99    47896.34    39196.18    32723.279999999999    30097.93    30834.51    45342.21    30752.29    32581.33    30866.19    47342.76    34432.74    33905.440000000002    29874.35    37942.129999999997    41003.18    34184.660000000003    30684.35    30442.57    47794.94    32163.5    30048.55    29295.119999999999    45517.07    35436.11    32431.81    29424.5    30371.45    46501.08    33317.120000000003    29389.5    28492.34    48373.55    34139.980000000003    27982.85    29294.29    47115.320022792657    33776.647282127102    28276.693148350536    29378.069738495549    47064.269402155478    33725.596661489923    28225.642527713357    29327.01911785837    47013.218781518299    33674.546040852743    28174.591907076177    29275.968497221183    46962.16816088112    33623.495420215557    28123.541286438998    29224.917876584004    46911.11754024394    33572.444799578378    28072.490665801819    29173.867255946825    46860.066919606761    33521.394178941198    28021.440045164632    29122.816635309646    46809.016298969575    33470.343558304019    27970.389424527453    29071.766014672467    46757.965678332395    33419.29293766684    27919.338803890274    29020.715394035287    46706.915057695216    33368.242317029653    27868.288183253095    28969.664773398101    Lower 95CI    40214    40221    40228    40235    40242    40249    40256    40263    40270    40277    40284    40291    40298    40305    40312    40319    40326    40333    40340    40347    40354    40361    40368    40375    40382    40389    40396    40403    40410    40417    40424    40431    40438    40445    40452    40459    40466    40473    40480    40487    40494    40501    40508    40515    40522    40529    40536    40543    40550    40557    40564    40571    40578    40585    40592    40599    40606    40613    40620    40627    40634    40641    40648    40655    40662    40669    40676    40683    40690    40697    40704    40711    40718    40725    40732    40739    40746    40753    40760    40767    40774    40781    40788    40795    40802    40809    40816    40823    40830    40837    40844    40851    40858    40865    40872    40879    40886    40893    40900    40907    40914    40921    40928    40935    40942    40949    40956    40963    40970    40977    40984    40991    40998    41005    41012    41019    41026    41033    41040    41047    41054    41061    41068    41075    41082    41089    41096    41103    41110    41117    41124    41131    41138    41145    41152    41159    41166    41173    41180    41187    41194    41201    41208    41215    41222    41229    41236    41243    41250    41257    41264    41271    41278    41285    41292    41299    41306    41313    41320    41327    41334    41341    41348    41355    41362    41369    41376    41383    41390    41397    41404    41411    41418    41425    41432    41439    41446    41453    41460    37229.286601615808    23890.569373899954    18390.536152528261    19491.789169572483    34670.849907804681    21331.983963324074    15831.777486243313    16932.834711759904    32519.53852898319    19180.457830992855    13680.018209247759    14780.825046058673    30617.262893122235    17277.91747739588    11777.198022548599    12877.710680009061    28886.777343751775    15547.125901733889    10046.087396383053    11146.268542464146    27283.499010716034    13943.505830197868    8442.1140408768588    9541.9307943247622    25778.943716173657    12438.577092467749    6936.8014315004439    8036.2242373427798    24353.609524545762    11012.840815344887    5510.6535239709228    6609.6554475103512    22993.455030030796    9652.2580403182219    4149.6336465294153    5248.1898949549759    Upper...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here