Question
This Assignment NEEDS two parts to be submitted PART A on Excel AND PART B on word document The document should be neat and have
- This Assignment NEEDS two parts to be submitted PART A on Excel AND PART B on word document
- The document should be neat and have clear graphs and tables (Titles, axis description, numbers).
- Round all figures to a whole#
- Your Answers should be authentic
Benny's restaurant serves all-day breakfast, lunch and dinner. Larry, an excellent CEO wants to improve on the quality of his restaurant and gathered some statistics that shows the following complaints.
PART A: on excel:
Analyze the following data/Research the best way-Justify using Pareto chart(s)on Excel : Draw and Label the graph(s)(8 marks)
Hint:- you can analyze by Lines, to be intensely focused on improving system quality.
PART B: on Word Document: (3.5 marks each)
A] What areas should Larry focus on to improve quality? Answer in Points B] WHY do you say so? How will he do so?
Date | Time | Line | Bad taste | Cold | Not in time | Insufficient quantity | Wrong delivery |
May 15 | 0800 | A | |||||
May 15 | 1300 | B | |||||
May 16 | 1000 | B | |||||
May 16 | 1345 | A | |||||
May 16 | 1530 | B | |||||
May 17 | 0830 | A | |||||
May 17 | 1100 | B | |||||
May 17 | 1400 | A | |||||
May 18 | 1030 | A | |||||
May 18 | 1145 | B | |||||
May 18 | 1500 | A | |||||
May 19 | 0845 | B | |||||
May 19 | 1030 | A | |||||
May 19 | 1400 | A | |||||
May 19 | 1600 | B |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started