Question: Please use my data and not one from a already answered question Gateways restaurant serves all-day breakfast, lunch and dinner. George B, an excellent CEO
Please use my data and not one from a already answered question
Gateways restaurant serves all-day breakfast, lunch and dinner. George B, 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
Hint:- You can analyze by Lines to be intensely focused on improving system quality
PART B : On word document
A] What areas should George focus on to improve quality?
The areas that George should focus on should be
| Date | Time | Line | Missing stock | Spilled | Badly Sealed | Underfilled | Bad Taste |
| 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
Get step-by-step solutions from verified subject matter experts
