Estimate OUTB (1).xlsx

	A	B	C	D	E
1
2	№	Name	Limit of contract costs	Expenses forecast	Difference
3	1	Lead and second plan actors	29 510 000	0	0
4	2	Crew	40 335 160	#REF!	0
5	3	Camera, equipment, light, sound	16 135 395	#REF!	0
6	4	Objects	9 725 400	#REF!	0
7	5	Vehicles	8 496 360	#REF!	0
8	6	Decoration	3 456 000	0	0
9	7	Props	1 522 800	#REF!	0
10	8	Act transport	1 770 800	#REF!	0
11	9	Costumes	5 724 000	#REF!	0
12	10	Make-up	#REF!	#REF!	0
13	11	Filmexpedition	24 487 100	#REF!	0
14	12	Stunt	1 512 000
15	13	Other direct expenses	6 346 620	#REF!	0
16	14	Post-production	9 306 900	#REF!	0
17	15	Graphics	4 608 783	#REF!	0
18	16	Music	3 456 000	#REF!	0
19	17	Overtime	2 901 864		0
20	18	Preparatory period	7 041 600
21	19	Unexpected expenses 10%	#REF!	#REF!	0
22	20	Pre-production
23	21	Project insurance 4%	#REF!
24	22
25	23	Taxes and fees
26		IN TOTAL:	#REF!	#REF!	0
31
32		Number of shifts	49
39
40		Input data:
41
42		Preparatory period	07.12.19 - 07.02.20
43		Filming period	09.03.20 - 09.07.20
44		Post-production period	09.08.20 - 09.11.20
45		Total, Film production	07.12.19 - 09.11.20
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
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
101
102
103
104
105
106
107
108
109
110