Final Project MG2051, math homework help
Question Description
Final Project MG2051
Each student must complete a Final Project. Students may copy this page and fillin 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 semiannually. 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 
Semiannually 

$1.00 
6% 
10 
Quarterly 

$1.00 
12% 
2 
Monthly 

$1.00 
8% 
15 
Semiannually 
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
All done.
Final Project MG2051
Each student must complete a Final Project. Students may copy this page and fillin 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
$5,692 $7,403 $3,591 $16,686
Edwards
7,652
7,590
3,021 $18,263
Graff
6,545
6,738
4,545 $17,828
Jackson
6,937
6,950
4,913 $18...
Brown University
1271 Tutors
California Institute of Technology
2131 Tutors
Carnegie Mellon University
982 Tutors
Columbia University
1256 Tutors
Dartmouth University
2113 Tutors
Emory University
2279 Tutors
Harvard University
599 Tutors
Massachusetts Institute of Technology
2319 Tutors
New York University
1645 Tutors
Notre Dam University
1911 Tutors
Oklahoma University
2122 Tutors
Pennsylvania State University
932 Tutors
Princeton University
1211 Tutors
Stanford University
983 Tutors
University of California
1282 Tutors
Oxford University
123 Tutors
Yale University
2325 Tutors