Purpose: Learn how to construct a Pareto Chart

Scenario: Late Pizza Deliveries Reasons and the Need to Reduce Late Pizza Deliveries going forward

Assume that the total number of late pizzas in the past year equals 1,000

You should brainstormed reasons in Part A, assign a value to each reason (e.g. oven was not pre-heated on time = 150 times out of 1,000)

Construct Pareto Chart utilizing the following template (excel is the best tool to use to construct the Pareto chart): Please note that Category D, A, B, E, C below have to correspond about reasons for late pizzas deliveries:

You do not have the budget to address and eliminate all reasons for late pizza deliveries. You need to recommend the actions to take based on the constructed Pareto Chart with the detailed explanation.