Pelican StoresReport on Promotional Sales

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.

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.

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

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

3.C Pie chart showing Method of payment V/s Items

70

30

PromotionalRegular

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

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

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.

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