| External failure | 24300 | | | Customer complaint remakes | $24,300 | | | To fill out the yellow cells, you must choose which cost fits each quality category. The total quality costs and categories are listed in cells A6:B9. The percentage of costs and their associated categories are listed in cells A15:B18.
For example: External Failure has a total cost of $24,300. Its associated percentage of total COQ is 2.08% (.0208). Look at the Reason, Cost and Quality Cost Category information in columns 'F' and 'G.' You will see that 24,300 is associated with a single reason. Enter the cost category from column 'A' into the Quality Cost Category in column 'G.' Then copy that information for each cost into its corresponding costs by category in the cells below.
Internal failure has a total cost of $550,700. A combination of values in column 'F' make up that total cost. You have to determine which associated costs, by reason, are applicable to each category. (i.e which combination of reason and costs total $550,700?). Once you determine that, follow the last few steps above to fill out column 'G,' and the costs by category information.
Make Pie Chart from % Quality Costs information. |
DEE9175
Prob08-06.xlsx
