Excel File Edit View Insert Format Tools Data Window Help 0? [ Tue 8:23 PM Q DE CHO2-BicycleInventorytxt (5) week2 Q ~ Search Sheet 9 Home Insert Page Layout Formulas Data Review View + Share ~ do Cut _ AutoSum Calibri (Body) 12 A- A = Wrap Text General AP Copy Fill Paste Merge & Center $ ~ % 2 00 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter C30 X V K M N 0 P R S T U w Product Purchase Cummulati ID Category Product Name+ Cost Selling Price Supplier Quantity on Hand Inventory Value Percentage ve % Road Runroad 5000 450.95 599.99 Run-Up Bikes 5 2,254.75 11.2% 11.2% Road Runroad 1000 250.95 350.99 Run-Up Bikes 2,007.60 10.0% 21.1% Road Elegant 210 281.52 394.13 icyclist's Choice 1,970.64 9.8% 30.9% Bicycle Inventory Prado Chart Road Runroad 4000 390.95 495.99 Run-Up Bikes 1,954.75 9.7% 40.6% 100% Mtn. Eagle 3 350.52 490.73 Bike-One 1,752.60 8.7% 49.3% $2,500.00 Road Classic 109 107.49 290.45 Bicyclist's Choice 1,452.43 7.2% 56.5% Hybrid Eagle 7 150.89 211.46 Bike-One 1,358.01 6.7% 63.3% $2,000.00 80% Hybrid Tea for Two 129.02 609 Simpson's Bike Supply 1,287.06 6.4% 69.7% 10 Mtn. Bluff Breaker The Bike Path 5.6% 75.2% $1,500.00 60% 375 495 1,125.00 11 Mtn. Eagle 2 401.11 561.54 Bike-One BO2.22 4.0% 79.2% $ Dollars 12 Leisure Breeze LE 109.95 149.95 The Bike Path 549.75 2.7% 81.9% $1,000.00 40% 13 17 Children Runkidder 100 50.95 75.99 Run-Up Bikes 09.50 2.5% 84.5% Mtn. letty Breaker 455.95 649.95 The Bike Path 455.95 2.3% 86.7% $500.00 20% Leisure Runcool 3000 85.95 135.99 Run-Up Bikes 129.75 2.1% 88.9% Children Coolest 100 69.99 97.98 Bicyclist's Choice 419.94 2.1% 91.0% $0.00 17 Mtn. Eagle 1 110.01 574.01 Bike-One 410.01 2.0% 93.0% 18 12 Children Green Rider 95.47 133.66 Simpson's Bike Supply 381.88 1.9% 94.9% Breeze Eagle 2 Eagle 3 Eagle 7 Starlight Eagle 1 Red Rider 19 Breeze 89.95 130.9 1.8% 96.7% Breeze LE Blue Moon Leisure The Bike Path 159.80 Classic 109 Green Rider Tea for Two Elegant 210 Coolest 100 Supreme 350 Runcool 3000 Bluff Breaker Twist & Shout Runroad 5000 Jetty Breaker Runroad 1000 Runroad 4000 Runkidder 100 Leisure Blue Moon 75.29 105.41 impson's Bike Supply 301.16 1.5%% 98.2% Runblend 2000 22 Leisure Supreme 350 70 Bicyclist's Choice 150.00 0.7% 98.9% 14 Children Red Rider 15 25.5 impson's Bike Supply 120.00 0.6% 99.5% 21 Leisure Starlight 100.47 140.66 Simpson's Bike Supply 100.47 0.5% 100.0% 15 Hybrid Runblend 200 180.95 255.99 Run-Up Bikes 0.0% 100.0% Products 24 Road Twist & Shout 490.5 635.7 Simpson's Bike Supply 0.0% 100.09 20,153.27 D Pivot Table by type CHO2-BicycleInventorytxt (5) + Ready - + 85% 2 ... XExcel File 0? [ Tue 8:23 PM Q DE Edit View Insert Format Tools Data Window Help CHO2-Bicycleinventorytxt (5) week2 Q ~ Search Sheet 9 + Share ~ Home Insert Page Layout Formulas Data Review View PivotTable Analyze Design _ AutoSum do Cut Calibri (Body) 12 A- A = Wrap Text General Fill Copy BIUTY A. Merge & Center $ % 2 00 .0 Conditional Format Cell Insert Delete Format Sort & Paste Clear Filter Format Formatting as Table Styles A3 X V fx Row Labels D E F G H I K L M N 0 P Q R T A C 1 N Row Labels Sum of Inventory Value 4 Children $1,431.32 5 Hybrid $2,645.07 6 Leisure $1,890.93 7 Mtn. $4,545.78 8 Road $9,640.17 9 Grand Total $20,153.27 10 11 12 13 14 15 20 29 30 35 Pivot Table by type CH02-BicycleInventorytxt (5) + - + 100% Ready 2 ... X