Determine what you can conclude from these relationships

Assignment Help Operation Management

Reference no: EM133580398

Assignment: Predictive & Qualitative Analysis Report

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:

A. Median age is between 25-45 years old.
B. Household median income is above the national average.
C. 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 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 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:

A. "Sales/Sq.Ft. ($)" versus "Bach. Degrees (%)"
B. "Median Income ($)" versus "Sales/Sq.Ft. ($)"
C. "Median Age (Years)" versus "Sales/Sq.Ft. ($)"
D. "Loyalty Card (%)" versus "Sales Growth (%)"

Task

Write a 700 to 1,050 words predictive and qualitative analysis report of Pastas R Us, Inc. that includes the following sections: scope and descriptive statistics, analysis, and recommendations and implementation.

Section I: Scope and descriptive statistics

Question A. State the report's objective.

Question B. Discuss the nature of the current data. What variables were analyzed?

Question C. Summarize your descriptive statistical findings.

Section II: Analysis

Question A. Interpret the scatter plots and designate the type of relationship (increasing/positive, decreasing/negative, or no relationship) observed in each one.

Question B. Determine what you can conclude from these relationships. You may include a copy of each chart in your report, but it is not required.

Section III: Recommendations and implementation

Question A. 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?

Question B. 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?

Question C. Based on the findings, recommend market positioning that targets a specific demographic. (Hint: Are younger people patronizing the restaurants more than older people?)

Question D. Include how the local culture and communities are represented in your market position in your recommendations.

Question E. 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?)

Reference no: EM133580398

Questions Cloud

Create a mathematical equation for the problem on first tab : Provide the background of the problem you are attempting to resolve. Create a mathematical equation for the problem on the first tab of your Excel Worksheet.

What does this patient most likely suffer from : Your 19-year-old female patient is short of breath. She is able to speak in 1-2 word sentences and tells you she takes Metoproterenol.

Which area of quality improvement would need most worked : which area of quality improvement would need "most" worked on or implemented. If they are failing in certain categories, that may be where they need to start

What technology is available to help prevent errors : Explain how using a standardized written measurement system would have prevented this adverse drug event.

Determine what you can conclude from these relationships : Determine what you can conclude from these relationships. You may include a copy of each chart in your report, but it is not required.

Can you separate education from health : Make a position, "Can you separate education from health?" Use Marmot to support your response.

Is the customer data being stored by the company at risk : Is the customer data being stored by the company at risk? Can it be compromised? 2. Is the data regarding the supplies of the company safe?

Continuing professional development : Work role in a future career. It will aid in enhancing the skills or learning of an individual for continuing professional development

Write the mission vision values and okrs based on scenario : Write the Mission, Vision, Values and OKR's based on the scenario you pick. and based on the scenario you picked you need to go through the Brightline Transform

User Account

All Pages