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

Explain the term - underwriting, Explain the term - Underwriting Und...

Explain the term - Underwriting Underwriting is an agreement whereby underwriter promises to subscribe to a specified number of debentures or shares or a specified amount of

NPV, purchase a machine worth Shs.1,500,000 which will have a residue value...

purchase a machine worth Shs.1,500,000 which will have a residue value Shs.200,000 after 5 years useful life. The saving in cost resulting from the use of this machine are: Sh

Captive insurance, discuss the meaning and advantage of captive insurance

discuss the meaning and advantage of captive insurance

Describe the transaction structure-financing, Description of the deal, anal...

Description of the deal, analysis of abnormal returns & premium (a)  Describe the transaction structure, mode of payment, and financing.  (b) Give your comment/assessment of

Overdraft finance, Overdraft Finance This finance is perfect to need a...

Overdraft Finance This finance is perfect to need as bridging finance in sense such should be required to solve the company's short term liquidity problems in specific those o

Calculate the incremental net present value, The following NPV's have been ...

The following NPV's have been calculated to determine if a compressor installation should be accelerated from Year 3 to Year 7. The compressor cost is $1,500,000.   a. C

Existence of quantity discounts, Existence of Quantity Discounts Recur...

Existence of Quantity Discounts Recurrently, the firm is capable to take benefits of quantity discounts.  Since these discounts affect the price per unit, they influence also

Real Estate Finance - Real options valuation, I need to understand a practi...

I need to understand a practice question for exam, but I only have a partial solution. I need a more detailed solution, so can understand how to arrive at the answer. The problem

Define two instances of liquidity ratio and efficiency ratio, Define two in...

Define two instances of Efficiency Ratio, Liquidity Ratio, Leverage Ratio? 1. Define two instances each of 'Efficiency Ratio', 'Liquidity Ratio', 'Leverage Ratio' and 'Prof

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