(Mt) – Staffordshire University Food with The Given Data Paper

Unformatted Preview
HINTS v Try to do a research on trends of this type of company. v The data is declaring the number of advertisement/ weeks on the television v Take help of “Sample” already added in week 2 on Moodle for your report writing. v Use pivot table v Radio button v Hypothesis analysis v Forecasting v Come up with some recommendations v At least 1500 words for the report writing. IMPORTANT INSTRUCTIONS: The report should include 5 scenarios based on the food sales given in the excel shee The each scenarios use one of the following methods to explain: 1. Use pivot table 2. Radio button 3. Hypothesis Analysis 4. Forecasting The scenarios should include some recommendations and examples as well. HINTS v The information is showing order date, category, product wise quantity sold, unit price and total price of the company (name any ABC PVT LTD) at different region and cities. This company is in USA. v Try to do a research on trends of this type of company. v The data is declaring the number of advertisement/ weeks on the television v Analysis can be done based upon the number of advertisement and quantity sold, region wise, category wise and product wise sale. v Add alteast five references for the tools/techniques you might be using in your methodology such as correlation, regression, pivot tables, etc. v Take help of “Sample” already added in week 2 on Moodle for your report writing. v Use pivot table v Radio button v Hypothesis analysis v Forecasting v Come up with some recommendations v At least 1500 words for the report writing. IMPORTANT INSTRUCTIONS: The report should include 5 scenarios based on the food sales given in the excel sheet. The scen The each scenarios use one of the following methods to explain: 1. Use pivot table 2. Radio button 3. Hypothesis Analysis 4. Forecasting The scenarios should include some recommendations and examples as well. e excel sheet. The scenarios should be based on the data of the food sales. OrderDate Region 1/1/2020 East 1/4/2020 East 1/7/2020 West 1/10/2020 East 1/13/2020 East 1/16/2020 East 1/19/2020 East 1/22/2020 West 1/25/2020 East 1/28/2020 East 1/31/2020 East 2/3/2020 East 2/6/2020 East 2/9/2020 West 2/12/2020 East 2/15/2020 East 2/18/2020 East 2/21/2020 East 2/24/2020 West 2/27/2020 West 3/2/2020 East 3/5/2020 West 3/8/2020 East 3/11/2020 East 3/14/2020 West 3/17/2020 East 3/20/2020 East 3/23/2020 West 3/26/2020 East 3/29/2020 East 4/1/2020 West 4/4/2020 West 4/7/2020 East 4/10/2020 East 4/13/2020 West 4/16/2020 East 4/19/2020 East 4/22/2020 West 4/25/2020 East 4/28/2020 East 5/1/2020 West 5/4/2020 East 5/7/2020 East 5/10/2020 West 5/13/2020 West No of TV adds per week 3 8 6 7 4 5 10 4 9 2 1 2 1 3 1 1 3 9 3 2 4 2 3 3 4 2 3 2 8 12 4 5 6 1 1 3 11 1 3 2 2 9 11 1 1 City Category Product Boston Boston Los Angeles New York Boston Boston Boston Los Angeles New York New York Boston Boston Boston Los Angeles New York New York Boston Boston Los Angeles Los Angeles New York San Diego Boston Boston Los Angeles New York New York San Diego Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Los Angeles New York New York San Diego Boston Boston Los Angeles Los Angeles Bars Crackers Cookies Cookies Cookies Bars Crackers Bars Bars Snacks Cookies Cookies Crackers Bars Bars Snacks Cookies Cookies Bars Cookies Cookies Cookies Bars Crackers Cookies Bars Snacks Cookies Bars Cookies Bars Snacks Bars Crackers Snacks Bars Snacks Bars Bars Snacks Cookies Bars Cookies Bars Crackers Carrot Whole Wheat Chocolate Chip Chocolate Chip Arrowroot Carrot Whole Wheat Carrot Carrot Potato Chips Arrowroot Chocolate Chip Whole Wheat Carrot Carrot Potato Chips Arrowroot Oatmeal Raisin Bran Oatmeal Raisin Chocolate Chip Oatmeal Raisin Carrot Whole Wheat Chocolate Chip Carrot Potato Chips Chocolate Chip Bran Oatmeal Raisin Carrot Potato Chips Carrot Whole Wheat Potato Chips Carrot Potato Chips Carrot Carrot Potato Chips Chocolate Chip Bran Oatmeal Raisin Carrot Whole Wheat 5/16/2020 5/19/2020 5/22/2020 5/25/2020 5/28/2020 5/31/2020 6/3/2020 6/6/2020 6/9/2020 6/12/2020 6/15/2020 6/18/2020 6/21/2020 6/24/2020 6/27/2020 6/30/2020 7/3/2020 7/6/2020 7/9/2020 7/12/2020 7/15/2020 7/18/2020 7/21/2020 7/24/2020 7/27/2020 7/30/2020 8/2/2020 8/5/2020 8/8/2020 8/11/2020 8/14/2020 8/17/2020 8/20/2020 8/23/2020 8/26/2020 8/29/2020 9/1/2020 9/4/2020 9/7/2020 9/10/2020 9/13/2020 9/16/2020 9/19/2020 9/22/2020 9/25/2020 9/28/2020 10/1/2020 East East West East East East West East West West East East West West East East West West East East West East East West West East East West East East West East East East West East East West East East East West East East West East East 3 2 3 2 3 1 16 6 2 22 1 12 1 11 3 3 1 11 2 3 3 2 2 1 3 11 10 1 1 4 1 9 1 4 3 3 2 1 12 1 11 10 4 3 5 4 New York New York San Diego Boston Boston Boston Los Angeles New York San Diego San Diego Boston Boston Los Angeles Los Angeles New York New York San Diego San Diego Boston Boston Los Angeles New York New York San Diego San Diego Boston Boston Los Angeles New York New York San Diego Boston Boston Boston Los Angeles New York New York San Diego Boston Boston Boston Los Angeles New York New York San Diego Boston Boston Bars Snacks Cookies Cookies Bars Crackers Cookies Cookies Bars Crackers Bars Crackers Bars Snacks Bars Cookies Bars Crackers Bars Crackers Cookies Bars Cookies Bars Snacks Bars Cookies Cookies Bars Crackers Cookies Cookies Bars Crackers Cookies Bars Cookies Bars Cookies Bars Snacks Bars Cookies Cookies Bars Cookies Bars Carrot Potato Chips Chocolate Chip Arrowroot Carrot Whole Wheat Oatmeal Raisin Chocolate Chip Carrot Whole Wheat Carrot Whole Wheat Carrot Potato Chips Bran Oatmeal Raisin Carrot Whole Wheat Carrot Whole Wheat Chocolate Chip Bran Oatmeal Raisin Bran Potato Chips Bran Oatmeal Raisin Chocolate Chip Carrot Whole Wheat Chocolate Chip Arrowroot Carrot Whole Wheat Chocolate Chip Bran Oatmeal Raisin Carrot Arrowroot Carrot Pretzels Carrot Arrowroot Chocolate Chip Bran Arrowroot Carrot 10/4/2020 10/7/2020 10/10/2020 10/13/2020 10/16/2020 10/19/2020 10/22/2020 10/25/2020 10/28/2020 10/31/2020 11/3/2020 11/6/2020 11/9/2020 11/12/2020 11/15/2020 11/18/2020 11/21/2020 11/24/2020 11/27/2020 11/30/2020 12/3/2020 12/6/2020 12/9/2020 12/12/2020 12/15/2020 12/18/2020 12/21/2020 12/24/2020 12/27/2020 12/30/2020 1/2/2021 1/5/2021 1/8/2021 1/11/2021 1/14/2021 1/17/2021 1/20/2021 1/23/2021 1/26/2021 1/29/2021 2/1/2021 2/4/2021 2/7/2021 2/10/2021 2/13/2021 2/16/2021 2/19/2021 East West West East East East West East East East West West East West West East East West West East West West East East East West West East East West East East East West West East East West East East East West West East East West East 3 3 11 19 15 1 1 2 2 2 4 8 9 2 4 5 8 1 1 5 11 1 1 1 1 1 1 22 4 5 3 4 1 7 8 9 1 4 4 4 1 4 2 2 1 1 5 Boston Los Angeles Los Angeles New York New York New York San Diego Boston Boston Boston Los Angeles Los Angeles New York San Diego San Diego Boston Boston Los Angeles Los Angeles New York San Diego San Diego Boston Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Crackers Bars Snacks Cookies Bars Crackers Bars Cookies Cookies Crackers Bars Snacks Bars Cookies Cookies Bars Cookies Bars Snacks Bars Cookies Cookies Bars Cookies Crackers Bars Snacks Cookies Cookies Cookies Cookies Bars Snacks Bars Cookies Bars Crackers Bars Cookies Bars Snacks Cookies Cookies Bars Snacks Cookies Bars Whole Wheat Carrot Potato Chips Arrowroot Carrot Whole Wheat Carrot Arrowroot Chocolate Chip Whole Wheat Carrot Potato Chips Carrot Arrowroot Oatmeal Raisin Bran Oatmeal Raisin Carrot Potato Chips Carrot Arrowroot Oatmeal Raisin Banana Chocolate Chip Whole Wheat Carrot Potato Chips Arrowroot Chocolate Chip Arrowroot Arrowroot Carrot Pretzels Bran Oatmeal Raisin Carrot Whole Wheat Carrot Arrowroot Carrot Potato Chips Arrowroot Chocolate Chip Carrot Potato Chips Oatmeal Raisin Carrot 2/22/2021 2/25/2021 2/28/2021 3/2/2021 3/5/2021 3/8/2021 3/11/2021 3/14/2021 3/17/2021 3/20/2021 3/23/2021 3/26/2021 3/29/2021 4/1/2021 4/4/2021 4/7/2021 4/10/2021 4/13/2021 4/16/2021 4/19/2021 4/22/2021 4/25/2021 4/28/2021 5/1/2021 5/4/2021 5/7/2021 5/10/2021 5/13/2021 5/16/2021 5/19/2021 5/22/2021 5/25/2021 5/28/2021 5/31/2021 6/3/2021 6/6/2021 6/9/2021 6/12/2021 6/15/2021 6/18/2021 6/21/2021 6/24/2021 6/27/2021 6/30/2021 7/3/2021 7/6/2021 7/9/2021 East West West East East West West East East West West East East West East East West West East East West East East West West East East West East East West East West West East East East West East East West East East East West West East 2 2 22 4 6 5 3 6 4 7 2 4 3 10 2 12 9 1 3 1 4 1 17 4 3 2 1 9 4 2 3 8 3 4 1 14 1 6 2 2 2 1 2 2 5 4 3 Boston Los Angeles Los Angeles New York New York San Diego San Diego Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Los Angeles New York San Diego San Diego Boston Boston Boston Los Angeles New York New York San Diego Boston Boston Boston Los Angeles Los Angeles New York Snacks Cookies Cookies Bars Cookies Bars Snacks Bars Snacks Bars Snacks Bars Cookies Bars Cookies Cookies Bars Crackers Bars Snacks Cookies Bars Cookies Cookies Cookies Bars Cookies Cookies Bars Snacks Cookies Bars Cookies Cookies Bars Cookies Crackers Bars Bars Cookies Bars Bars Cookies Crackers Bars Cookies Cookies Pretzels Arrowroot Chocolate Chip Bran Oatmeal Raisin Bran Potato Chips Carrot Potato Chips Carrot Potato Chips Bran Oatmeal Raisin Carrot Arrowroot Oatmeal Raisin Carrot Whole Wheat Carrot Potato Chips Chocolate Chip Bran Oatmeal Raisin Arrowroot Chocolate Chip Bran Oatmeal Raisin Chocolate Chip Carrot Pretzels Chocolate Chip Carrot Arrowroot Oatmeal Raisin Bran Oatmeal Raisin Whole Wheat Carrot Bran Oatmeal Raisin Carrot Banana Chocolate Chip Whole Wheat Bran Oatmeal Raisin Arrowroot 7/12/2021 7/15/2021 7/18/2021 7/21/2021 7/24/2021 7/27/2021 7/30/2021 8/2/2021 8/5/2021 8/8/2021 8/11/2021 8/14/2021 8/17/2021 8/20/2021 8/23/2021 8/26/2021 8/29/2021 9/1/2021 9/4/2021 9/7/2021 9/10/2021 9/13/2021 9/16/2021 9/19/2021 9/22/2021 9/25/2021 9/28/2021 10/1/2021 10/4/2021 10/7/2021 10/10/2021 10/13/2021 10/16/2021 10/19/2021 10/22/2021 10/25/2021 10/28/2021 10/31/2021 11/3/2021 11/6/2021 11/9/2021 11/12/2021 11/15/2021 11/18/2021 11/21/2021 11/24/2021 11/27/2021 East West East East East West West East West West East East West East East West East East East West West East East West East East East West West East East West East East East West East East West East East West East East West East East 3 1 1 1 1 1 5 6 8 2 3 1 2 2 3 3 19 1 1 4 5 2 1 4 4 3 1 3 3 20 1 3 9 3 2 2 5 1 1 11 15 17 18 1 1 17 21 New York San Diego Boston Boston Boston Los Angeles Los Angeles New York San Diego San Diego Boston Boston Los Angeles New York New York San Diego Boston Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Boston Los Angeles New York New York San Diego Boston Boston Los Angeles New York New York San Diego Boston Boston Cookies Bars Bars Cookies Crackers Cookies Cookies Bars Cookies Cookies Bars Snacks Bars Bars Cookies Bars Cookies Bars Snacks Bars Cookies Bars Snacks Bars Cookies Bars Snacks Bars Cookies Cookies Cookies Bars Cookies Bars Crackers Bars Bars Snacks Cookies Bars Cookies Bars Cookies Cookies Bars Cookies Cookies Chocolate Chip Bran Banana Chocolate Chip Whole Wheat Arrowroot Chocolate Chip Carrot Arrowroot Oatmeal Raisin Carrot Pretzels Carrot Bran Oatmeal Raisin Carrot Arrowroot Carrot Pretzels Bran Oatmeal Raisin Carrot Potato Chips Carrot Arrowroot Carrot Pretzels Bran Oatmeal Raisin Arrowroot Chocolate Chip Carrot Arrowroot Carrot Whole Wheat Carrot Bran Potato Chips Chocolate Chip Bran Oatmeal Raisin Carrot Arrowroot Chocolate Chip Carrot Arrowroot Chocolate Chip 11/30/2021 12/3/2021 12/6/2021 12/9/2021 12/12/2021 12/15/2021 12/18/2021 12/21/2021 12/24/2021 12/27/2021 12/30/2021 East West West East East West East East East West West 1 3 11 1 1 6 2 24 2 2 3 Boston Los Angeles Los Angeles New York New York San Diego Boston Boston Boston Los Angeles Los Angeles Crackers Bars Cookies Bars Crackers Cookies Cookies Cookies Crackers Bars Cookies Whole Wheat Bran Oatmeal Raisin Carrot Whole Wheat Chocolate Chip Arrowroot Chocolate Chip Whole Wheat Bran Oatmeal Raisin Quantity sold 33 87 58 82 38 54 149 51 100 28 36 31 28 44 23 27 43 123 42 33 85 30 61 40 86 38 68 39 103 193 58 68 91 23 28 48 134 20 53 64 63 105 138 25 21 UnitPrice TotalPrice 1.77 3.49 1.87 1.87 2.18 1.77 3.49 1.77 1.77 1.35 2.18 1.87 3.49 1.77 1.77 1.35 2.18 2.84 1.87 2.84 1.87 2.84 1.77 3.49 1.87 1.77 1.68 1.87 1.87 2.84 1.77 1.68 1.77 3.49 1.68 1.77 1.68 1.77 1.77 1.68 1.87 1.87 2.84 1.77 3.49 58.41 303.63 108.46 153.34 82.84 95.58 520.01 90.27 177 37.8 78.48 57.97 97.72 77.88 40.71 36.45 93.74 349.32 78.54 93.72 158.95 85.2 107.97 139.6 160.82 67.26 114.24 72.93 192.61 548.12 102.66 114.24 161.07 80.27 47.04 84.96 225.12 35.4 93.81 107.52 117.81 196.35 391.92 44.25 73.29 61 49 55 27 58 33 288 76 42 20 75 38 306 28 110 51 52 28 136 42 75 72 56 51 31 56 137 107 24 30 70 31 109 21 80 75 74 45 28 143 27 133 110 65 33 81 77 1.77 1.68 1.87 2.18 1.77 3.49 2.84 1.87 1.77 3.49 1.77 3.49 1.77 1.68 1.87 2.84 1.77 3.49 1.77 3.49 1.87 1.87 2.84 1.87 1.68 1.87 2.84 1.87 1.77 3.49 1.87 2.18 1.77 3.49 1.87 1.87 2.84 1.77 2.18 1.77 3.15 1.77 2.18 1.87 1.87 2.18 1.77 107.97 82.32 102.85 58.86 102.66 115.17 817.92 142.12 74.34 69.8 132.75 132.62 541.62 47.04 205.7 144.84 92.04 97.72 240.72 146.58 140.25 134.64 159.04 95.37 52.08 104.72 389.08 200.09 42.48 104.7 130.9 67.58 192.93 73.29 149.6 140.25 210.16 79.65 61.04 253.11 85.05 235.41 239.8 121.55 61.71 176.58 136.29 38 40 114 224 141 32 20 40 49 46 39 62 90 103 32 66 97 30 29 92 139 29 30 36 41 44 29 237 65 83 32 63 29 77 80 102 31 56 52 51 24 58 34 34 21 29 68 3.49 1.77 1.68 2.18 1.77 3.49 1.77 2.18 1.87 3.49 1.77 1.68 1.77 2.18 2.84 1.87 2.84 1.77 1.68 1.77 2.18 2.84 2.27 1.87 3.49 1.77 1.68 2.18 1.87 2.18 2.18 1.77 3.15 1.87 2.84 1.77 3.49 1.77 2.18 1.77 1.68 2.18 1.87 1.77 1.68 2.84 1.77 132.62 70.8 191.52 488.32 249.57 111.68 35.4 87.2 91.63 160.54 69.03 104.16 159.3 224.54 90.88 123.42 275.48 53.1 48.72 162.84 303.02 82.36 68.1 67.32 143.09 77.88 48.72 516.66 121.55 180.94 69.76 111.51 91.35 143.99 227.2 180.54 108.19 99.12 113.36 90.27 40.32 126.44 63.58 60.18 35.28 82.36 120.36 31 30 232 68 97 86 41 93 47 103 33 57 65 118 36 123 90 21 48 24 67 27 129 77 58 47 33 82 58 30 43 84 36 44 27 120 26 73 38 40 41 27 38 34 65 60 37 3.15 2.18 1.87 1.87 2.84 1.87 1.68 1.77 1.68 1.77 1.68 1.87 2.84 1.77 2.18 2.84 1.77 3.49 1.77 1.68 1.87 1.87 2.84 2.18 1.87 1.87 2.84 1.87 1.77 3.15 1.87 1.77 2.18 2.84 1.87 2.84 3.49 1.77 1.87 2.84 1.77 2.27 1.87 3.49 1.87 2.84 2.18 97.65 65.4 433.84 127.16 275.48 160.82 68.88 164.61 78.96 182.31 55.44 106.59 184.6 208.86 78.48 349.32 159.3 73.29 84.96 40.32 125.29 50.49 366.36 167.86 108.46 87.89 93.72 153.34 102.66 94.5 80.41 148.68 78.48 124.96 50.49 340.8 90.74 129.21 71.06 113.6 72.57 61.29 71.06 118.66 121.55 170.4 80.66 40 26 22 32 23 20 64 71 90 38 55 22 34 39 41 41 136 25 26 50 79 30 20 49 40 31 21 43 47 175 23 40 87 43 30 35 57 25 24 83 124 137 146 34 20 139 211 1.87 1.87 2.27 1.87 3.49 2.18 1.87 1.77 2.18 2.84 1.77 3.15 1.77 1.87 2.84 1.77 2.18 1.77 3.15 1.87 2.84 1.77 1.68 1.77 2.18 1.77 3.15 1.87 2.84 2.18 1.87 1.77 2.18 1.77 3.49 1.77 1.87 1.68 1.87 1.87 2.84 1.77 2.18 1.87 1.77 2.18 1.87 74.8 48.62 49.94 59.84 80.27 43.6 119.68 125.67 196.2 107.92 97.35 69.3 60.18 72.93 116.44 72.57 296.48 44.25 81.9 93.5 224.36 53.1 33.6 86.73 87.2 54.87 66.15 80.41 133.48 381.5 43.01 70.8 189.66 76.11 104.7 61.95 106.59 42 44.88 155.21 352.16 242.49 318.28 63.58 35.4 303.02 394.57 20 42 100 38 25 96 34 245 30 30 44 3.49 1.87 2.84 1.77 3.49 1.87 2.18 1.87 3.49 1.87 2.84 69.8 78.54 284 67.26 87.25 179.52 74.12 458.15 104.7 56.1 124.96