jagomart
digital resources
picture1_Budget Spreadsheet 40939 | Games Production Program Budget Template Sample


 212x       Filetype XLSX       File size 0.06 MB       Source: www.bulletpoint.com.au


File: Budget Spreadsheet 40939 | Games Production Program Budget Template Sample
sheet 1 instructions locked screen australia budget games and interactive media worked example template version 12 instructions sheet overview this document contains the following in addition to this instructions sheet ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
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

































































































































































































































































































































































`






























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

...Sheet instructions locked screen australia budget games and interactive media worked example template version overview this document contains the following in addition to project summary a cover that derives its information from worksheet also editable where all of your staff allocations fixed costs go including accrued development sa fees resource rates you can input for each roles on datalists hidden some definitions durations milestones white areas worksheets are everything else is libreoffice users should contact assistance unprotecting edit fields set chargeout superannuation role reflect company s salaries fill general details choose whether going be budgeted weekly or monthly affects derived resources use dropdown boxes projected at correct weeksmonths allocate them if don t person will not have cost associated with proportion weekmonth member working more lines available needed contingency percentage applied rsquo team least point schedule they due take care mess up switch betw...

no reviews yet
Please Login to review.