Identify which variables are significant to predicting

Assignment Help Operation Management
Reference no: EM131744713

Review "Benchmark Assignment - Data Analysis Case Study" and "Benchmark Assignment - Data Analysis Case Study Data" for this topic's case study, evaluating operations for a local restaurant.

Although your friend and restauranteur Michael Tanaglia offered to go over your findings in person, you believe it would be appropriate to also prepare a report and document your findings in writing. In a 1,000-1,250-word report, explain your approach for each evaluation and the rationale for the methods you used. Include any recommendations based on customer satisfaction, forecasting, and staff scheduling data.

Use an Excel spreadsheet file for the calculations and explanations. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell). Students are highly encouraged to use the "Benchmark Assignment - Data Analysis Case Study Template" and "Benchmark Assignment - Data Analysis Case Study Linear Programming Template" to complete this assignment.
Mac users can use StatPlus:mac LE, free of charge, from AnalystSoft.

Benchmark Assignment - Data Analysis Case Study

The Cicero Italian Restaurant was founded by Anthony Tanagliain 1947 in Cicero, Illinois, a suburb of Chicago. He built the business with his family from a small pizza and pasta restaurant to 10locations in the Chicago area. Michael Tanaglia, Anthony's grandson, moved to Arizona to escape the cold Chicago winters and opened a restaurant in the Chandler area.

The Arizona restaurant gained momentum thanks to the Chicago-style pizza and quality Italian dishes. Anthony decided to expand operations in Arizona, adding a second location in Glendale. The Glendale location was managed by Michael's son Tony.

After ayear of operations, Michael had some concerns with the Glendale location. Michael does not want his family's business to fail, and he wants his grandfather's legacy to last. Michael also understands how important an operational evaluation can be to identifying the strengths and weaknesses of a business.

Michael confides his concerns to you andasks if you will do him a favor and use your quantitative analytic expertise to help him evaluate the Glendale location's operations in three key areas: customer satisfaction, customer forecasting, and staff scheduling. As his friend, you agree - though his offer to treat you to the large pizza of your choice didnot hurt.

First Evaluation

The first evaluation required an understanding of the factors thatcontribute to customer satisfaction and spending. Refer to the data Michael provided in the Excel spreadsheet "Benchmark Assignment - Data Analysis Case Study Data."

Identify which variables are significant to predicting overall satisfaction. Develop and interpret the prediction equation and the coefficient of determination. Based upon the data in this evaluation, what areas should Michael and Tony Tanaglia focus on to improve customer satisfaction?

Second Evaluation

The second evaluation requires a forecast of customers based upon demand. Michael reviewed data for the previous 11 months in an attempt to better forecast restaurant customer volume.

Month

# of Customers

January

650

February

725

March

850

April

825

May

865

June

915

July

900

August

930

September

950

October

899

November

935

December

?

Which method should the business owner use to yield the lowest amount of error and what would be the forecast for December?Refer to the Excel spreadsheet "Benchmark Assignment - Data Analysis Case Study Template."

Third Evaluation

The third evaluation concerns staff scheduling.Some of the customers have complained that service is slow. The restaurant is open from 11:00 a.m.to midnight every day of the week. Tony divided the workday into five shifts. The table below shows the minimum number of workers needed during the five shifts of time into which the workday is divided.

Shift

Time

# of Staff Required

1

10:00 a.m.- 1:00 p.m.

3

2

1:00 p.m. - 4:00 p.m.

4

3

4:00 p.m. - 7:00 p.m.

6

4

7:00 p.m. - 10:00p.m.

7

5

10:00 p.m. - 1:00 a.m.

4

The owners must find the right number of staff to report at each start time to ensure that there is sufficient coverage. The organization is trying to keep costs low and balance the number of staff with the size of the restaurant, so the total number of workers is constrained to 15.

Based on these factors, recommend the staff for each shift to accommodate the minimum requirements for customer service.Refer to the Excel spreadsheet "Benchmark Assignment - Data Analysis Case Study Linear Programming Template."

Reference no: EM131744713

Questions Cloud

Briefly introduce and summarize the given article : Briefly introduce and summarize the article. Do the author's arguments support his or her main point? What evidence supports the main point?
Find the expected counts for each cell : Grades. Two different professors teach an introductory Statistics course. The table shows the distribution of final grades they reported.
Check the assumptions and conditions for inference : Check the assumptions and conditions for inference, cannot afford to use it unless he is sure of attaining at least
Make a scatterplot of these data : Gas chromatography. Gas chromatography is a technique used to detect very small amounts of a substance, for example, a contaminant in drinking water.
Identify which variables are significant to predicting : Identify which variables are significant to predicting overall satisfaction. Develop and interpret the prediction equation and the coefficient of determination.
Many dairy cows now receive injections of bst : Many dairy cows now receive injections of BST, a hormone intended to spur greater milk production. After the first injection,
What is probability that all freshmen receive financial aid : Suppose at least 15 freshmen receive financial aid. What is the probability that all 20 freshmen receive financial aid
National collegiate athletic association tournament : Golf scores. Here are the golf scores of 6 members of a women's golf team in the first two rounds of the National Collegiate Athletic Association tournament:
Find the p-value for your test : Test an appropriate hypothesis about this table and state your conclusions - Are the conditions for inference satisfied? Find the P-value for your test.

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd