Pelican

De La Salle – College of St. Benilde

School of Hotel, Restaurant and Institution Management

Graduate School

Master of Science in Tourism and Hospitality Management

Quantitative Analysis for Tourism and Hospitality

Case Study:

“PELICAN STORE”

Submitted to:

Dr. Red Mariano

Submitted by:

John Christopher Bonifacio

Thomas Edward Chua

Jefrey Ormita

Zemir Rollan

Case Study 1:

PELICAN STORES

Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores located throughout the country. They ran a one-day promotion that offered discount coupons to its customers from the other National Clothing stores. They collected data from a sample of 100 customers’ in-store credit card transactions from that day. Management wanted to learn about the customer base and to evaluate the promotion involving the discount coupon. This report will examine the customer profiles that will include gender, marital status, net sales and age groups through the use of tabular and graphical descriptive statistics. In addition, the effectiveness of the promotional campaign will be evaluated by looking at key variables including types of customer and age groups as compared to net sales. 

Case Problem

1. Descriptive Statistics on net sales and descriptive statistics on net sales by various classifications of customers.

2. Descriptive Statistics concerning the relationship between age and net sales.

Data Analysis

Table 1 : Net Sales (All Customers) of Pelican Store

Price Range | Frequency | Relative Frequency | % Frequency | | Cumulative Frequency | Cumulative Relative Frequency | Cumulative % Frequency |

| | | | | | | |

10-23 | 8 | 0.08 | 8% | | 8 | 0.08 | 8% |

24-37 | 10 | 0.1 | 10% | | 18 | 0.18 | 18% |

38-51 | 21 | 0.21 | 21% | | 39 | 0.39 | 39% |

52-65 | 17 | 0.17 | 17% | | 56 | 0.56 | 56% |

66-79 | 11 | 0.11 | 11% | | 67 | 0.67 | 67% |

80-93 | 4 | 0.04 | 4% | | 71 | 0.71 | 71% |

94-107 | 8 | 0.08 | 8% | | 79 |...