Chat with us, powered by LiveChat You are an analyst for a multi-state compa - Writeedu
Login

04 Sep You are an analyst for a multi-state compa

Posted at 02:36h in Business & Finance by

Use the attached data file for the following.

You are an analyst for a multi-state company in the food industry. Clean the data, if needed, and explain the following:

1. What city buys the most products? Explain.

2. What region has the highest revenue? Explain.

3. What is the most popular category of food? Explain.

4. Provide a time series analysis for each product.

5. Are there any other techniques you could use to analyze the given data for food sales? Explain.

6. Finally, think about how you could use these techniques at your own job or future job. Explain in-depth how these techniques could assist your organization.

7. Questions one to four should have a pivot table, graph, etc. to find these answers. Then explain in-depth which city, region, and product is performing best. You will need to explain this to management, and your recommendations to potentially grow sales in other regions.

Need minimum 6 peer reviewed citations. APA format. 5-7 pages of content + charts, graphs and figures.

Sheet1

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

Do you need help with this question?

Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.

WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.

With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Chat with us today! We are always waiting to answer all your questions.

Click here to Place your Order Now



OrderDate Region City Category Product Quantity UnitPrice TotalPrice
1/1/2020 East Boston Bars Carrot 33 1.77 58.41
1/4/2020 East Boston Crackers Whole Wheat 87 3.49 303.63
1/7/2020 West Los Angeles Cookies Chocolate Chip 58 1.87 108.46
1/10/2020 East New York Cookies Chocolate Chip 82 1.87 153.34
1/13/2020 East Boston Cookies Arrowroot 38 2.18 82.84
1/16/2020 East Boston Bars Carrot 54 1.77 95.58
1/19/2020 East Boston Crackers Whole Wheat 149 3.49 520.01
1/22/2020 West Los Angeles Bars Carrot 51 1.77 90.27
1/25/2020 East New York Bars Carrot 100 1.77 177
1/28/2020 East New York Snacks Potato Chips 28 1.35 37.8
1/31/2020 East Boston Cookies Arrowroot 36 2.18 78.48
2/3/2020 East Boston Cookies Chocolate Chip 31 1.87 57.97
2/6/2020 East Boston Crackers Whole Wheat 28 3.49 97.72
2/9/2020 West Los Angeles Bars Carrot 44 1.77 77.88
2/12/2020 East New York Bars Carrot 23 1.77 40.71
2/15/2020 East New York Snacks Potato Chips 27 1.35 36.45
2/18/2020 East Boston Cookies Arrowroot 43 2.18 93.74
2/21/2020 East Boston Cookies Oatmeal Raisin 123 2.84 349.32
2/24/2020 West Los Angeles Bars Bran 42 1.87 78.54
2/27/2020 West Los Angeles Cookies Oatmeal Raisin 33 2.84 93.72
3/2/2020 East New York Cookies Chocolate Chip 85 1.87 158.95
3/5/2020 West San Diego Cookies Oatmeal Raisin 30 2.84 85.2
3/8/2020 East Boston Bars Carrot 61 1.77 107.97
3/11/2020 East Boston Crackers Whole Wheat 40 3.49 139.6
3/14/2020 West Los Angeles Cookies Chocolate Chip 86 1.87 160.82
3/17/2020 East New York Bars Carrot 38 1.77 67.26
3/20/2020 East New York Snacks Potato Chips 68 1.68 114.24
3/23/2020 West San Diego Cookies Chocolate Chip 39 1.87 72.93
3/26/2020 East Boston Bars Bran 103 1.87 192.61
3/29/2020 East Boston Cookies Oatmeal Raisin 193 2.84 548.12
4/1/2020 West Los Angeles Bars Carrot 58 1.77 102.66
4/4/2020 West Los Angeles Snacks Potato Chips 68 1.68 114.24
4/7/2020 East New York Bars Carrot 91 1.77 161.07
4/10/2020 East New York Crackers Whole Wheat 23 3.49 80.27
4/13/2020 West San Diego Snacks Potato Chips 28 1.68 47.04
4/16/2020 East Boston Bars Carrot 48 1.77 84.96
4/19/2020 East Boston Snacks Potato Chips 134 1.68 225.12
4/22/2020 West Los Angeles Bars Carrot 20 1.77 35.4
4/25/2020 East New York Bars Carrot 53 1.77 93.81
4/28/2020 East New York Snacks Potato Chips 64 1.68 107.52
5/1/2020 West San Diego Cookies Chocolate Chip 63 1.87 117.81
5/4/2020 East Boston Bars Bran 105 1.87 196.35
5/7/2020 East Boston Cookies Oatmeal Raisin 138 2.84 391.92
5/10/2020 West Los Angeles Bars Carrot 25 1.77 44.25
5/13/2020 West Los Angeles Crackers Whole Wheat 21 3.49 73.29
5/16/2020 East New York Bars Carrot 61 1.77 107.97
5/19/2020 East New York Snacks Potato Chips 49 1.68 82.32
5/22/2020 West San Diego Cookies Chocolate Chip 55 1.87 102.85
5/25/2020 East Boston Cookies Arrowroot 27 2.18 58.86
5/28/2020 East Boston Bars Carrot 58 1.77 102.66
5/31/2020 East Boston Crackers Whole Wheat 33 3.49 115.17
6/3/2020 West Los Angeles Cookies Oatmeal Raisin 288 2.84 817.92
6/6/2020 East New York Cookies Chocolate Chip 76 1.87 142.12
6/9/2020 West San Diego Bars Carrot 42 1.77 74.34
6/12/2020 West San Diego Crackers Whole Wheat 20 3.49 69.8
6/15/2020 East Boston Bars Carrot 75 1.77 132.75
6/18/2020 East Boston Crackers Whole Wheat 38 3.49 132.62
6/21/2020 West Los Angeles Bars Carrot 306 1.77 541.62
6/24/2020 West Los Angeles Snacks Potato Chips 28 1.68 47.04
6/27/2020 East New York Bars Bran 110 1.87 205.7
6/30/2020 East New York Cookies Oatmeal Raisin 51 2.84 144.84
7/3/2020 West San Diego Bars Carrot 52 1.77 92.04
7/6/2020 West San Diego Crackers Whole Wheat 28 3.49 97.72
7/9/2020 East Boston Bars Carrot 136 1.77 240.72
7/12/2020 East Boston Crackers Whole Wheat 42 3.49 146.58
7/15/2020 West Los Angeles Cookies Chocolate Chip 75 1.87 140.25
7/18/2020 East New York Bars Bran 72 1.87 134.64
7/21/2020 East New York Cookies Oatmeal Raisin 56 2.84 159.04
7/24/2020 West San Diego Bars Bran 51 1.87 95.37
7/27/2020 West San Diego Snacks Potato Chips 31 1.68 52.08
7/30/2020 East Boston Bars Bran 56 1.87 104.72
8/2/2020 East Boston Cookies Oatmeal Raisin 137 2.84 389.08
8/5/2020 West Los Angeles Cookies Chocolate Chip 107 1.87 200.09
8/8/2020 East New York Bars Carrot 24 1.77 42.48
8/11/2020 East New York Crackers Whole Wheat 30 3.49 104.7
8/14/2020 West San Diego Cookies Chocolate Chip 70 1.87 130.9
8/17/2020 East Boston Cookies Arrowroot 31 2.18 67.58
8/20/2020 East Boston Bars Carrot 109 1.77 192.93
8/23/2020 East Boston Crackers Whole Wheat 21 3.49 73.29
8/26/2020 West Los Angeles Cookies Chocolate Chip 80 1.87 149.6
8/29/2020 East New York Bars Bran 75 1.87 140.25
9/1/2020 East New York Cookies Oatmeal Raisin 74 2.84 210.16
9/4/2020 West San Diego Bars Carrot 45 1.77 79.65
9/7/2020 East Boston Cookies Arrowroot 28 2.18 61.04
9/10/2020 East Boston Bars Carrot 143 1.77 253.11