Excel

Documentation

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

						Stephanie Lorenz: Stephanie Lorenz: Background formatting is distracting and makes this worksheet difficult to read.	CASINO NIGHT FUNDRAISER
	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 Actual

Goal Actual 4000 6059

Income

	CASINO NIGHT FUNDRAISER - 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 Stephanie Lorenz: Stephanie Lorenz: Emphasize difference between Poker Chip raffle and standard Raffle Ticket raffle.
	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 FUNDRAISER - EXPENSES Stephanie Lorenz: Stephanie Lorenz: Updated spelling of Fundraiser on all worksheets.
	EXPENSES
	NAME	EXPENSE	TOTAL
	Sarah Harrington	Copies	$35
	Watson	Decorations	$61
	Gonzales	Food	$150
	Mehta	Hall rental fee	$250
	Harrington	Auctioneer	$100
			$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)