ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Job Cost Template Version 2023.1.1
Developed by Tom Stimson
2
CustomerOrder #
3
Event NameStart Date
4
Salesperson
Completion Date
5
6
7
REVENUE
PROJECTED COSTS VS RETAIL REVENUE
ACTUAL COSTS VS ACTUAL REVENUE
8
Labor
Quote NotesProposal Price% Retail
% Invoice
Pre-Job Cost
Cost % Actual Cost %
9
#DIV/0!#DIV/0!Fixed House Cost - #DIV/0!Payroll0.00%
10
#DIV/0!#DIV/0!Fixed House Cost - 0.00%Payroll0.00%
11
#DIV/0!#DIV/0!Quoted Cost0.00%Invoice0.00%
12
#DIV/0!#DIV/0!Fixed House Cost - 0.00%Payroll0.00%
13
#DIV/0!#DIV/0!Fixed House Cost - 0.00%Payroll0.00%
14
#DIV/0!#DIV/0!Fixed House Cost - 0.00%Payroll0.00%
15
#DIV/0!#DIV/0!Quoted Cost0.00%Invoice0.00%
16
#DIV/0!#DIV/0!Quoted Cost0.00%Invoice0.00%
17
#DIV/0!#DIV/0!Quoted Cost0.00%Invoice0.00%
18
Total Labor $ - #DIV/0!#DIV/0!Total - 0.00%Total - 0.00%
19
Travel
Quote NotesProposal Price% Retail
% Invoice
20
#DIV/0!#DIV/0!Quoted Cost0.00%Expense0.00%
21
#DIV/0!#DIV/0!Quoted Cost0.00%Expense0.00%
22
#DIV/0!#DIV/0!Quoted Cost0.00%Expense0.00%
23
#DIV/0!#DIV/0!Quoted Cost0.00%Expense0.00%
24
Total Travel $ - #DIV/0!#DIV/0!Total - 0.00%Total - 0.00%
25
Rental Equipment
Quote NotesProposal Price% Retail
% Invoice
26
#DIV/0!#DIV/0!Fixed House Cost - 0.00%Subrentals0.00%
27
#DIV/0!#DIV/0!Quoted Cost0.00%Subrentals0.00%
28
#DIV/0!#DIV/0!Quoted Cost0.00%Subrentals0.00%
29
#DIV/0!#DIV/0!Quoted Cost0.00%Subrentals0.00%
30
#DIV/0!#DIV/0!Quoted Cost0.00%Subrentals0.00%
31
Total Rental Equipment $ - #DIV/0!#DIV/0!Total - 0.00%Total - 0.00%
32
Other Charges
Quote NotesProposal Price% Retail
% Invoice
33
#DIV/0!#DIV/0!Quoted Cost0.00%Expense0.00%
34
#DIV/0!#DIV/0!Quoted Cost0.00%Expense0.00%
35
#DIV/0!#DIV/0!Quoted Cost0.00%Expense0.00%
36
#DIV/0!#DIV/0!Fixed House Cost - 0.00%
Fixed House Cost
0.00%
37
Total Other Charges $ - #DIV/0!#DIV/0!Total - 0.00%Total - 0.00%
38
39
Total Retail Revenue
 $ - Total COGS - #DIV/0!Total COGS - 0.00%
40
41
Selling Costs
Quote Notes% Retail
% Invoice
42
(Discounts)#DIV/0!#DIV/0!
43
(Outside Commission)#DIV/0!#DIV/0!
44
Total Deductions $ - #DIV/0!#DIV/0!
Projected Deductions
 - 0.00%
Total Deductions
 - 0.00%
45
Projected Total Cost
 - #DIV/0!Total Cost - #DIV/0!
46
Net Revenue
 $ - #DIV/0!#DIV/0!
Projected Gross Profit
 $ - #DIV/0!Gross Profit $ - #DIV/0!
47
48
49
COMMISSION REPORT ON JCF
50
Retail Income $ -
51
Gross Profit $ -
52
GP % of Retail#DIV/0!
53
Floor GP %30.00%
54
Commissionable GP#DIV/0!
55
Sales Commission#DIV/0!25.00%
56
Sales Bonus $ - 2.00%
57
Total Sales Incentive#DIV/0!#DIV/0!
58
Total Sales Incentive#DIV/0!#DIV/0!
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