Part 1: Review 1.) “Benchmark Assignment – Data Analysis Case Study” and 2.) “Benchmark Assignment – Data Analysis Case Study Data” for this topic’s case study, evaluating operations for a local restaurant (Attached docs.)
Part 2: 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. Compose and write 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.
3.) *Important” Use an Excel spreadsheet file for the calculations and explanations (Must be applied on excel document). All CELLS should contain the formulas (i.e., if a formula was used to calculate the entry in that cell).
4.) 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.