Need A,B,C to be reflected on excel i don't understand what to do

..12.2 Boreki Enterprises has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to a divide these items into ABC classifications. ITEM ANNUAL DEMAND COST/UNIT A2 3,000 $50 B8 4,000 12 C7 1,500 45 D1 6,000 10 E9 1,000 20 F3 500 500 G2 300 1,500 H2 600 20 1,750 10 JB 2,500 5 a) Develop an ABC classification system for the 10 items. b) How can Boreki use this information? c) Boreki reviews the classification and then places item A2 into the A category. Why might he do so? PX 15 12/9/21 Inventory/ABC Analysis Enter the unit costs and the unit volumes into the shaded data area. NOTE: The dollar volume in column F (but not in column L) is adjusted to prevent ties. Percent of dollar volume accounted for by A items 75.00% Percent of dollar volume accounted for by B items 15.00% 90.00% Results - sorted by dollar volume Cum Dollar Percent Percent Volume Unit Dollar of Dollar of Dollar Categor Rank Item Volume Cost Volume Volume Volume ly Item 2 0 ol $ #DIV/0! #DIV/0! A 2 Item 1 ol o $ #DIV/0! | #DIV/0! #DIV/0! $ Unit Cost Dollar Volume Rank Volume Percent Dollar of Dollar volume Volume $ 0.00 #DIV/0! $ 0.00 #DIV/0! Item 2 Item 1 1 Item 2 Total