SEARCH
| > Features |
August 2008: Error found on Budget worksheet.
Cell M1375 should be the sum of L1275:L1374, not M1275:M1374.
Corrected version now available (Aug 08).
August 2008: Error found on Budget worksheet.
Cell M1157 should be the sum of L1064:L1156, not M1064:M1156.
Corrected version now available (Aug 08).
Resources
The new budget structure is exactly matched by the explanations and advice contained in the AFC's updated publication "The Satchel - Film Budgeting and Production Management", see The Satchel page for an order form.
Under Filming in Australia, Sample Production Paperwork (or just click here), the AFC website also provides useful forms and templates that can assist with budget preparation and ongoing production management.
General
Throughout the budget there are more prompts reminding you to use Worksheets help you with your costings.
Throughout there are more prompts to remind you to seek quotes for services and supplies.
The Information page contains instructions on how to link summary, budget and worksheets if lines are deleted.
The front page is simplified.
Above the Line
Story and Script - A line has been added or storyboards/pre-visualisation.
Producers, Directors and Above-the-Line Cast - formulae have been added to break out fees and expenses into pre, sheet and post.
Below the Line
OH&S - line added for consultant, and also for workplace inspections.
Overtime and loadings - line added for estimate of travel time.
Fringes - Default is now 100% PAYG, but line & formula remain if companies are hired; Fringes - Cast & extras superannuation is now 10%, formulae adjusted.
Cast - separate line for holiday pay for TV cast.
Cast - Singers, dancers and dummy musicians moved to support cast from Extras.
Old "Film and Lab" section is re-named "Image Capture".
* It is in two sections, one for film and one for tape/HD capture.
* There are prompts to note finished length, total footage and aspect ratio.
* References to magnetic stock have been removed.
* "Video Inserts" has been moved to new Section J, see below.
* DVD Extras, "Making of" and Electronic Press Kit production have been moved to Publicity.
* Prompt added for "days" in rushes couriers.
* "Rushes theatre/equipment - location" added.
* Line added for internet transmission of rushes.
Old "Video Post" has been moved from Section J into Post-production
Section J is now an expanded section for archival footage, stock footage and video insert footage.
Lighting - the generator now appears on the line beneath the lighting truck.
Grips - line added for diving requirements.
Line added for tutoring van, if required.
Location rushes equipment has been moved to Section I.
Craft services - line added, if required.
Cleaning - removed from Section P, as it appears in Section L.
Postproduction
The break at Postproduction is more clearly identified.
Picture and sound sections have been more clearly identified.
Budget line numbers accord with the explanations and descriptions in The Satchel.
Edge numbering has been deleted.
Fringes - superannuation noted at 9%, and a reminder to check that the sound package includes fringes if an all-up quote is supplied.
Transport - line added for internet transmission of assemblies and cuts.
Section U - renamed "Image Postproduction".
* Subsections alphabetized to allow easier navigation in conjunction with The Satchel.
* Archival section has been moved to Section J.
* Section U.n. covers video postproduction and tape finish, moved from Section J.
* Reference to "slash dupes" has been removed.
* Reference to "Effects" has been removed from Titles.
* Section U.2 re-named "Digital Visual Effects", with the strong recommendation that a detailed breakdown and quote are provided.
Publicity - Line added for poster key art, an FFC requirement.
Delivery - Lines added for freight and for ISAN registration (FFC requirement).
Worksheets
Development - funding sources now appear first, at the top of the page.
Cast - new worksheets, 3a and 3b, to assist with cast deal structure calculations.
Crew overtime, loadings and travel time:
* typo in previous worksheet corrected, now refers to correct columns.
* Worksheet now links to crew rates n budget, saves tedious re-typing.
* More positions have been moved over to "Shooting Crew" to reflect positions where overtime is payable.
* Automatic calculation in cell O180 removed so overtime is not automatically calculated on 4 hours for every shoot day - the calculations at the bottom of the chart have been amended.
* Provision for estimated travel time for away-from-home location shoots.
Allowances
* Now shows individual positions cf. travel worksheet
* Removed "description" columns - rarely used
* "Rate/weeks" headings consistent across the page
Workers Compensation: Casts/Stunts-below line:
Line 401: A note has been added "Stunt equipment (Line 460) is included. If not required, amend totals"
The calculation of the Stunts personnel area includes Line 460-Stunt Equipment. If the stunt equipment allowance is high, this will affect the workers compensation figure. If required, amend the total figure in I401 to exclude stunt equipment.
ASDA Production Levy
I1219: Is incorrectly calculating from the previous line
Formula currently reads I1218*G1218
Change to I1219*G1219
Worksheet 2: Crew
Loadings Budget - lines 179 -1812
The loadings budget area is calculating the full day rate and not the loading only.
A note has been added to remind that if Saturday is already included as a shoot day, 11 hours should be deducted from the Saturday loading calculation.
The following crew members have been added at lines 166-169:
Extras Casting Coordinator
Stunt Coordinator
Caterer 1
Caterer 2
Worksheet 6: Travel & Accommodation
The following crew members have been added at lines 164-167:
Extras Casting Coordinator
Stunt Coordinator
Caterer 1
Caterer 2
Worksheet 10: Locations
This worksheet has been totally revised. If you are cutting and pasting changes into your own budget version, we suggest you replace your worksheet with this more detailed version.
Modified Thu 14 July 2003
Completion Guarantor
This category is multiplying twice by a percentage calculation
Change the following formulas:
Cell I61205: =E1205*G1205
Note: multiplies the percentage for the completion guarantor (in E1205) by the sum of above and below totals (in G1205). Ensure you remove the % sign in Cell I1205.
Contingency
This category is multiplying twice by a percentage calculation
Change the following formulas:
Cell I1207: =E1207*G1207
Note: multiplies the percentage for the contingency (in E1207) by the below the line total (in G1207). Ensure you remove the % sign in Cell I1207.
SPAA Production Levy
This category is multiplying twice by a percentage calculation
Change the following formulas:
Cell E1218: Ensure this is a percentage by clicking on this cell, go to FORMAT - CELLS - NUMBER - click on "Percentage" in list of choices in box - OK. To check, enter the number 0 (Zero) in this cell and it should show "0%"
Cell I1218: =E1218*G1218
Note: Ensure you remove the % sign in Cell I1218.
ASDA Production Levy
This category is multiplying twice by a percentage calculation
Change the following formulas:
Cell E1219: Ensure this is a percentage by clicking on this cell, go to FORMAT - CELLS - NUMBER - click on "Percentage" in list of choices in box - OK. To check, enter the number 0 (Zero) in this cell and it should show "0%"
Cell I1219: =E1219*G1219
Note: Ensure you remove the % sign in Cell I1219.
