Copyright © 2008, The McGraw-Hill Companies, Inc.
245
CHAPTER 5
EXERCISES- a. Anycorp has regional sales offi ces in Des Moines, Omaha, Denver, Boise, and Spokane. In the third quarter, the
sales for these offi ces were $1,845,275, $2,087,416, $1,878,080, $3,567,029, and $2,502,135, respectively.
The company set a $2,000,000 sales target for each of its offi ces for this quarter.
Create a spreadsheet to record the sales for each of the fi ve offi ces for the third quarter. Your spreadsheet should
also show the sales target for each offi ce, and how far that offi ce’s sales fell above (or below) their target. Your
spreadsheet should also total the sales, target, and amount above (or below) target for the company as a whole.
b. Suppose that in the fourth quarter, Anycorp raised its sales targets to $3,000,00 for Boise and $2,500,000 for
Spokane, leaving the other offi ces’ targets at $2,000,000. Sales in the fourth quarter came in at $2,534,026 for Des
Moines, $1,546,032 in Omaha, $1,994,032 in Denver, $3,075,075 for Boise, and $2,403,716 for Spokane. Modify
the spreadsheet created in part a to fi nd each offi ce’s performance against their sales target, as well as the overall
company’s sales and performance against the sales target. - What rate of return do I need to earn to turn a $250 monthly investment into $450,000 in 20 years? In 30 years?
40 years? - Shandora owes $7,325.19 on a personal loan. The interest rate is 11¾%, and she is paying $125 a month. How long
will it take for her to pay off the debt entirely? - For a fundraiser, the students at School No. 19 are collecting labels from Tastyland Farms soup products. Each
condensed soup label is worth 1.5 Tastyland points, each premium soup label is worth 2.5 points, each label from
canned pastas or stew is worth 3 points, and each label from a club-pak of microwave soup bowls is worth 5 points.
In October, the students collected 1,289 condensed soup labels, 835 premium labels, 1,572 pasta or stew labels, and
72 club-pak microwave soup labels.
a. Set up a spreadsheet to calculate the total number of points they earned in October.
b. Use the spreadsheet to fi nd the total number of points earned in November, when they collected 1,572, 1,099,
3,059, and 42 labels of each type (listed by type in the same order as before.)- Robbie has $19,772.59 in his 401(k) account now. He plans to deposit $125 a month for the next 3 years, then
increase his deposits to $225 a month for the next 7 years, and then stop making deposits altogether. If his account
earns 9%, how much will he have 35 years from now?