Download - Pelican stores report
![Page 1: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/1.jpg)
Pelican StoresReport on Promotional Sales
![Page 2: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/2.jpg)
1. Background
Pelican stores is a chain of women’s apparel stores operating throught the country.
It sent few discount coupons to customers of other stores. The store collected a sample of 100 customers.
![Page 3: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/3.jpg)
2. Managerial Questions:
1. Percent frequency distribution for key variables 2. A bar graph or pie chart showing the number of customer
purchases attributable to the method of payment 3. A crosstabulation of type of customer(Regular of promotional)
versus net sales. 4. A Scatter diagram to explore the relationship between net sales
and customer age.
![Page 4: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/4.jpg)
3.A Percent Frequency distribution of Age and Net SalesAge
Sum of Net Sales
Count of Net Sales
20-24 5 0.0525-29 5 0.0530-34 19 0.1935-39 11 0.1140-44 18 0.1845-49 15 0.1550-54 13 0.1355-59 3 0.0360-64 5 0.0565-69 2 0.0270-74 3 0.0375-80 1 0.01Grand Total 100 1
![Page 5: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/5.jpg)
3.B Percent Frequency distribution of Age and Sum of Items purchased
Row Labels Sum of Items % Frequency20 3 0.009316770186335422 4 0.012422360248447224 1 0.003105590062111828 17 0.052795031055900630 47 0.14596273291925532 16 0.049689440993788834 5 0.01552795031055936 13 0.040372670807453438 18 0.055900621118012440 14 0.043478260869565242 31 0.096273291925465844 16 0.049689440993788846 28 0.086956521739130448 15 0.04658385093167750 17 0.052795031055900652 11 0.034161490683229854 28 0.086956521739130456 11 0.034161490683229858 2 0.006211180124223660 3 0.009316770186335462 6 0.018633540372670868 7 0.021739130434782670 1 0.003105590062111872 5 0.01552795031055974 2 0.006211180124223678 1 0.0031055900621118Grand Total 322 1
![Page 6: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/6.jpg)
3.C Pie chart showing Method of payment V/s Items
70
30
PromotionalRegular
![Page 7: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/7.jpg)
3.D Crosstabulation showing type of customer V/s Net SalesCount of Customer ItemsType of Customer 1 2 3 4 5 6 7 8 9 10 13 17
Grand Total
Promotional 14 17 8 9 8 6 1 1 3 1 1 1 70Regular 15 10 2 1 1 1 30Grand Total 29 27 10 10 9 7 1 1 3 1 1 1 100
![Page 8: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/8.jpg)
3.E Scatter diagram showing relationship between Net Sales & Customer Age
0.00 50.00 100.00 150.00 200.00 250.00 300.00 350.000102030405060708090
Scatter diagram showing relationship between Customer age and Net Sales
Age
Age
![Page 9: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/9.jpg)
4. Findings
1. As the store is Women’s apparel store, the Female customers are purchasing more items than that of Male customers.
2. The people of age group 30-34 are purchasing more items with a share of 19%.
3. 70% of the customers are promotional customers v/s 30% of Regular customers.
4. The users of Proprietory cards are more in number than that of other card users i.e, 70% of the customers are using proprietory cards.
5. Married customers are more in number than unmarried customers. 84% of the customers are married than that of 16% of unmarried.
6. More number of customers are buying only 1 or 2 items.
![Page 10: Pelican stores report](https://reader036.vdocuments.us/reader036/viewer/2022083118/58747cef1a28ab4a758b899b/html5/thumbnails/10.jpg)
5. Suggestions
1. The promotion ran successfully as the sales are more of promotional customers.
2. The customers are now knowing Pelican Stores.3. As the people of age group 30-34 are buying more items, the store
should also concentrate on the age group of more than 35.4. As more number of customers are purchasing 1 or 2 items only, the
store should provide discounts or offer for the customers who are purchasing more than 2 no’s of items.
5. The store should great deals for the customers who are using other than proprietary card.
6. The store should also focus on Unmarried customers