Need help? We are here

# Scenario: Pastas R Us Inc. is a fastcasual restaurant chain specializing in noodlebased dishes soups and salads. Since its inception

Scenario:
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 national average
At least 15
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.
Report:
Write a 750-word statistical report that includes the following sections:
Section 1: Scope and descriptive statistics
Section 2: Analysis
Section 3: Recommendations and Implementation
Section 1 – Scope and descriptive statistics
State the report’s objective.
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.
Section 2 – Analysis
Using Excel, create scatter plots and display the regression equations for the following pairs of variables:
“BachDeg
%” versus “Sales/SqFt”
“MedIncome” versus “Sales/SqFt”
“MedAge” versus “Sales/SqFt”
“LoyaltyCard(
%)” versus “SalesGrowth(
%)”
In your report, include the scatter plots. For each scatter plot, designate the type of relationship observed (increasing/positive, decreasing/negative, or no relationship) and determine what you can conclude from these relationships.
Section 3: Recommendations and implementation
Based on your findings above, assess which expansion criteria seem to be more effective.Could any expansion criterion be changed or eliminated? If so, which one and why?
Based on your findings above, does it appear as if the Loyalty Card is positively correlated with sales growth? Would you recommend changing this marketing strategy?
Based on your previous findings, recommend marketing positioning that targets a specific demographic. (Hint: Are younger people patronizing the restaurants more than older people?)
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 survey/samples or census?)

Order a Similar Paper and get 15% Discount on your First Order

## Related Questions

### Business CaseElevator Pitch Exercise Using exactly one hundred 100 words you will provide an elevator pitchbusiness case for

Business Case/Elevator Pitch ExerciseUsing exactly one hundred (100) words you will provide an elevator pitch/business case for one of the Projects you selected to review for Week 1.This pitch/case should cover the important elements of the project: who, what, where, when, and why?Exercise will be completed using the attached template.Open

### bill needs help setting up a spreadsheet tell him him how to do the following: what formula or function does

ill needs help setting up a spreadsheet, tell him him how to do the following: what formula or function does he put in column F that will show his expenses for the day? what formula of func tion goes in column through F in row 13 that will give him

### BIO2071 SU01 Microbiology Lab Review Sheet 6 questions What are the types of organisms that can cause parasitic diseases in

BIO2071 SU01 Microbiology LabReview Sheet 6 questionsWhat are the types of organisms that can cause parasitic diseases in the human being? Explain at least four such organisms.What are the different routes that pathogenic protozoans can use to enter the host?What are three methods for establishing a laboratory diagnosis of an

### BusinessLevel and CorporateLevel StrategiesIn BusinessLevel and CorporateLevel Strategies In this assignment you are to use the same corporation you selected

Business-Level and Corporate-Level StrategiesIn Business-Level and Corporate-Level StrategiesIn this assignment, you are to use the same corporation you selected and focused on for Assignment1: Strategic Management and Strategic Competitiveness and Assignment 2: External and Internal Environments. (Coca Cola)Researchthe company on its own website, the public filings on the Securities and

### Business Process Redesign If you have you been involved with a company doing a redesign of business processes discuss what

Business Process RedesignIf you have you been involved with a company doing a redesign of business processes, discuss what went right during the redesign and what went wrong from your perspective. Additionally, provide a discussion on what could have been done better to minimize the risk of failure. If you

### By Sunday night at midnight your assignment is to edit the SW inflight survey posted as a PDF on D2L.

By Sunday night at midnight your assignment is to edit the SW inflight survey posted as a PDF on D2L.First, create a word document where you go through and identify problems with the survey, and how you intend to fix them! Think about what kind of data is being gathered,

### By the due date assigned submit your threeparagraph essay as a Microsoft Word attachment. You will complete this assignment using

By the due date assigned, submit your three-paragraph essay as a Microsoft Word attachment. You will complete this assignment using the play Proof on https://books.google.com/books?id=MEfWYY3G1MkC&pg=PA4&lpg=PA4&dq=david+auburn+proof+the+back+porch+of+a+house+in+chicago&source=bl&ots=XR8jFOMZtK&sig=ACfU3U3lcS1elsz4K-sKnGwaAssN47-p6A&hl=en&sa=X&ved=2ahUKEwjervXBtLfpAhUOiqwKHckhB14Q6AEwDnoECAoQAQ#v=onepage&q=david%20auburn%20proof%20the%20back%20porch%20of%20a%20house%20in%20chicago&f=falseDirectionsRead the play Proof, and then write an analysis of one of the characters. You may use the brainstorming questions below to generate ideas, or you

### Business law knowledge preferred No less than 250 words On April 20 2010 an offshore BP

Business law knowledge preferredNo less than 250 words On April 20, 2010, an offshore BP drilling rig in the Gulf of Mexico exploded after a blowout and sank two days later. Eleven people were killed and the massive oil spill continues to harm humanity and the environment. The coasts of

### Business Drivers for Information Security Policies It is impossible to eliminate all business risks. In fact you would

Business Drivers for Information Security PoliciesIt is impossible to eliminate all business risks. In fact, you would not want to. Taking risks and making a return on those risks are essential to business. How you manage that risk is what makes businesses successful. A good policy can reduce the likelihood

### CAN YOU DO THIS FOR ME DUE 5182020 replies of 150250 words each in response to 2

CAN YOU DO THIS FOR ME DUE 5/18/2020replies of 150–250 words each in response to 2 other classmates’ threads; you must also provide at least 1 scholarly reference in support of each of your replies . The scholarly references and scriptures you incorporate in your initial posts and both replies

### Business Process Redesign If you have you been involved with a company doing a redesign of business processes

Business Process RedesignIf you have you been involved with a company doing a redesign of business processes, discuss what went right during the redesign and what went wrong from your perspective. Additionally, provide a discussion on what could have been done better to minimize the risk of failure. If you

### Capitalism is an economic and political system in which a countrys trade and industry are controlled by private owners for

Capitalism is an economic and political system in which a countrys trade and industry are controlled by private owners for profit, rather than by the state whereas socialism is a political and economic theory of social organization which advocates that the means of production, distribution, and exchange should be owned

### By October of 2017 Yahoo estimated that3 billion user accounts werecompromised. Users passwords in clear text payment card data and

By October of 2017, Yahoo estimated that3 billion user accounts werecompromised. Users passwords in clear text, payment card data and bank information were not stolen. Yet, it remains one of the largest data breaches.What that teach us as asecurityprofessionaland asregularuser ?

### Capstone Project Overview The purpose of this Capstone Project is for students to examine and solve real world information assurance

Capstone Project OverviewThe purpose of this Capstone Project is for students to examine and solve real world information assurance problems and apply associated techniques to create practical solutions. The course takes an integrative and senior security officer approach to address the policy, risk, and control opportunities within cyberspace and IT

### CAN YOU DO THIS FOR ME….DUE 5182020 Christian Worldview Essay Attached Files: Christian Worldview Essay Grading Rubric

CAN YOU DO THIS FOR ME….DUE 5/18/2020Christian Worldview EssayAttached Files:Christian Worldview Essay Grading Rubric (16.212 KB)You will watch the presentation in Module/Week 1 and research examples of people in law enforcement who have demonstrated or expressed their integration of a Christian Worldview into the field of criminal justice. You will

### Case Study 1: Auctions and Dynamic Pricing Case Study 1: Auctions and Dynamic Pricing The following video describes auctions

Case Study 1: Auctions and Dynamic Pricing Case Study 1: Auctions and Dynamic PricingThe following video describes auctions as price discovery mechanisms:The Ideal Auction. https://youtu.be/4kWuxfVbIaUUse the video on auctions and at least three academic or high-quality business publications (see acceptable types below) to answer the following questions in 5–7 pages.

### Can someone pleaaaaaase do this 34 page paper that is due today at 7pm I understand it is last minute

Can someone pleaaaaaase do this 3-4 page paper that is due today at 7pm!?!? I understand it is last minute and urgent but it is a final grade on Japanese literature! I need all instructions to be completed and guidelines to be followed! I will pay good money to someone

### Case Study 1: Auctions andDynamic Pricing The following video describes auctions as price discovery mechanisms: The Ideal Auction. Use the

Case Study 1: Auctions andDynamic PricingThe following video describes auctions as price discovery mechanisms:The Ideal Auction.Use the video on auctions and at least three academic or high-quality business publications (see acceptable types below) to answer the following questions in 5–7 pages. Other articles and resources can be found at the