jagomart
digital resources
picture1_Excel Sheet Download 11556 | Theatre Project Award Budget Template 2021 | Sample Application


 191x       Filetype XLS       File size 0.16 MB       Source: www.artscouncil.ie


File: Excel Sheet Download 11556 | Theatre Project Award Budget Template 2021 | Sample Application
not fill in yellow or grey highlighted cells they are filled in automatically  ...

icon picture XLS Filetype Excel XLS | Posted on 05 Jul 2022 | 3 years ago
Partial file snippet.
Sheet 1: BUDGET DETAIL


Theatre Project Budget Template: 2021 Page 1
Page 1 - notes















Applicant name










ARN










Name of project






















INSTRUCTIONS










You must provide written evidence of ALL financial and in-kind support listed in the below budget.





- Please fill in white cells only. Cells need to be filled only where relevant to your proposal.
- DO NOT fill in yellow or grey highlighted cells; they are filled in automatically.
- DO NOT insert new rows or columns, as this will prevent the worksheet from calculating correctly.
- Feel free to use the 'Notes/Comments' section on the right, or to explain budgets in more detail in your supporting material if you need to.
- If you make a mistake in a number cell, be sure to enter '0' rather than 'Delete', otherwise a sum may be deleted accidentally.
- NOTE: only cash expenditure should be listed under costs; all in-kind expenditure should be listed separately in the next tab, and the total given at the bottom of the template (e.g. if you are getting rehearsal space for free, do not include the cost under technical costs in the template). - All items of income MUST be backed up by evidence within your supporting material (e.g. if you are planning on raising money through fundraising, you must provide evidence of a fundraising plan and/or a successful previous fundraising campaign. If you are budgeting local-authority funding, you must provide evidence of that funding, or evidence that the local authority in question is aware of your and/or your organisation's work).


















NUMBERS - these are so we can monitor employment numbers, and also to enable the spreadsheet to calculate costs below
Notes/Comments (where relevant)



Number of cast/performers -





Number of stage-management personnel -





Number of freelance creative personnel Director, designers, etc. NOTE: this does not include personnel employed full-time if you are applying on behalf of, or in partnership with, an organisation. -





No of weeks pre production/development -





Number of weeks' rehearsal -





Number of performance weeks -





Number of performances -

















INCOME (do not include in-kind amounts)





The following section is for 'Presentation' and 'Production' only (i.e. where there is a box-office target)









1. Box-office-income calculator - this is so we can track audience numbers and understand how you have arrived at your audience target





Audience target, where relevant
Fill in the columns to the right to calculate box-office target
Venue capacity (give the average if more than one) Number of performances Target attendance (%) Total audience target






- - 0% -





Box office
Fill in the average ticket yield to calculate gross box-office income
Average ticket yield







€- €-

















Programme/publication sales
Fill in the columns to the right to calculate programme-sales income
Item cost Venue capacity No. of perfs. % purchased






€- - - 0% €-

















Total box-office and programme/publication sales income (NB: we understand that you may not be processing or receiving this) €-

















The following section is for all applications (only fill in cells relevant to your proposal)









2. Non-box-office income - this is income towards your proposal other than box-office income
Notes/Comments (where relevant)


Local-authority/other public funding (if any)
Grant funding that you propose to commit directly to the proposed project







International funding (if any)
Funding from Culture Ireland or other international agencies that you propose to commit directly to the proposed project







Production partners - cash only (if any)
Cash commitment from organisations or entities supporting your application
€-





Sponsorship/fundraising (if any) €-





Guarantees or fees (if any, as agreed per MOU) - enter amount here that has been agreed you will receive in guarantees where relevant €-





Other income (please specify)
€-

















Total non-box-office income €-

















In-kind income





Total value of in-kind income (see next tab) €-

















GROSS INCOME (box office + programme sales + non-box-office + other + value of support in kind) €-
















3. Cost of sales - this is the cost of selling to audiences, whether by rental, box-office split, or a combination of the two
Notes/Comments (where relevant)



Venue rental/box-office split





Venue rental: rental to venue partner(s) (enter entirety of box-office income here if it is all payable to venue/production partner) €-





AND/OR





Box-office split to venue/production partner (enter total cash value of split to venue/production partner - NOT percentage amount) €-





Other costs





Author's royalties (usually calculated as a percentage of gross box office) €-





Credit-card commission €-





Commission on programme/publication sales €-





Other (please specify)
€-





Total cost of sales €-

















NET INCOME (gross income minus cost of sales) Enter this figure in section 3.2 of the application form €-


















Theatre Project Budget Template: 2021 Page 2
Page 2 - notes















Applicant name 0







ARN 0







Name of project 0



















EXPENDITURE (do not include in-kind amounts)
















1. Production fees (for personnel paid on the basis of a fee)





Producer's fee €-





Director's fee €-





Writer's fee/commission €-





Actors'/performers' fees (if not waged; otherwise use row 92 below) Give average weekly fee here: €- €-





Dramaturg's fee €-





Set-designer's fee (if the set and costume designer are the same person, give the total fee here) €-





Costume-designer's fee €-





Lighting-designer's fee €-





Sound-designer's fee €-





Composer's/musical-director's fee €-





Video/stage-visuals-design fee €-





Voice-coach's fee €-





Choreographer’s fee / movement/fight-director's fee €-





Assistant-director's fee €-





Production-manager's fee (if not salaried) €-





VAT (where relevant) €-





Other (please specify)
€-





Total production fees €-
















2. Wages (for personnel paid on the basis of a weekly wage) Per week
Rehearsals
(or development)
Performance
(where relevant)
TOTALS
Notes/Comments (where relevant)



Cast wages (average) €-
€- €- €-





Stage-director's wages €-
€- €- €-





Stage-manager's wages €-
€- €- €-





ASM's wages €-
€- €- €-





Production-manager's wages (if salaried)

€- €- €-





Other (please specify)

€- €- €-





Overtime
€- €- €-





Holiday pay @ 8%
Enter 0 here if holiday pay is not being included
8.00%
€- €- €-





Employer's PRSI contribution @11.08%
Enter 0 here if you are paying fees and not paying an employer's PRSI contribution
11.08%
€- €- €-





Total wages €-
















3. Technical costs
Notes/Comments (where relevant)



Rehearsal-venue cost €-





Set materials and paint €-





Construction/carpentry fees €-





Set-painting fees €-





Stage-crew fees






Hair and make-up €-





Costume purchase/hire €-





Costume-construction/fitting fees €-





Props purchase/hire €-





Stage-management expenses €-





Production transport €-





Lighting hire €-





Sound hire €-





A/V-equipment hire €-





Lighting and sound-technician fees €-





Mobile-phone/communications expenses €-





Weekly wardrobe costs (per week in performance) €- €-





Production running costs (per week in performance; this should include petty cash for props buying, maintenance and repairs) €- €-





Other (please specify)
€-





Total technical costs €-






























Theatre Project Budget Template: 2021 Page 3
Page 3 - notes















Applicant name 0







ARN 0







Name of project 0













4. Promotion and publicity
Notes/Comments (where relevant)



Design promotional artwork €-





Print: flyers, posters, PR materials €-





Layout and print programme €-





Billboards/advertising sites €-





Photography €-





Press advertising €-





Radio/TV advertising €-





Web advertising/maintenance €-





Hospitality €-





PR/consultancy costs €-





Other (please specify)
€-





Total promotion and publicity €-











5. Administration costs
Notes/Comments (where relevant)



Administrator fees/wages €-





Rights/commissioning of play (usually an advance payment to a writer or writer's agent for the licence or rights to a play) €-





Travel costs (for any personnel not normally resident where the proposed activity is taking place) €-





Accommodation costs (for any personnel not normally resident where the proposed activity is taking place) €-





Scripts purchase/copying €-





Auditions/casting expenses €-





Administration costs/expenses €-





Insurance €-





Phone charges €-





Travel (for administration purposes) €-





Digital documentation/video of show €-





Miscellaneous costs/petty cash €-





Audit fees €-





Other (please specify)
€-





Total administration costs €-











6. Travel/accommodation costs (for productions playing more than one venue)
Notes/Comments (where relevant)



Cast/crew accommodation €-





Cast/crew travel €-





Technical-crew accommodation & travel €-





Set/equipment transport €-





Other (please specify)
€-





Total travel/accommodation costs €-

















Contingency (usually calculated as a percentage of the overall budget; enter the percentage here) 0.0% €-

















In-kind expenditure





Total value of in-kind expenditure €-

















TOTAL EXPENDITURE
Enter this figure in section 3.1 of the application form €-

















TOTAL NET INCOME
As at [G61] above €-

















AMOUNT REQUESTED FROM THE ARTS COUNCIL Enter this figure in section 3.3 of the application form €-






Sheet 2: IN-KIND INCOME


Theatre Project Budget Template

















Applicant name 0





ARN 0





Name of project 0















INSTRUCTIONS








- Please give a brief description of any in-kind supports you have secured towards your proposal



- Note that all financial support – including in-kind support – must be evidenced in detail in your supporting materials through the use of MOUs and/or letters of support



- The total value of in-kind income and expenditure will appear automatically within the relevant line in the budget template on the previous tab













Details of in-kind income













Item Details (delete the text below and give details)
VALUE
Please name below the supporting docs where these amounts are evidenced. Evidence must include agreed amounts.

Cost of sales (rental/split) e.g. discount on venue rental
€-



Fees e.g. value of foregone fees to collaborators (this might be an expert offering research or advice at a reduced rate or pro bono. NOTE: professional artists working on projects should not 'waive' fees). €-



Wages e.g. value of foregone wages to performers (this might be in an instance where a professional is working for less than they might usually command. NOTE: professionals working on projects should not 'waive' wages) €-



Technical costs e.g. rehearsal space, equipment hire €-



Promotion & publicity e.g. PR support from venue €-



Administration e.g. bookkeeping, contracts, general admin €-



Other (please specify) e.g. fundraising support, other types of support €-













TOTAL VALUE OF IN-KIND INCOME

€-




The words contained in this file might help you see if this file matches what you are looking for:

...Sheet budget detail theatre project template page notes applicant name arn of instructions you must provide written evidence all financial and inkind support listed in the below please fill white cells only need to be filled where relevant your proposal do not yellow or grey highlighted they are automatically insert new rows columns as this will prevent worksheet from calculating correctly feel free use notescomments section on right explain budgets more supporting material if make a mistake number cell sure enter rather than delete otherwise sum may deleted accidentally note cash expenditure should under costs separately next tab total given at bottom eg getting rehearsal space for include cost technical items income backed up by within planning raising money through fundraising plan andor successful previous campaign budgeting localauthority funding that local authority question is aware organisation s work numbers these so we can monitor employment also enable spreadsheet calculate ...

no reviews yet
Please Login to review.