Troop 297 - Event Date: 11/25/2011
Time: 11:38 PM
Enter event name & date
Adults cost/person = $
name event cost total paid cash check# check s.a. perm. med. driving comments
$0.00
Scouts
name event cost total paid cash check# check s.a. perm. med. riding with comments
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 0 0 0
a2d2cace-8f8b-4270-9839-ff224b42a8c7.XLS Page 1 of 4
Troop 297 - Event Date: 11/25/2011
Time: 11:38 PM
event cost per person:
event deposit $0.00
lodging/camping fee $0.00
activity fee $0.00
other $0.00
total costs $0.00 if you add more event cost lines, make sure the total calculation sums all the lines
cost/person $0.00 / 0 = $0.00 red field: total # of adults and scouts coming to event
plus consumable fee $0.00 + $1.00 = $1.00 this amount is rounded up to the nearest dollar
event cost over/under:
total cost for event $0.00
minus total amount paid $0.00
event over/under $0.00
food costs:
receipt 1 $0.00
receipt 2 $0.00
receipt 3 $0.00
total cost for food $0.00 if you add more receipt lines, make sure the total calculation sums all the lines
cost/person for food $0.00 / 0 = $0.00
a2d2cace-8f8b-4270-9839-ff224b42a8c7.XLS Page 2 of 4
Event Cost Per Person: Comments
Flat Fee
Event Deposit $100.00 why is deposit here? This is an amount paid?
Lodging/Camping Fee $120.00
Per Person Costs Persons
Per Person Costs
Lift Ticket $320.00 $ 16.00 20 Lift ticket/1 bonus ticket
Equipment Rental $0.00 $ 24.00 0 Equipment Rental Per person
Tubing Fee $0.00 $ 15.00 0 Per 2 hours per Person
Lunch/Dinner $120.00 $ 6.00 20 Deluxe meal is $7.00
$0.00 $ - 0
Add More Rows from here on down as necessary
Travel Costs
Total Cost Mileage 1 way Per Mile Vehicles
Travel Costs $188.16 147 0.32 4
Estimated Costs $848.16 if you add more event cost lines, make sure the total calculation sums all the
red field: total # of adults and scouts
Cost/Person $848.16 / 20 = $42.41 event
Plus Consumable Fee $42.41 + $1.00 = $44.00 this amount is rounded up to the neare
is consumable fee calculated into anyth
Event Cost Over/Under:
Total Cost For Event $848.16 cost/person
Minus Total Amount Paid #REF! cost/person - amount received from attendees
Event Over/Under #REF! difference row 21 - row 22
Food Costs: How is amount of food estimated
Estimated $ 250.00 # of Meals 5 $ 2.50 Cost estimate per meal prepared
Actuals Persons Per Estimated
Patrol 1 $0.00 8 $100.00
Patrol 2 $0.00 8 $100.00
Patrol 3 $0.00 4 $50.00
Total Cost For Food $0.00 if you add more receipt lines, make sure the total calculation sums all the lin
Cost/Person For Food $0.00 / 20 = $0.00
unt paid?
as necessary
l calculation sums all the lines
al # of adults and scouts coming to
rounded up to the nearest dollar
e fee calculated into anything?
calculation sums all the lines