| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Copyright © 2017 Bithell Games. Made possible by purchasers of The GameDev Business Handbook (GameDevBizBook.com). For instructions on use, visit GameDevBizBook.com/digital-supplements. | |||||||||||||||||||||||||||||||||||||||||
2 | Yearly | Monthly | Hourly | Totals | January Y1 | February Y1 | March Y1 | April Y1 | May Y1 | June Y1 | July Y1 | August Y1 | September Y1 | October Y1 | November Y1 | December Y1 | January Y2 | February Y2 | March Y2 | April Y2 | May Y2 | June Y2 | July Y2 | August Y2 | September Y2 | Total | ||||||||||||||||
3 | FILL IN ONLY BRIGHT YELLOW CELLS | 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 | ||||||||||||||||||||
4 | Key Milestones | Vertical slice | Alpha | Beta | Gold | Launch | Post-launch | |||||||||||||||||||||||||||||||||||
5 | Line Item | Production Periods | Pre-Production | Production | Alpha/Beta | Post-launch support | ||||||||||||||||||||||||||||||||||||
6 | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | ||||||||||||||||||||
7 | Income | $2,580,897 | $2,000,000 | $207,848 | $167,376 | $205,673 | $2,580,897 | $0 | ||||||||||||||||||||||||||||||||||
8 | ||||||||||||||||||||||||||||||||||||||||||
9 | 10-00 | Operations | ||||||||||||||||||||||||||||||||||||||||
10 | 10-01 | Creative Lead/Designer/ Executive Producer | $86,000 | $7,167 | $44.79 | $150,500 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | (Video Game Creative Director Salary, n.d.) | (Game Designer/Creative Director Salary, n.d.) | (Video Game Director Salary, n.d.) | ||||||||||||
11 | 10-02 | Business Manager/project Manager | $84,000 | $7,000 | $43.75 | $147,000 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | (Gaming Manager Salary, n.d.) | (How Much Does a Video Game Project Manager Make?, n.d.) | (Gaming Manager Salary in United States, n.d.) | ||||||||||||
12 | Hour Total | |||||||||||||||||||||||||||||||||||||||||
13 | Operations Total | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $297,500 | 6,720 | ||||||||||||||||||
14 | Pre-Production Hrs: | 1920.00 | Production Hrs: | 4160 | Post Hrs: | 640.00 | 6720 | |||||||||||||||||||||||||||||||||||
15 | 20-00 | Coder | ||||||||||||||||||||||||||||||||||||||||
16 | 20-01 | Technical Lead / Coder | $110,000 | $9,167 | $57.29 | $192,500 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | (Lead game programmer salary in Houston, TX, n.d.) | (Technical lead salary in the United States, n.d.) | (Lead game programmer salary, n.d.) | ||||||||||||
17 | 20-02 | Coder #1 (Contract) | $81,000 | $6,750 | $42.19 | $101,250 | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | (Video game programmer salary, n.d.) | (How much does a game programmer make? n.d.) | |||||||||||||
18 | 20-03 | Coder #2 (Contract) | $81,000 | $6,750 | $42.19 | $101,250 | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | (Video game programmer salary, n.d.) | (How much does a game programmer make? n.d.) | |||||||||||||
19 | Coder Total | $9,167 | $9,167 | $9,167 | $9,167 | $9,167 | $9,167 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $22,667 | $395,000 | 8,160 | ||||||||||||||||||
20 | ||||||||||||||||||||||||||||||||||||||||||
21 | PreProduction Hrs: | 960 | Production Hrs: | 6240 | Post Hrs: | 960.00 | 8160 | |||||||||||||||||||||||||||||||||||
22 | 30-00 | Art | ||||||||||||||||||||||||||||||||||||||||
23 | 30-01 | Art Lead | $129,000 | $10,750 | $67.19 | $225,750 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | (Video game creative director salary, n.d.) | (Art director salary in the United States, n.d.) | |||||||||||||
24 | 30-02 | Art Contractor 1 Environment | $65,000 | $5,417 | $33.85 | $81,250 | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | (Game environment artist salary, n.d.) | (Environment artist salary, n.d.) | |||||||||||||
25 | 30-03 | Art Contractor 2 Character | $65,000 | $5,417 | $33.85 | $78,542 | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 80 | (Video game character artist salary in the United States, n.d.) | (Video game artist salary in the United States, n.d.) | |||||||||||||
26 | 30-04 | Art Contractor 3 2D | $65,000 | $5,417 | $33.85 | $35,208 | 0 | 0 | 0 | 0 | 0 | 0 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 0 | 0 | (Video game artist salary in the United States, n.d.) | (Game artist salary, n.d.) | |||||||||||||
27 | Hour Total | |||||||||||||||||||||||||||||||||||||||||
28 | Art Total | $10,750 | $10,750 | $10,750 | $10,750 | $10,750 | $10,750 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $24,292 | $21,583 | $18,875 | $420,750 | 9,120 | ||||||||||||||||||
29 | PreProduction Hrs: | 960 | Production Hrs: | 7280 | Post Hrs: | 880.00 | 9,120 | |||||||||||||||||||||||||||||||||||
30 | 40-00 | Animation | ||||||||||||||||||||||||||||||||||||||||
31 | 40-01 | Animation Lead | $81,000 | $6,750 | $42.19 | $135,000 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 80 | 80 | (Lead animator salary, n.d.) | (How much does a lead animator make?, n.d.) | |||||||||||||
32 | Hour Total | |||||||||||||||||||||||||||||||||||||||||
33 | Animation Total | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $3,375 | $3,375 | $135,000 | 3,200 | ||||||||||||||||||
34 | PreProduction Hrs: | 960 | Production Hrs: | 2080 | Post Hrs: | 160.00 | 3,200 | |||||||||||||||||||||||||||||||||||
35 | 50-00 | Contract serv. | ||||||||||||||||||||||||||||||||||||||||
36 | 50-01 | Sound Engineer | $59,000 | $4,917 | $30.73 | $17,208 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $4,917 | $4,917 | $4,917 | $0 | $2,458 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
37 | 50-02 | Music $154/min | $9,240 | Revenue Share | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $7,700 | $0 | $7,700 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | (Christopher, n.d.) | ||||||||||||||||
38 | 50-03 | Testing | $18.00 | $2,520 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $0 | $0 | |||||||||||||||||
39 | 50-04 | Voice-Over | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Hour total | |||||||||||||||||
40 | 700 | |||||||||||||||||||||||||||||||||||||||||
41 | Contracted Serv. Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $4,917 | $12,617 | $4,917 | $7,700 | $2,458 | $0 | $0 | $0 | $0 | $0 | $0 | $32,608 | |||||||||||||||||||
42 | Production Hrs: | 700 | Post Hrs: | 0.00 | ||||||||||||||||||||||||||||||||||||||
43 | 60-00 | Production G&A | ||||||||||||||||||||||||||||||||||||||||
44 | 60-01 | Software/Serv/Cloud (Software as a Service - SaaS) | $3,332 | $0 | $0 | $0 | $0 | $29 | $29 | $29 | $29 | $29 | $29 | $29 | $29 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $1,200 | $1,200 | (Law, 2021) | |||||||||||||||||
45 | 60-02 | Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | (Picard, 2019) | ||||||||||||||||
46 | Production G&A Total | $0 | $0 | $0 | $0 | $29 | $29 | $29 | $29 | $29 | $29 | $29 | $29 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $1,200 | $1,200 | $3,332 | |||||||||||||||||||
47 | ||||||||||||||||||||||||||||||||||||||||||
48 | 70-00 | G&A (Not in dev month calc.) | ||||||||||||||||||||||||||||||||||||||||
49 | 70-01 | Accounting | $6,794 | $21 | $21 | $500 | $21 | $21 | $500 | $21 | $21 | $500 | $21 | $21 | $3,500 | $21 | $21 | 500 | $21 | $21 | $500 | $21 | $21 | $500 | ||||||||||||||||||
50 | 70-02 | Legal | $8,800 | $8,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $800 | $0 | $0 | $0 | ||||||||||||||||||
51 | 70-03 | Misc. | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||
52 | 70-04 | Marketing | $90,000 | $7,500 | $46.88 | $93,750 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $3,750 | |||||||||||||||
53 | 70-05 | Advertising | $1,100,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $100,000 | $200,000 | $300,000 | $200,000 | $300,000 | ||||||||||||||||||
54 | 70-06 | Travel | $25,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $25,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||
55 | Hour Total | |||||||||||||||||||||||||||||||||||||||||
56 | G&A Total | $8,021 | $21 | $500 | $21 | $21 | $500 | $21 | $21 | $8,000 | $7,521 | $7,521 | $11,000 | $32,521 | $7,521 | $8,000 | $7,521 | $107,521 | $208,800 | $307,521 | $207,521 | $304,250 | $1,234,344 | 2000 | ||||||||||||||||||
57 | Production Hrs: | 1760 | Post Hrs: | 240 | Net Income | |||||||||||||||||||||||||||||||||||||
58 | Total Expenses | $48,854 | $40,854 | $41,333 | $40,854 | $40,883 | $41,362 | $67,925 | $67,925 | $75,904 | $75,425 | $80,342 | $91,521 | $105,413 | $83,196 | $78,433 | $75,496 | $175,496 | $276,775 | $375,496 | $270,513 | $364,533 | $2,518,534 | -$1,716,675 | ||||||||||||||||||
59 | Contingency (10%) | $4,885 | $4,085 | $4,133 | $4,085 | $4,088 | $4,136 | $6,793 | $6,793 | $7,590 | $7,543 | $8,034 | $9,152 | $10,541 | $8,320 | $7,843 | $7,550 | $17,550 | $27,678 | $37,550 | $27,051 | $36,453 | $251,853 | |||||||||||||||||||
60 | Profit/Loss | $1,946,260 | $1,905,406 | $1,864,073 | $1,823,218 | $1,782,335 | $1,740,973 | $1,673,048 | $1,605,123 | $1,529,219 | $1,453,794 | $1,373,452 | $1,281,931 | $1,176,519 | $1,093,323 | $1,014,889 | $939,393 | $763,897 | $487,122 | $111,626 | -$158,886 | -$523,420 | -$189,491 | Sub total hours | ||||||||||||||||||
61 | 29,900 | |||||||||||||||||||||||||||||||||||||||||
62 | Milestone Payments | 1 | 2 | 3 | 4 | |||||||||||||||||||||||||||||||||||||
63 | Amount | $500,000 | $500,000 | $500,000 | $500,000 | |||||||||||||||||||||||||||||||||||||
64 | Cashflow | $446,260 | $401,320 | $355,854 | $310,914 | $265,942 | $220,444 | $145,726 | $571,009 | $487,514 | $404,547 | $316,171 | $215,498 | $99,544 | $8,029 | $421,752 | $338,707 | $145,661 | -$158,792 | -$71,837 | -$369,401 | -$770,388 | ||||||||||||||||||||
65 | ||||||||||||||||||||||||||||||||||||||||||
66 | Pre-production: | $254,142 | Production: | $1,629,346 | Post-launch: | $635,046 | ||||||||||||||||||||||||||||||||||||
67 | PreProduction Hrs: | 4800 | Production Hrs: | 22,220.00 | Post-launch hrs: | 2,880 | ||||||||||||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||||||||||||||||||
69 | Copyright © 2017 Bithell Games. Made possible by purchasers of The GameDev Business Handbook (GameDevBizBook.com). For instructions on use, visit GameDevBizBook.com/supplements. | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | |||||||||||||||||||
70 | ||||||||||||||||||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||||||||||||||||||