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

Shareholders and creditors, Shareholders and Creditors Shareholders A...

Shareholders and Creditors Shareholders And Creditors or bond or debenture holders Bondholders are lenders or providers of long term debt capital.  Usually they will provi

Net advantage to leasing, 1. Biily Mays , Inc, (BMC) is interested in acqui...

1. Biily Mays , Inc, (BMC) is interested in acquiring a 1 million pre to print and circulate its meages. The press has 8 years useful life at the end of which its expected to be 90

Effective reach and effective frequency-insurance , Before purchasing insur...

Before purchasing insurance we have to go through different factors. Among different important factors there are two most crucial aspects we should consider before buying insurance

Find the costs of financing, Find the costs of financing for two schedules ...

Find the costs of financing for two schedules of monthly payments on a 25-year mortgage. The cash value of the house today is $500,000. You are paying monthly at a fixed rate of 6%

Characteristics of sole proprietorship, Characteristics of Sole Proprietors...

Characteristics of Sole Proprietorship A. It caters for customers' personal attention B. Accounts do not must be audited C. Limited to such finances like: F

Net Income Problem:, A firm has the following accounts: What is the net inc...

A firm has the following accounts: What is the net income for the period? Net patient revenue = $1,500,000 Supply expense = $200,000 Depreciation expense = $100,000 Salaries and b

Example of earnings yield valuation, Example of Earnings Yield Valuation ...

Example of Earnings Yield Valuation Estimated maintainable earnings are £240,000 per annum; rate of return required is 25 percent. Calculate the value of the business. V

The price jump on its initial day of trading, Following the Initial Public ...

Following the Initial Public Offering (IPO), the shares of Rosetta Stone, the language instruction company, jumped almost 44 percent from an initial price of $18 to $25.55 in late-

Role of cma - share prices, Role of CMA - Share Prices Role of CMA in ...

Role of CMA - Share Prices Role of CMA in determination of share prices 1. The CMA does not in any type of way influence share price of quoted companies. 2. The prices o

Functions of the stock exchange, Functions of the Stock Exchange The e...

Functions of the Stock Exchange The essential function of a stock exchange is the raising of funds for investment in long-term assets. Whereas this basic function is very sign

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