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

Price - sales of goods, Price - Sales of Goods Like where section 10 p...

Price - Sales of Goods Like where section 10 provides such the price for goods may like fixed by like: (i) Contract; and one is (ii) The manner provided within the contr

Management of inventories, Management of Inventories Manufacturing fir...

Management of Inventories Manufacturing firms contains three major kinds of inventories as: Work-in-progress Finished goods inventory Raw materials The firm

Partnerships - types of business organisations, Partnerships - Types of B...

Partnerships - Types of Business Organisations Defination "The relationship, that exists with persons carrying on a business in common by a view of profit." Formati

Stock market index, Stock Market Index Definition of Stock Market Ind...

Stock Market Index Definition of Stock Market Index An index is a numerical figure that measures relative change in variables between two type of durations. Examples

Sole proprietorship, Sole Proprietorship Definition - A sole proprietor...

Sole Proprietorship Definition - A sole proprietorship or sole tradership is the oldest and simplest form of business. It is that type of business organization where one person

PERDIEM CLAIM, how to make a perdiem claim format to maintain the records o...

how to make a perdiem claim format to maintain the records of staff

Corporate finance, I need report on Corporate Finance. Do you provide help ...

I need report on Corporate Finance. Do you provide help in topic Corporate Finance? I need expert's assistance to solve my college assignment. Please suggest if it works for me.

Explain mechanics of security trading in stock exchange, Explain Mechanics ...

Explain Mechanics of security trading in Stock Exchange Introduction: An investor should have some knowledge of how the securities markets operate. Marketing of old or new se

What is expected return, 1. Using the variance-covariance matrix (∑) and th...

1. Using the variance-covariance matrix (∑) and the expected return vector (er) given in the appendix, calculate the set of weights that correspond to the portfolio that maximizes

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