ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Pricing Public Programs Worksheet
2
3
4
5
6
7
8
Use this template to create a budget proposal and calculate the costs of community programs you wish to propose. The spreadsheet will total the costs and also calculate the PD budget reduction in your city needed to pay for the program.
9
10
11
12
13
ANALOGY: Use this method if you want to expand an existing program e.g. "serve 25% more families through the existing family recreation program"
14
15
16
17
18
PARAMETRIC: Use this method if you know the unit cost to provide a service e.g. "provide emergency shelter to families experiencing temporary homelessness at a cost of $25 per family per night"
19
20
21
22
23
BOTTOM-UP: Use this method if you want to price out each component of the program e.g. "a job placement program to serve 2,500 people per month would need a staff of 25 and a budget of $1M per year"
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
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