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

Selection of remuneration policy, Selection of Remuneration Policy Th...

Selection of Remuneration Policy The alternative of a suitable remuneration policy through a company will depend, with another thing, on: 1. Cost: the extent to that the p

Compute the payback period - example, Compute the Payback Period - Example ...

Compute the Payback Period - Example Cedes restriction has the following details of two (2) of the future production plans. Just one of these machines will be purchased and su

Assumptions underlying percentage of sales method, Assumptions Underlying P...

Assumptions Underlying Percentage of Sales Method The fundamental supposition underlying the use of % of sales method is such, there is no inflation in the economy such is the

Homework, the two problems below (P1 and P2). Five marks each. Part marks w...

the two problems below (P1 and P2). Five marks each. Part marks will be allocated, but if you have the incorrect answer then you cannot expect to get more than half marks. Project

Shareholders and management, Shareholders and Management There is near...

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

Identified two mutually exclusive projects, The director of capital budgeti...

The director of capital budgeting for a firm has identified two mutually exclusive projects, A and B, with the following expected net cash flows: Expected Net Cash Flows Year

Example of stock market index, Example of Stock Market Index The follo...

Example of Stock Market Index The following six companies constitute the index of democratic republic of Kusadikika.             Company  A  B

Underwriting - stock market, Underwriting - Stock Market 1. This is th...

Underwriting - Stock Market 1. This is the supposition of risk relating unsubscribed shares 2. When new shares are issued, they might be beneath -written or unsubscribed. A

Assignment, Following details are related to three companies which are iden...

Following details are related to three companies which are identical except in terms of ''''r''''. Company ABC Ltd. MNC Ltd. XYZ Ltd. Cost of capital 10% 10% 10% Earn per Share Rs

Valuation of business, Valuation of Business A business may be valued ...

Valuation of Business A business may be valued for different type of reasons that as for merger, acquisition, or takeover or liquidation or outright sale.  During purchasing a

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