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 0000 1,965 $ 1,965 00 2 010 0002 BF2x3 Bandage, Fabric, 2x3 50 $ 1 0000 1,253 $ 1,253 00 3 010 0003 BF2x4 Bandage, Fabric, 2x4 50 $ 1 1000 5,254 $ 5,779 40 4 010 0004 BF2x6 Bandage, Fabric, 2x6 50 $ 1 1000 2,545 $ 2,799 50 5 010 0005 BF3x3 Bandage, Fabric, 3x3 50 $ 1 2500 2,654 $ 3,317 50 6 010 0006 BF3x4 Bandage, Fabric, 3x4 50 $ 1 2500 2,354 $ 2,942 50 7 010 0007 BF3x6 Bandage, Fabric, 3x6 50 $ 1 2500 7,852 $ 9,815 00 8 010 0008 BF4x4 Bandage, Fabric, 4x4 50 $ 1 5000 4,541 $ 6,811 50 9 010 0009 BF4x5 Bandage, Fabric, 4x5 50 $ 1 5000 4,596 $ 6,894 00 10 010 0010 BF4x6 Bandage, Fabric, 4x6 50 $ 1 5000 5,598 $ 8,397 00 11 010 0011 BF4x8 Bandage, Fabric, 4x8 50 $ 1 5000 8,965 $ 13,447 50 12 020 0001 G1x2 Gauze, 1x2 10 $ 2 5000 7,832 $ 19,580 00 13 020 0002 G1x4 Gauze, 1x4 10 $ 2 5000 4,856 $ 12,140 00 14 020 0003 G2x2 Gauze, 2x2 10 $ 3 0000 5,653 $ 16,959 00 15 020 0004 G2x3 Gauze, 2x3 10 $ 3 0000 4,653 $ 13,959 00 16 020 0005 G2x4 Gauze, 2x4 10 $ 3 0000 2,587 $ 7,761 00 17 020 0006 G3x3 Gauze, 3x3 10 $ 3 2500 6,943 $ 22,564 75 18 020 0007 G3x4 Gauze, 3x4 10 $ 3 2500 6,413 $ 20,842 25 19 020 0008 G3x5 Gauze, 3x5 10 $ 3 2500 5,444 $ 17,693 00 20 020 0009 G3x6 Gauze, 3x6 10 $ 3 2500 2,665 $ 8,661 25 21 020 0010 G4x4 Gauze, 4x4 10 $ 4 0000 3,653 $ 14,612 00 22 020 0011 G4x5 Gauze, 4x5 10 $ 4 0000 1,866 $ 7,464 00 23 020 0012 G4x6 Gauze, 4x6 10 $ 4 0000 1,500 $ 6,000 00 24 020 0013 G4x7 Gauze, 4x7 10 $ 4 0000 2,350 $ 9,400 00 25 020 0014 GR2x10 Gauze, Roll, 2x10M 5 $ 5 0000 865 $ 4,325 00 26 020 0015 GR3x10 Gauze, Roll, 3x10M 5 $ 5 0000 8,956 $ 44,780 00 27 020 0016 GR4x10 Gauze, Roll, 4x10M 5 $ 5 0000 689 $ 3,445 00 28 020 0017 GR6x10 Gauze, Roll, 6x10M 5 $ 5 0000 1,523 $ 7,615 00 29 020 0018 GR2x25 Gauze, Roll, 2x25M 5 $ 7 2500 2,274 $ 16,486 50 30 020 0019 GR3x25 Gauze, Roll, 3x25M 5 $ 7 2500 1,165 $ 8,446 25 31 020 0020 GR4x25 Gauze, Roll, 4x25M 5 $ 7 2500 7,746 $ 56,158 50 32 020 0021 GR6x25 Gauze, Roll, 6x25M 5 $ 7 2500 3,745 $ 27,151 25 33 020 0022 GR8x10 Gauze, Roll, 8x10M 5 $ 7 2500 1,474 $ 10,686 50 34 200 0005 SCM1432 Scissors, Medical 1 $ 4 7500 2,655 $ 12,611 25 35 050 0005 S0 01nm Suture, 0 01nm 25 $ 8 5000 154 $ 1,309 00 36 050 0006 S0 02nm Suture, 0 02nm 25 $ 8 5000 765 $ 6,502 50 37 050 0007 S0 03nm Suture, 0 03nm 25 $ 8 5000 663 $ 5,635 50 38 050 0008 S0 04nm Suture, 0 04nm 25 $ 8 5000 334 $ 2,839 00 39 050 0009 S0 05nm Suture, 0 05nm 25 $ 8 5000 222 $ 1,887 00 40 300 0100 GMS Gloves, Medical, BL, S 100 $ 9 6500 1,235 $ 11,917 75 41 300 0101 GMM Gloves, Medical, BL, M 100 $ 9 6500 1,458 $ 14,069 70 42 300 0102 GML Gloves, Medical, BL, L 100 $ 9 6500 5,575 $ 53,798 75 43 300 0103 GMXL Gloves, Medical, BL, XL 100 $ 10 0000 9,965 $ 99,650 00 44 300 0104 GMXXL Gloves, Medical, BL, XXL 100 $ 10 0000 5,212 $ 52,120 00 45 300 0105 GGBLKS Gloves, General, BLK, S 100 $ 6 5000 6,867 $ 44,635 50 46 300 0106 GGBLKM Gloves, General, BLK, M 100 $ 6 5000 6,665 $ 43,322 50 47 300 0107 GGBLKL Gloves, General, BLK, L 100 $ 6 5000 11,155 $ 72,507 50 48 300 0108 GGBLKXL Gloves, General, BLK, XL 100 $ 7 0000 5,535 $ 38,745 00 49 300 0109 GGBLKXXL Gloves, General, BLK, XXL 100 $ 7 0000 5,558 $ 38,906 00 50 400 0090 MSBLK Masks, Surgical, BLK 50 $ 43 0000 15,000 $ 645,000 00 51 400 0091 MSBLU Masks, Surgical, BLU 50 $ 43 0000 23,000 $ 989,000 00 52 400 0092 MSWHT Masks, Surgical, WHT 50 $ 43 0000 25,444 $ 1,094,092 00 53 410 0050 GSM Gown, YLLW, SM 10 $ 32 0000 1,689 $ 54,048 00 54 410 0051 GM Gown, YLLW, M 10 $ 32 0000 1,258 $ 40,256 00 55 410 0052 GL Gown, YLLW, L 10 $ 32 0000 1,257 $ 40,224 00 56 410 0053 GXL Gown, YLLW, XL 10 $ 32 0000 4,444 $ 142,208 00 57 410 0054 GXXL Gown, YLLW, XXL 10 $ 32 0000 4,669 $ 149,408 00 58 500 0100 WDDisinfectant Wipes, Disinfectant, 50 10 $ 38 2500 5,423 $ 207,429 75 59 500 0101 SF50ml Sanitizer, Foam, 50ml 25 $ 56 0000 5,632 $ 315,392 00 60 500 0102 SF250ml Sanitizer, Foam, 250ml 25 $ 56 0000 3,002 $ 168,112 00 61 500 0103 SF500ml Sanitizer, Foam, 500ml 25 $ 56 0000 1,547 $ 86,632 00 62 500 0104 DRTU, 750ml Disinfectant, RTU, 750ml 25 $ 129 5000 1,236 $ 160,062 00 63 500 0105 DL Disinfectant, RTU, 1 5L 25 $ 199 0000 123 $ 24,477 00 64 500 0106 DL Disinfectant, RTU, 5L 25 $ 324 0000 89 $ 28,836 00 65 500 0107 DC500ml Disinfectant, Concentrate, 500ml 10 $ 20 0000 123 $ 2,460 00 66 500 0108 DC750ml Disinfectant, Concentrate, 750ml 10 $ 30 0000 148 $ 4,440 00 67 500 0109 DCL Disinfectant, Concentrate, 1 5L 10 $ 40 0000 75 $ 3,000 00 68 750 0500 MS1x3 Mesh, Surgical, 1x3 5 $ 10 0000 365 $ 3,650 00 69 750 0501 MS1x4 Mesh, Surgical, 1x4 5 $ 10 0000 789 $ 7,890 00 70 750 0502 MS1x5 Mesh, Surgical, 1x5 5 $ 10 0000 854 $ 8,540 00 71 750 0503 MS1x6 Mesh, Surgical, 1x6 5 $ 10 0000 442 $ 4,420 00 72 750 0504 MS2x2 Mesh, Surgical, 2x2 5 $ 12 0000 257 $ 3,084 00 73 750 0505 MS2x3 Mesh, Surgical, 2x3 5 $ 12 0000 854 $ 10,248 00 74 750 0506 MS2x4 Mesh, Surgical, 2x4 5 $ 12 0000 856 $ 10,272 00 75 750 0507 MS2x5 Mesh, Surgical, 2x5 5 $ 12 0000 445 $ 5,340 00 76 750 0508 MS2x6 Mesh, Surgical, 2x6 5 $ 12 0000 554 $ 6,648 00 77 750 0509 MS3x3 Mesh, Surgical, 3x3 5 $ 14 0000 336 $ 4,704 00 78 750 0510 MS3x4 Mesh, Surgical, 3x4 5 $ 14 0000 875 $ 12,250 00 79 750 0511 MS3x5 Mesh, Surgical, 3x5 5 $ 14 0000 596 $ 8,344 00 80 750 0512 MS3x6 Mesh, Surgical, 3x6 5 $ 14 0000 153 $ 2,142 00 81 750 0513 MS4x4 Mesh, Surgical, 4x4 5 $ 16 0000 128 $ 2,048 00 82 750 0514 MS4x5 Mesh, Surgical, 4x5 5 $ 16 0000 785 $ 12,560 00 83 750 0515 MS4x6 Mesh, Surgical, 4x6 5 $ 16 0000 587 $ 9,392 00 84 750 0516 MS4x8 Mesh, Surgical, 4x8 5 $ 16 0000 865 $ 13,840 00 85 200 0015 ST100 Stethoscope 1 $ 20 0000 856 $ 17,120 00 86 200 0030 HMRRFL Hammer, Reflex 1 $ 4 5000 83 $ 373 50 87 620 0058 TPE, Med, 1x5M Tape, Medical, 1x5M 5 $ 3 7400 120 $ 448 80 88 620 0059 TPE, Med, 2x5M Tape, Medical, 2x5M 5 $ 3 7900 135 $ 511 65 89 620 0060 TPE, Med, 3x5M Tape, Medical, 3x5M 5 $ 4 0200 145 $ 582 90 90 620 0061 TPE, Med, 4x5M Tape, Medical, 4x5M 5 $ 4 1600 168 $ 698 88 91 620 0062 TPE, Med, 1x10M Tape, Medical, 1x10M 5 $ 4 8500 178 $ 863 30 92 620 0063 TPE, Med, 2x10M Tape, Medical, 2x10M 5 $ 5 0000 135 $ 675 00 93 620 0064 TPE, Med, 3x10M Tape, Medical, 3x10M 5 $ 5 4600 116 $ 633 36 94 620 0065 TPE, Med, 4x10M Tape, Medical, 4x10M 5 $ 5 7800 140 $ 809 20 95 820 5260 STPL1 Staple, Medical, 1cm 5 $ 8 0000 425 $ 3,400 00 96 820 5261 STPL2 Staple, Medical, 2cm 5 $ 8 6000 356 $ 3,061 60 97 820 5262 STPL4 Staple, Medical, 4cm 5 $ 9 2400 752 $ 6,948 48 98 820 5263 STPL6 Staple, Medical, 6cm 5 $ 10 5600 954 $ 10,074 24 99 820 5264 STPL8 Staple, Medical, 8cm 5 $ 11 7200 568 $ 6,656 96 100 820 5265 STPL10 Staple, Medical, 10cm 5 $ 16 0000 114 $ 1,824 00 Total Annual Spend $ 5,255,739 72 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 report that will help you create 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2024

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.0000 1,965

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.0000	1,965	$ 1,965.00
2	010-0002	BF2x3	Bandage, Fabric, 2x3	50	$ 1.0000	1,253	$ 1,253.00
3	010-0003	BF2x4	Bandage, Fabric, 2x4	50	$ 1.1000	5,254	$ 5,779.40
4	010-0004	BF2x6	Bandage, Fabric, 2x6	50	$ 1.1000	2,545	$ 2,799.50
5	010-0005	BF3x3	Bandage, Fabric, 3x3	50	$ 1.2500	2,654	$ 3,317.50
6	010-0006	BF3x4	Bandage, Fabric, 3x4	50	$ 1.2500	2,354	$ 2,942.50
7	010-0007	BF3x6	Bandage, Fabric, 3x6	50	$ 1.2500	7,852	$ 9,815.00
8	010-0008	BF4x4	Bandage, Fabric, 4x4	50	$ 1.5000	4,541	$ 6,811.50
9	010-0009	BF4x5	Bandage, Fabric, 4x5	50	$ 1.5000	4,596	$ 6,894.00
10	010-0010	BF4x6	Bandage, Fabric, 4x6	50	$ 1.5000	5,598	$ 8,397.00
11	010-0011	BF4x8	Bandage, Fabric, 4x8	50	$ 1.5000	8,965	$ 13,447.50
12	020-0001	G1x2	Gauze, 1x2	10	$ 2.5000	7,832	$ 19,580.00
13	020-0002	G1x4	Gauze, 1x4	10	$ 2.5000	4,856	$ 12,140.00
14	020-0003	G2x2	Gauze, 2x2	10	$ 3.0000	5,653	$ 16,959.00
15	020-0004	G2x3	Gauze, 2x3	10	$ 3.0000	4,653	$ 13,959.00
16	020-0005	G2x4	Gauze, 2x4	10	$ 3.0000	2,587	$ 7,761.00
17	020-0006	G3x3	Gauze, 3x3	10	$ 3.2500	6,943	$ 22,564.75
18	020-0007	G3x4	Gauze, 3x4	10	$ 3.2500	6,413	$ 20,842.25
19	020-0008	G3x5	Gauze, 3x5	10	$ 3.2500	5,444	$ 17,693.00
20	020-0009	G3x6	Gauze, 3x6	10	$ 3.2500	2,665	$ 8,661.25
21	020-0010	G4x4	Gauze, 4x4	10	$ 4.0000	3,653	$ 14,612.00
22	020-0011	G4x5	Gauze, 4x5	10	$ 4.0000	1,866	$ 7,464.00
23	020-0012	G4x6	Gauze, 4x6	10	$ 4.0000	1,500	$ 6,000.00
24	020-0013	G4x7	Gauze, 4x7	10	$ 4.0000	2,350	$ 9,400.00
25	020-0014	GR2x10	Gauze, Roll, 2x10M	5	$ 5.0000	865	$ 4,325.00
26	020-0015	GR3x10	Gauze, Roll, 3x10M	5	$ 5.0000	8,956	$ 44,780.00
27	020-0016	GR4x10	Gauze, Roll, 4x10M	5	$ 5.0000	689	$ 3,445.00
28	020-0017	GR6x10	Gauze, Roll, 6x10M	5	$ 5.0000	1,523	$ 7,615.00
29	020-0018	GR2x25	Gauze, Roll, 2x25M	5	$ 7.2500	2,274	$ 16,486.50
30	020-0019	GR3x25	Gauze, Roll, 3x25M	5	$ 7.2500	1,165	$ 8,446.25
31	020-0020	GR4x25	Gauze, Roll, 4x25M	5	$ 7.2500	7,746	$ 56,158.50
32	020-0021	GR6x25	Gauze, Roll, 6x25M	5	$ 7.2500	3,745	$ 27,151.25
33	020-0022	GR8x10	Gauze, Roll, 8x10M	5	$ 7.2500	1,474	$ 10,686.50
34	200-0005	SCM1432	Scissors, Medical	1	$ 4.7500	2,655	$ 12,611.25
35	050-0005	S0.01nm	Suture, 0.01nm	25	$ 8.5000	154	$ 1,309.00
36	050-0006	S0.02nm	Suture, 0.02nm	25	$ 8.5000	765	$ 6,502.50
37	050-0007	S0.03nm	Suture, 0.03nm	25	$ 8.5000	663	$ 5,635.50
38	050-0008	S0.04nm	Suture, 0.04nm	25	$ 8.5000	334	$ 2,839.00
39	050-0009	S0.05nm	Suture, 0.05nm	25	$ 8.5000	222	$ 1,887.00
40	300-0100	GMS	Gloves, Medical, BL, S	100	$ 9.6500	1,235	$ 11,917.75
41	300-0101	GMM	Gloves, Medical, BL, M	100	$ 9.6500	1,458	$ 14,069.70
42	300-0102	GML	Gloves, Medical, BL, L	100	$ 9.6500	5,575	$ 53,798.75
43	300-0103	GMXL	Gloves, Medical, BL, XL	100	$ 10.0000	9,965	$ 99,650.00
44	300-0104	GMXXL	Gloves, Medical, BL, XXL	100	$ 10.0000	5,212	$ 52,120.00
45	300-0105	GGBLKS	Gloves, General, BLK, S	100	$ 6.5000	6,867	$ 44,635.50
46	300-0106	GGBLKM	Gloves, General, BLK, M	100	$ 6.5000	6,665	$ 43,322.50
47	300-0107	GGBLKL	Gloves, General, BLK, L	100	$ 6.5000	11,155	$ 72,507.50
48	300-0108	GGBLKXL	Gloves, General, BLK, XL	100	$ 7.0000	5,535	$ 38,745.00
49	300-0109	GGBLKXXL	Gloves, General, BLK, XXL	100	$ 7.0000	5,558	$ 38,906.00
50	400-0090	MSBLK	Masks, Surgical, BLK	50	$ 43.0000	15,000	$ 645,000.00
51	400-0091	MSBLU	Masks, Surgical, BLU	50	$ 43.0000	23,000	$ 989,000.00
52	400-0092	MSWHT	Masks, Surgical, WHT	50	$ 43.0000	25,444	$ 1,094,092.00
53	410-0050	GSM	Gown, YLLW, SM	10	$ 32.0000	1,689	$ 54,048.00
54	410-0051	GM	Gown, YLLW, M	10	$ 32.0000	1,258	$ 40,256.00
55	410-0052	GL	Gown, YLLW, L	10	$ 32.0000	1,257	$ 40,224.00
56	410-0053	GXL	Gown, YLLW, XL	10	$ 32.0000	4,444	$ 142,208.00
57	410-0054	GXXL	Gown, YLLW, XXL	10	$ 32.0000	4,669	$ 149,408.00
58	500-0100	WDDisinfectant	Wipes, Disinfectant, 50	10	$ 38.2500	5,423	$ 207,429.75
59	500-0101	SF50ml	Sanitizer, Foam, 50ml	25	$ 56.0000	5,632	$ 315,392.00
60	500-0102	SF250ml	Sanitizer, Foam, 250ml	25	$ 56.0000	3,002	$ 168,112.00
61	500-0103	SF500ml	Sanitizer, Foam, 500ml	25	$ 56.0000	1,547	$ 86,632.00
62	500-0104	DRTU, 750ml	Disinfectant, RTU, 750ml	25	$ 129.5000	1,236	$ 160,062.00
63	500-0105	DL	Disinfectant, RTU, 1.5L	25	$ 199.0000	123	$ 24,477.00
64	500-0106	DL	Disinfectant, RTU, 5L	25	$ 324.0000	89	$ 28,836.00
65	500-0107	DC500ml	Disinfectant, Concentrate, 500ml	10	$ 20.0000	123	$ 2,460.00
66	500-0108	DC750ml	Disinfectant, Concentrate, 750ml	10	$ 30.0000	148	$ 4,440.00
67	500-0109	DCL	Disinfectant, Concentrate, 1.5L	10	$ 40.0000	75	$ 3,000.00
68	750-0500	MS1x3	Mesh, Surgical, 1x3	5	$ 10.0000	365	$ 3,650.00
69	750-0501	MS1x4	Mesh, Surgical, 1x4	5	$ 10.0000	789	$ 7,890.00
70	750-0502	MS1x5	Mesh, Surgical, 1x5	5	$ 10.0000	854	$ 8,540.00
71	750-0503	MS1x6	Mesh, Surgical, 1x6	5	$ 10.0000	442	$ 4,420.00
72	750-0504	MS2x2	Mesh, Surgical, 2x2	5	$ 12.0000	257	$ 3,084.00
73	750-0505	MS2x3	Mesh, Surgical, 2x3	5	$ 12.0000	854	$ 10,248.00
74	750-0506	MS2x4	Mesh, Surgical, 2x4	5	$ 12.0000	856	$ 10,272.00
75	750-0507	MS2x5	Mesh, Surgical, 2x5	5	$ 12.0000	445	$ 5,340.00
76	750-0508	MS2x6	Mesh, Surgical, 2x6	5	$ 12.0000	554	$ 6,648.00
77	750-0509	MS3x3	Mesh, Surgical, 3x3	5	$ 14.0000	336	$ 4,704.00
78	750-0510	MS3x4	Mesh, Surgical, 3x4	5	$ 14.0000	875	$ 12,250.00
79	750-0511	MS3x5	Mesh, Surgical, 3x5	5	$ 14.0000	596	$ 8,344.00
80	750-0512	MS3x6	Mesh, Surgical, 3x6	5	$ 14.0000	153	$ 2,142.00
81	750-0513	MS4x4	Mesh, Surgical, 4x4	5	$ 16.0000	128	$ 2,048.00
82	750-0514	MS4x5	Mesh, Surgical, 4x5	5	$ 16.0000	785	$ 12,560.00
83	750-0515	MS4x6	Mesh, Surgical, 4x6	5	$ 16.0000	587	$ 9,392.00
84	750-0516	MS4x8	Mesh, Surgical, 4x8	5	$ 16.0000	865	$ 13,840.00
85	200-0015	ST100	Stethoscope	1	$ 20.0000	856	$ 17,120.00
86	200-0030	HMRRFL	Hammer, Reflex	1	$ 4.5000	83	$ 373.50
87	620-0058	TPE, Med, 1x5M	Tape, Medical, 1x5M	5	$ 3.7400	120	$ 448.80
88	620-0059	TPE, Med, 2x5M	Tape, Medical, 2x5M	5	$ 3.7900	135	$ 511.65
89	620-0060	TPE, Med, 3x5M	Tape, Medical, 3x5M	5	$ 4.0200	145	$ 582.90
90	620-0061	TPE, Med, 4x5M	Tape, Medical, 4x5M	5	$ 4.1600	168	$ 698.88
91	620-0062	TPE, Med, 1x10M	Tape, Medical, 1x10M	5	$ 4.8500	178	$ 863.30
92	620-0063	TPE, Med, 2x10M	Tape, Medical, 2x10M	5	$ 5.0000	135	$ 675.00
93	620-0064	TPE, Med, 3x10M	Tape, Medical, 3x10M	5	$ 5.4600	116	$ 633.36
94	620-0065	TPE, Med, 4x10M	Tape, Medical, 4x10M	5	$ 5.7800	140	$ 809.20
95	820-5260	STPL1	Staple, Medical, 1cm	5	$ 8.0000	425	$ 3,400.00
96	820-5261	STPL2	Staple, Medical, 2cm	5	$ 8.6000	356	$ 3,061.60
97	820-5262	STPL4	Staple, Medical, 4cm	5	$ 9.2400	752	$ 6,948.48
98	820-5263	STPL6	Staple, Medical, 6cm	5	$ 10.5600	954	$ 10,074.24
99	820-5264	STPL8	Staple, Medical, 8cm	5	$ 11.7200	568	$ 6,656.96
100	820-5265	STPL10	Staple, Medical, 10cm	5	$ 16.0000	114	$ 1,824.00
						Total Annual Spend	$ 5,255,739.72

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 inAppendix A, generate report that will help you create 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.