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
Find the costs of financing for two schedules of monthly payments on a 25-year mortgage. The cash value of the house today is $500,000. You are paying monthly at a fixed rate of 6%

Differences between Debt and Preference Share Capital Differences between Debt and Preference Share Capital are given below:   DEBT

What is the Process of Investing in Securities ? There are several process of investing in securities:- (1) Finding a Broker (2) Selection of Brokers (3) Opening an Account w

what is bank draft?How it can be prepared?

Homework Chapter 4 A mortgage loan in the amount of $100,000 is made at 12% interest for 20 years. Payments are to be monthly in each part of this problem. a. What will monthly

1.  Suppose you would like to buy a house and you decided you can pay 3500 per month for 30 years.  Your bank has approved you for a 30-year fixed rate mortgage loan at a quoted AP

flotation cost of 15% for bond, bonds 8%,$1,000 par value, 16 year maturity

What are the main functions of the financial systems? The main functions of financial systems in short are as follows: a. Give the mechanisms by that funds can be transferre

Investment Bank A lending entity is engaged in all the phases of privacy offerings the including managing, underwriting, trading, and the distributing new security issues.

What does reserve requirements and the discount rate? What the Fed Does: Reserve needs and the Discount Rate The federal funds market Financial market which allows banks