Please answer in excel

ABC Analysis The ABC Analysis is one of the most established analysis methods within business administration. The following information was provided to us by a brownie baker (BB). In an attempt to understand our inventory better, we will use his data to perform calculations and create our initial inventory management policies. Using the data below, complete an ABC analysis. Identify the classification for each item Create 1 inventory management policy rule for each classification (not including cycle counting) Calculate the number of items counted per day if the policies are: A items every 22 working days; B items 100 days; Citems every 300 days Description Item G Item E Item C Item B Item D Item H Item F Annual Demand 1,693 1,087 1,567 3411,205 241 1,375 857 1,057 953 Cost 731 1,149 1,276 1,630 1,249 195 1,535 1,494 924 1,569 * f d HOT Demand Unit Cost Total Cost Percentage Policy (ABC) Count Category (ABC) Total Days Amount Unit