| Purchase Tracking Sheet | |||||||||
| # | Date | Description | Colour Number | Item # | QTY | Price per Unit | Price | Tax | Total Cost |
| 1 | Oct. 16 | Latex Primer | 2 | $29.99 | $59.98 | $9.00 | $68.98 | ||
| 2 | Oct. 17 | Latex Ceiling Paint | 1 | $29.99 | $29.99 | $4.50 | $34.49 | ||
| 3 | Oct. 17 | Roller | 1 | $8.99 | $8.99 | $1.35 | $10.34 | ||
| 4 | Oct. 17 | Low Pile Roler Sleeve | 2 | $3.29 | $6.58 | $0.99 | $7.57 | ||
| 5 | Oct. 18 | Cloth Drop Sheet | 1 | $12.99 | $12.99 | $1.95 | $14.94 | ||
| 6 | Oct. 18 | Paint Tray | 1 | $5.99 | $5.99 | $0.90 | $6.89 | ||
| 7 | Oct. 18 | Nylon Brush | 1 | $7.99 | $7.99 | $1.20 | $9.19 | ||
| 8 | $0.00 | $0.00 | $0.00 | ||||||
| 9 | $0.00 | $0.00 | $0.00 | ||||||
| 10 | $0.00 | $0.00 | $0.00 | ||||||
| 11 | $0.00 | $0.00 | $0.00 | ||||||
| 12 | $0.00 | $0.00 | $0.00 | ||||||
| 13 | $0.00 | $0.00 | $0.00 | ||||||
| 14 | $0.00 | $0.00 | $0.00 | ||||||
| 15 | $0.00 | $0.00 | $0.00 | ||||||
| 16 | $0.00 | $0.00 | $0.00 | ||||||
| 17 | $0.00 | $0.00 | $0.00 | ||||||
| 18 | $0.00 | $0.00 | $0.00 | ||||||
| 19 | $0.00 | $0.00 | $0.00 | ||||||
| 20 | $0.00 | $0.00 | $0.00 | ||||||
| 21 | $0.00 | $0.00 | $0.00 | ||||||
| 22 | $0.00 | $0.00 | $0.00 | ||||||
| 23 | $0.00 | $0.00 | $0.00 | ||||||
| 24 | $0.00 | $0.00 | $0.00 | ||||||
| 25 | $0.00 | $0.00 | $0.00 | ||||||
| 26 | $0.00 | $0.00 | $0.00 | ||||||
| 27 | Total Purchases | $152.39 | |||||||
| You must program the spreadsheet and use formulas to calculate the Price, Tax and Total Costs. This will be taught in computer class. | |||||||||