ID Product Category Product Name Purchase Cost Selling Price
20 Road Runroad 5000 450.95 599.99
18 Road Runroad 1000 250.95 350.99
11 Road Elegant 210 281.52 394.13
19 Road Runroad 4000 390.95 495.99
9 Mtn. Eagle 3 350.52 490.73
5 Road Classic 109 207.49 290.49
10 Hybrid Eagle 7 150.89 211.46
23 Hybrid Tea for Two 429.02 609
2 Mtn. Bluff Breaker 375 495
8 Mtn. Eagle 2 401.11 561.54
4 Leisure Breeze LE 109.95 149.95
17 Children Runkidder 100 50.95 75.99
13 Mtn. Jetty Breaker 455.95 649.95
16 Leisure Runcool 3000 85.95 135.99
6 Children Coolest 100 69.99 97.98
7 Mtn. Eagle 1 410.01 574.01
12 Children Green Rider 95.47 133.66
3 Leisure Breeze 89.95 130.95
1 Leisure Blue Moon 75.29 105.41
22 Leisure Supreme 350 50 70
14 Children Red Rider 15 25.5
21 Leisure Starlight 100.47 140.66
15 Hybrid Runblend 2000 180.95 255.99
24 Road Twist & Shout 490.5 635.7
Inventory Value Units
Road 9640.17 32
Mtn. 4545.78 12
Hybrid 2645.07 12
Leisure 1890.93 22
Children 1431.32 28
Supplier Quantity on Hand Inventory Value Percentage
Run-Up Bikes 5 $ 2,254.75 11.19%
Run-Up Bikes 8 $ 2,007.60 9.96%
Bicyclist's Choice 7 $ 1,970.64 9.78%
Run-Up Bikes 5 $ 1,954.75 9.70%
Bike-One 5 $ 1,752.60 8.70%
Bicyclist's Choice 7 $ 1,452.43 7.21%
Bike-One 9 $ 1,358.01 6.74%
Simpson's Bike Supply 3 $ 1,287.06 6.39%
The Bike Path 3 $ 1,125.00 5.58%
Bike-One 2 $ 802.22 3.98%
The Bike Path 5 $ 549.75 2.73%
Run-Up Bikes 10 $ 509.50 2.53%
The Bike Path 1 $ 455.95 2.26%
Run-Up Bikes 5 $ 429.75 2.13%
Bicyclist's Choice 6 $ 419.94 2.08%
Bike-One 1 $ 410.01 2.03%
Simpson's Bike Supply 4 $ 381.88 1.89%
The Bike Path 4 $ 359.80 1.79%
Simpson's Bike Supply 4 $ 301.16 1.49%
Bicyclist's Choice 3 $ 150.00 0.74%
Simpson's Bike Supply 8 $ 120.00 0.60%
Simpson's Bike Supply 1 $ 100.47 0.50%
Run-Up Bikes 0 $ - 0.00%
Simpson's Bike Supply 0 $ - 0.00%
$ 20,153.27 100.00%
Cumulative This chart isn't available in your version of Excel.
11.19%
Editing this shape or saving this workbook into a different file format will permanently break the chart.
21.15%
30.93%
40.63%
49.32%
56.53%
63.27%
69.66%
75.24%
79.22%
81.95%
84.47%
86.74%
88.87%
90.95%
92.99%
94.88%
96.67%
98.16%
98.91%
99.50%
100.00%
100.00%
100.00%
y break the chart.
Product Name Sum of Inventory Value
Blue Moon $ 301.16
Bluff Breaker $ 1,125.00
Breeze $ 359.80
Breeze LE $ 549.75
Classic 109 $ 1,452.43
Coolest 100 $ 419.94
Eagle 1 $ 410.01
Eagle 2 $ 802.22
Eagle 3 $ 1,752.60
Eagle 7 $ 1,358.01
Elegant 210 $ 1,970.64
Green Rider $ 381.88
Jetty Breaker $ 455.95
Red Rider $ 120.00
Runblend 2000 $ -
Runcool 3000 $ 429.75
Runkidder 100 $ 509.50
Runroad 1000 $ 2,007.60
Runroad 4000 $ 1,954.75
Runroad 5000 $ 2,254.75
Starlight $ 100.47
Supreme 350 $ 150.00
Tea for Two $ 1,287.06
Twist & Shout $ -
Total Result $ 20,153.27