PHG Revenue Calculator.xlsx

	G	H	I	J	K	L	M	N	O	P	Q
1
2
3	The PHG Revenue Calculator
4
5	The below rates are fairly conservative and reflect the premium pet care services we deliver.
6	If you would like to adjust the rates, please save a copy first. If on a smart phone, you will need to download the Google Sheets app first before saving a copy (File, Make a copy).
7
8	Dog Walking: Choose your rate for walking one dog, once per day
9
10	Select Rate:	£19.00
11
12		Mon	Tue	Wed	Thu	Fri	Week	Month	Year
13	1 Dog	£19	£19	£19	£19	£19	£95	£412	£4,655
14	2 Dogs	£38	£38	£38	£38	£38	£190	£823	£9,310
15	3 Dogs	£57	£57	£57	£57	£57	£285	£1,235	£13,965
16	4 Dogs	£76	£76	£76	£76	£76	£380	£1,647	£18,620
17	5 Dogs	£95	£95	£95	£95	£95	£475	£2,058	£23,275
18	6 Dogs	£114	£114	£114	£114	£114	£570	£2,470	£27,930
19	7 Dogs	£133	£133	£133	£133	£133	£665	£2,882	£32,585
20	8 Dogs	£152	£152	£152	£152	£152	£760	£3,293	£37,240
21	9 Dogs	£171	£171	£171	£171	£171	£855	£3,705	£41,895
22	10 Dogs	£190	£190	£190	£190	£190	£950	£4,117	£46,550
23	11 Dogs	£209	£209	£209	£209	£209	£1,045	£4,528	£51,205
24	12 Dogs	£228	£228	£228	£228	£228	£1,140	£4,940	£55,860
25
26
27	Cat Visits: Choose your rate for visiting one cat household per day
28
29	Select Rate:	£16.00
30
31		Mon	Tue	Wed	Thu	Fri	Sat	Sun	Week	Month	Year
32	1 Household	£16	£16	£16	£16	£16	£21	£21	£122	£529	£5,978
33	2 Households	£32	£32	£32	£32	£32	£42	£42	£244	£1,057	£11,956
34	3 Households	£48	£48	£48	£48	£48	£63	£63	£366	£1,586	£17,934
35	4 Households	£64	£64	£64	£64	£64	£84	£84	£488	£2,115	£23,912
36	5 Households	£80	£80	£80	£80	£80	£105	£105	£610	£2,643	£29,890
37
38
39	Service Mix: Choose how many dogs and how many cat vists per day, and select the number of weeks holiday you would take per year
40
41	Select number of dogs per day (Mon - Fri)			6 Dogs
45	Select number of cat visits per day (Mon - Sun)			4 Households
46	Select your annual holiday			3 weeks
47
48
49	Annual Revenue Estimate: Based on your inputs above, your estimated revenue is show below *
50	The yearly revenue figures factor in your holiday and assumes all dog walking customers take 3 weeks holiday per year
51
52			Week	Month	Year
53	Dog Walking		£570	£2,470	£26,220
54	Cat Visits		£488	£2,115	£23,912
55	Total Estimated Revenue		£1,058	£4,585	£50,132
56
57	Fun Fact: This doesn't include any additional services you may choose offer, such as small animal boards or house sits
58
59	* The figures in this calculator are for illustrative purposes only and these revenues cannot be guaranteed
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103