ID Product Number Product Category Product Name Purchase Cost Selling Price Supplier Number Quantity on Hand Reorder Level
1
1
Road
Classic 109
$207.49
$290.49
1
7
2
2
2
Road
Elegant 210
$281.52
$394.13
1
7
2
3
3
Road
$250.95
$350.99
3
8
5
4
4
Mtn.
Eagle 3
$350.52
$490.73
2
5
2
15
15
Children
Red Rider
$15.00
$25.50
4
8
5
16
16
Children
Coolest 100
$69.99
$97.98
1
6
5
17
17
Children
Green Rider
$95.47
$133.66
4
4
5
18
18
Road
$390.95
$495.99
3
5
5
19
19
Road
$450.95
$599.99
3
5
5
20
20
Road
Twist & Shout
$490.50
$635.70
4
0
2
21
21
Leisure
Breeze
$89.95
$130.95
5
4
2
22
22
Leisure
Breeze LE
$109.95
$149.95
5
5
4
23
23
Mtn.
Bluff Breaker
$375.00
$495.00
5
3
3
24
24
Mtn.
Jetty Breaker
$455.95
$649.95
5
1
2
5
5
Mtn.
Eagle 2
$401.11
$561.54
2
2
2
6
6
Mtn.
Eagle 1
$410.01
$574.01
2
1
2
8
8
Hybrid
Eagle 7
$150.89
$211.46
2
9
2
9
9
Hybrid
Tea for Two
$429.02
$609.00
4
3
2
10
10
Leisure
Runcool 3000
$85.95
$135.99
3
5
5
11
11
Leisure
Starlight
$100.47
$140.66
4
1
2
12
12
Leisure
Supreme 350
$50.00
$70.00
1
3
5
13
13
Leisure
Blue Moon
$75.29
$105.41
4
4
2
14
14
Children
Runkidder 100
$50.95
$75.99
3
10
5
ID No
Supplier Number
Company Name
Street Address
City
State
ZIP Code
1 1 Bicyclist’s Choice 1459 Washington Avenue Sioux Falls SD 57106
2
2
Bike-One
2000 Oceanside Lane
San Diego
CA
3
3
Run-Up Bikes
1155 Fifth Avenue
Long Branch
NJ
Simpson’s Bike
5
5
The Bike Path
1999 Stephen Hands Path
East Hampton
NY