Pastas R Us Inc.s Expansion Criteria and Statistical Analysis

Need help with assignments?

Our qualified writers can create original, plagiarism-free papers in any format you choose (APA, MLA, Harvard, Chicago, etc.)

Order from us for quality, customized work in due time of your choice.

Click Here To Order Now

Introduction

The purpose of the present report is to determine whether the current expansion criteria of Pastas R Us, Inc. can be improved using statistical analysis. In order to achieve the purpose, statistical analysis was used to study correlations between key performance indicators of the company. According to Mariappan (2019), statistical analysis is the key to making unbiased business decisions.

A database of 74 restaurants that includes nine crucial metrics was used for the purpose. The data base included information on the area of the restaurants in square feet, per person average spending, sales growth over previous year, loyalty card percent of net sales, annual sales, median household income, annual sales per square foot, median age, and percentage of adults in the area with a bachelor degree or above. The descriptive statistics of the sample are provided in Table 1 below.

Table 1. Descriptive statistics

Square Feet Per Person Average Spending Sales Growth Over Previous Year (%) Loyalty Card % of Net Sales Annual Sales Per Sq Ft Median HH Income (3 Miles) Median Age (3 Miles) % w/ Bachelors Degree (3 Miles) Annual Sales
Mean 2,580 7.04 7.41 2.03 420 62,808 35.20 26.31 1,059,381
Median 2,500 7.00 7.03 2.08 396 62,757 35.00 26.50 1,035,749
Standard Deviation 375 0.3 6.62 0.55 137 17,904 3.65 7.00 280,423
Skewness 0.53 0.90 0.49 -0.76 1.24 0.3 -0.17 0.14 0.36
Range 2,548 1.43 37.12 3.09 809 81,424 18.80 26.00 1,246,632
Minimum 1,251 6.54 -8.31 0.29 179 32,929 24.70 14.00 499,968
Maximum 3,799 7.97 28.81 3.38 987 114,353 43.50 40.00 1,746,600
Q1 2,400 6.83 3.98 1.86 333 46,953 32.53 20.25 877,478
Q3 2,735 7.18 11.42 2.33 484 76,194 37.53 30.75 1,228,867
IQR 335 0.35 7.44 0.47 151 29,241 5.00 10.50 351,389

Descriptive statistics is of extreme importance, as it can help to summarize the data and spot correlation between variables (McClaive et al., 2018). The descriptive statistics demonstrates that the average size of the companys restaurants is 2,580 square feet (SD = 375) with a person average spending of $7.04 (SD = 0.3) per person. The average sales growth of the restaurants was 7.41% (SD = 6.62) during the last year, and the loyalty card sales were around 2.03% (SD = 0.55) from net sales. The average median household income three miles around the restaurants was $62,808 (SD = 17,904) and the average median age in the area was 35.2 year (SD = 3.65). The average percentage of adults with a bachelors degree in the are was 26.31 (SD = 7). The average annual sales were $1,059,381 (SD = $280,423). All of the variables had a distribution close to the normal distribution curve, except for annual sales per square foot, which had a moderate positive skew (see Figure 1 below). According to Field (2018), such a distribution may demonstrate a violation of the assumption of normality, which may affect the reliability of further statistical analysis.

Distribution of sales by square foot
Figure 1. Distribution of sales by square foot

Section 2. Analysis

This section focuses on the analysis of relationships between various pairs of variables. The relationships are examined in Figures 2-5 below.

Scatterplot of Sales per sq ft by BachDeg%
Figure 2. Scatterplot of Sales per sq ft by BachDeg%

The analysis demonstrates that there was a positive linear correlation between the variables. This implies that the higher the percentage of adults with a bachelors degree living in the three-mile area, the higher the sales per square foot in the restaurant. Even though the line is somewhat close to being parallel to the x-axis, the slope was still significant. Moreover, the R2 coefficient demonstrated that the equation could explain 11.7% of the changes in the sales per square foot.

Sales per sq. ft. by median income
Figure 3. Sales per sq. ft. by median income

Figure 3 above demonstrates that there was almost no correlation between median income in the area even though the trendline indicates an insignificant negative linear correlation. The trendline was very close to being parallel, which demonstrates that a constant-only model would have a similar coefficient of determination. Therefore, it was concluded that median income had no significant impact on sales per square foot. It was confirmed by the R2 coefficient, which was very close to zero.

Sales per sq. ft. by median age
Figure 4. Sales per sq. ft. by median age

Figure 4 above demonstrates that there was almost no correlation between median age in the area even though the trendline indicates an insignificant negative linear correlation. While it should be acknowledged that the trendline had a greater angle in comparison with the median income, it was still concluded that the median age had no significant impact on sales per square foot. Moreover, R2 coefficient demonstrated that the model could explain less than 1% of the changes in sales per square foot.

Sales growth by loyalty card sales
Figure 5. Sales growth by loyalty card sales

Figure 5 above demonstrated that there was a negative linear correlation between loyalty card sales and sales growth. Even though the relationship was relatively weak (R2 = 0.0881), it was considerable. The coefficient of determination state that the model could explain 8.8% of the changes in sales per square foot.

Recommendations and Implementation

The analysis demonstrates that the current expansion criteria is imperfect. In particular, median age and median income of people in the three-mile area appeared to have very little effect on sales per square foot, while the percentage of adults with a bachelors degree was a strong criterion. Therefore, it is recommended to avoid using median age and median income level as expansion criteria.

The analysis also demonstrated that the current loyalty card program is ineffective, as there was a negative correlation between sales growth and loyalty card sales. Therefore, the company needs to revise its current loyalty card program to avoid losses in revenues.

Conclusion

When selecting a target population for advertisements, it is recommended to target younger adults with higher level of education. This recommendation needs to be tested using surveys. Pastas R Us should randomly survey its customers asking about their education level, age, and how the marketing program affected their purchase decision. This would help to understand if more educated and younger adults were more likely to eat at the companys restaurants.

References

Field, A. (2018). Discovering statistics using SPSS: North American edition (5th ed.). Sage.

Mariappan, P. (2019). Statistics for Business. CRC Press.

McClaive, J., Benson, G. & Sincich, D. (2018). Statistics for business and economics. Pearson.

Need help with assignments?

Our qualified writers can create original, plagiarism-free papers in any format you choose (APA, MLA, Harvard, Chicago, etc.)

Order from us for quality, customized work in due time of your choice.

Click Here To Order Now