1. Open the file and save your working file as a .xlsx file in another folder.
2. Create columns for Inventory Value, Percentage, and Cumulative % in H-J.
3. Calculate the Inventory Value in Column H using Purchase Cost x Quantity.
4. Use the SUM formula to calculate the Total Inventory column total.
5. Use the Data-Sort option to sort all columns by Inventory Value in descending order.
6. Calculate the Percentage of Inventory in column I; use an anchor ($) in the formula.
7. Use the SUM formula to calculate the percentage column total.
8. Create a formula to calculate the Cumulative %.

Format Painter Form Undo Clipboard F Font Alignment Number F 12 vi XVfx =+G2*D2 A B C D E F G H I J Product Product Purchase Selling Quantity on Inventory Cumula ID Category Name Cost Price Supplier Hand Value Percentage tive % 20 Road Runroad 5000 450.95 599.99 Run-Up Bikes $ 2,254.75 11.2% 11.2% 18 Road Runroad 1000 250.95 350.99 Run-Up Bikes S 2,007.60 10.0% 21.1% 11 Road Elegant 210 281.52 394.13 Bicyclist's Choice 7 $ 1,970.64 9.8% 30.9% 19 Road Runroad 4000 390.95 495.99 Run-Up Bikes 5 S 1,954.75 9.7% 40.6% 9 Min. Eagle 3 350.52 490.73 Bike-One 5 $ 1,752.60 8.7% 49.3% 5 Road Classic 109 207.49 290.49 Bicyclist's Choice 7 $ 1,452.43 7.2% 56.5% 10 Hybrid Eagle 7 150.89 211.46 Bike-One 9 $ 1,358.01 6.7% 63.3% 23 Hybrid Tea for Two 429.02 609 Simpson's Bike Supply 3 $ 1287.06 6.4% 69.7% 2 Min. Bluff Breaker 375 495 The Bike Path 3 S 1,125.00 5.6% 75.2% 8 Mtn. Eagle 2 401.11 561.54 Bike-One 2 $ 802.22 4.0% 79.2% 4 Leisure Breeze LE 109.95 149.95 The Bike Path 5 $ 549.75 2.7% 81.9% 17 Children Runkidder 100 50.95 75.99 Run-Up Bikes 10 $ 509.50 2.5% 84.5% 13 Mtn. Jetty Breaker 455.95 649.95 The Bike Path 1 $ 455.95 2.3% 86.7% 16 Leisure Runcool 3000 85.95 135.99 Run-Up Bikes 5 $ 429.75 2.1% 88.9% 6 Children Coolest 100 69.99 97.98 Bicyclist's Choice 6 S 419.94 2.1% 91.0% 7 Mtn. Eagle 1 410.01 574.01 Bike-One 1 $ 410.01 2.0% 93.0% 12 Children Green Rider 95.47 133.66 Simpson's Bike Supply 4 $ 381.88 1.9% 94.9% 3 Leisure Breeze 89.95 130.95 The Bike Path 4 5 359.80 1.8% 96.7% 1 Leisure Blue Moon 75.29 105.41 Simpson's Bike Supply 4 $ 301.16 1.5% 98.2% 22 Leisure Supreme 350 50 70 Bicyclist's Choice 3 5 150.00 0.7% 98.9% 14 Children Red Rider 15 25.5 Simpson's Bike Supply 8 S 120.00 0.6% 99.5% 21 Leisure Starlight 100.47 140.66 Simpson's Bike Supply 1 S 100.47 0.5% 100.0% 15 Hybrid Runblend 2000 180.95 255.99 Run-Up Bikes OS 0.0% 100.0% 24 Road Twist & Shout 490.5 635.7 Simpson's Bike Supply OS 0.0% 100.0% $ 20,153.27Runroad 5000 $2.254.75 Runroad 1000 $2,007 979 6454 Elegant 210 Runroad 4000 $1, 752 Eagle 3 Classic 109 $1,452 43 $1.358 Eagle 7 51.287 Tea for Two $1 125 Bluff Breaker $802 Eagle 2 Breeze LE Runkidder 100 Jetty Breaker Bicycle Inventory Pareto Chart Runcool 3000 $549-4309-3155.9429.3419.9410-9581 8359. Coolest 100 Eagle 1 Green Rider Breeze Blue Moon $301. 16 Supreme 350 Red Rider $150.9920.8200.47 5- Starlight Runblend 2000 Twist & Shout 90% 60% 80% 0% 70% 40% 50% 10% 20% 30% 100% Axis TitleRow Labels Sum of Inventory Value Children $1,431.32 Hybrid $2,645.07 Leisure $1,890.93 Mtn. $4,545.78 Road $9,640.17 Grand Total $20,153.27 PT-by Type CHO2-Bicycleinventorytxt +