Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

complete a analysis by fully discussing the results (Charts/Diagrams with explanation) in 2018 & 2019 individually, and the comparison between 2018 & 2019 that are

complete a analysis by fully discussing the results (Charts/Diagrams with explanation) in 2018 & 2019 individually, and the comparison between 2018 & 2019 that are related to: Top 10 Customers Monthly Sales Overview Top 10 Products 8 Product Categories Top 10 Regions

Also, include Recommendations/Suggestions

2. Monthly Sales Overview in 2018, 2019 & their comparison. How have sales developed in 2019 - compared to the year before - 2018? Who are the Top 10 Customers in 2018, 2019 & their comparison? What changes can be noted? What are the Top 10 Products -- based on product name in 2018, 2019 & their comparison?

What changes can be noted?

What are the 8 Product Categories -- based on product category in 2018, 2019 & their comparison? What changes can be noted?

How are sales distributed over the Top 10 Regions in 2018, 2019 & their comparison?

imageimageimageimageimage

A B 20 Sum of Order_Price_Total C D Sum of Order_Price_Total E F 21 22 Top 10 2019 Customers 23 24 25 26 27 Customer_Name 28 29 30 31 32 LINO-Delicateses Suprmes dlices Folk och f HB White Clover Markets esnake Canyon Grocery Hungry Owl All-Night Grocers Kniglich Essen Ernst Handel QUICK-Stop Save-a-lot Markets $0.00 $200,000.00 $400,000.00 Customer_Name Total Top 10 2018 Customers Piccolo und mehr Simons bistro Blondel pre et fils Hungry Owl All-... Queen Cozinha Mre Paillarde Rattlesnake Canyon... QUICK-Stop Save-a-lot Markets Total Ernst Handel $0.00 $100,000.00 $200,000.00 33 34 35 36 37 Order_Date_Year Sum of Product_Order_Price_Total 38 80000 39 70000 40 60000 50000 41 40000 42 30000 43 20000 44 10000 45 0 Years 2018 46 47 48 49 50 51 52 Wolski Zajazd Wartian Herkku Trail's Head Gourmet. The Cracker Box Spcialits du monde Sant Gourmet Reggiani Caseifici Queen Cozinha Pericles Comidas clsicas North/South Let's Stop N Shop Magazzini Alimentari Riuniti La maison d'Asie Hungry Owl All-Night.. GROSELLA-Restaurante Galera del gastrnomo France restauration Ernst Handel Die Wandernde Kuh Cactus Comidas para llevar Blido Comidas preparadas Around the Horn 2019 53 Customer_Name 54

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Management

Authors: Robbins, DeCenzo, Coulter

7th Edition

132996855, 0-13-610982-9 , 9780132996853, 978-0-13-61098, 978-0136109822

More Books

Students also viewed these General Management questions

Question

Write a program to check an input year is leap or not.

Answered: 1 week ago

Question

Write short notes on departmentation.

Answered: 1 week ago

Question

What are the factors affecting organisation structure?

Answered: 1 week ago

Question

What are the features of Management?

Answered: 1 week ago

Question

Briefly explain the advantages of 'Management by Objectives'

Answered: 1 week ago