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

Finance, the real risk-free rate of interest is 4%. inflation is expected t...

the real risk-free rate of interest is 4%. inflation is expected to be 2% this year and 4% during the next 2 years. assume that the maturity risk premium is zero. what is the yield

Operations research, A paper mill produces two grades of paper viz., X and ...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Cost of redeemable debentures and preference shares, Cost of Redeemable Deb...

Cost of Redeemable Debentures and Preference Shares Redeemable fixed return securities have an exact maturity period.  The cost of those securities is called redemption yield

Share price, A firm just announced that it will cut its dividend from 4.9 d...

A firm just announced that it will cut its dividend from 4.9 dollars per share to 2.1 dollars per share at the end of this year. The dividend was expected to grow 2.7% every year b

Asset management, Which of the following is not considered to be an investm...

Which of the following is not considered to be an investment objective

Financial leverage on a cost of equity, Please describe the effect of finan...

Please describe the effect of financial leverage on a cost of equity and firm's equity beta.

Required barrels of water per day, In the present case, we need to take a d...

In the present case, we need to take a decision about implementing one of the available two options, based on various factors. The available two options are either to complete a se

Advances, advances from foreigners

advances from foreigners

Financial cycle, what is the applicability of a financial cycle to poultry...

what is the applicability of a financial cycle to poultry?

Gloria the Investor, Gloria the Investor Gloria is a seasoned sales manage...

Gloria the Investor Gloria is a seasoned sales manager with a very large international company. Although she has a great deal of experience with sales, she has little experience w

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