$2)$ The Pareto Chart. $($This exercise involves drawing two separate charts$)$

A contractor organization is concerned about the quality of its housing construction and conducts a survey of its quality defects.$$ The data collected are shown below

$$

Item$$ No$.$ of defects$$ $ Cost per defect

Doors$1043\mathrm{.}50$

Ceiling$977$

Paint$3239$

Roof$12120$

Windows$11347$

Carpet$2233$

Plumbing$837$

$$

a$.$ Draw this chart by hand. You should be able to show people how to do that in the $$field where the trades involved may not have ready access to special software $($and $$hardware$)$

b$.$ You may repeat the drawing of the chart using Excel or the $$brighthub$$ website shown under Section $3$ below, but at least one chart should be drawn by hand.$$Please ensure that the finished document is in Word and that it can be opened $$

c$.$ Special note: Do the analysis first based on the number of defects.$$ Construct the $$matrix as discussed in the lecture $($See below$),$ then fill in the values required for the analysis.$$

d$.$ Draw a Pareto chart based on the number of defects shown in the survey. Identify $$the categories that merit attention, based on the $80/20$ rule.

e$.$ Explain the actions that you would recommend, based on the chart.

f$.$ Following that, draw a second Pareto chart, based on the combined cost of each defect. Hint: Multiply the number of occurrences of each defect by its corresponding cost.

g$.$ Identify the categories that merit attention, based on the $80/20$ rule.

h$.$ Explain how drawing the second chart changes your decision$-$making and $$recommendation