Excel

Documentation

New Perspectives Excel 2013

Tutorial 12: SAM Project 1a

Highland Community Preschool

COLLABORATING ON A SHARED WORKBOOK

Author:

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 NIGHT Abraham Miller: Abraham Miller: Can we change the name to just Casino Night?
	EVENT GOAL
	$4,000.00
		Goal	Actual Abraham Miller: Abraham Miller: Confirmed the cell references for all formulas.
	EVENT INCOME	$4,500	$7,255
	EXPENSES	$500	$696
	TOTAL RAISED	$4,000	$6,559
	OVER/UNDER	$0 Abraham Miller: Abraham Miller: I found the dash confusing, so updated.	$2,559 Abraham Miller: Abraham Miller: Updated formula to correct cell references.

WE EXCEEDED OUR EXPECTATIONS!

Goal Actual

Goal Actual 4000 6559

Income

	CASINO NIGHT - INCOME
	TICKET SALES	$2,600
	SILENT AUCTION	$3,885
	RAFFLE	$220
	POKER CHIPS	$550
	TOTAL RAISED	$7,255 Abraham Miller: Abraham Miller: Updated formula to proper range.
	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	200 Abraham Miller: Abraham Miller: Overbid themselves, but agreed to pay the higher bid amount.	Abraham Miller: Abraham Miller: Updated formula to proper range.							15	6	5		16	100 Abraham Miller: Abraham Miller: Sasha and Beata each purchased 50 chips.	50
	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,885		19	35	20		3	100	50
	15	4	200						6	15	10				$550
	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 - EXPENSES
	EXPENSES
	NAME	EXPENSE	TOTAL
	Harringson Abraham Miller: Abraham Miller: Typo in Sarah's last name.	Copies	$35
	Watson	Decorations	$61
	Gonzales	Food	$150
	Mehta	Hall rental fee	$250
	Harrington	Auctioneer	$200 Abraham Miller: Abraham Miller: Auctioneer's website has price quoted at $200 for an event.
			$696

Casino Night Expenses

Copies Decorations Food Hall rental fee Auctioneer 35 61 150 250 200

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)