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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!