Analyzing Big Data Case Study

profilep_patel359
BurnsideStorage.xlsx

Sheet1

Inventory Number Description Type Cost Price On Hand Quantity Sales per year
B003 8' Picnic Table Table $211.00 $350.00 44 157
B007 8' x 4' Steel Shed Shed $425.00 $700.75 50 215
B008 6' x 4' Steel Shed Shed $310.00 $520.99 50 241
B009 Bending Trellis Trellis $50.00 $57.00 20 100
B010 12' Wishing Fount Fount $131.00 $195.99 25 147
B011 10' x 16' Aluminum Outbuilding Outbuilding $810.00 $1,075.99 10 67
B012 Burnside’s Better Trellis Trellis $770.00 $850.00 25 70
B014 8' x 6' Steel Shed Shed $150.00 $200.00 50 500
B016 8' x 10' Picnic Table Table $270.99 $399.99 50 299
B017 10' x 14' Steel Shed Shed $650.00 $1,200.00 20 250
B018 8' x 10' Aluminum Outbuilding Outbuilding $540.00 $805.00 50 600
B019 4' Aerogenerator Aerogenerator $31.00 $46.00 300 201
B022 8' x 10' Pine Shed Shed $1,140.00 $1,800.00 72 100
B023 6' x 20’ Covered Span Span $1,250.00 $1,401.00 42 75
B025 12' Square Pine Gazebo Gazebo $2,500.00 $3,000.00 71 144
B026 12' x 20' Steel Shed Shed $1,393.56 $1,950.99 32 65
B031 12' Pine Rotunda Rotunda $2,970.00 $3,500.00 15 39
B033 8' x 10' Steel Outbuilding Outbuilding $840.47 $1,050.99 80 210
B034 6' x 6' Pine Garden Shack Shack $880.00 $951.00 120 330