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

Challenges to finance manager., Ask question #Minimum what are the challeng...

Ask question #Minimum what are the challenges that a finance manager may face?

Determine what is the current market price of the bond, 1.  A company is tr...

1.  A company is trying to decide which one of two projects it should accept. Both projects have similar start-up costs. Project 1 will generate annual cash flows of $52,000 a year

Attributes of venture capital, Attributes of venture capital Equi...

Attributes of venture capital Equity participation Venture Capital participates with direct purchase of shares or fixed return securities as debentures and prefere

IS-LM, After read all the available information carefully, prepare a two pa...

After read all the available information carefully, prepare a two page (double-spaced) essay and answer the following questions: Assume that we have the following data: C=100+0.50Y

Bank draft, what is bank draft?How it can be prepared?

what is bank draft?How it can be prepared?

Nash equilibrium, Suppose that two players are playing the following game. ...

Suppose that two players are playing the following game.  Player A can choose either Top or Bottom, and Player B can choose either Left or Right.  The payoffs are given in the foll

Calculate the current price of the common stock, Church Inc. is presently e...

Church Inc. is presently enjoying relatively high growth because of a surge in the demand for its new product. Management expects earnings and dividends to grow at a rate of 25% f

Creditors trade - measuring business performance, Creditors Trade - Measuri...

Creditors Trade - Measuring Business Performance Creditors Trade These are interested in the company's capability to meet their short-term obligations as and whenever the

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