Final Project MG2051, math homework help

Jul 7th, 2016

Anonymous

Category:

Art Design

Price: $10 USD

Question description

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?

Tutor Answer

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.
SalespersonRegion 1Region 2Region 3Total
Becker