Pastas R Us, Inc. is a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads. Since its inception, the business development team has favored opening new restaurants in areas (within a 3-mile radius) that satisfy the following demographic conditions:

• Median age between 25 – 45 years old
• Household median income above the national average
• At least 15% college-educated adult population

Last year, the marketing department rolled out a Loyalty Card strategy to increase sales. Under this program, customers present their Loyalty Card when paying for their orders and receive some free food after making 10 purchases.

The company has collected data from its 74 restaurants to track important variables such as average sales per customer, year-on-year sales growth, sales per sq. ft., Loyalty Card usage as a percentage of sales, and others. A key metric of financial performance in the restaurant industry is annual sales per sq. ft. For example, if a 1200 sq. ft. restaurant recorded $2 million in sales last year, then it sold $1,667 per sq. ft.

Executive management wants to know whether the current expansion criteria can be improved. They want to evaluate the effectiveness of the Loyalty Card marketing strategy and identify feasible, actionable opportunities for improvement. As a member of the analytics department, you’ve been assigned the responsibility of conducting a thorough statistical analysis of the company’s available database to answer executive management’s questions.

• Discuss the nature of the current database. What variables were analyzed?
• Summarize your descriptive statistics findings from Excel. Use a table and insert appropriate graphs. 

Transcribed Image Text:

Pastas R Us, Inc. Database (n = 74 restaurants) Per Person Sales Growth Over Loyalty Card % Annual Sales Square Feet Average Spending Previous Year (%) Median HH Median Age % w Bachelor's (3 Miles) Degree (3 Miles) of Net Sales Per Sq Ft Income (3 Miles) Sqft LoyaltyCard% Sales/SqFt 2.07 Obs Sales/Person Medincome MedAge 34.4 BachDeg% 2354 6.81 -8.31 701.97 45177 31 2 2604 7.57 4.01 -3.94 2.54 209.93 364.92 443.04 51888 41.2 20 3 2453 6.89 1.66 51379 40.3 24 4. 2340 7.13 -3.39 2.06 66081 35.4 29 5 2500 7.04 3.30 2.48 399.20 50999 31.5 18 6 2806 -1.94 2.96 6.93 7.11 264. 64 571.59 41562 36.3 35.1 30 44196 50975 72808 7 2250 -0.77 2.28 14 8 2400 7.13 -0.37 -0.25 2.34 642.25 461.45 638.82 484.38 581.09 37.6 33 9. 2709 6.58 6.77 2.20 34. 9 34.8 28 10 1990 -0.17 2.34 79070 29 11 2392 6.66 0.47 2.09 78497 36.2 39 12 2408 7.03 0.55 2.47 41245 33003 90988 32.2 23 13 2627 2500 7.03 7.00 0.77 1.92 2.04 2.02 267.71 572.84 30.9 37.7 22 37 14 15 1986 7.38 2.05 2.01 586.48 37950 34.3 24 16 2500 7.18 2.12 2.64 368.73 45206 32.4 17 17 2668 7.35 2.84 2.22 351.47 37 79312 37345 46226 32.1 18 2517 6.95 2.88 2.07 458.24 31.4 22 19 1251 7.02 3.96 1.94 987, 12 30.4 36 20 21 2998 2625 6.85 7.16 4.04 4.05 2.17 0.72 357.45 70024 54982 54932 33.9 35.6 35.9 34 26 405.77 22 2300 6.99 4.05 2.00 680.80 20 23 2761 7.28 4.24 1.81 20 368.02 303.95 34097 33.6 24 2764 7.07 4.58 2.13 46593 37.9 26 25 26 2430 7.05 5.09 2.50 393.90 51893 40.6 21 5. 14 88162 89016 114353 2154 6.54 2.63 562. 12 37.7 37 27 28 2400 2430 6.70 6.91 5.48 5.86 1.95 2.04 494.88 36.4 40.9 34 34 310.07 373.46 29 2549 7.58 5.91 1.41 75366 35.0 30 30 2500 7.03 5.98 2.05 235.81 48163 49956 26.4 16 31 3653 6.84 6.08 2.13 413.08 37.1 28 32 2440 6.94 6.08 6.13 2.08 625.22 45990 30.3 36 33 2600 45723 31.3 7.07 7.00 2.73 274.30 18 34 35 2160 2800 6.27 6.57 1.95 2.04 542.62 178.56 43800 29.6 32.9 36 18 7.08 68711 375.33 329.09 36 2757 6.75 6.90 1.62 65150 39329 63657 40.7 24 37 2450 6.81 6.94 1.95 29.3 22 38 2400 7.12 7.64 6.62 1.64 1.78 297.37 37.3 29 67099 75151 39 2270 7.39 323.17 39.8 25 40 2800 6.76 7.67 2.23 468.84 33.9 28 41 2520 2487 7.11 7.91 8.08 2.15 2.83 352.57 380.34 93876 79701 35.0 35.0 40 42 7.05 39 43 2629 6.90 8.27 2.37 398.12 77115 35.9 30 44 3200 7.17 8.54 3.07 312.15 52766 32929 87863 73752 85366 39180 33.0 17 45 2335 6.75 8.58 2.19 452.16 30.9 38.5 22 46 2500 7.45 8.72 1.28 698.64 367.19 29 19 47 2449 7.00 8.75 1.76 40.5 431.93 367.06 48 2625 3150 6.96 7.30 8.79 8.90 2.51 1.90 32.1 29 18 49 50 34.8 38.0 2625 6.96 9. 12 1.98 400.53 56077 77449 56822 19 51 2741 6.71 9.47 2.41 414.36 37.0 34 52 2500 6.82 6.58 10.17 2.17 481.11 34.7 25 2450 2986 53 10.66 2.16 538.06 80470 36.4 30 54 7.56 10.97 0.29 330.48 55584 36.8 21 78001 55 56 2967 3000 6.98 7.28 11.34 1.85 1.88 249.93 32 2 34.8 30 30 291.87 517.40 551.58 75307 11.45 11.51 57 2500 2600 2800 6.76 2.19 76375 36.7 28 58 6.92 2.56 11.73 11.83 11.95 61857 33.8 31 59 6.73 6.91 2.16 386.81 427.50 61312 72040 34.2 16 60 2986 2.10 39.0 31 40 33 28 61 2223 6.77 12.47 1.98 453.94 512.46 345.27 234.04 92414 92602 59599 34.9 39.3 35.6 62 2300 3799 7.33 7.87 12. 80 0.87 1.07 63 64 13.78 14.09 14.23 2700 6.95 3.38 72453 36.0 23 65 2650 7.33 1.17 348.33 67925 41.1 16 14.60 66 67 2500 6.95 2.14 348.47 42631 24.7 25 75652 39650 48033 67403 2994 7.21 7.25 14.88 0.93 294.95 40.5 25 18 68 2718 15.42 2.22 361.14 32.9 69 70 16. 18 17.23 3700 7.65 6.93 1.68 467.71 403.78 30.3 36.2 15 2000 2.41 19 71 2400 6.79 18.43 2.81 245.74 339.94 80597 32.4 27 7.37 20.76 60928 73762 64225 72 2450 1.09 43.5 21 73 2575 2400 6.76 25.54 28.81 0.64 1.77 400.82 326.54 41.6 29 74 7.97 31.4 15 Pastas R Us, Inc. Database (n = 74 restaurants) Per Person Sales Growth Over Loyalty Card % Annual Sales Square Feet Average Spending Previous Year (%) Median HH Median Age % w Bachelor's (3 Miles) Degree (3 Miles) of Net Sales Per Sq Ft Income (3 Miles) Sqft LoyaltyCard% Sales/SqFt 2.07 Obs Sales/Person Medincome MedAge 34.4 BachDeg% 2354 6.81 -8.31 701.97 45177 31 2 2604 7.57 4.01 -3.94 2.54 209.93 364.92 443.04 51888 41.2 20 3 2453 6.89 1.66 51379 40.3 24 4. 2340 7.13 -3.39 2.06 66081 35.4 29 5 2500 7.04 3.30 2.48 399.20 50999 31.5 18 6 2806 -1.94 2.96 6.93 7.11 264. 64 571.59 41562 36.3 35.1 30 44196 50975 72808 7 2250 -0.77 2.28 14 8 2400 7.13 -0.37 -0.25 2.34 642.25 461.45 638.82 484.38 581.09 37.6 33 9. 2709 6.58 6.77 2.20 34. 9 34.8 28 10 1990 -0.17 2.34 79070 29 11 2392 6.66 0.47 2.09 78497 36.2 39 12 2408 7.03 0.55 2.47 41245 33003 90988 32.2 23 13 2627 2500 7.03 7.00 0.77 1.92 2.04 2.02 267.71 572.84 30.9 37.7 22 37 14 15 1986 7.38 2.05 2.01 586.48 37950 34.3 24 16 2500 7.18 2.12 2.64 368.73 45206 32.4 17 17 2668 7.35 2.84 2.22 351.47 37 79312 37345 46226 32.1 18 2517 6.95 2.88 2.07 458.24 31.4 22 19 1251 7.02 3.96 1.94 987, 12 30.4 36 20 21 2998 2625 6.85 7.16 4.04 4.05 2.17 0.72 357.45 70024 54982 54932 33.9 35.6 35.9 34 26 405.77 22 2300 6.99 4.05 2.00 680.80 20 23 2761 7.28 4.24 1.81 20 368.02 303.95 34097 33.6 24 2764 7.07 4.58 2.13 46593 37.9 26 25 26 2430 7.05 5.09 2.50 393.90 51893 40.6 21 5. 14 88162 89016 114353 2154 6.54 2.63 562. 12 37.7 37 27 28 2400 2430 6.70 6.91 5.48 5.86 1.95 2.04 494.88 36.4 40.9 34 34 310.07 373.46 29 2549 7.58 5.91 1.41 75366 35.0 30 30 2500 7.03 5.98 2.05 235.81 48163 49956 26.4 16 31 3653 6.84 6.08 2.13 413.08 37.1 28 32 2440 6.94 6.08 6.13 2.08 625.22 45990 30.3 36 33 2600 45723 31.3 7.07 7.00 2.73 274.30 18 34 35 2160 2800 6.27 6.57 1.95 2.04 542.62 178.56 43800 29.6 32.9 36 18 7.08 68711 375.33 329.09 36 2757 6.75 6.90 1.62 65150 39329 63657 40.7 24 37 2450 6.81 6.94 1.95 29.3 22 38 2400 7.12 7.64 6.62 1.64 1.78 297.37 37.3 29 67099 75151 39 2270 7.39 323.17 39.8 25 40 2800 6.76 7.67 2.23 468.84 33.9 28 41 2520 2487 7.11 7.91 8.08 2.15 2.83 352.57 380.34 93876 79701 35.0 35.0 40 42 7.05 39 43 2629 6.90 8.27 2.37 398.12 77115 35.9 30 44 3200 7.17 8.54 3.07 312.15 52766 32929 87863 73752 85366 39180 33.0 17 45 2335 6.75 8.58 2.19 452.16 30.9 38.5 22 46 2500 7.45 8.72 1.28 698.64 367.19 29 19 47 2449 7.00 8.75 1.76 40.5 431.93 367.06 48 2625 3150 6.96 7.30 8.79 8.90 2.51 1.90 32.1 29 18 49 50 34.8 38.0 2625 6.96 9. 12 1.98 400.53 56077 77449 56822 19 51 2741 6.71 9.47 2.41 414.36 37.0 34 52 2500 6.82 6.58 10.17 2.17 481.11 34.7 25 2450 2986 53 10.66 2.16 538.06 80470 36.4 30 54 7.56 10.97 0.29 330.48 55584 36.8 21 78001 55 56 2967 3000 6.98 7.28 11.34 1.85 1.88 249.93 32 2 34.8 30 30 291.87 517.40 551.58 75307 11.45 11.51 57 2500 2600 2800 6.76 2.19 76375 36.7 28 58 6.92 2.56 11.73 11.83 11.95 61857 33.8 31 59 6.73 6.91 2.16 386.81 427.50 61312 72040 34.2 16 60 2986 2.10 39.0 31 40 33 28 61 2223 6.77 12.47 1.98 453.94 512.46 345.27 234.04 92414 92602 59599 34.9 39.3 35.6 62 2300 3799 7.33 7.87 12. 80 0.87 1.07 63 64 13.78 14.09 14.23 2700 6.95 3.38 72453 36.0 23 65 2650 7.33 1.17 348.33 67925 41.1 16 14.60 66 67 2500 6.95 2.14 348.47 42631 24.7 25 75652 39650 48033 67403 2994 7.21 7.25 14.88 0.93 294.95 40.5 25 18 68 2718 15.42 2.22 361.14 32.9 69 70 16. 18 17.23 3700 7.65 6.93 1.68 467.71 403.78 30.3 36.2 15 2000 2.41 19 71 2400 6.79 18.43 2.81 245.74 339.94 80597 32.4 27 7.37 20.76 60928 73762 64225 72 2450 1.09 43.5 21 73 2575 2400 6.76 25.54 28.81 0.64 1.77 400.82 326.54 41.6 29 74 7.97 31.4 15

Answer rating: 100% (QA)

Answer Organisation Pastas Ru Inc Speciality Noodles Soups and Salads No of Restaurants 74 As Pastas Ru Inc is a FB organisation they key focus should ... View the full answer