Actual Cost of Sales Calculation Worksheet
“This tool will help you calculate your actual cost per sale. Answer the following questions based upon your annual business plan or forecast. When you are finished simply click on the calculate button at the bottom and you results will be displayed.” Note that some questions request monthly data and other annual data.
Sales Associates
1.
How many full time Sales Associates do you employ?
2.
How many homes do you plan to sell annually?
3.
What is your average sales price?
$
4.
What is the commission percentage you pay per sale?
%
5.
Monthly individual Sales Associate Salary expense?
$
6.
Monthly individual Sales Associate Draw expense?
$
7.
How much is your average Annual Sales Associate bonus?
$
Sales Management
8.
How many full time sales managers, directors and VP’s do you employ?
9.
What is the total amount paid for managers, directors and VP salaries per year?
$
10.
Do you pay managers, directors and VP’s an override? If so, how much as a % of sale or as $ per sale?
%
$
11.
What is the total amount of Manager, Director, and VP bonuses per year?
$
Benefits
**If your actual amounts vary from the industry norms, you may manually input that amount after selecting the Yes button.
12.
Do you provide health insurance to your associates? (per employee per month)
Yes
No
$
13.
Do you provide dental insurance to your associates? (per employee per month)
Yes
No
$
14.
Do you provide vision insurance to your associates? (per employee per month)
Yes
No
$
15.
Do you provide life insurance to your associates? (per employee per month)
Yes
No
$
16.
Do you provide disability insurance to your associates? (per employee per month)
Yes
No
$
17.
Do you have a 401K matching program? (per employee per month)
Yes
No
$
Business Expenses
18.
Annual expense for uncollectable draws (write-offs)?
$
19.
Annual Sales Associate training and recruitment expense?
$
20.
Annual MLS and other associated fees?
$
21.
How much is each Sales Associate given per month for cell phone?
$
22.
How much is each Sales Associate given per month for auto/gas allowance?
$
23.
How much is each Sales Associate given per month for client entertainment/other?
$
24.
How much is each manager/director/VP given per month for cell phone?
$
25.
How much is each manager/director/VP given per month for auto/gas allowance?
$
26.
How much is each manager/director/VP given per month for client entertainment/other?
$