**The Boutique - Making Change with the help of a
Spreadsheet
**

**
**In the Math Shop
version of Boutique the student plays the role of a store clerk who
sells clothes. The main task is to handle the exchange of money and
give correct change. In this example, the student is given $5.00 for an
item that costs $4.22. The right change is 78¢.

Assuming you have at least 9 of each coin (quarters, dimes, nickels and pennies) in your register, what are the different ways you could make the necessary change? What’s the

A spreadsheet is a handy tool to help you with this problem.

Open a new Excel worksheet.

Set up a spreadsheet that looks like this.

**
**In order for the spreadsheet to do
the calculations for you, you will need formulas to find the value of
the coins, the total number of coins, and the amount of money that you
still need to give the customer. (This last column is not absolutely
necessary but is very helpful.)

The formula:

"behind" cell F2 is: =B2*.25 + C2*.10 + D2*.05 + E2

“behind” cell G2 is: B2 + C2 + D2 + E2

“behind” cell H2 is: .78 - F2

Use Fill Down to replicate the formulas relative to the rows they are in. Highlight (click inside) the cell or cells you wish to replicate. Drag the lower right hand corner of the cell as far down as you wish (about 30 rows) and release.