# Benchmark - Data Analysis Case Study, business and finance homework help

Anonymous
account_balance_wallet \$30

### Question 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

whgrab
School: Rice University

let me know if you need more

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...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors