Non Profit Budget Templates - Excel
W
Description
Non Profit Budget Templates document sample
Document Sample


PROPOSED PROGRAM/PROJECT/EVENT BUDGET
WIT Event Budget Template - Venue Sponsored Evening Event
TKT $ CALC
Non- Corp Catering
Member Memb Tables Conc. FOC's $/Head
Ticket Price $25 $40 $0 $15 $0 $0
Sales #s 30 10
# Attendees 30 10 0 0 0 Total #
Ticket Revenue $750 $400 $0 $0 $0 Total Tkt $
VARIABLES Assumptions
People/Table 10 Venue is free of charge
Where possible venue sponsor provides catering. If not then catering costs need to be
Operational Hours 10 managed to meet budget outcomes
Merchant Fee Rate 4.00% Alcohol will be purchased by Operations through preferred supplier if required
Sponsorship $ recommended only. Sponsors should compliment venue sponsor
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 1 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
All prices mus be GST inclusive
Enter your data into WHITE fields only. Do NOT enter data in the YELLOW shaded fields as these contain formulas.
Do NOT insert new rows in the Detailed Budget section as this will defeat the purpose of using the financial report format!
Budget Actuals
Ordinary Income/Expense
Income
Sponsorship Cash Rec'd
Business Corporate
Government Funding
Total Sponsor Cash Rec'd $0
Ticket Revenue $1,150
Total Income $1,150
Expense
Accommodation & Meals
Advertising
AV & Multimedia
Awards & Prizes
Catering (incl F&B) $0
Entertainment or Speakers
Fees Audit
Fees Bank
Fees Merchant Cards $46
Insurance
Magazine
Marketing - eNewsletter
Operations Resources
Administration Mgr
Event Manager
Program Director
Web Manager
Total Operations Resources $0
Parking
Office/Event Supplies
Postage/Courier/Freight
Printing/Photocopying
Sponsorship Given
Telephone
Volunteer Care
Venue Hire
Event Costs $46
Operations Resources $375
Operational Costs $12
Operational Expenses $387
Total Expenses $433
Event Profit/Lass $718 Target $287.50
Net Ordinary Income Target $720.00
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 2 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
Total $
Catering
$0
40
$1,150
g costs need to be
supplier if required
nue sponsor
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 3 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 4 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
WIT Event Budget Template - Lunch
TKT $ CALC
Non- Catering
Member Memb Corp Tables Conc. FOC's $/Head
Ticket Price $60 $80 $540 $45 $0 $45
Sales #s 60 10 3 2
# Attendees 60 10 30 2 0 Total #
Ticket Revenue $3,600 $800 $1,620 $90 $0 Total Tkt $
VARIABLES Assumptions
People/Table 10 All liaison with Venues will be undertaken by Operations
Operational Hours 15 Above ticket pricing is minimum to be charged
Merchant Fee Rate 4.00%
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 5 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
All prices mus be GST inclusive
Enter your data into WHITE fields only. Do NOT enter data in the YELLOW shaded fields as these contain formulas.
Do NOT insert new rows in the Detailed Budget section as this will defeat the purpose of using the financial
Budget Actuals
Ordinary Income/Expense
Income
Sponsorship Cash Rec'd
Business Corporate
Government Funding
Total Sponsor Cash Rec'd $0
Ticket Revenue $6,110
Total Income $6,110
Expense
Accommodation & Meals
Advertising
AV & Multimedia
Awards & Prizes
Catering (incl F&B) $4,590
Entertainment or Speakers
Fees Audit
Insurance
Office/Event Supplies
Postage/Courier/Freight
Printing/Photocopying
Sponsorship Given
Telephone
Volunteer Care
Venue Hire
Event Costs $4,834
Operations Resources $563
Operational Costs $1,209
Operational Expenses $1,771
Total Expenses $6,606
Event Profit/Lass -$496 Target $1,527.50
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 6 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
Total $
Catering
$4,590
102
$6,110
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 7 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 8 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
WIT Event Budget Template - Workshop
TKT $ CALC
Non- Corp Catering Total $
Member Memb Tables Conc. FOC's $/Head Catering
Ticket Price $25 $40 $0 $15 $0 $8 $304
Sales #s 30 5 3
# Attendees 30 5 0 0 3 Total # 38
Ticket Revenue $750 $200 $0 $0 $0 Total Tkt $ $950
VARIABLES Assumptions
People/Table 10 Venue is free of charge
Where possible venue sponsor provides catering. If not then catering costs need to
Operational Hours 3 be managed to meet budget outcomes
Merchant Fee Rate 4.00% Alcohol will be purchased by Operations through preferred supplier if required
Sponsorship $ recommended only. Sponsors should compliment venue sponsor
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 9 of 10
PROPOSED PROGRAM/PROJECT/EVENT BUDGET
All prices mus be GST inclusive
Enter your data into WHITE fields only. Do NOT enter data in the YELLOW shaded fields as these contain formulas.
Do NOT insert new rows in the Detailed Budget section as this will defeat the purpose of using the financial
Budget Actuals
Ordinary Income/Expense
Income
Sponsorship Cash Rec'd
Business Corporate $250
Government Funding
Total Sponsor Cash Rec'd $250
Ticket Revenue $950
Total Income $1,200
Expense
Accommodation & Meals
Advertising
AV & Multimedia
Awards & Prizes
Catering (incl F&B) $304
Entertainment or Speakers
Fees Merchant Cards $38
Parking
Office/Event Supplies
Postage/Courier/Freight
Printing/Photocopying
Sundry
Travel
Volunteer Care
Venue Hire
Event Costs $342
Operations Resources $113
Operational Costs $86
Operational Expenses $198
Total Expenses $540
Event Profit/Lass $660 Target $237.50
7/17/2010, 10:06 PM, 3bb55278-f056-4f15-981f-c578391f46c4.xls Page 10 of 10
Related docs
Get documents about "