Microsoft Excel Activity #1: Inventory Classification X Question 1 0110 Submit The data for 10 inventoried items ol a small company has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop inventory classification based on annual inventory dollar usage and answer the following questions. (Note: This example illustrates that judgment must be applied when using the ABC classification method, and the 80/20 rule should only be used as a general guideline.) A-Z x Qoen spreadsheet Questions 1. Calculate the percent of total dollar usage for each item. Round your answers to two decimal places. Ttem Number A245 N376 Percent of Total Dollar Usage 9 Classification by Annual Dollar Usage A A R116 06 B CO24 B R221 B P112 06 B T049 C B615 0 L227 C 1519 45 C Rack Next 1 Type here to search O O O'C Cloudy AO 40 ENG 8:48 PM 2021-11-14 Microsoft Excel Activity #1: Inventory Classification X Question 1 0110 L227 Submit 98 % T519 2. What is the total projected annual dallar usage? Round your answer to the nearest cent. $ items under ABC classification. Do not round intermediate calculations. Round your 3. Complete the following table by entering the number of items in each category and their percentage of total number answers to the nearest whole number, Count Percentage B D c 4. Complete the following table by entering the percent of total annual dollar usage of items in each category. Round your answers to two decimal places Percent of Total Annual Dollar Usage A B % % Check My Work Reset Problem Back Next Type here to search O'C Cloudy AO 40 ENG 8:49 PM 2021-11-14 Excel Templale - Saved Search (All +Q) File home Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments v Arial 10 B V V abe Merge Currency $ V [ifi ... D1 E F G H K M N P A B D D Inventory Classification Based on Annual Dollar Usage 1 Formulas - Item Cost $180 $0.80 $ $0.28 $4.25 S10.25 $2.00 $7.25 $0.30 $ $1.95 $26.75 Annual Usage (Units) Annual Usage (S) 20.000 30,500 27 DOD 1.450 520 1,300 192 3,500 480 12 % of Total Annual Classification by Annual Dollar Usage Dollar Usage A A B B B B C C 3 Item Number 4 A346 5 N378 6 R116 7 C024 8 R221 9 P112 10 T049 11 B615 12 L227 13 1519 14 15 16 17 18 19 20 21 Annual Usage (5) #N/A #NA #N/A #NA #N/A #N/A #N/A #N/A WNA #N/A F % of Total Annual Dollar Usage #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #NA F F Total HNA Count Percentage Atems Bitems Citerns Count #N/A #NA #N/A Percentage #A #N/A #N/A #N/A % of Total Annual Dollar Usage 22 23 24 25 A items items Citems Total Annual Dollar Usage SNA #N/A #NA + = Sheet1 + Calculation Mode: Automatic Workbook Statistics Type here to search O . Give Feedback to Microsoft - 100% + 8:49 PM 0 0C Cloudy AO ENG 40 2021-11-14