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

Cost of debentures, Do you guys provide Cost of Debentures assignment help....

Do you guys provide Cost of Debentures assignment help. I need writing a report on Cost of Debentures and it is about 2000 words. Let me know. I need to buy your solution.

Commercial banks - banking institutions, Commercial Banks - Banking Institu...

Commercial Banks - Banking Institutions These are financial institutions such accept deposits of money from the universal public, safeguard the deposits and create them availa

Concentration banking, Concentration Banking Firms along with regional...

Concentration Banking Firms along with regional sales outlets can designate specific of these as regional collection centre. Customers during these areas are necessitated to r

Development banks and financial institutions, Development Banks and Financi...

Development Banks and Financial Institutions There are some sectors in the economy such may not secure adequate funds from commercial banks for different motives. a) May re

Present value of a lump sum - dcf technique, Present Value of a Lump Sum - ...

Present Value of a Lump Sum - DCF Technique Generally an investor would want to know how much he or she would stop currently to get a provided amount in year 1, 2, ... n.  In

Finance.., the nominal fee interest rate in your account is 7% your semi-an...

the nominal fee interest rate in your account is 7% your semi-annually rate of interest APY will be?

Advantages of development financial institutions, Advantages of Development...

Advantages of Development Financial Institutions Advantages or Functions or can say Case for Development Financial Institutions 1. They grant venture capital 2. They gra

Draw a bar chart, The construction of a highway is broken into 14 activitie...

The construction of a highway is broken into 14 activities as shown in the following table. Draw a bar chart of this construction project. Activity ID Desc

Rights of ordinary shareholders, Rights of Ordinary Shareholders A. Ri...

Rights of Ordinary Shareholders A. Right to vote Choose BOD Purchase/Sales of assets B. Influence decisions as: Right to residual ass

Roa - return on assets, ROA - Return on Assets The Average of the ...

ROA - Return on Assets The Average of the industry ROA was 10.02% for 2004, 6.81% for 2005, and 7.32% for 2006. The chart showed that Lenovo had a little bit higher ROA th

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