Administration consultant project
Admin’s Target
By:
Ammara Farooq
Grayson Ricafort
Esmeralda Ramirez
Josiah Orozco
Alyssa Becerra
Denisse Ramos Talavera
Descriptive Statistics
The Average Shipping cost to ship a product on truck is 28.758, while on air it is 8.571.
This will let the company know that shipping through truck is more expensive. Shipment through air is far more reliable as noted in the pie chart. This is a possibility to decrease spending and increase revenue.
Average Shipping: 14.7908
Mean Shipping Cost:
6.18
Average Product Base Margin:
0.4918
Mean Product Base Margin:
0.5
Total Averages
| median target PSP | $5.79 |
| average target PSP | $7.22 |
| median walmart PSP | $5.79 |
| average walmart PSP | $7.14 |
| The Average Discount percent of all Products | 5 |
Comparing Target and Walmart Sales Prices
Both companies almost have the same prices.
Olay Regenerist Moisturizer, Hellmann's Real Mayonnaise, and Folgers Classic Roast are the only ones with slight price differences.
4
Product sale price
Wal-Mart Folgers Classic Roast Hamburger Helper Frenchs Mustard Hellmanns Real Mayonnaise Kraft Miracle Whip Pringles Listerine Cool Mint Pantene Color Reserve Volume Shampoo Aveeno Active Naturals Daily Mositurizing Lotion Olay Regenerist Moisturizer Fancy Feast Wet Cat Food Gourmet Entree Nice n Easy Haircolor Cover Girl Lash Blast Volume Mascara 6.97 2.0 1.77 2.97 4.97 2.25 5.79 3.96 11.27 27.47 6.98 8.96 7.47 Target Folgers Classic Roast Hamburger Helper Frenchs Mustard Hellmanns Real Mayonnaise Kraft Miracle Whip Pringles Listerine Cool Mint Pantene Color Reserve Volume Shampoo Aveeno Active Naturals Daily Mositurizing Lotion Olay Regenerist Moisturizer Fancy Feast Wet Cat Food Gourmet Entree Nice n Easy Haircolor Cover Girl Lash Blast Volume Mascara 9.49 2.04 1.99 4.49 4.99 2.29 5.79 4.99 11.39 22.99 6.99 8.99 7.49
Products
Prices
Positive Correlation
2011 prices vs. Present prices
There is a perfect positive correlation
Correlation Coefficient r= 0.9885946 which is near 1, which makes the correlation almost the same.
Correlation bewteen walmart prices and walmart 2011 prices
Wal-Mart Folgers Classic Roast Hamburger Helper Frenchs Mustard Hellmanns Real Mayonnaise Kraft Miracle Whip Pringles Listerine Cool Mint Pantene Color Reserve Volume Shampoo Aveeno Active Naturals Daily Mositurizing Lotion Olay Regenerist Moisturizer Fancy Feast Wet Cat Food Gourmet Entree Nice n Easy Haircolor Cover Girl Lash Blast Volume Mascara 6.97 2.0 1.77 2.97 4.97 2.25 5.79 3.96 11.27 27.47 6.98 8.96 7.47 Wal-Mart (2011) Folgers Classic Roast Hamburger Helper Frenchs Mustard Hellmanns Real Mayonnaise Kraft Miracle Whip Pringles Listerine Cool Mint Pantene Color Reserve Volume Shampoo Aveeno Active Naturals Daily Mositurizing Lotion Olay Regenerist Moisturizer Fancy Feast Wet Cat Food Gourmet Entree Nice n Easy Haircolor Cover Girl Lash Blast Volume Mascara 9.47 2.67 2.17 3.97 4.37 1.67 4.99 4.96 11.27 32.97 7.48 7.78 7.47
Products
Prices
Product Correlation
Sales vs. Discounts
There is NO apparent correlation between product Sales and the Discount.
r= 0.0742363, which is near 0, meaning that there is no correlation.
Product sales
Discount
Relative Frequency
There is NO association between Ship Mode and Product Container.