Shop Rate Calculator
This calculator provides a methodology for calculating a rate and the results are indicative Consult your accountant or financial advisor for any financial advice. Step 1
Click button to go to the "Sales and COGS" page Fill in the cells which are pale yellow. This data provides "Historical Performance" which is used when calculating Sales Targets and is u is also used in benchmarking your performance
Step 2
Click button to go to the "Business Overheads" page Fill in the cells which are pale yellow. This data provides "Historical Performance" which is used to set the Overheads budget for the nex Step 3
Click button to go to the "Staff Wages" page Fill in the cells which are pale yellow. Complete the "On Cost Percentage" this value adjusts the Wage to include a allowance for Annua etc 3% cover A/L and LSL. If staff consistently do Overtime this must be included. Overtime is assumed at time and a half for The owner is only included in "Productive Staff" if they actually work on the floor repairing vehicles
The owner's wage can be included in "Non Chargeable Staff" or can be included in the required "
Step 4 Click on the "Productivity Planning" Tab. Fill in the cells which are pale yellow. Complete the "Standard Hours for each person" and "Productivity" for person.
Use the table at the bottom of the input as a guide for both the "Standard Hours" and "Productivity
Step 4 Click on the "Shop Rate" Tab. Fill in the cells which are pale yellow. Complete the "Required Net Profit" and "Paint Materials Budget" The cell in Blue are automatically filled in but can be adjusted.
culator
culating a rate and the results are indicative only and does not constitute fin ancial advice. r any financial advice.
is used when calculating Sales Targets and is used to set the "Paint Materi als Budget", this data
is used to set the Overheads budget for the next financial period.
usts the Wage to include a allowance for Annual Leave (A/L) Loading, Long Ser vice Leave (LSL)
ded. Overtime is assumed at time and a half for 44 weeks. hey actually work on the floor repairing vehicles.
eable Staff" or can be included in the required "Net Profit"
nd "Productivity" for person. for both the "Standard Hours" and "Productivity" for both tradespeople an d apprentices.
Sales and COGS
Shop Rate Calculator Historical Information Input Data Collection Period
No. of months covered: Starting (DD/MM/YY) Ending (DD/MM/YY) Number of Jobs Last Year
Previous Years Sales
Panel Shop Labour Sales Paint Shop Labour & Material Sales Parts Sales Sublet Other
Total $
-
$
-
$
-
Cost of Sales
- Paint - Parts - Consumables/Materials - Sub-contactors - external - Body Materials -
Total $ Gross Profit Net Profit
$
-
$ $
-
$ $
-
e1a7eb1b-517c-45cd-b73a-a89566cad192.xls
10
8/20/20095:01 AM
Business Overheads
Shop Rate Calculator
BUSINESS OVERHEADS
2004 -2005 Actuals Accountancy and Mgt Fees Advertising and Promotion Bad Debts Bank and Credit Charges Bank Interest Consultancy Cleaning Depreciation - Equipment Deprecation - Vehicles Donations Electricity Factoring Fees Freight & Cartage Gas/Baking Oven fuel Ins. - Excluding Motor Vehicles Lease Payments - Equipment Lease Payments - Others Legal Services Licences & Permits Office Expenses Plant & Equipment Hire Postage Printing and Stationary Rates and Taxes Rent or Leases of Premises Repairs and Maintenance Replacement of Tools Rubbish Removal Security Staff Amenities Subscriptions Superanuation - Employees Tax - Pay Roll Telephone Towing Training Travel Uniforms/Protective Clothing Vehicle Expenses - Lease Vehicle Expenses - Fuel Vehicle Expenses - Maintenance Vehicle Expenses - Insurance/Reg Vehicle Expenses - Registration Workcover Miscellaneous Expenses 2005 -2006 Actuals 2006 -2007 Actuals Budget 2007 2008
All Others TOTAL
$ $ $ $ -
e1a7eb1b-517c-45cd-b73a-a89566cad192.xls
11
8/20/20095:01 AM
Staff Wages
Shop Rate Calculator
STAFF WAGES Productive Staff
On Cost Percentage Staff Category 1. Owner 2. Panel Beater - 1 Panel Beater - 2 Panel Beater - 3 Panel Beater - 4 Panel Beater - 5 Panel Beater - 6 Panel Beater - 7 3. App. Panel Beater - 1 App. Panel Beater - 2 App. Panel Beater - 3 4. Painter - 1 Painter - 2 Painter - 3 Painter - 4 5. App Painter - 1 App. Painter - 2 6. Trades Assistant 7. Labourer - 1 TOTAL 3% Number Avg O/T per week Wage Real Wage Sub Total $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ -
Non-Chargeable Staff
Staff Category Number Avg O/T per week Wage Real Wage $ $ $ $ $ $ $ $ Sub Total $ $ $ $ $ $ $ $ $ -
TOTAL
e1a7eb1b-517c-45cd-b73a-a89566cad192.xls
12
8/20/20095:01 AM
Productivity Planning
Shop Rate Calculator
PRODUCTIVITY PLANNING
Staff Category 1. Owner 2. Panel Beater - 1 Panel Beater - 2 Panel Beater - 3 Panel Beater - 4 Panel Beater - 5 Panel Beater - 6 Panel Beater - 7 3. App. Panel Beater - 1 App. Panel Beater - 2 App. Panel Beater - 3 4. Painter - 1 Painter - 2 Painter - 3 Painter - 4 5. App Painter - 1 App. Painter - 2 6. Trades Assistant 7. Labourer - 1 Number Std Hours Hours Productivity Chargeable Worked % Hours
TOTAL
0
e1a7eb1b-517c-45cd-b73a-a89566cad192.xls
13
8/20/20095:01 AM
Shop Rate
Shop Rate Calculator
YOUR SHOP RATES Profit Target
(Includes Owner's Wage, Return on Investment, Owner's Super etc)
Wages Panel Beaters (inc. apprentices) $ Painters (inc apprentices) $ Other Productives $ Total Productives Wages Non-Chargeable Wages Overheads (does not include the owner)
$ $ $ $
-
Required Gross Profit
Historical Gross Profit % Target Gross Profit %
Required Sales Value
Parts Sales % Parts Margin % 18%
Parts Margin $ Adjusted Gross Profit Total Saleable Hours Saleable Hours Paintshop Paint and Materials Budget Average Hourly Rate (Panelshop) = Average Hourly Rate (Paintshop) =
0 0
e1a7eb1b-517c-45cd-b73a-a89566cad192.xls
14
8/20/20095:01 AM