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

  Production technology is given by the production function

Where L represents labor hours, K machine hours and q the amount of output. The market wage and rental rates are, w= $25 and r = $100.

  Action in response to the oil price increase

both the short run and the long run assuming that the government takes no action in response to the oil price increase.

  Write down mareko intertemporal budget constraint

Write down Mareko's intertemporal budget constraint in future value terms. How much pineapple will Mareko consume in each period.

  When two bundles have equal philosophy books

Tony loves philosophy books and candy bars. When comparing two bundles Tony always chooses the bundle with more philosophy books regardless of the number of candy bars. However, when two bundles have equal philosophy books he chooses the one with mor..

  Summarize the criminal procedures

Summarize the criminal procedures that occurred in this case, from arrest through appeal, if applicable.

  Maintenance for certain type of machine

A manufacturing company is planning to set aside $75,000 now and $120,000 one year from now for possible maintenance for a certain type of machine. If the maintenance won't be needed for 4 years, how much will the company have in the account, if it e..

  Monthly cost of producing vintage model cars

The table below shows the monthly cost of producing vintage model cars for collectors for quantities 0, 100, 200, and 500.

  Price elasticity demand for clothing in your country

Briefly explain ANY TWO (2) determinants of the price elasticity demand for clothing in your country?

  What is the meaning of a surplus or deficit

What is the meaning of a surplus or deficit on the a) merchandise trade balance, b) goods and services balance, and c) current account balance?

  Sierra leone gross domestic policy

What relationship is there between Sierra Leone's Gross Domestic Policy and its economy?

  The multiplier effect comes together with crowding effect

The multiplier effect comes together with crowding effect. A recession results in decrease of welfare program. A recession results in decrease of tax revenue. The unemployment and inflation are in inverse relation. The unemployment and inflation rela..

  Explain whether it would be considered pure-quasi public

For each item in this list, please explain whether it would be considered a pure public, quasi-public or pure private good. (TIP: Think about whether the item has shared consumption and/or exclusivity to determine what type of good it is.)

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