Need Mathematics help with sales, gallons and yards

Final Project MG2051

Each student must complete a Final Project.  Students may copy this page and fill-in blanks for submission of their answers. A separate sheet(s) must be attached to show work done where applicable. The Final Project can be in either Word or Excel and will be submitted in the dropbox titled Final Project.  A cover sheet should indicate the student’s name, course number, instructor’s name, and the date submitted. 

Problem 1: In the following sales report, total the rows and the columns, and then check that the grand total is the same both horizontally and vertically.

Salesperson

Region 1

Region 2

Region 3

Total

Becker

$5,692

$7,403

$3,591

Edwards

  7,652

  7,590

  3,021

Graff

  6,545

  6,738

  4,545

Jackson

  6,937

  6,950

  4,913

Total

Problem 2: Anne Domingoes drives a Volvo that gets 32 miles per gallon. How many miles can she travel on 25 gallons of gas?

Problem 3: Sharon Parker bought 20 yards of material to make curtains. She used 4 ½ yards for one bedroom window, 8 and 3/5 yards for another window, and 3 and 7/8 yards for a hall window. How much material did she have left?

Problem 4: While training for a marathon, Kristin Woods jogged 7 ¾ miles per hour for 2 and 2/3 hours. How many miles did Kristin jog?

Problem 5: On a map, one inch equals 240 miles. How many miles are represented by 3/8 inch?

Problem 6: Leslie Tracy purchased her home for $51,500. She sold it last year for $221,200. What percentage profit did she make on the sale?

Problem 7: Northwest chemical Company received an invoice for $12,480, dated March 12, with terms of 2/10, n/30. If the invoice is paid March 22, what was the amount due?

Problem 8: The cost of an office chair is $159 and the markup rate is 24% of the cost.  What is A. the dollar markup and B. the selling price?

Problem 9: Parker and Company pays Selma Stokes on a variable commission scale. In a month when Selma had net sales of $155,000, what was her Gross Pay based on the following scale?

Net Sales

Commission Rate

Up to $40,000

5%

Excess of $40,000 to $75,000

5.5%

Excess of $75,000 to $100,000

6%

More than $100,000

7%

Problem 10: David Siderski bought a $7,500 bank certificate paying 16% compounded semi-annually. How much money did he get upon cashing in his certificate 3 years later?

Problem 11: Use the Business Math Handbook to find the table factor for each of the following:

Future Value

Rate

# of Years

Compounded

Table Value?

$1.00

10%

5

Annually

$1.00

12%

8

Semi-annually

$1.00

6%

10

Quarterly

$1.00

12%

2

Monthly

$1.00

8%

15

Semi-annually

Problem 12: You received a $2,000 rebate that brought the price of your car down to $20,000; the financing was for 48 months, and your total interest was $3,279. Using the table in the Business Math Handbook, what was your APR?