Find out total amount of sales, Finance Basics

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)

Posted Date: 2/23/2013 2:30:30 AM | Location : United States







Related Discussions:- Find out total amount of sales, Assignment Help, Ask Question on Find out total amount of sales, Get Answer, Expert's Help, Find out total amount of sales Discussions

Write discussion on Find out total amount of sales
Your posts are moderated
Related Questions
what is the financial position of the company in term of leverage, liquidity and fluidity? Were the position better in 2013 compared to 2012 ? Possible ratios : - Levera

Shareholders and Management There is near separation of ownership and management of the firm. Landlord employs professionals as managers who such have technical skills. Manage

Mr. and Mrs. smith are considering the purchase of a house. They can afford to make  a mortgage payment of $750 per month. If the current mortgage interest rate is 9% with monthly

Stock Split and Reverse Split This is whereas a block of shares is broken down into smaller units or shares hence the number of ordinary shares rises and their respective par

Explain about the functions of financial systems. Financial systems perform the necessary economic function of channelling funds through units who have stored surplus funds to

effect of gdp in the domestic market

Valuation of Share A number of parties are interested however in the value of shares and securities and that will include: Company shareholders, vendors and directors of

on may 1, counts, inc has a balance of $1000 in office supplie. during may the company buys $500 more of the office supplies. on may 31 the company counts the supplies and finds 20

Define the term - Finding a Broker Selection of a broker depends largely on the kind of services rendered by a specific broker as well as upon the type of transaction that a

Taxation Position and Profitability & Liquidity Profitability and liquidity A company's capacity to pay dividend will be determined primarily with its capability to creat