M9.7. The finished goods inventory of a small manufacturing company is shown below (available in data file for Module 9). Perform an ABC analysis on the data (Assign A items to a maximum of 70 % of the cumulative value and B items to a maximum of the next 20% of the cumulative value (a total of 90%).) SKU Code 1021 1204 1448 2144 2282 2456 2698 3129 3141 3310 3312 3712 3943 4351 4682 4683 4991 5231 5940 5995 6466 6912 7006 7060 Unit Value $ 125.00 $ 10.00 $ 12.00 $ 20.00 $ 17.00 $ 500.00 $ 25.00 $ 5.00 $ 2.00 S 1.00 $ 0.75 S 8.00 $ 1.50 $ 0.75 $ 3.00 $ 1.00 $1,500.00 $ 20.00 $ 110.00 S 50.00 $ 0.90 S 8.00 $ 45.00 S 3.00 Demand (units) 100 1,750 2,000 200 330 675 85 2,500 1,000 1,500 625 200 125 410 700 1,200 320 600 120 1,500 200 1,200 1,700 300 SMU > LZU 5995 6466 6912 7006 7060 7087 7670 8101 8447 8989 9034 s $ $ S $ $ $ S 50.00 0.90 8.00 45.00 3.00 4.00 2.00 10.00 7.00 6.00 4.00 1,500 200 1,200 1,700 300 800 75 6,000 S $ 800 500 1,500 a) How many items are assigned as "A" items? b) How many items are assigned as "B" items? c) How many items are assigned as "C" items? d) What assignment was made to the following items: 24567 59952 89897 9034? M9.8 Submit Excel file with solution for M9.7 using Inventory Calculations Template worksheet as demonstrated and formatted in videos. No credit for M9.7 unless this Excel file is submitted