HourlyRateChargeoutsheet

	A	B	C	D	E	F	H	I
1	Basic Hourly Rate calculator			Only change the numbers that are in purple
2
3	Fuel						£1,700.66	Use fuel cost calculator below
4	Machinery fuel						£300.00
5	Insurance						£300.00
6	Tools						£150.00
7	Machinery servicing and costs						£300.00
8	Vehicle costs						£200.00
9	Clothing						£150.00
10	Work Boots						£60.00
11	Advertising						£300.00
12	Telephone and internet						£320.00
13	Mobile Phone						£250.00
14	Professional Association subs.						£200.00
15	Tax	25%					£5,000.00
16	NI	12%					£2,400.00
17
18	My Salary			Change your desired slary			£20,000.00	This is the amount you would like to take home
19
20
21	Total Costs Per Year						£31,630.66
22
23
24	Working hours per year						2,000	Based on a forty hour week x 50 weeks
25
26
27	Charge Out Per Hour						£15.82
28
29
30
31
32
33
34
35	Fuel costs
36		MP Month	MPL	Fuel used	Cost p/l	Cost of fuel
37	January	500	7.55	66.23	1.2	£79.47
38	February	500	7	66.23		£79.47
39	March	700		92.72		£111.26
40	April	900		119.21		£143.05
41	May	1000		132.45		£158.94
42	June	1200		158.94		£190.73
43	July	1200		158.94		£190.73
44	August	1200		158.94		£190.73
45	September	1200		158.94		£190.73
46	October	900		119.21		£143.05
47	November	900		119.21		£143.05
48	December	500		66.23		£79.47
49		10700		1417.22		£1,700.66