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

Financial markets, term paper about financial markets in pakistan

term paper about financial markets in pakistan

Bases of share valuation, Bases of Share Valuation Share valuation can...

Bases of Share Valuation Share valuation can be done on the basis of income and asset values. On the basis of income still a share will be entitled to two forms of income. For

Inventory management - supply chain management, Inventory Management - Supp...

Inventory Management - Supply Chain Management Determination of the best ordering policy in a manufacturing organisation In a manufacturing organisation, procurement may ha

Modern methods of capital projects, what are the modern methods of evaluati...

what are the modern methods of evaluating capital projects? how they different from old methods?

Evaluate the riskiness of an investment , Compare the three investments bel...

Compare the three investments below in terms of their riskiness. What is the best way to evaluate the riskiness of an investment given the information you have on them?

What are the significant points of fiscal policy, What are the significant ...

What are the significant points of Fiscal Policy? Significant points of Fiscal Policy: a. Meaning of fiscal policy and why this is an significant tool into managing economic

Important points for shareholders and creditors, Important Points for Share...

Important Points for Shareholders and Creditors 1. In raising capital, the borrowing firm will constantly question the financial securities in form of preference shares

Common Stock Valuation, Bates, inc. pays a dividend of $1.25 and is current...

Bates, inc. pays a dividend of $1.25 and is currently selling for $36.95. If investors require a 12% return on their investment, what growth rate would Bates Inc. have to provide t

Discounted cash flow rate of return of a project, Given the following Prese...

Given the following Present Value Plot for Projects A and B, which are mutually exclusive projects, answer the following questions: (i) What is the DCFROR for Project A? fo

Development of plastic money in middle asia, Development of Plastic Money i...

Development of Plastic Money in Middle Asia Motive behind the Fast Development of This Finance (Plastic Money) In Middle Asia a) High incidences of fraud via dishonest empl

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