Sheet 1: Instructions - LOCKED

	
	

		
SCREEN AUSTRALIA BUDGET: GAMES AND INTERACTIVE MEDIA - worked example
	
	

		
Template version 1.2
	
	

		


	
	

		
Instructions
	
	

		


	
	

		
Sheet Overview:
	
	

		
This document contains the following in addition to this Instructions sheet:
	
	

		
Project Summary: A locked cover sheet that derives its information from the Budget Worksheet
	
	

		
Budget Summary: A locked sheet that also derives its information from the Budget Worksheet
	
	

		
Budget Worksheet: The editable sheet where all of your staff allocations and fixed costs go (including your accrued development costs and SA fees).
	
	

		
Resource Rates: The editable sheet where you can input the costs for each of the staff Roles on your project.
	
	

		
DataLists: A locked and hidden DataLists sheet that contains some definitions (Durations and Milestones).
	
	

		


	
	

		
Instructions:
	
	

		
White areas on the worksheets are editable, everything else is locked.
	
	

		
LibreOffice users should contact Screen Australia for assistance in unprotecting the sheet to edit the white fields.
	
	

		
On the Resource Rates sheet: 
	
	

		
 - Set the resource charge-out rates and superannuation rates for each role  to reflect your company's costs and salaries.
	
	

		
On the Budget Worksheet:
	
	

		
 - Fill in the general project details
	
	

		
 - Choose whether your project is going to be budgeted weekly or monthly (this affects the resource costs derived from the Resources sheet).
	
	

		
 - Use the dropdown boxes to fill in your projected milestones at the correct weeks/months.
	
	

		
 - Allocate all of your staff to the project and set the correct role for them (if you don't set a role the person will not have a cost associated with them).
	
	

		
 - Fill in the proportion of each week/month that each staff member is working on the project (more hidden lines are available if needed).
	
	

		
 - Set the Contingency percentage that will be applied to the project’s development team costs (this should be at least 10%).
	
	

		
 - Fill in the fixed development costs and the point in the development schedule that they are due.
	
	

		
 - Take care not to mess up your fixed development costs if you switch between weekly or monthly budgeting.
	
	

		
 - The fixed development costs section includes space for Accrued Development Costs (such as costs of developing the game design, the EPOC, etc).
	
	

		
 - If you enter Accrued Development Costs, ensure the staff allocation and fixed costs only include data for rest of the production, not for already elapsed time.
	
	

		
 - The budget automatically calculates Screen Australia’s 2% admin fee.
	
	

		
 - The budget template includes $5,000 for solicitor’s fees to secure a Chain of Title which will be required for successfully funded applications.
	
	

		


	
	

		


	
	

		
Version change log
	
	

		
v1.1: Fixed bug in cell protection experienced by Mac users
	
	

		
v1.2: Removed/consolidated many of the fixed cost categories, removed Motion Capture category entirely and added a mo-cap row in with Outsourcing.
	
	

		
v1.2: Added more instructions for how to use Accrued Costs To Date, and not to double-count staffing and fixed costs with accrued costs.
	
	

		
v1.2: Adjusted calculation of Average Cost Per Person Month to take into account Accrued Costs to Date.
	
	

		
v1.2: Hid 5 columns of months/weeks (columns AB to AF) to shrink the sheet for improved printing. You can unhide them if you need to.
	



Sheet 2: Project Summary - LOCKED

	
	
	
	
	

		


		


		


	
	

		


		


		
Preparation Date: 01 Jun 2013
		


	
	

		


		


		


		


	
	

		


		
Screen Australia - Games and Interactive Media Budget
		


	
	

		


		


		


		


	
	

		


		
Project Summary (Automatically Generated)
		


	
	

		


		


		


	
	

		


		
Developer:
		
Persistent Thunder
		


	
	

		


		
Project Name:
		
CHOCOLATE RAIN
		


	
	

		


		
Contact:
		
Jessie Applicant
		


	
	

		


		
Email Address:
		
jessie@persistentthunder.com
		


	
	

		


		


		


		


	
	

		


		
Preparation Date:
		
6/1/2013
		


	
	

		


		
Est. Start Date:
		
9/1/2013
		


	
	

		


		
Est. Release Date:
		
11/1/2014
		


	
	

		


		
Project Duration:
		
16 months
		


	
	

		


		
Budgeting Period:
		
Month
		


	
	

		


		


		


		


	
	

		


		
Overall Project Budget:
		
 $630,543 
		


	
	

		


		


		


		


	
	

		


		
Screen Australia Request:
		
 $250,000 
		


	
	

		


		
Screen Australia Contribution:
		
40%
		


	
	

		


		
Contribution Acceptable?
		
Yes
		


	
	

		


		
Grant or Investment? 
		
Investment
		


	
	

		


		


		


		


	
	

		


		
Contingency:
		
10%
		


	
	

		


		
Solicitor's Letter/Chain of Title Costs:
		
 $5,000 
		


	
	

		


		
Screen Australia Legal & Admin Fees:
		
 $5,000 
		


	
	

		


		


		


		


	
	

		


		
Total Person Months:
		
107
		


	
	

		


		
Average Cost Per Person Month:
		
 $5,921 
		


	
	

		


		


		


		


	
	

		


		


		
Subtotals
		


	
	

		


		
Staff:
		
 $551,221 
		


	
	

		


		
Contingency:
		
 $55,122 
		


	
	

		


		
Development Costs To Date:
		
 $-   
		


	
	

		


		
Development Overheads:
		
 $14,200 
		


	
	

		


		
Outsourcing:
		
 $-   
		


	
	

		


		
Audio:
		
 $-   
		


	
	

		


		
Testing and Certification:
		
 $-   
		


	
	

		


		
Business Expenses:
		
 $5,000 
		


	
	

		


		
Data Hosting:
		
 $-   
		


	
	

		


		
Licensing:
		
 $-   
		


	
	

		


		
Travel:
		
 $-   
		


	
	

		


		
PR and Marketing:
		
 $-   
		


	
	

		


		
Manufacturing:
		
 $-   
		


	
	

		


		
Screen Australia Legal & Admin Fees:
		
 $5,000 
		


	
	

		


		
Total Project Budget:
		
 $630,543 
		


	
	

		


		


		


		


	



Sheet 3: Budget Summary - LOCKED

	
	
	
	
	
	
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Budget Summary
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		
Month 1
		
Month 2
		
Month 3
		
Month 4
		
Month 5
		
Month 6
		
Month 7
		
Month 8
		
Month 9
		
Month 10
		
Month 11
		
Month 12
		
Month 13
		
Month 14
		
Month 15
		
Month 16
		
Month 17
		
Month 18
		
Month 19
		
Month 20
		
Month 21
		
Month 22
		
Month 23
		
Month 24
		
Month 25
		
Month 26
		


		


	
	

		


		
Staff:
		


		
 $551,221 
		
 $26,115 
		
 $26,115 
		
 $26,115 
		
 $39,058 
		
 $39,058 
		
 $39,058 
		
 $39,058 
		
 $42,392 
		
 $42,392 
		
 $46,479 
		
 $46,479 
		
 $46,479 
		
 $32,700 
		
 $23,844 
		
 $17,940 
		
 $17,940 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $551,221 
		


	
	

		


		
Contingency:
		


		
 $55,122 
		
 $2,611 
		
 $2,611 
		
 $2,611 
		
 $3,906 
		
 $3,906 
		
 $3,906 
		
 $3,906 
		
 $4,239 
		
 $4,239 
		
 $4,648 
		
 $4,648 
		
 $4,648 
		
 $3,270 
		
 $2,384 
		
 $1,794 
		
 $1,794 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $55,122 
		


	
	

		


		
Development Costs To Date:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
Development Overheads:
		


		
 $14,200 
		
 $2,000 
		
 $-   
		
 $3,050 
		
 $-   
		
 $-   
		
 $3,050 
		
 $-   
		
 $-   
		
 $3,050 
		
 $-   
		
 $-   
		
 $3,050 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $14,200 
		


	
	

		


		
Outsourcing:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
Audio:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
Testing and Certification:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
Business Expenses:
		


		
 $5,000 
		
 $5,000 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $5,000 
		


	
	

		


		
Data Hosting:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
Licensing:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
Travel:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
PR and Marketing:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
Manufacturing:
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		
Screen Australia Legal & Admin Fees:
		


		
 $5,000 
		
 $5,000 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $5,000 
		


	
	

		


		
Total Project Budget:
		


		
 $630,543 
		
 $40,726 
		
 $28,726 
		
 $31,776 
		
 $42,964 
		
 $42,964 
		
 $46,014 
		
 $42,964 
		
 $46,631 
		
 $49,681 
		
 $51,127 
		
 $51,127 
		
 $54,177 
		
 $35,970 
		
 $26,228 
		
 $19,734 
		
 $19,734 
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $630,543 
		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
`