You are the assistant to the band director for the Upper Saddle River Marching Band, and you must prepare a report showing the status of the marching band fundraising event for presentation to the board of trustees. The report will summarize all sales of all items and include the total profit-to-date with the amount remaining to reach the profit goal. You will open the partially completed workbook, create formulas, format for presentation to the board, and add charts to graphically depict the sales over time and by product.
| 7/8/2006 |
7/9/2006 |
7/10/2006 |
7/11/2006 |
7/12/2006 |
7/13/2006 |
7/14/2006 |
Number of Items Sold |
Profit |
Percent of Profit |
| 22 |
18 |
17 |
19 |
19 |
18 |
25 |
|
|
|
| 11 |
8 |
13 |
14 |
12 |
8 |
10 |
|
|
|
| 9 |
5 |
11 |
8 |
11 |
7 |
14 |
|
|
|
| 0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
| 12 |
12 |
14 |
15 |
14 |
16 |
12 |
|
|
|
| 15 |
12 |
19 |
15 |
14 |
16 |
12 |
|
|
|
| 1 |
2 |
2 |
2 |
2 |
6 |
2 |
|
|
|
| 2 |
8 |
8 |
8 |
8 |
13 |
4 |
|
|
|
| 2 |
4 |
8 |
8 |
8 |
13 |
4 |
|
|
|
| 4 |
10 |
8 |
8 |
8 |
13 |
4 |
|
|
|