In this Bicycles Inventory Data in the above. Create a Pareto Analysis table to identify the smallest subset of products (names) which consumes the major partition of total inventory value. Write the identified subset of product names at the bottom of the Pareto Analysis table. All calculations involved in the worksheet preparation must be completed using appropriate formulae.

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