|
|
|
|
|
|
|
5
|
|
|
|
|
|
WEDDING PROFITABILITY
CALCULATOR
|
How To Use This Calculator
Read the instructions listed in each line and Input the requested
information . Use guesstimates or averages if specific values are not known.
Current values shown are references only - replace them with your specific
data or delete if not applicable. USE TAB KEY TO MOVE BETWEEN ACTIVE CELLS
|
AX=5
|
|
|
|
AI=6
|
|
|
UPDATED JAN 25, 2011
|
|
$ AUS
|
S=7
|
|
|
|
INPUT
STUDIO VARIABLES
|
UKX = 8
|
|
|
1
|
Input the
quantity of weddings you currently photograph or expect to photograph each
year
|
|
ALBUMS AUSTRALIA PROVIDES THIS CALCULATOR AS A SERVICE TO
OUR CLIENTS
FORMULAS USED HAVE BEEN THOUROUGHLY CHECKED, HOWEVER ALBUMS AUSTRALIA TAKES NO RESPONSIBILITY FOR ANY POSSIBLE
ERRORS
|
UKI=9
|
|
|
2
|
Input the
set sell value of your most popular album package. (Do not include up sell
values)
|
|
|
|
|
3
|
Input the
quantity of page sides that
are included in this package
|
|
|
|
|
4
|
Input the
value that you sell additional page sides for
|
|
|
|
|
5
|
Input the
value of what you expect your business to return as a profit at the end of
the year. This is after your wages are paid.
|
|
|
|
|
6
|
Input the
percentage value that weddings makes up out of your entire business
|
|
|
|
|
|
|
|
|
ANNUAL COSTS
|
The
following calculation breaks down your annual expenses into a 'per wedding'
expense.
|
|
|
|
|
Input
Full Annual Values
|
|
Annual
Costs Converted Into 'Per Wedding' Costs
|
|
|
|
7
|
Input
your annual cost for I.T. per year. Include computers software, hardware etc.
(If you spend 5,000 over 5 years - input 1,000)
|
|
|
|
|
|
|
|
8
|
Input
your annual cost for advertising
|
|
|
|
|
|
|
|
9
|
Input
your annual admin costs (phone, stationery, office machines etc.)
|
|
|
|
|
|
|
|
10
|
Input
your annual cost for business insurance (public liability, camera insurance
etc.
(If you spend 5,000 over 5 years - input 1,000)
|
|
|
|
|
|
|
|
11
|
Input
your annual cost for cameras, lenses and accessories
(If you spend 5,000 over 5 years - input 1,000)
|
|
|
|
|
|
|
|
12
|
Input
your annual business associated car costs (finance, depreciation, fuel,
maintenance & repair)
|
|
|
|
|
|
|
|
13
|
Input
your annual cost for car insurance
|
|
|
|
|
|
|
|
14
|
Input
your annual cost for studio rent
|
|
|
|
|
|
|
|
15
|
Input any
other annual cost that is not listed above
|
|
|
|
|
|
|
|
16
|
Input any
other annual cost that is not listed above
|
|
|
|
|
|
|
|
|
|
|
|
Input
'True' Hourly Labour Rates For Up To Two Different Staff Members
|
|
|
|
|
Input True Hourly Labour Cost (As determined by using the Albums Australia 'True Cost of Labour' Calculator)
|
STAFF #1
|
STAFF #2
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Allocate
Time Spent By Each Staff For The Following Studio Chores
|
|
|
|
You are able to assign the task to two different Staff
Members in case they are on different pay rates and do different chores.
Inputs Into Both Columns are allowed (i.e. you use an assistant when shooting
a wedding)
|
|
|
|
|
|
STAFF #1
|
STAFF #2
|
Calculated
Labour Cost For Each Wedding
|
|
|
|
17
|
Input
approx phone time you spend on each wedding
inquiry (even if you do not book them)
|
(Minutes)
|
|
|
|
|
|
18
|
Approximately how many phone inquiries do you answer for
every wedding that you book?
|
Qty
|
|
|
|
|
|
|
19
|
Input
approx time you take to interview and explain your products and services once
the couple has booked you.
|
(Minutes)
|
|
|
|
|
|
|
20
|
Input approx time you take to formally book a wedding
|
(Minutes)
|
|
|
|
|
|
|
21
|
Input average time spent per wedding for contact calls,
follow ups, chasing details, organising appointments and chasing payments
|
(Minutes)
|
|
|
|
|
|
|
22
|
Input average time spent formatting & downloading
cards and backing up files per wedding
|
(Hours)
|
|
|
|
|
|
|
23
|
Input average time spent during the wedding day (include
preparing equipment, driving to and from locations & shooting time
|
(Hours)
|
|
|
|
|
|
|
24
|
Input average time spent editing, deleting and organising
image files per wedding
|
(Hours)
|
|
|
|
|
|
|
25
|
Input average time spent designing an album
|
(Hours)
|
|
|
|
|
|
|
26
|
Input average time spent presenting and selling your album
design per wedding
|
(Hours)
|
|
|
|
|
|
|
27
|
Input average time spent
per wedding - changing an album design to meet client's needs
|
(Minutes)
|
|
|
|
|
|
|
28
|
Input average time spent ordering prints, chasing orders,
checking in and trimming prints per wedding
|
(Minutes)
|
|
|
|
|
|
|
29
|
Input average time spent assembling the album per
wedding
|
(Hours)
|
|
|
|
|
|
|
|
|
30
|
Input average time spent reviewing finished album with
client
|
(Minutes)
|
|
|
|
|
|
|
31
|
Guestimate the total amount of time that you spend on I.T.
per year. Include researching. purchasing products, installing hardware and
software, setting up networks, learning programs and backing up admin
files
|
(Hours)
|
|
|
|
|
|
|
32
|
Input any other time spent 'per wedding' not listed above
|
(Minutes)
|
|
|
|
|
|
|
|
|
|
|
|
|
ALBUM
COSTS
|
|
|
|
|
33
|
Select
your preferred album type and size by clicking on the Blue cell to the right
|
|
Price Ea.
|
Extended Price
|
|
|
|
|
34
|
Select
your preferred cover material from the drop down list to the right.
|
|
|
|
(#N/A =
Not Applicable)
|
|
|
|
35
|
Select
your preferred cover enhancement from the drop down list to the right. Select
"None" if not required
|
|
|
|
|
|
|
|
36
|
Input the
quantity of leaves you
require in your album. (1 Leaf equals 2 page sides)
|
|
|
|
|
|
|
|
37
|
Select
Mat Style For Designer
Albums Only (All other album do not require mats)
|
|
|
|
(Mat
Qty = 2 x Leaf Qty)
(#N/A = Not Applicable)
|
|
|
|
38
|
Input
total quantity of Single Page Panorama page sides
|
|
|
|
(#N/A =
Not Applicable)
|
|
|
|
39
|
Input
total quantity of Double Page Panorama page sides
|
|
|
|
(#N/A =
Not Applicable)
|
|
|
|
40
|
Select
your preferred album packaging
|
|
|
|
(#N/A =
Not Available)
|
|
|
|
|
|
|
|
"ITEM COSTS" Per Wedding
|
|
|
|
|
QTY
P / WEDD
|
COST EA.
|
Calculated
Cost Per Wedding
|
|
|
|
|
41
|
Input
your average lab printing cost per album
|
|
|
|
|
|
|
|
42
|
Input any
transport costs to get prints to studio from lab
|
|
|
|
|
|
|
|
43
|
Input any
transport costs to get prints to Albums Australia if required
|
|
|
|
|
|
|
|
44
|
Input any
other "per wedding" out of pocket cost not listed above
|
|
|
|
|
|
|
|
|
|
|
|
TRAVEL COST ON
WEDDING DAY
|
Qty km
|
Cost Per km
|
|
Total
Travel Cost
|
|
|
|
43
|
Input the
average quantity of km you drive to photograph a wedding and the current cost
per km (Current RACV Value - inc. fuel, wear & tear = $0.68 p/km)
|
|
|
|
|
|
|
|
|
|
|
|
YOUR TOTAL HOURS PER WEDDING
|
|
|
|
|
|
|
|
|
|
Staff #1
|
Staff #2
|
|
Total
Hours
Per Wedding
|
|
|
|
44
|
This is
how many productive labour hours Per Staff Member you invest into every
wedding!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45
|
This is
how much you pay for labour (per person and total labour) per wedding!
|
|
|
|
|
|
|
|
46
|
This is how much you pay per
wedding for annually accrued costs
|
|
|
|
|
47
|
This is how much you pay for
an album per wedding!
|
|
|
|
|
48
|
This is how much you pay for
travel per wedding!
|
|
|
|
|
49
|
This is how much you pay for
out of pocket expenses per wedding!
|
|
|
|
|
50
|
Total Cost To Produce Each
Wedding Including Your Labour
|
|
|
|
|
51
|
This
is how much additional you need to earn
(per wedding after any additional costs) to meet your profitability target
listed above!
|
|
|
|
|
55
|
This
is the minimum each wedding sale needs to average
for you to reach your profitability target
|
|
|
|
|
56
|
This
is how many more page sides you need to sell
(using your current 'Additional' Page Side sell value listed above) to
reach your profitability target
|
|
|
|
|
57
|
This
is the total quantity of page sides you need to sell per album to reach
your profitability target
|
|
|
|
|
|
|
|
|
ALBUM PACKAGE
FORECASTERS
Determine How Much You Need To Sell Each Additional Page Side For - To Reach Your Profitable Sales Target
|
|
|
|
|
58
|
Enter
a 'sell value' for a proposed new
album package
|
|
|
|
|
59
|
Additional
Sales Required
To Reach "Annual Profit Target"
|
|
|
|
|
61
|
Enter
a quantity of "Additional Page Sides"
that you are confident that you can up sell with every wedding album
|
|
|
|
|
62
|
This Is The Sale Value Required For Each
Additional Page Side You Sell
To Achieve Your Target Profitability -
|
|
|
|
|
|
OR
|
Determine
How Many Additional Page Side You Need To Sell To Reach Your Profitable Sales
Target
|
|
|
|
63
|
Enter
a preferred sell value for each "Additional" Page Side You Can Sell
With Each Album Package
|
|
|
|
|
64
|
This is how many "Additional Page
Sides that you need to sell
(at the value you listed in line 63) to meet your profitable sales target
|
|
|
|
|
|
|
|