Summative Assessment: Predictive and Qualitative Analysis Report

Since its inception, the Pastas R Us business development team has favored opening new restaurants in areas that satisfy the following demographic conditions within a 3-mile radius:
The median age is between 25–45 years old.
The household median income is above the national average.
At least 15% of the adult population is college-educated.

Last year, the marketing department rolled out a loyalty card strategy to increase sales. Under this program, customers present their loyalty cards 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 1,200 sq. ft. restaurant recorded $2 million in sales last year, then it sold $1,667 per sq. ft.

Preparation
Analyze the Pastas R Us charts file for your report, including the scatter plots and regression equations for the following pairs of variables:
“Sales/Sq.Ft. ($)” versus “Bach. Degrees (%)”
“Median Income ($)” versus “Sales/Sq.Ft. ($)”
“Median Age (Years)” versus “Sales/Sq.Ft. ($)”
“Loyalty Card (%)” versus “Sales Growth (%)”

Assessment Deliverable

As a sales manager, you will use statistical methods to support actionable business decisions for Pastas R Us, Inc., a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads. In simpler terms, you are reviewing available information to determine if what your company is doing works. In this assessment, you use predictive and qualitative analysis skills to create a report for the executive team from available Pastas R Us, Inc. data about the effectiveness of the current expansion criteria, loyalty card program, and marketing position.

Scenario
Since its inception, the Pastas R Us business development team has favored opening new restaurants in areas that satisfy the following demographic conditions within a 3-mile radius:
The median age is between 25–45 years old.
The household median income is above the national average.
At least 15% of the adult population is college-educated.

Last year, the marketing department rolled out a loyalty card strategy to increase sales. Under this program, customers present their loyalty cards 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 1,200 sq. ft. restaurant recorded $2 million in sales last year, then it sold $1,667 per sq. ft.

Preparation
Analyze the Pastas R Us charts file for your report, including the scatter plots and regression equations for the following pairs of variables:
“Sales/Sq.Ft. ($)” versus “Bach. Degrees (%)”
“Median Income ($)” versus “Sales/Sq.Ft. ($)”
“Median Age (Years)” versus “Sales/Sq.Ft. ($)”
“Loyalty Card (%)” versus “Sales Growth (%)”

Assessment Deliverable

Write a 700- to 1,050-word predictive and qualitative analysis report Must be an MS Word document that includes the following sections: scope and descriptive statistics, analysis, and recommendations and implementation. Make sure that each of these sections has headings (see the rubric).

Section 1: Scope and descriptive statistics
State the report’s objective.
Discuss the nature of the current data. What variables were analyzed?
Summarize your descriptive statistical findings from Week 1. In the summary section, Cut and paste the table from Week 1 HW showing all the descriptive statistics for all variables and add a summary.

Section 2: Analysis
Interpret the scatter plots and designate the type of relationship using regression parameters (increasing/positive, decreasing/negative, or no relationship) observed in each one.
Determine what you can conclude from these relationships. You need to include a copy of each chart in your report (you can cut and paste from the handout).

Section 3: Recommendations and Implementation (see the rubric, each rubric section should have a clear heading)
Based on the findings, assess which expansion criteria seem to be more effective. Could any expansion criterion be changed or eliminated? If so, which one(s) and why?
Based on the findings, does it appear as if the loyalty card is positively correlated with sales growth? Would you recommend any changes to this marketing strategy?
Based on the findings, recommend market positioning that targets a specific demographic. (Hint: Are younger people patronizing the restaurants more than older people?)
Include how the local culture and communities are represented in your market position in your recommendations.
Indicate what information should be collected to track and evaluate the effectiveness of your recommendations. How can this data be collected? (Hint: Would you use surveys/samples or census?)

Format your references according to APA guidelines.

Summative Assessment: Predictive and Qualitative Analysis Report

We offer the best custom writing paper services. We have answered this question before and we can also do it for you.

GET STARTED TODAY AND GET A 20% DISCOUNT coupon code DISC20

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.