{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input Data","Hourly Rate Calculator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input Data","index":0,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,16,32,17],[28,19,32,20],[28,1,32,2],[28,4,32,5],[28,7,32,8],[28,10,32,11],[28,13,32,14],[0,1,0,20],[1,2,2,2],[1,5,2,5],[1,8,2,8],[1,11,2,11],[1,20,2,20],[1,17,2,17],[1,14,2,14]]}
[null,"Average Rates of Pay Calculator"]
[null,"Workshop Technicians","Hourly Rate",null,"Front of House","Hourly Rate",null,"Parts Dept.","Hourly Rate",null,"Driver/Valeters","Hourly Rate",null,"Management","Hourly Rate",null,"Apprentices","Hourly Rate",null,"Other Staff","Hourly Rate"]
[null,{"$f":"COUNTIF($C$4:$C$25,\">0\")","v":4},null,null,{"$f":"COUNTIF($F$4:$F$25,\">0\")","v":1},null,null,{"$f":"COUNTIF($I$4:$I$25,\">0\")","v":1},null,null,{"$f":"COUNTIF($L$4:$L$25,\">0\")","v":1},null,null,{"$f":"COUNTIF($O$4:$O$25,\">0\")","v":1},null,null,{"$f":"COUNTIF($R$4:$R$25,\">0\")","v":1},null,null,{"$f":"COUNTIF($U$4:$U$25,\">0\")","v":1}]
[null,"Master Technician 1",15,null,"Reception Team Leader",10,null,"Parts Manager",null,null,"Driver/Valeter Team Leader",9,null,"Director",null,null,"Apprentice 1",6.5,null,"Cleaner",9]
[null,"Master Technician 2",null,null,"Receptionist 1",null,null,"Parts Operative 1",10,null,"Driver/Valeter 1",null,null,"Director",null,null,"Apprentice 2",null,null,"A N Other"]
[null,"Master Technician 3",null,null,"Receptionist 2",null,null,"Parts Operative 2",null,null,"Driver/Valeter 2",null,null,"Workshop Manager",17,null,"Apprentice 3"]
[null,"Technician 1",10.5,null,"Receptionist 3",null,null,"Parts Operative 3",null,null,"Driver/Valeter 3",null,null,"Other",null,null,"Apprentice 4"]
[null,"Technician 2",null,null,"Receptionist 4",null,null,"Parts Operative 4",null,null,"Driver/Valeter 4"]
[null,"Technician 3"]
[null,"Technician 4"]
[null,"Technician 5"]
[null,"Technician 6"]
[null,"Technician 7"]
[null,"Technician 8"]
[null,"Technician 9"]
[null,"Technician 10"]
[null,"Technician 11"]
[null,"Technician 12"]
[null,"Mot Tester 1",10]
[null,"Mot Tester 2",11.8]
[null,"Mot Tester 3"]
[null,"Mot Tester 4"]
[null,"Fitter 1"]
[null,"Fitter 2"]
[null,"Fitter 3"]
[null,"Average Technician Hourly Rate",{"$f":"(SUM(C4:C25))/B3","v":11.824999999999999},null,"Average Receptionist Hourly Rate",{"$f":"(SUM(F4:F25))/E3","v":10},null,"Average Parts Staff Hourly Rate",{"$f":"(SUM(I4:I25))/H3","v":10},null,"Average Driver/Valeter Hourly Rate",{"$f":"(SUM(L4:L25))/K3","v":9},null,"Average Management Hourly Rate",{"$f":"(SUM(O4:O25))/N3","v":17},null,"Average Apprentice Hourly Rate",{"$f":"(SUM(R4:R25))/Q3","v":6.5},null,"Average Combined 'Other Staff' Hourly Rate",{"$f":"(SUM(U4:U25))/T3","v":9}]
[]
[]
[null,"You may use the average hourly rate information above to manually enter into the  'Hourly Rate Calculator' on the next tab, or click on the button below to automatically transfer the information.\nDO NOT use the button if the average shows '######'",null,null,"You may use the average hourly rate information above to manually enter into the  'Hourly Rate Calculator' on the next tab, or click on the button below to automatically transfer the information.\nDO NOT use the button if the average shows '######'",null,null,"You may use the average hourly rate information above to manually enter into the  'Hourly Rate Calculator' on the next tab, or click on the button below to automatically transfer the information.\nDO NOT use the button if the average shows '######'",null,null,"You may use the average hourly rate information above to manually enter into the  'Hourly Rate Calculator' on the next tab, or click on the button below to automatically transfer the information.\nDO NOT use the button if the average shows '######'",null,null,"You may use the average hourly rate information above to manually enter into the  'Hourly Rate Calculator' on the next tab, or click on the button below to automatically transfer the information.\nDO NOT use the button if the average shows '######'",null,null,"You may use the average hourly rate information above to manually enter into the  'Hourly Rate Calculator' on the next tab, or click on the button below to automatically transfer the information.\nDO NOT use the button if the average shows '######'",null,null,"You may use the average hourly rate information above to manually enter into the  'Hourly Rate Calculator' on the next tab, or click on the button below to automatically transfer the information.\nDO NOT use the button if the average shows '######'"]

{"sheet":"Hourly Rate Calculator","index":1,"n_rows":38,"n_cols":21,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,1,4],[1,10,1,11],[10,1,10,3],[10,5,10,6],[11,2,11,6],[11,8,11,9],[12,5,12,6],[12,8,12,9],[13,2,14,2],[13,3,14,3],[13,4,14,4],[35,10,36,11],[37,10,39,11],[35,1,41,7],[22,1,22,4],[24,1,25,3],[24,4,25,4],[24,5,24,6],[25,5,25,6],[25,10,25,11],[26,10,30,11],[28,2,28,6],[30,3,30,6],[33,3,33,6],[15,5,22,6]]}
[]
[null,null,"Workshop Operating Times",null,null,null,null,null,null,null,"Overheads"]
[null,null,"Workshop Operating Times\nFrom","Workshop Operating Times\nTo","Daily Operating Hours","Number\nof\nTechnicians","Total Break Time per Day","Daily\nHours\nAvailable",null,null,"Item\n","Cost Per\nAnnum"]
[null,"Monday to Friday","08:30:00","17:30:00",{"$f":"D4-C4","v":"09:00:00"},4,"00:30:00",{"$f":"((E4-G4)*F4)","v":1.4166666666666665},null,null,"Business Rates Payable",13200]
[null,"Saturday","08:30:00","17:30:00",{"$f":"D5-C5","v":"09:00:00"},4,"00:30:00",{"$f":"(E5-G5)*F5","v":1.4166666666666665},null,null,"Water Rates",2000]
[null,"Sunday","08:30:00","17:30:00","09:00:00",4,"00:30:00",1.4166666666666665,null,null,"Telephone/Broadband",2250]
[null,"Thursday","08:30:00","17:30:00","09:00:00",4,"00:30:00",1.4166666666666665,null,null,"Gas/Electricity",3000]
[null,"Friday","08:30:00","17:30:00","09:00:00",4,"00:30:00",1.4166666666666665,null,null,"Insurances",2875]
[null,"Saturday","08:30:00","12:30:00","04:00:00",2,"00:00:00",0.33333333333333337,null,null,"Premises Lease/Mortgage",15000]
[null,"Sunday","08:30:00","17:30:00","09:00:00",0,"00:00:00",0,null,null,"Equipment Costs/Rental",2600]
[null,"Total Weekly Operating Hours",null,null,{"$f":"SUM(E4:E10)","v":2.4166666666666665},"Annually Available Hrs.",null,{"$f":"(SUM(H4:H10)*52)","v":385.66666666666657},null,null,"Loan Repayments",6000]
[null,null,"Technician Annual Holiday Entitlement Including Bank Holidays   ",null,null,null,null,28,"Days",null,"Vehicle Costs",2500]
[null,null,null,null,null,"Total Holiday Hours   ",null,{"$f":"((H12*8)*E16)/24","v":37.333333333333336},"Hours",null,"Marketing/Advertising",1800]
[null,null,"Ave. Hourly\nRate","Hours\nWorked","No. Staff\nIn Dept"," ",null,null,null,null,"Training & Recruitment",2250]
[null,null,null,null,null,null,null,"Weekly Cost",null,null,"Professional Fees",3800]
[null,"Technician(s)",{"$f":"'Input Data'!$C$26","v":11.824999999999999},40,{"$f":"'Input Data'!$B$3","v":4},"If the data to the left has been imported from the data input tab, it can be overwritten manually if desired.",null,{"$f":"(C16*D16)*E16","v":1892},null,null,"Transaction Fees (Credit/Debit Cards)",1760,null,null,null,null,null,null,null,null," "]
[null,"Receptionist(s)",{"$f":"'Input Data'!$F$26","v":10},40,{"$f":"'Input Data'!$E$3","v":1},null,null,{"$f":"C17*D17*E17","v":400},null,null,"Equipment Maintenance & Repair",2950]
[null,"Parts Department",{"$f":"'Input Data'!$I$26","v":10},40,{"$f":"'Input Data'!$H$3","v":1},null,null,{"$f":"C18*D18*E18","v":400},null,null,"Hazardous Waste Disposal",1500]
[null,"Driver/Valeter(s)",{"$f":"'Input Data'!$L$26","v":9},45,{"$f":"'Input Data'!$K$3","v":1},null,null,405,null,null,"Consumables",0]
[null,"Manager(s)",{"$f":"'Input Data'!$O$26","v":17},40,{"$f":"'Input Data'!$N$3","v":1},null,null,680,null,null,"Security & Alarm Monitoring",200]
[null,"Apprentice(s)",{"$f":"'Input Data'!$R$26","v":6.5},40,{"$f":"'Input Data'!$Q$3","v":1},null,null,260,null,null,"Garage Management System Costs",2000]
[null,"Staff (Other)",{"$f":"'Input Data'!$U$26","v":9},38,{"$f":"'Input Data'!$T$3","v":1},null,null,342,null,null,"Miscellaneous Costs",1100]
[null,"Annual Staffing Costs",null,null,null,null,null,{"$f":"SUM(H16:H22)*52","v":227708},null,null,"Total Overheads",{"$f":"SUM(L4:L22)","v":66785}]
[]
[null,"Technician Efficiency",null,null,0.8,"Saleable Hours"]
[null,null,null,null,null,{"$f":"H11-H13","v":348.33333333333326},null,null,null,null,"Break Even Hourly Cost"]
[null,null,null,null,null,null,null,"Per Annum",null,null,{"$f":"(H34/(F26*E25*24))","v":50.093293062200964}]
[null,"Staff Costs",null,null,null,null,null,{"$f":"H23","v":227708}]
[null,"Staff Benefits/Bonuses",null,null,null,null,null,2000]
[null,"Employer NI @",0.13800000000000001,null,null,null,null,{"$f":"(H28+H29)*C30","v":31699.704000000002}]
[null,"Pension contribution @",0.03,null,null,null,null,{"$f":"H28*C31","v":6831.24}]
[null,"Total Overheads",null,null,null,null,null,{"$f":"L23","v":66785}]
[null,null,null,null,null,null,null,null,null,null,"Enter Net Profit Margin Required",0.2]
[null,null,null,"Total Operating Costs  ",null,null,null,{"$f":"SUM(H28:H32)","v":335023.94400000002},null,null,"Charge Out Rate",{"$f":"(K27*L33)+K27","v":60.111951674641155}]
[]
[null,"Disclaimer:\nThe information and calculations within the calculation tool are designed as a guide only.\nThe tool is intended for a review of labour costs and charge out rates. Parts, oils, coolants and other items sold through the garage will also contribute to the profitability of the business.\nAlways consult your accountant or other financial advisors on business profitability and remember to take into account local competition before making any adjustments to your hourly rate.",null,null,null,null,null,null,null,null,"Potential Labour Sales Value If All Saleable Hours Billed at \n'Charge Out Rate'"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(F26*L34)*24","v":502535.91599999997}]