$\backslash$table$[[$Number$,$Item Number,Catalogue Number,$->$ Description,Package Qty $,$Package Cost,Annual Consumption $($pkgs$),$Extended Cost$],[1,010-0001,$BFF$-1,$Bandage, Fabric, Fingertip,$50,1\mathrm{.}0000,1,965,1,965\mathrm{.}00],[2,010-0002,$BF$2$x$3,$Bandage, Fabric, $2\backslash$times $3,50,1\mathrm{.}0000,1,253,1,253\mathrm{.}00],[3,010-0003,$BF$2$x$4,$Bandage, Fabric, $2\backslash$times $4,50,1\mathrm{.}1000,5,254,5,779\mathrm{.}40],[4,010-0004,$BF$2$x$6,$Bandage, Fabric, $2\backslash$times $6,50,1\mathrm{.}1000,2,545,2,799\mathrm{.}50],[5,010-0005,$BF$3$x$3,$Bandage, Fabric, $3\backslash$times $3,50,1\mathrm{.}2500,2,654,3,317\mathrm{.}50],[6,010-0006,$BF$3$x$4,$Bandage, Fabric, $3\backslash$times $4,50,1\mathrm{.}2500,2,354,2,942\mathrm{.}50],[7,010-0007,$BF$3$x$6,$Bandage, Fabric, $3\backslash$times $6,50,1\mathrm{.}2500,7,852,9,815\mathrm{.}00],[8,010-0008,$BF$4$x$4,$Bandage, Fabric, $4\backslash$times $4,50,1\mathrm{.}5000,4,541,6,811\mathrm{.}50],[9,010-0009,$BF$4$x$5,$Bandage, Fabric, $4\backslash$times $5,50,1\mathrm{.}5000,4,596,6,894\mathrm{.}00],[10,010-0010,$BF$4$x$6,$Bandage, Fabric, $4\backslash$times $6,50,1\mathrm{.}5000,5,598,8,397\mathrm{.}00],[11,010-0011,$BF$4$x$8,$Bandage, Fabric, $4\backslash$times $8,50,1\mathrm{.}5000,8,965,13,447\mathrm{.}50],[12,020-0001,$G$1$x$2,$Gauze, $1\backslash$times $2,10,2\mathrm{.}5000,7,832,19,580\mathrm{.}00],[13,020-0002,$G$1$x$4,$Gauze, $1\backslash$times $4,10,2\mathrm{.}5000,4,856,12,140\mathrm{.}00],[14,020-0003,$G$2$x$2,$Gauze, $2\backslash$times $2,10,3\mathrm{.}0000,5,653,16,959\mathrm{.}00],[15,020-0004,$G$2$x$3,$Gauze, $2\backslash$times $3,10,3\mathrm{.}0000,4,653,13,959\mathrm{.}00],[16,020-0005,$G$2$x$4,$Gauze, $2\backslash$times $4,10,3\mathrm{.}0000,2,587,7,761\mathrm{.}00],[17,020-0006,$G$3$x$3,$Gauze, $3\backslash$times $3,10,3\mathrm{.}2500,6,943,22,564\mathrm{.}75],[18,020-0007,$G$3$x$4,$Gauze, $3\backslash$times $4,10,3\mathrm{.}2500,6,413,20,842\mathrm{.}25],[20,020-0009,$G$3$x$6,$Gauze, $3\backslash$times $6,10,3\mathrm{.}2500,2,665,8,661\mathrm{.}25],[21,020-0010,$G$4$x$4,$Gauze, $4\backslash$times $4,10,4\mathrm{.}0000,3,653,14,612\mathrm{.}00],[22,020-0011,$G$4$x$5,$Gauze, $4\backslash$times $5,10,4\mathrm{.}0000,1,866,7,464\mathrm{.}00],[23,020-0012,$G$4$x$6,$Gauze, $4\backslash$times $6,10,4\mathrm{.}0000,1,500,6,000\mathrm{.}00],[24,020-0013,$G$4$x$7,$Gauze, $4$x$7,10,4\mathrm{.}0000,2,350,9,400\mathrm{.}00]]$A$-$B$-$C Analysis: Explain how you can identify products that should be your priority for managing and ensuring reliable performance.

Thinking back to your time at the College, you recall the power of A$-$B$-$C analysis and the benefits that it can provide to you and your organization. You decide to try the $10-20-70$ ratio for the initial ranges of these early reports.

Using the product sampling provided in Appendix A$,$ generate a report that will help you create an A$-$B$-$C report that can be segmented into the three categories.

Sort the items into descending order based on the total spend per item.

Insert a row between each Category division and insert a Subtotal for each Category.

Insert a Grand Total summary at the end of the report.

Verify the actual percentage values $($that is$,$ the ratio of the Category Subtotal to the Grand Total$).$ In the Grand Total area at the foot of the report, record the percentage of each Category beside the Category Subtotal, and verify the percentage total $($that is$,$ tally the three percentages$).$ This total may not be exactly $100\%,$ but it should be close.

Please note that although the Appendix A sampling consists of more than $100$ line items, statistically this is still a small sampling. You will find that your results will not completely match the theory and the percentage divisions that you might expect. That is acceptable.