Categories
Numerical analysis homework help

  Scenario:  Pastas R Us, Inc. is a fast-casual restaurant chain specializing in

 
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% 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.
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?)
Cite references to support your assignment.

Categories
Numerical analysis homework help

  Scenario:  Pastas R Us, Inc. is a fast-casual restaurant chain specializing in

 
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% 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.
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?)
Cite references to support your assignment.

Categories
Numerical analysis homework help

Attached Files:  Analytic Summary.pptx (359.25 KB)  Theory and Methods Basic

Attached Files:
 Analytic Summary.pptx (359.25 KB)
 Theory and Methods Basics.pptx (363.3 KB)
 example Case+Study+Analysis_+Analyzing+Player+Behavior+In+The+NFL+Runningback.pdf (251.757 KB)
 example Sports+analytics+case+study+project.pdf (386.891 KB)
YOU ARE NOT CREATING A MODEL – YOU ARE COMMUNICATING HOW YOU WOULD TACKLE A PROBLEM USING THE ANALYTICS STEPS LISTED IN THE “FINAL PROJECT” DOCUMENT. THIS IS THEORY-BASED.1. Watch the video: https://365datascience.com/career-advice/expert-interviews/data-use-cases-sports-analytics/2. Watch the video to write a case study/report: https://www.youtube.com/watch?v=beGwPSAwD4o&t=2s3. Choose a case study either from page 2 of the attached “CASE STUDY” document or another case study found on the web regarding Sports Analytics (i.e how Analytics is used in Physical Therapy, see Exercise Analytics).  You should look for applications where you can apply analytics and machine learning knowledge to improve some aspects of the Sports data lifecycle (see the Introduction to Sports Analytics course). Feel free to speak with me to talk through your idea if you pull it from the Internet or another class. other ideas:  https://www.samford.edu/sports-analytics/case-studies  https://towardsdatascience.com/scope-of-analytics-in-sports-world-37ed09c39860  https://www.digitaldividedata.com/clients/case-studies/sports-analytics4. Create a solid project on how sports analytics is used in your specific use case. You should speak to “How data science is applied in the broad field of Sports.”Data: a. You can create fake data in Excel (we create fake data in class at times to understand the topic we are discussing) and add it as a snapshot to the presentation.          b. You can take a screenshot of data on the web that supports how data is being used in your area. Look for, or think of examples from your use case that ties in topics of what you have learned in the class.5. Presentation should be presented in a Word document, PDF, or PPTX.6. two examples of student submissions are attached.7. Your work should be original else you will be penalized. You can reference articles/quotes but ensure the reader knows you’re referencing these quotes/articles. 

Categories
Numerical analysis homework help

Which of the pairs among the variables seem to be correlated?

The dataset ToyotaCorolla.jmp contains data on used cars on sale during the late summer of 2004 in the Netherlands. It has 1436 records containing details on 38 attributes, including Price, Age, Kilometers, HP, and other specifications.
Explore the data using the data visualization (e.g., Graph > Scatterplot Matrix and Graph > Graph Builder) capabilities of JMP. Which of the pairs among the variables seem to be correlated? (Refer to the guides and videos at jmp.com/learn, under Graphical Displays and Summaries, for basic information on how to use these platforms.)
We plan to analyze the data using various data mining techniques described in future chapters. Prepare the dataset for data mining techniques of supervised learning by creating partitions using the JMP Pro Make Validation Column utility (from the Cols menu). Use the following partitioning percentages: training (50%), validation (30%), and test (20%). Describe the roles that these partitions will play in modeling.

Categories
Numerical analysis homework help

You need to determine if your truck will safely make it over the bridge.

 
You are a Business Analyst working for the ABC Ball Bearing company. An hour ago, you sent an order of 74 boxes of your A1 ball bearings to a customer on your delivery truck.  You have just found out that your truck is going to go over a bridge that has a weight limit of 11,500 lbs.  You need to determine if your truck will safely make it over the bridge.  If you determine that the truck cannot make it over the bridge, you will need to call the driver and have him/her turn back.
The plant manager has told you that an empty delivery truck with the driver weights about 8500 lbs.
You have 30 boxes of the A1 ball bearings in your plant. You immediately had them weighed.  The weights of the boxes are:

Categories
Numerical analysis homework help

How is each factor related to elasticities of demand?

  
ASSIGNMENT QUESTIONS
1. What are the relevant factors to be considered for modeling a demand function for Maa mustard oil? How is each factor related to elasticities of demand? How does the estimation of demand function incorporate the impact of each factor using the multiple regression technique?
2. Analyze the estimated demand function and calculate the elasticities of demand for Hind Oil Industries’ product. What do these calculations suggest about the effects of changes in each of these variables?
3. What would be the impact of a price change by HOI on the total revenue of Maa mustard oil, keeping other variables constant?
4. What is the optimum price at which total revenue can be maximized for Maa mustard oil if the competitors’ prices do not increase in October 2015 (scenario l)? If competitors increase their prices by around 6 percent, as suggested in the case (scenario 2), what would be the optimum price? Does the company benefit if competitors increase their prices? Perform all calculations under the assumption of no increase in promotional expenditure in the next month and a 1-per-cent increase in the per capita income of consumers.
5. Plot a demand curve and a total revenue curve using the estimated values of quantity demanded from question 4. Analyze the findings of question 4 by using the concept of the total revenue test and the plotted graphs.