Part III Estella Guerra South Texas College 5

Part III Estella Guerra South Texas College 5 -6 -2016 ORGL-3321

The type of data that is provided is based of food products. It tells us the order ID number that way it will be easier to track down and file it. The order date year, order date month, and order date day will help to make sure they have the days exactly in order and make it easier to understand the data. The customer’s name always help to know what store is getting the order. The country helps out to know where it will be shipped to. A very important column is what the product name is and where we can find product category. They also have the unit price and how much they ordered so like that all the customer has to do is multiply the unit price with the quantity and they get the total price of the merchandise, but since they also provide the total price is will not be necessary to do the math unless they just want to make sure they did not get charged more. The data can be used for keeping track of the product of who they sell it too, how much of it do they sell, and it can also help to see how much money the company should be making. If they add up all the total of the merchandise at the end of the day they can see how much they have made that day of the month. It can be helpful to keep track of what product they sell the most off and they can always have more in a warehouse just in case the orders keep coming in. The data can also be used to see who is their number one company that orders from them; and they can always make a better deal with them since they order their merchandise often.

How sales have changed in 2013 2012 400000 350000 300000 250000 200000 150000 Total 100000 50000 oo d Se af od u ce y Pr ltr t/P ou G D ra M in s ea /C er od Pr ai ry C 2013 500000 450000 400000 350000 300000 250000 200000 150000 100000 50000 0 oo d Se af Pr od u ce y ltr ea M ra in s /C er od G Pr D ai ry t/P ou ea ls s uc t s io n ct fe on C C on d im ra ge s en ts Total ve Be Row Labels Sum of Order_Date_Year Beverages 430782 Condiments 223443 Confections 344223 Dairy Products 350262 Grains/Cereals 207339 Meat/Poultry 167079 Produce 136884 Seafood 370392 Grand Total 2230404 ea ls s uc t s io n ct fe on on d C Be im ra ge s en ts 0 ve Row Labels Sum of Order_Date_Year Beverages 338016 Condiments 191140 Confections 295764 Dairy Products 338016 Grains/Cereals 175044 Meat/Poultry 164984 Produce 122732 Seafood 261560 Grand Total 1887256 2012

Top 10 Customers 1. QUICK-Stop 2. Save-a-lot Markets 3. Ernst Handel 4. Hungry Owl All-Night Grocers 5. Rattlesnake Canyon Grocery 6. Hanari Carnes 7. Mère Paillarde 8. Folk och fä HB 9. Königlich Essen 10. Queen Cozinha

Top 10 Products 1. Côte de Blaye 2. Thüringer Rostbratwurst 3. Raclette Courdavault 4. Camembert Pierrot 5. Tarte au sucre 6. Gnocchi di nonna Alice 7. Manjimup Dried Apples 8. Alice Mutton 9. Rössle Sauerkraut 10. Mozzarella di Giovanni

Recommendations It would be easier if they had a chart for every year done separately so it can be easier to access information when needed. Need to find ways to up sale in regions that have less profit for 2013. Encourage sales representatives to step outside their boundaries and create more sales. Create a incentive plan for top sales associates for all regions, so they can stay motivated to continue up selling the products.