A X B fx C D E F G H ID Bicycle Inventory Product Category Q1 Product color Product Name Expiry date Purchase Cost Selling Price Supplier Simpson's Bike Quantity on Hand Inventory code 1 Leisure Red Blue Moon 3/3/2021 $75.29 $105.41 Supply 4 Leisure Red 2 Mtn. Green Bluff Breaker 2/24/2020 $375.00 $495.00 The Bike Path 3 Mtn. Green 3 Leisure Blue Breeze 3/6/2022 $89.95 $130.95 The Bike Path 4 Leisure Blue 4 Leisure Red Breeze LE 1/25/2023 $109.95 $149.95 The Bike Path 5 Leisure Red 5 Road Yellow Classic 109 6/6/2021 $207.49 $290.49 Bicyclist's Choice 6 Children Purple Coolest 100 7/5/2023 $69.99 $97.98 Bicyclist's Choice 7 Mtn Red Eagle 1 4/10/2023 $410.01 $574.01 Bike-One 8 Mtn. Green Eagle 2 10/11/2022 $401.11 $561.54 Bike-One 9 Mtn. Blue Eagle 3 11/12/2022 $350.52 $490.73 Bike-One 10 Hybrid Red Eagle 7 12/1/2021 $150.89 $211.46 Bike-One 11 Road Yellow Elegant 210 9/8/2020 $281.52 $394.13 Bicyclist's Choice 12 Children Purple Green Rider 1/2/2023 $95.47 $133.66 13 Mtn. Red Jetty Breaker 1/2/2025 $455.95 $649.95 14 Children Green Red Rider 3/7/2022 $15.00 $25.50 15 Hybrid Blue Runblend 2000 3/8/2021 $180.95 $255.99 16 Leisure Red Runcool 3000 7/5/2023 $85.95 $135.99 17 Children Yellow Runkidder 100 4/10/2023 $50.95 $75.99 Run-Up Bikes Run-Up Bikes Run-Up Bikes 18 Road Purple Runroad 1000 10/11/2022 $250.95 $350.99 Run-Up Bikes 19 Road Red Runroad 4000 11/12/2022 $390.95 $495.99 Run-Up Bikes 20 Road Green Runroad 5000 12/1/2021 $450.95 $599.99 21 Leisure Blue Starlight 9/8/2020 $100.47 22 Leisure Red Supreme 350 2/24/2020 $50.00 $140 66 $70.00 23 Hybrid Yellow Tea for Two 3/6/2022 $429.02 $609 00 24 Road Purple Twist & Shout 1/25/2023 $490.50 $635.70 Simpson's Bike Supply The Bike Path Simpson's Bike Supply Run-Up Bikes Simpson's Bike Supply Bicyclist's Choice Simpson's Bike Supply Simpson's Bike Supply 7 Road Yellow 6 Children Purple 1 Mtn. Red 2 Mtn. Green 5 Mtn. Blue 9 Hybrid Red 7 Road Yellow 4 Children Purple 1 Mtn. Red 8 Children Green 0 Hybrid Blue 5 Leisure Red 10 Children Yellow 8 Road Purple 5 Road Red 5 Road Green 1 Leisure Blue 3 Leisure Red 3 Hybrid Yellow 0 Road Purple