Excel
anneN
support_np_e13_t12_p1a_ksnotes.xlsxDocumentation
| New Perspectives Excel 2013 | |
| Tutorial 12: SAM Project 1a | |
| Highland Community Preschool | |
| COLLABORATING ON A SHARED WORKBOOK | |
| Author: | %FirstName% %LastName% |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Overview
| CASINO NIGHTFUNDRAISER | ||||||
|
Kevin Staszowski: Kevin Staszowski: This chart is hard to read and the axis are not labeled. Update before presenting information. |
||||||
| EVENT GOAL | ||||||
| $4,000.00 | ||||||
| Goal | Actual | |||||
| EVENT INCOME | $4,500 | $6,655 | ||||
| EXPENSES | $500 | $596 | ||||
| TOTAL RAISED | $4,000 | $6,059 | ||||
| OVER/UNDER | - | $1,559 | ||||
WE EXCEEDED OUR EXPECTATIONS!
Goal ActualGoal Actual 4000 6059
Income
| CASINO NIGHTFUNDRAIER - INCOME | |||||||||||||||
| TICKET SALES | $2,600 | ||||||||||||||
| SILENT AUCTION | $3,835 | ||||||||||||||
| RAFFLE | $220 | ||||||||||||||
| POKER CHIPS | $525 | ||||||||||||||
| TOTAL RAISED | $6,655 | ||||||||||||||
| TICKET SALES | SILENT AUCTION | RAFFLE TICKETS | POKER CHIPS | ||||||||||||
| PADDLE # | QTY | $TOTAL | ITEM | PADDLE # | $TOTAL | PADDLE # | QTY | $TOTAL | PADDLE # | QTY | $TOTAL | ||||
| 1 | 4 | 200 | Dinner for 4 | 4 | 150 | 15 | 6 | 5 | 16 | 50 | 25 | ||||
| 2 | 6 | 300 | Harbor cruise | 14 | 150 | 4 | 15 | 10 | 21 | 100 | 50 | ||||
| 3 | 2 | 100 | Hand-knit sweater | 2 | 75 | 7 | 15 | 10 | 3 | 100 | 50 | ||||
| 4 | 4 | 200 | Manicure | 9 | 25 | 19 | 35 | 20 | 6 | 100 | 50 | ||||
| 5 | 2 | 100 | Framed Art | 22 | 250 | 22 | 6 | 5 | 9 | 100 | 50 | ||||
| 6 | 1 | 50 | Beaded necklace | 13 | 50 | 3 | 35 | 20 | 8 | 50 | 25 | ||||
| 7 | 2 | 100 | Pearl earrings | 22 | 100 | 14 | 6 | 5 | 21 | 50 | 25 | ||||
| 8 | 2 | 100 | Kayak trip | 5 | 100 | 9 | 35 | 20 | 3 | 100 | 50 | ||||
| 9 | 2 | 100 | Car detail | 8 | 50 | 13 | 15 | 10 | 13 | 50 | 25 | ||||
| 10 | 4 | 200 | Vacation house | 11 | 1000 | 6 | 35 | 20 | 17 | 50 | 25 | ||||
| 11 | 2 | 100 | Classroom 1 Art piece | 6 | 750 | 9 | 6 | 5 | 18 | 50 | 25 | ||||
| 12 | 1 | 50 | Classroom 2 Art piece | 17 | 660 | 2 | 15 | 10 | 4 | 100 | 50 | ||||
| 13 | 2 | 100 | Overnight babysitting | 21 | 475 | 20 | 35 | 20 | 7 | 50 | 25 | ||||
| 14 | 1 | 50 | $3,835 | 19 | 35 | 20 | 3 | 100 | 50 | ||||||
| 15 | 4 | 200 | 6 | 15 | 10 | $525 | |||||||||
| 16 | 1 | 50 | 5 | 6 | 5 | ||||||||||
| 17 | 2 | 100 | 3 | 15 | 10 | ||||||||||
| 18 | 2 | 100 | 18 | 6 | 5 | ||||||||||
| 19 | 2 | 100 | 17 | 15 | 10 | ||||||||||
| 20 | 2 | 100 | $220 | ||||||||||||
| 21 | 2 | 100 | |||||||||||||
| 22 | 2 | 100 | |||||||||||||
| $2,600 | |||||||||||||||
Expenses
| CASINO NIGHT FUNDRASER - EXPENSES | |||||||||||
| EXPENSES Kevin Staszowski: Kevin Staszowski: The tables on the Income and Expense worksheets are not setup in a consistent format. |
|||||||||||
|
Kevin Staszowski: Kevin Staszowski: Include a similar pie chart for the Income worksheet. | NAME | EXPENSES | TOTAL | ||||||||
| Harrington | Copies | $35 | |||||||||
| Watson | Decorations | $61 | |||||||||
| Gonzales | Food | $150 | |||||||||
| Mehta | Hall rental fee | $250 | |||||||||
| Harrington | Auctioneer | $100 Kevin Staszowski: Kevin Staszowski: Note that we were given a discount rate from Auctioneer |
|||||||||
| $596 | |||||||||||
Casino Night Expenses
Copies Decorations Food Hall rental fee Auctioneer 35 61 150 250 100
Notes
| Notes: | ||
| Copies | ||
| Expected | $40 | |
| Actual | $35 | <-- Sarah found better deal with local print shop. |
| in Sarah's office | ||
| Decorations: | ||
| Expected | $75 | |
| Actual | $61 | |
| Reused previous decorations | ||
| Confirm decorating committee | ||
| Food: | ||
| Expected | $75 | |
| Actual | $150 | |
| Revisit food budget next year | ||
| Auctioneer | ||
| Marta Harrington | ||
| 617-555-5234 | ||
| $100 for evening (non-profit rate) | ||
| Needs pitcher of water (without ice) | ||
