Find out total amount of sales, Finance Basics

Assignment Help:

Imagine Joy is the sales manager in a computer retail company and has summarized for each sales transaction the following information:

  • Sales person
  • Date of sales
  • Units sold or returned
  • Total price received or paid out for returns

The data appear below. Joy needs you to find out the following with appropriate titles for the items specified above:

a)  The total $ amount of items sold by each salesperson

b)  The # of units returned

c)  The total $ amount of sales in or after 2005

d) The total $ amount of sales made by someone other than Tim.

e) Among transactions involving at least 40 units, the average # of Inspiron in each sale made by Zaret.

Trans #

Name

Date

Product

Units

Dollars

1

Betsy

4/1/2004

Inspiron

45

 $ 137.20

2

Jim

3/10/2004

Vostro

50

 $ 152.01

3

Ashley

2/25/2005

XPS

9

 $   28.72

4

Jim

5/22/2006

Inspiron

55

 $ 167.08

5

Zaret

6/17/2004

Inspiron

43

 $ 130.60

6

Tim

11/27/2005

Adamo

58

 $ 175.99

7

Joe

3/21/2004

Adamo

8

 $   25.80

8

Tim

12/17/2006

 Inspiron

72

 $ 217.84

9

Ashley

7/5/2006

 Adamo

75

 $ 226.64

10

Betsy

8/7/2006

 Inspiron

24

 $   73.50

11

Ashley

11/29/2004

 Latitude

43

 $ 130.84

12

Ashley

11/18/2004

 Inspiron

23

 $   71.03

13

Joe

8/31/2005

 Inspiron

49

 $ 149.59

14

Jim

1/1/2005

 Adamo

18

 $   56.47

15

Zaret

9/20/2006

 Vostro

-8

 $  (21.99)

16

Joe

4/12/2004

 Latitude

45

 $ 137.39

17

Tim

4/30/2006

 Latitude

66

 $ 199.65

18

Tim

8/31/2005

 Inspiron

88

 $ 265.19

19

Betsy

10/27/2004

 Adamo

78

 $ 236.15

20

Zaret

11/27/2005

 Inspiron

57

 $ 173.12

21

Joe

6/2/2006

 XPS

12

 $   38.08

22

Tim

9/24/2004

 Latitude

28

 $   86.51

23

Betsy

2/1/2006

 Adamo

25

 $   77.31

24

Zaret

5/2/2005

 Vostro

29

 $   88.22

25

Ashley

11/7/2004

 XPS

-4

 $   (9.94)


Related Discussions:- Find out total amount of sales

Illustrate in brief about the investment process, Illustrate in brief abou...

Illustrate in brief about the Investment  Process A  typical  investment  decision  undergoes  a  five  step  procedure which, in turn, forms the foundation of investment pr

Discuss capital budgeting techniques, Discuss capital budgeting technique...

Discuss capital budgeting techniques including : the Payback Rule, IRR, NPV, and the Profitability Index. Be sure to discuss the advantages and disadvantages of each one.  Di

Calculate effective annual cost, What is the effective annual cost of skipp...

What is the effective annual cost of skipping the discount and paying at the end of the net period for the following credit terms: 6/10, net 70? please show work"

Comparison between modern and traditional methods, Comparison between Moder...

Comparison between Modern and Traditional Methods Both modern and traditional methods will indicate or show strong weaknesses which like a company cannot use either to choose

Find the no-arbitrage cost of the european call option, Question: Suppo...

Question: Suppose that a security is presently selling for a price of $65, the nominal interest rate is 8%, and the security volatility is 0.15. a) Determine Delta of a Euro

Financial markets-securities and financial intermediaries, Describe the str...

Describe the structure of financial systems with financial markets, securities and financial intermediaries. By a structural point of view a financial system can be considered

Calculate the current stock price, The Bim-Bom Company is expected to pay a...

The Bim-Bom Company is expected to pay a dividend of $3.10 per share at the end of the year, and that dividend is expected to grow at a constant rate of 4.00% per annum.  The compa

Valuation of securities, Valuation of Securities The previous methods ...

Valuation of Securities The previous methods were perfect for valuing the entire business however it is also essential to ascertain the value of part of a business namely shar

Write Your Message!

Captcha
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