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
 
 

Convert Excel spreadsheet to HTML page