50.1K

Verified Solution

Link Copied!

Category A - 80 % total revenue : The items with the largest annual revenue that together equal 80% of the total annual revenue. B - 15 % : Those items that equal 80% to 95% of the total annual revenue. C - 5%: The remaining items that comprise approximately 5% of total revenue from 95%+ to 100%

AutoSave Off H. A14 - Inventory Ila Search Fabiola Alfaro Vargas FA File Home Insert Page Layout Formulas Data Review View Help Share Comments Default Ruler Formula Bar Q 100 Zoom 100% Zoom to Selection Split Hide New Arrange Freeze Window AIL Panes Unhide PL View Side by Side IDI Synchronous Scrolling Reset Window Position Gridlines Headings Keep Exit New Options Macros Normal Page Break Page Custom Preview Layout Views Workbook Views Switch Windows Sheet View Show Zoom Window Macros F51 X B D E F H | J K L M N o P o R s T Note: In the questions below use the Count function when possible 5 Use the "count" function to count the number of parts 0 25 26 27 28 29 30 31 32 33 34 35 36 37 6 0 According to Pareto's law, how many of these should we expect Pareto Use the round function with o decimal pla A parts 20% Use the round and count functions B parts 30% Use the round and count functions C parts 50% Use the "sum" function Total 100% 11 0 0 0 For 7-8 use the countif function on the Running Total Criteria 38 7 How many parts fall into category A based on the Running % Tota

Answer & Explanation Solved by verified expert

See Answer