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 financial statement effects, Attached is the file for your bond...

Attached is the file for your bond problem. Your group must use the following for the bond problem. In addition, using the general ledger software as described in the project i

Calculate effective annual interest rate, 1 st bank offers you a car loa...

1 st bank offers you a car loan at an annual interest rate of 10% compounded monthly. What effective annual interest rate is the bank charging you?  Solution - Calculate

Example of theoretical value, Example of Theoretical Value As a result...

Example of Theoretical Value As a result of the purchase of an asset, the income stream will rise by of £1,000 per annum for 25 years.  By assuming a discount rate of 20 perce

Developer’s budget calculation, A prospective developer is considering purc...

A prospective developer is considering purchasing a site for the construction of a ‘Business Village’ at a price of £750 000. It will provide a let-able office floor space of 17 50

Evaluate the companys financing strategy, For any company that is quoted on...

For any company that is quoted on the London Stock Market, you are required to write a report to existing shareholders on any TWO of the following issues. Each answer carries equal

Compute Interest Assignment, Based on the example in Lesson 2, compute your...

Based on the example in Lesson 2, compute your quarterly interest for three years if you deposit $500 at 8 percent, compounded quarterly. Remember to divide the 8 percent by 4 to g

Factors of capital structure, Factors of Capital Structure 1. Availab...

Factors of Capital Structure 1. Availability of securities - This influences the company's employ of debt finance that means such if a company has enough securities, so then

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

Estate Planning, Paper on Estate Planning (3–5 pages) Evaluate the tools c...

Paper on Estate Planning (3–5 pages) Evaluate the tools commonly used in estate planning, including trusts, life insurance, and annuities. Compare the tools as to how they would 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