Largest value of the purchase cost and selling price

Assignment Help Business Economics
Reference no: EM133082678

Using the below Bicycle inventory data set, compute the following: 

a. Find the smallest and largest value of the purchase cost and selling price.

b. Total number of unique suppliers.

c. Total quantity per supplier.

d. Total number of different products available for Children.

e. Find the supplier/s whose selling price is greater than $200 and the product category is hybrid. 

ID

Product Category

Product Name

Purchase Cost

Selling Price

Supplier 

Quantity on Hand

1

Leisure

Blue Moon

$75.29

$105.41

Simpson's Bike Supply

4

2

Mtn.

Bluff Breaker

$375.00

$495.00

The Bike Path

3

3

Leisure

Breeze

$89.95

$130.95

The Bike Path

4

4

Leisure

Breeze LE

$109.95

$149.95

The Bike Path

5

5

Road

Classic 109

$207.49

$290.49

Bicyclist's Choice

7

6

Children

Coolest 100

$69.99

$97.98

Bicyclist's Choice

6

7

Mtn.

Eagle 1

$410.01

$574.01

Bike-One

1

8

Mtn.

Eagle 2

$401.11

$561.54

Bike-One

2

9

Mtn.

Eagle 3

$350.52

$490.73

Bike-One

5

10

Hybrid

Eagle 7

$150.89

$211.46

Bike-One

9

11

Road

Elegant 210

$281.52

$394.13

Bicyclist's Choice

7

12

Children

Green Rider

$95.47

$133.66

Simpson's Bike Supply

4

13

Mtn.

Jetty Breaker

$455.95

$649.95

The Bike Path

1

14

Children

Red Rider

$15.00

$25.50

Simpson's Bike Supply

8

15

Hybrid

Runblend 2000

$180.95

$255.99

Run-Up Bikes

0

16

Leisure

Runcool 3000

$85.95

$135.99

Run-Up Bikes

5

17

Children

Runkidder 100

$50.95

$75.99

Run-Up Bikes

10

18

Road

Runroad 1000

$250.95

$350.99

Run-Up Bikes

8

19

Road

Runroad 4000

$390.95

$495.99

Run-Up Bikes

5

20

Road

Runroad 5000

$450.95

$599.99

Run-Up Bikes

5

21

Leisure

Starlight

$100.47

$140.66

Simpson's Bike Supply

1

22

Leisure

Supreme 350

$50.00

$70.00

Bicyclist's Choice

3

23

Hybrid

Tea for Two

$429.02

$609.00

Simpson's Bike Supply

3

24

Road

Twist & Shout

$490.50

$635.70

Simpson's Bike Supply

0

Reference no: EM133082678

Questions Cloud

Different techniques in making fashion accessories : 1. What is the importance of knowing the different techniques in making fashion accessories?
How can opportunity costs affect a business decision : Explain why the consideration of opportunity costs may be very relevant to a firm. How can opportunity costs affect a business decision?
Prepare journal entries according to standard practice : Prepare journal entries according to standard practice to record the purchase of assets, depreciation expense, and accumulated depreciation
Redesign of the original kindle : Amazon's Kindle (its electronic book, magazine, and newspaper reader) has been far more successful than its SONY competitor. However, the original Kindle had so
Largest value of the purchase cost and selling price : a. Find the smallest and largest value of the purchase cost and selling price.
Explain the purpose of a general ledger in accounting : Explain the purpose of a general ledger in accounting and give at least two examples of transactions that may be recorded in this journal
Explain economic differences between bargain and promise : (a) Fully explain the economic differences between a bargain and a promise. In your explanation explain how the economic steps that occur effect the indifferenc
Contract between the two landlords : Question 1: Fully explain why an "improvement" contract between the two landlords will fail?
Country population size and living standards : Consider a Malthusian economy. For each of the following scenarios, use the diagrams to illustrate what happens to a country's population size and living standa

Reviews

Write a Review

Business Economics Questions & Answers

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd