Estimating cost

Sheet1

Hannah Burrows
Annual Staff Picnic
Budget	$ 100,000
Risk retainer	5%	$ 5,000
Staff	500
Expected Attendance	350
Date	July 15th, 2023
Items	Quantity	Cost	Store	Total
Bus	9	1500	Charater linkz	$ 13,500
Plates	500	0.47	True Value Rental	$ 235
Cups	500	0.47	True Value Rental	$ 235
Forks	500	0.37	True Value Rental	$ 185
Knives	500	0.37	True Value Rental	$ 185
Spoons	500	0.37	True Value Rental	$ 185
Tables	6	8.53	True Value Rental	$ 51
Chairs	500	1.89	True Value Rental	$ 945
Tent (15*15)	1	187.62	True Value Rental	$ 188
Tent (30*60)	1	1062	True Value Rental	$ 1,062
Water Barrels	2	10.66	True Value Rental	$ 21
Coolers	12	21.86	True Value Rental	$ 262
Garbage Cans	5	8.21	True Value Rental	$ 41
Chaffing Dishes	12	14.12	True Value Rental	$ 169
Sterno fuel	24	1.5	True Value Rental	$ 36
Water Slides	1	250	Air Fun and Games	$ 250
Water Slides	1	250	Air Fun and Games	$ 250
Water Slides	1	250	Air Fun and Games	$ 250
Ice	12	14	Sams	$ 196
Soda	14	29	Sams	$ 290
Alcohol	10	50	C.B.K catering	$ 20,000
Food	400	50	Dj Shannon	$ 550
DJ	1	27	Amazon	$ 54
Prizes	2	21	Amazon	$ 12,600
Balloons	600	24	Amazon	$ 14,688
Leis	612
		3783.44		$ 66,429
Total	4726
Money Left Over				$ 33,571