{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INFO","INPUT1","INPUT2","OUTPUT","EXAMPLE"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"INFO","index":0,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"QUOTING & CHARGE RATE CALCULATOR"]
[]
[]
[null,"Purpose"]
[]
[null,"Situations arise where a person insists that only a certain low hourly rate can be charged.  However, they"]
[null,"proceed to add a percentage to the materials and a percentage to the costed hours and a percentage to"]
[null,"the total of costed hours and materials.  This is justified on the basis that is what is expected in a"]
[null,"particular industry.  Alternatively the industry standard for quantity, volume, linear measurement etc. is"]
[null,"used in the belief that this is the only way to get a job.  Not surprisingly the above person wins a lot of"]
[null,"little unprofitable jobs and always lose the profitable ones."]
[]
[null,"This spreadsheet lists questions that need to be asked and shows how to quote fairly and profitably."]
[]
[]
[null,"Steps"]
[]
[null,1,null,"Enter what you would like to earn weekly and your 10 key expenses on the INPUT1 tab."]
[]
[null,2,null,"Enter answers to questions relating to your working habits onto the INPUT2 tab."]
[]
[null,3,null,"The OUTPUT is ready to print."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Charge Rate.xls"]

{"sheet":"INPUT1","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"QUOTING AND CHARGE RATE CALCULATOR"]
[]
[null,null,null,null,null,"$"]
[null,null,"What would you like to earn per week?",null,null,0]
[]
[null,null,"What are your 10 key expenses per year (other than materials)?"]
[]
[null,null,null,"Advertising",null,0]
[null,null,null,"Bank charges & interest",null,0]
[null,null,null,"Leasing",null,0]
[null,null,null,"Rent",null,0]
[null,null,null,"Repairs & Maintenance",null,0]
[null,null,null,"Subcontractors",null,0]
[null,null,null,"Wages",null,0]
[null,null,null,"Electricity",null,0]
[null,null,null,"Gas",null,0]
[null,null,null,"Other",null,0]

{"sheet":"INPUT2","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"QUOTING AND CHARGE RATE CALCULATOR"]
[]
[null,null,"What are your working habits?"]
[]
[null,null,null,"Number of employees",null,0]
[]
[null,null,null,null,"YOU","EMPLOYEES"]
[null,null,"Hours per day",null,0,0]
[null,null,"Days per week",null,0,0]
[null,null,"Holidays per year (days)",null,0,0]
[null,null,"Weeks off for wet weather, strikes,"]
[null,null,null,"sickness & accidents etc.",0,0]
[null,null,"How many days of the 10 public "]
[null,null,null,"holidays do you take?",0,0]
[null,null,"How many hours would be"]
[null,null,null,"non-productive in a day?",0,0]

{"sheet":"OUTPUT","index":3,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"QUOTING AND CHARGE RATE CALCULATOR"]
[]
[]
[null,null,null,null,null,"$"]
[null,"What would you like to earn per week?",null,null,null,{"$f":"INPUT1!F6","v":0}]
[]
[null,"What are your 10 key expenses per year (other than materials)?"]
[null,null,null,null,null,"$"]
[null,{"$f":"INPUT1!D10","v":"Advertising"},null,null,null,{"$f":"INPUT1!F10","v":0}]
[null,{"$f":"INPUT1!D11","v":"Bank charges & interest"},null,null,null,{"$f":"INPUT1!F11","v":0}]
[null,{"$f":"INPUT1!D12","v":"Leasing"},null,null,null,{"$f":"INPUT1!F12","v":0}]
[null,{"$f":"INPUT1!D13","v":"Rent"},null,null,null,{"$f":"INPUT1!F13","v":0}]
[null,{"$f":"INPUT1!D14","v":"Repairs & Maintenance"},null,null,null,{"$f":"INPUT1!F14","v":0}]
[null,{"$f":"INPUT1!D15","v":"Subcontractors"},null,null,null,{"$f":"INPUT1!F15","v":0}]
[null,{"$f":"INPUT1!D16","v":"Wages"},null,null,null,{"$f":"INPUT1!F16","v":0}]
[null,{"$f":"INPUT1!D17","v":"Electricity"},null,null,null,{"$f":"INPUT1!F17","v":0}]
[null,{"$f":"INPUT1!D18","v":"Gas"},null,null,null,{"$f":"INPUT1!F18","v":0}]
[null,{"$f":"INPUT1!D19","v":"Other"},null,null,null,{"$f":"INPUT1!F19","v":0}]
[null,null,null,null,null,{"$f":"SUM(F9:F18)","v":0}]
[]
[null,null,null,null,"YOU NEED TO MAKE",{"$f":"F5*52+F19","v":0},"PLUS MATERIALS"]
[]
[]
[null,"What are your working habits?"]
[]
[null,"Number of employees",null,null,null,null,{"$f":"INPUT2!F7","v":0}]
[]
[null,null,null,null,null,"YOU","EMPLOYEES"]
[null,"Hours per day",null,null,null,{"$f":"INPUT2!E10","v":0},{"$f":"INPUT2!F10","v":0}]
[null,"Days per week",null,null,null,{"$f":"INPUT2!E11","v":0},{"$f":"INPUT2!F11","v":0}]
[null,"Holidays per year (days)",null,null,null,{"$f":"INPUT2!E12","v":0},{"$f":"INPUT2!F12","v":0}]
[null,"Weeks off for wet weather, strikes,"]
[null,"           sickness & accident etc",null,null,null,{"$f":"INPUT2!E14","v":0},{"$f":"INPUT2!F14","v":0}]
[null,"How many days of the 10 public"]
[null,"            holidays do you take?",null,null,null,{"$f":"INPUT2!E16","v":0},{"$f":"INPUT2!F16","v":0}]
[null,"How many hours would be"]
[null,"            non-productive in a day?",null,null,null,{"$f":"INPUT2!E18","v":0},{"$f":"INPUT2!F18","v":0}]
[]
[null,null,null,null,"WORK",{"$f":"(F29-F37)*((F30*52)-(F31+(F33*F30)+F35))","v":0},{"$f":"(G26*(G29-G37)*((G30*52)-(G31+(G33*G30)+G35)))","v":0},"HOURS PER YEAR"]
[]
[]
[]
[]
[null,"WHEN YOU QUOTE YOU NEED TO CHARGE THE"]
[null,null,null,"    COST OF MATERIALS PLUS:",null,null,{"$f":"IF(F21=0,0,F21/SUM(F39:G39))","v":0},"PER HOUR"]

{"sheet":"EXAMPLE","index":4,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"QUOTING AND CHARGE RATE CALCULATOR"]
[null,null,null,null,"(SAMPLE REPORT ONLY)"]
[]
[null,null,null,null,null,"$"]
[null,"What would you like to earn per week?",null,null,null,1000]
[]
[null,"What are your 10 key expenses per year (other than materials)?"]
[null,null,null,null,null,"$"]
[null,"Advertising",null,null,null,6000]
[null,"Bank charges & interest",null,null,null,3000]
[null,"Leasing",null,null,null,10000]
[null,"Rent",null,null,null,10000]
[null,"Repairs & Maintenance",null,null,null,5000]
[null,"Subcontractors",null,null,null,6000]
[null,"Wages",null,null,null,50000]
[null,"Electricity",null,null,null,3000]
[null,"Gas",null,null,null,4000]
[null,"Other",null,null,null,4000]
[null,null,null,null,null,{"$f":"SUM(F9:F18)","v":101000}]
[]
[null,null,null,null,"YOU NEED TO MAKE",{"$f":"F19+(52*F5)","v":153000},"PLUS MATERIALS"]
[]
[]
[null,"What are your working habits?"]
[]
[null,"Number of employees",null,null,null,null,2]
[]
[null,null,null,null,null,"YOU","EMPLOYEES"]
[null,"Hours per day",null,null,null,8,6]
[null,"Days per week",null,null,null,6,6]
[null,"Holidays per year (days)",null,null,null,15,20]
[null,"Weeks off for wet weather, strikes,"]
[null,"           sickness & accident etc",null,null,null,8,8]
[null,"How many days of the 10 public"]
[null,"            holidays do you take?",null,null,null,5,10]
[null,"How many hours would be"]
[null,"            non-productive in a day?",null,null,null,3,1]
[]
[null,null,null,null,"WORK",{"$f":"(F29-F37)*((F30*52)-(F31+(F33*F30)+F35))","v":1220},{"$f":"(G26*(G29-G37)*((G30*52)-(G31+(G33*G30)+G35)))","v":2340},"HOURS PER YEAR"]
[]
[]
[]
[]
[null,"WHEN YOU QUOTE YOU NEED TO CHARGE THE"]
[null,null,null,"    COST OF MATERIALS PLUS:",null,null,{"$f":"IF(F21=0,0,F21/SUM(F39:G39))","v":42.977528089887642},"PER HOUR"]