Question: This Assignment NEEDS two parts: PART A AND PART B on the same Excel as two sheets The document should be neat and have clear
- This Assignment NEEDS two parts: PART A AND PART B on the same Excel as two sheets
- The document should be neat and have clear graphs and tables (Titles, axis description, numbers).
- Black font, Times New Roman, size 12/14 is preferred. Round all figures to a whole#
- Do NOT copy the Questions into your submission document
- Do NOT share any part of your Assignment with anyone. You are liable for your document.
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 same Excel in another sheet:
A] What areas should George focus on to improve quality?
B] WHY do you say so?
| 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
