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?