Description
Review "Benchmark Assignment - Data Analysis Case Study" (ATTACHED)and "Benchmark Assignment - Data Analysis Case Study Data" (ATTACHED)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 required to use the "Benchmark Assignment - Data Analysis Case Study Template" (ATTACHED)and "Benchmark Assignment - Data Analysis Case Study Linear Programming Template"(ATTACHED)
to complete this assignment (Use the provided template( please do not modify template) to complete assignment).
Prepare the assignment according to the guidelines found in the APA Style Guide.
This assignment uses a rubric (ATTACHED). Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. All sections of rubric must be included in the answer.
This assignment required to submit this assignment to Turnitin so please make sure to so assignment accordingly
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
let me know if you need more
Running head: BENCHMARKING
1
Benchmarking assignment
Instructor name
Submitted by
Date
BENCHMARKING
2
It is concerned with staff scheduling, the data provided total five shifts starting from morning 11
am to midnight. The required number of staff as stated are 3, 4, 6, 7, and 4 for shift 1, shift 2,
shift 3, shift 4, and shift 5 respectively. With this, there are some complaints coming up from the
customers about the slow service. The method to know the right number of staff for each shift is
linear programming. The owner must work to reduce the cost of the restaurant. The total
availability of staff for all the shifts is 15. However, the results obtained in the solver depicts the
same results But as per my observation of the entire scenario, I can say that shift 1 requires not
more than 2 employees because the opening time of restaurant is 11 a.m. Two employees are
enough to manage the entire area, as the customers during opening hours are also very less. For
shift 2, it should be 3 because this is the time when the customers start visiting for lunch. The
customers during the shift 2 are mainly businessman who has a meeting with their clients, the
employees of the nearby area who wish to have lunch outside, or the college going students who
plans for the parties outside their college premises. For shift 3, the number of staff should be 4
because these are the hours when the office hour finishes and people plan for dinner outside.
During shift 4, the requirement of staff should be 4, as the shift finishes at 10:00 p.m. This is the
time when people stay out of their home to enjoy outside with friends or fa...