Office of the Chief Financial Officer CITY OF DETROIT

CITY OF DETROIT
Office of the Chief Financial Officer
Financial Report for the 4 Months ended October 31, 2015
December 21, 2015
Table of contents
Item
Page
1. Executive summary
2
2. FY 2016 projection
3
3. October year to date (YTD) cash flow budget to actuals analysis
4
4. October YTD cash flow to general ledger reconciliation
5
5. October YTD property tax revenue collections
6
6. October accounts payable summary
7
7. Exit financing summary
8
8. October headcount budget to actual
9
10. External funding summary
10
OFFICE OF THE CHIEF FINANCIAL OFFICER
1
Executive summary
•
•
•
The Office of the CFO went live with Oracle Planning and Budgeting Cloud Services, the budget module of the financial
management system, in October 2015
•
City departments, in conjunction with the new Office of Departmental Financial Services, are finalizing their FY 2017
Budget Submission Request
•
The Office of the CFO will work with the Mayor’s Office to align the FY 2017 Budget with the Mayor’s priorities and work
with the City Council on its review and approval of the FY 2017 Budget
The Office of the CFO has had overwhelming interest in new positions as part of its restructuring. As of December 18, 2015, the
Office of the CFO has:
•
Made over 150 offers to middle management, professional, and paraprofessional candidates
•
Conducted over 650 structured interviews for professional and paraprofessional candidates
October YTD actuals indicate that FY 2016 results are favorable to budget
•
The primary tax revenues are based on the September 2015 Consensus Revenue Estimating Conference results. No
adjustment was warranted based on actual revenues collected since the Conference
•
Payroll and benefits related expenditures are projected to be below budget as a result of lower headcount, partially offset by a
higher number of contract staff and expected wage increases to the public safety employees
•
Reinvestment related expenditures are moving forward consistent with timing of project implementation as well as the
amount of Exit financing proceeds available
OFFICE OF THE CHIEF FINANCIAL OFFICER
2
FY 2016 is projected to result in a General Fund surplus
$ in millions
General Fund
Notes
General Fund Property taxes
Net Income taxes
Utility taxes
Gaming taxes
Distributable State aid
Other
Other operating revenues
Total Revenues
FY 2016
Projection (1)
$
(2)
(3)
(4)
Payroll, taxes, & deductions
Benefits
Pension contributions
Subsidy payments
Materials, contracts & other operating expenditures
$
Variance
100.8
268.4
15.9
169.0
197.4
284.9
35.1
1,071.5
$
16.2
(4.4)
24.1
3.3
(2.2)
(4.9)
(35.1)
(3.0)
(315.0)
(108.9)
(29.1)
(81.2)
(420.4)
(329.8)
(119.6)
(28.6)
(81.6)
(428.4)
14.8
10.8
(0.5)
0.4
8.0
Total Expenditures
(954.5)
(988.0)
33.5
Operating Surplus
114.0
83.5
30.5
(78.9)
(83.5)
4.6
35.1
0.0
35.1
Debt service
Surplus / (Deficit)
(5)
(5)
117.0
264.0
40.0
172.3
195.2
280.0
1,068.5
EM's
Budget
(6)
(7)
Notes:
(1) No adjustments were made to the projections based on YTD October activity
(2) EM's budget includes $12.5m transfer to the Public Lighting Authority (PLA). FY 2016 Projection reflects transfer in expenditures
(3) EM's budget includes Public Lighting Dept. (PLD) revenues from internal charges and reimbursements from DTE ($26m) and
grant receipts for blight ($9m), which will not flow through the General Fund
(4) FY 2016 Projection reflects September 2015 Consensus Estimating Revenue Conference results
(5) Lower projected expenditures due to vacant positions as a result of lower headcount, partially offset by projected public safety wage increases
(6) EM's budget includes PLD operating expenditures ($26m) and payments related to blight ($9m), which will no longer be incurred
by the General Fund. FY 2016 Projection includes $12.5m transfer to PLA
(7) Lower interest payment on Exit financing due to principal repayment
OFFICE OF THE CHIEF FINANCIAL OFFICER
3
The City’s YTD net cash flows are ahead of budget
$ in millions
General Fund
Actual
4 months
Prior Year
4 months
Difference
Budget (1)
4 months
Variance
General Fund Property taxes
Net Income taxes
Utility taxes
Gaming taxes
Distributable State aid
Other
Total Receipts
67.1
78.5
5.7
56.5
64.2
65.9
337.8
87.1
73.6
4.7
60.7
63.4
121.4
410.9
(20.1) (2)
4.9
1.0
(4.2)
0.8
(55.5) (4)
(73.1)
59.9
80.9
4.2
57.4
65.2
63.4
331.0
7.2
(2.4) (3)
1.5
(0.9)
(1.0)
2.5
6.8
Payroll, taxes, & deductions
Benefits
Pension contributions
Subsidy payments
Materials, contracts & other operating expenditures
(126.1)
(17.3)
(8.3)
(98.6)
(122.2)
(40.8)
(7.2)
(175.2)
(3.9)
23.4
(1.1)
70.5 (4)
(130.3)
(22.8)
(12.1)
(89.5)
4.3
5.5
3.8
(15.2) (5)
(250.3)
(345.3)
89.0
(254.7)
(1.6)
87.5
65.6
15.9
76.2
5.2
(62.7)
18.2
(44.5)
(28.3)
17.2
(11.1)
(28.2)
1.0
(27.3)
(26.5)
(44.6)
(71.2)
43.0
54.4
(11.4)
5.1
207.9
156.8
43.0
54.4
(0.0)
251.0
(0.2)
211.0
Total Disbursements
Operating Surplus (before Reinvestment)
Financing Adjustments
Non-Financing Adjustments
Total Adjustments to arrive at Net Cash Flow
Net Cash Flow (8)
Memo:
Beginning cash balance (net of dist. owed) (9)
Net Cash Flow (8)
Lockbox reserves
Ending cash balance (net of dist. owed) (9)
(30.0) (6)
62.8 (7)
32.8
38.0
Notes:
(1) Budget has been spread based on historical cash activity.
(2) Negative difference versus prior year primarily due to Wayne County settlement checks as a result of foreclosure activity.
(3) $4m in income tax refunds issued in FY'16 are related to FY'15.
(4) Negative trend in other receipts is offset by positive trend in materials, contracts & other operating expenditures and is primarily attributable to the segregation of DPW, BSEED, and Grants proceeds.
(5) Variance partially due to Bankruptcy-related payments not included in the Budget.
(6) Actuals include $30m principal repayment on Exit financing made in August 2015.
(7) Actuals include property tax collections related to Wayne County foreclosure activity. Budget includes $44.6m of reinvestment payments in excess of Exit financing proceeds.
(8) Net Cash Flow was determined based on General Fund cash activity adjusted for known deposits in transit, prior period adjustments and classification differences.
(9) The main operating account contains cash balances of the Risk Management Fund, Construction Fund, Street Funds, Solid Waste Fund, General Grants, and Motor Vehicle Fund.
OFFICE OF THE CHIEF FINANCIAL OFFICER
4
Differences between cash and general ledger YTD are mostly due to the period in which activity was
recorded
$ in millions
General Fund
General Fund Property taxes
Net Income taxes
Utility taxes
Gaming taxes
Distributable State aid
Other
Total Receipts
Payroll, taxes, & deductions
Benefits
Pension contributions
Subsidy payments
Materials, contracts & other operating expenditures
Notes
Cash Actual
$
(1)
(2)
(1)
(3)
(4)
(5)
(6)
Total Disbursements
Operating Surplus (before Reinvestment)
Financing Adjustments
Non-Financing Adjustments
Subtotal Adjustments
Net Surplus/(Deficit)
(7)
(8)
$
67.1
78.5
5.7
56.5
64.2
65.9
337.8
Posted
$
General Ledger
To Be Posted
67.8 $
61.6
1.7
13.7
33.9
178.6
Total
$
4.0
42.9
5.0
51.9
Difference
67.8
61.6
5.7
56.5
38.9
230.5
$
0.7
(16.9)
0.0
(64.2)
(27.0)
(107.3)
(126.1)
(17.3)
(8.3)
(98.6)
(99.2)
(29.7)
(10.0)
(42.0)
(11.8)
-
(111.0)
(29.7)
(10.0)
(42.0)
15.1
(12.4)
(1.8)
56.6
(250.3)
(181.0)
(11.8)
(192.8)
57.5
87.5
(2.4)
40.1
37.7
(49.9)
(62.7)
18.2
(44.5)
(19.0)
(19.0)
-
(19.0)
(19.0)
43.6
(18.2)
25.5
43.0
$
(21.4) $
40.1
$
18.6
$
(24.4)
Notes:
(1) City records activity related to FY 2015 in the general ledger that was collected in FY 2016 (Income Taxes ($14m) and DSA ($64m))
(2) City will be recording amounts to be posted in the general ledger by the end of December
(3) Difference primarily due to $13m collected in FY 2016 to be recorded in FY 2015 and $6m of cash specific transactions
(4) Difference primarily due to cash actuals including payroll expenses incurred in FY 2015, but paid in FY 2016
(5) General Fund transferred less than total invoice amounts as the Benefits Fund (Fund 7500) had a cash balance of $13m at the beginning of the fiscal year.
(6) Cash actuals include grants ($3m), non-General Fund entities ($6m), cash specific transactions ($11m), and invoices related to FY 2015 paid in FY 2016 ($34m),
partially driven by the accounts payable amnesty program
(7) Cash actuals include Exit financing principal repayment ($30m) and set asides for both Note C ($4m) and DSA secured LTGO bonds ($10m)
(8) Cash actuals include collections from FY 2015, primarily related to property tax revenues ($17m)
OFFICE OF THE CHIEF FINANCIAL OFFICER
5
The collection rate for City property taxes YTD is marginally better than the prior year
$ in millions
Adjusted tax
roll (1)
General City
Debt Service
Solid Waste
Total City (3)
FY 2016
Collections
YTD (2)
Collection
rate
Adjusted tax
roll (1)
FY 2015
Collections
YTD (2)
Collection
rate
$
131.8 $
69.6
59.6
62.8
32.1
19.0
47.7%
46.2%
31.9%
$
132.6 $
73.8
57.0
59.0
33.5
17.5
44.5%
45.4%
30.8%
$
260.9 $
113.9
43.7%
$
263.3 $
110.1
41.8%
Note:
(1) The adjusted tax roll is a full year amount and includes amounts which may not have been billed yet by the City.
(2) Amounts do not include collections from Wayne County settlement checks as a result of foreclosure activity.
(3) Amounts are net of property taxes collected on behalf of DPS, State Education Trust, Wayne County and other
Non-City taxing authorities.
OFFICE OF THE CHIEF FINANCIAL OFFICER
6
The City is paying invoices timely. Invoices on hold or bankruptcy related may take longer to pay
$ in millions
Aging by Department
(excluding Bankruptcy-Related AP and Invoices On Hold)
Department
1 Department of Public Works
2 Information Technology Services
3 Planning and Development Department
Accounts Payable (AP) as of 10/30/15
Total AP
$ 52.74
Less: Bankruptcy-Related AP (1)
(8.98)
Less: AP on Hold (2)
(22.48)
Net AP Not on Hold (3)
$ 21.28
4 Department of Transportation
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Historical Accounts Payable
Excluding Bankruptcy-Related and Invoices on Hold AP
$60
$50
$40
$30
$36.82
$34.64
$23.70
$25.81
$31.57
$27.31
$28.02
$21.28
$22.77
$10
$Feb
Mar
Apr
May
Net AP Not
on Hold
Recreation Department
Health Department
Police Department
Public Lighting Department
Law Department
General Service Dept
Fire Department
Non-Departmental
Municipal Parking Department
36th District Court
Buildings and Safety Department
Airport Department
Department of Elections
Library
City Council
Department of Administrative Hearings
Other Departments (21 depts)
Subtotal - Non DWSD
1.20
$
$18.35
$20
Jan
Days Past Due
Net AP
Current
1-30
31-60
61-90
91+
$
2.61 $
0.68 $ 0.72 $ 0.22 $ 0.27 $ 0.72
2.29
1.00
0.08
0.01
1.20
(0.00)
1.45
0.06
0.85
0.19
0.34
0.01
Jun
Jul
Aug
Sep
Oct
Water Department
Sewerage Department
Subtotal - DWSD
$
Total
$
1.02
0.11
0.08
-
(0.01)
0.93
0.91
0.77
0.49
0.42
0.41
0.40
0.32
0.27
0.17
0.08
0.06
0.06
0.05
0.01
0.01
0.02
12.93 $
100%
0.03
0.08
0.30
0.60
5.65
0.15
0.08
0.38
0.38
0.29
0.22
0.11
0.06
0.21
0.29
0.08
0.09
0.33
0.00
0.00
0.03
0.00
0.01
0.00
0.01
0.00
0.01
0.00
0.00
1.49
0.00
11.40 $ 4.03 $
88%
31%
0.65
0.12
0.05
0.00
0.07
0.00
0.05
0.01
0.00
0.00
1.44 $
11%
0.02
0.01
0.01
0.00
0.01
0.05
0.04
0.00
0.01
0.00
1.97 $
15%
0.15
0.12
0.01
0.01
0.07
0.06
0.03
0.06
0.04
0.05
0.00
0.00
0.00
1.33
10%
5.65
2.69
8.35 $
1.04
3.72
0.34
1.82
1.38 $ 5.53 $
0.68
0.28
0.96 $
0.06
0.05
0.11 $
0.16
0.22
0.38
21.28 $
100%
12.78 $ 9.56 $
60%
45%
2.41 $
11%
2.08 $
10%
1.70
8%
Notes:
(1) Bankruptcy-related invoices are excluded as they will not be paid in the ordinary course, but instead will be resolved as part of the bankruptcy process.
(2) Invoices typically placed on a system hold are pending validation.
(3) Total Net AP Not on Hold include retainage holdbacks to be paid upon completion of projects, which total $2.9m primarily in amounts over 31 days past due.
OFFICE OF THE CHIEF FINANCIAL OFFICER
7
Exit financing proceeds have been used to jump start improving technology, neighborhoods, and
public safety
• Total number of projects decreased by two from the September report due to a facilities capital project that was
consolidated under General Services
$ in millions
Number of
Projects
Available Exit financing proceeds
Project Allocation:
Dept. of Innovation and Technology
Blight
Police
Fire
General Services
OCFO
BSEED
Law
DDOT
Recreation
Human Resources
Other
Total
Amount
Approved
$
5 $
7
6
9
13
6
1
1
1
1
2
3
55 $
Interest/Fees Paid
Total
Amount Paid
233.2
(34.2) $
(29.7)
(29.0)
(22.0)
(20.3)
(15.7)
(4.4)
(2.2)
(1.8)
(1.2)
(0.8)
(0.3)
(161.6) $
(19.8)
(17.6)
(17.0)
(10.6)
(17.1)
(14.7)
(1.2)
(0.4)
(1.8)
(1.2)
(0.7)
(2.9)
(105.1)
(2.8)
Amount reserved for projects under review
$
OFFICE OF THE CHIEF FINANCIAL OFFICER
68.9
8
General City headcount is increasing and remains under budget
Actual
Oct'14
Actual
Oct'15
Budget
FY 2016 (1)
Variance
% Variance
2,683
1,158
3,841
2,766
1,234
4,000
2,990
1,339
4,329
224
105
329
7%
8%
8%
10
370
182
7
77
92
36
86
49
10
175
271
128
353
46
1,892
8
360
182
8
81
96
33
94
56
5
176
299
96
353
62
1,909
16
345
219
8
95
130
48
103
62
17
116
457
97
353
75
2,141
8
(15)
37
0
14
34
15
9
6
12
(60)
158
1
0
13
232
11%
Total General City
5,733
5,909
6,470
561
9%
Enterprise
Airport
BSEED
Transportation
Parking
Water/Sewerage
Library
Total Enterprise
3
175
916
84
1,477
315
2,970
3
178
999
85
1,310
297
2,872
4
205
917
94
1,674
334
3,228
1
27
(82)
9
364
37
356
11%
Total City
8,703
8,781
9,698
917
9%
Public safety
Police
Fire (2)
Total Uniform
Non-public safety
Budget
Dept. of Public Works (3)
Finance
Health & Wellness
Human Resources
Housing & Revitalization/Planning & Development
Dept. of Innovation and Technology
Law
Mayor
Public Lighting Dept.
Recreation (3) (4)
General Services (3)
Legislative (5)
36th District Court
Other (6)
Total Civilian
Notes:
(1) Includes positions for reinvestment projects that have been approved for funding.
(2) Budget reflects 1,189 FTE per Four Year Financial Plan and 150 funded by SAFER grants.
(3) Includes seasonal workers anticipated to complete work at the departments in the near-term.
(4) Budget for Recreation includes FTEs, however, actuals are reported by headcount including seasonal (temporary) workers.
(5) Includes: Auditor General, Zoning, City Council, Ombudsperson, City Clerk, and Elections.
(6) Includes: Human Rights, Administrative Hearings, Homeland Security, Non-departmental, and some reinvestment.
OFFICE OF THE CHIEF FINANCIAL OFFICER
9
The City is leveraging funding from external sources
• During October, the Office of Grants Management worked with departments to close out grants that had been fully expended
• The City received 13 new grants in Housing & Revitalization, Police, and Recreation
$ in millions
Amount
Awarded
Department
Housing & Revitalization
Transportation
Fire
Health & Wellness Promotion
Public Works
Police
Recreation
Homeland Security and Emergency Management
General Services
Other (1)
Active Federal/State grants (2)
$
$
Active private grants
Active private donations
Total active grants and donations
$
Number
of Grants
252.6
163.9
33.4
26.2
35.1
28.8
4.8
1.5
1.5
1.9
549.7
20
39
8
4
24
38
23
6
2
10
174
17.9
17
20.7
588.3
31
222
Notes:
(1) Other includes BSEED, Airport, and Office of Grants Management
(2) Total does not include Hardest Hit Fund grants, which are reflected in the Land Bank Authority
OFFICE OF THE CHIEF FINANCIAL OFFICER
10
Page Intentionally Left Blank
OFFICE OF THE CHIEF FINANCIAL OFFICER
11
City of Detroit
FY14 Single Audit
3-Year Comparison
Year
Number of Findings
Amount of Questioned Costs
2012
2013
92
63
$ 14,814,652.00 $ 18,512,118.00 $
Number of Findings
100
90
80
70
60
50
40
30
20
10
0
92
63
41
2012
2013
2014
Number of Findings
Amount of Questioned Costs
$20,000,000.00
$18,000,000.00
$16,000,000.00
$14,000,000.00
$12,000,000.00
$10,000,000.00
$8,000,000.00
$6,000,000.00
$4,000,000.00
$2,000,000.00
$-
$18,512,118.00
$14,814,652.00
$11,918.00
2012
2013
Amount of Questioned Costs
2014
2014
41
11,918.00
89 (Rev. 04-15)
RICK SNYDER
GOVERNOR
STATE OF MICHIGAN
DEPARTMENT OF TREASURY
LANSING
NICK A. KHOURI
STATE TREASURER
DETROIT FINANCIAL REVIEW COMMISSION
RESOLUTION 2015-18
CONSENTING TO THE CITY’S TIME EXTENSION FOR ITS ANNUAL
AUDIT REPORT FOR THE FISCAL YEAR ENDED JUNE 30, 2015
WHEREAS, Public Act 181 of 2014, the Michigan Financial Review Commission Act
(the “Act”), allows for the creation of the Detroit Financial Review Commission (the
“Commission”) within the Michigan Department of Treasury; and
WHEREAS, Section 6(1) of the Act empowers the Commission to provide oversight for
the City of Detroit (the “City”) beginning on the Effective Date of the Plan of Adjustment; and
WHEREAS, Section 6(3) of the Act requires the Commission to ensure that the City
complies with the requirements of, among other things, MCL 141.427(4); and
WHEREAS, MCL 141.427(4) requires that the City file with the State Treasurer its
annual audit report for the fiscal year ended June 30, 2015 no later than December 31, 2015; and
WHEREAS, the City has requested the State Treasurer to extend the date by which it
must file its annual audit report for the fiscal year ended June 30, 2015 from December 31, 2015
to no later than March 31, 2016, and the State Treasurer is willing to consent to such extension
pursuant to MCL 141.427(4); and
WHEREAS, the City has requested this Commission to similarly extend the date to file
its annual audit report to no later than March 31, 2016.
NOW THEREFORE, be it resolved by the Detroit Financial Review Commission as
follows:
1
1.
That the Commission hereby consents to the extension of time for the City to
complete and file its annual audit report for the fiscal year ended June 30, 2015
with the State Treasurer from December 31, 2015 to no later than March 31,
2016.
2.
That the minutes of the Detroit Financial Review Commission meeting at which
this Resolution is adopted take notice of the adoption of this Resolution.
3.
This Resolution shall have immediate effect.
2
IN WITNESS WHEREOF, the members of the Commission, or their designees, have signed and
adopted this Resolution.
DETROIT FINANCIAL REVIEW COMMISSION
By
Darrell Burks, Detroit Financial Review Commission
Member
By
Michael Duggan, Detroit Financial Review
Commission Member
By
Stacy Fox, Detroit Financial Review Commission
Member
By
Lorron James, Detroit Financial Review Commission
Member
By
Brenda Jones, Detroit Financial Review Commission
Member
By
Nick A. Khouri, State Treasurer and Detroit Financial
Review Commission Member
By
William Martin, Detroit Financial Review
Commission Member
By
John S. Roberts, Detroit Financial Review
Commission Member
By
Tony Saunders, Detroit Financial Review Commission
Member
Date: ____________________
Detroit, Michigan
DETROIT 56620-1 1347403v2
3
89 (Rev. 04-15)
RICK SNYDER
GOVERNOR
STATE OF MICHIGAN
DEPARTMENT OF TREASURY
LANSING
NICK A. KHOURI
STATE TREASURER
DETROIT FINANCIAL REVIEW COMMISSION
RESOLUTION 2015-19
APPROVING THE COLLECTIVE BARGAINING AGREEMENT
AMENDMENTS BETWEEN THE CITY OF DETROIT AND THE
DETROIT POLICE OFFICERS ASSOCIATION, THE DETROIT POLICE
LIEUTENANTS AND SERGEANTS ASSOCIATION, AND THE DETROIT
POLICE COMMAND OFFICERS ASSOCIATION
WHEREAS, Public Act 181 of 2014, the Michigan Financial Review Commission Act
(the “Act”), allows for the creation of the Detroit Financial Review Commission (the
“Commission”) within the Michigan Department of Treasury; and
WHEREAS, Section 6(1) of the Act empowers the Commission to provide oversight for
the City of Detroit (the “City”) beginning on the Effective Date of the Plan of Adjustment; and
WHEREAS, Section 6(9) of the Act requires that during the period of oversight, the City
shall submit new and amended collective bargaining agreements, to which it is a party, to the
Commission for review and approval after approval by the City’s governing body and mayor;
and
WHEREAS, Section 6(9) of the Act further requires the Commission to approve or reject
collective bargaining agreements submitted to it within 45 days of submission; and
WHEREAS, the Mayor and City Council of Detroit approved collective bargaining
agreement amendments between the City of Detroit and the Detroit Police Officers Association,
the Detroit Police Lieutenants and Sergeants Association, and the Detroit Police Command
Officers Association on December 17, 2015, for a term expiring June 30, 2020; and
1
WHEREAS, at the Commission meeting on December 21, 2015, the City presented the
aforementioned collective bargaining agreement amendments to the Commission.
NOW THEREFORE, be it resolved by the Detroit Financial Review Commission as
follows:
1.
That the City’s collective bargaining agreement amendments between the City of
Detroit and the Detroit Police Officers Association, the Detroit Police Lieutenants
and Sergeants Association, and the Detroit Police Command Officers Association,
presented to the Commission on December 21, 2015, are hereby approved.
2.
That the minutes of the Detroit Financial Review Commission meeting at which
this Resolution is adopted take notice of the adoption of this Resolution.
3.
This Resolution shall have immediate effect.
2
IN WITNESS WHEREOF, the members of the Commission, or their designees, have signed and
adopted this Resolution.
DETROIT FINANCIAL REVIEW COMMISSION
By
Darrell Burks, Detroit Financial Review Commission
Member
By
Michael Duggan, Detroit Financial Review
Commission Member
By
Stacy Fox, Detroit Financial Review Commission
Member
By
Lorron James, Detroit Financial Review Commission
Member
By
Brenda Jones, Detroit Financial Review Commission
Member
By
Nick A. Khouri, State Treasurer and Detroit Financial
Review Commission Member
By
William Martin, Detroit Financial Review
Commission Member
By
John S. Roberts, Detroit Financial Review
Commission Member
By
Tony Saunders, Detroit Financial Review Commission
Member
Date: ____________________
Detroit, Michigan
DETROIT 56620-1 1347403v2
3
11/25/2015
Summary of Detroit Police Officers (DPOA), Detroit Lieutenants and Sergeants
(DPLSA), and Detroit Police Command Officer (DPCOA) Collective Bargaining Proposal
History
DPOA, DPLSA, and DPCOA took a 10% cut in wages in 2012, in addition to pension and health
care cuts received by other unions. In 2014, under collective bargaining agreements ratified
during bankruptcy, DPOA received an 8% base wage increase and DLSA and DPCOA received
5%. DPOA received higher base wage because they agreed to significant work rule changes
that paid for the difference.
Comparison of Detroit Police Officer wages compared to other surrounding cities
Starting Officers
Detroit Today
Southfield
Sterling Hts.
Warren
Farm Hills
$31,700
$43,100
$43,800
$45,800
$49,600
5 Year Officers
Detroit Today
Southfield
Sterling Hts.
Warren
Farm. Hills
$51,700
$62,200
$75,500
$64,900
$71,400
The Impact: We currently have 221 vacant police officer positions
Average Attrition Rate: 13 per month (160 per year)
160
New officers needed to be hired over 12 months for full force:
381
Filling Police Officer Positions: The 6 Month Training Academies
New officers go through a 6-month training academy before being placed in service.
Goal is to hire 180 new officers a year to offset 160 currently leaving. If we can cut attrition to
10 per month, (120 per year), we can gain 60 filled positions a year.
Training Academy Schedule for FY 15-16:
July 20, 2015
27 (20 remaining in class)
Sept 28, 2015
24 (19 remaining in class)
Nov 23, 2015
16 (14 remaining in class)
Jan 18, 2016
30
11/25/2015
Recommended Proposal for New CBAs for 3 Police Unions
A new contract would be based on meeting 3 goals:
1) Dramatically improve the quality and quantity of new police officer applicants
2) Increase the commitment to education/professionalism in the department
3) Cut the attrition rate for sworn officers from 13 per month to 10 per month
The Proposal:
1)
2)
3)
4)
5)
Raise all sworn officers salaries 4% effective 1/1/16
Give 2% wage bump to all DPOA members with minimum 2 years of college
Give 2% wage bump to all DPLSA members with minimum 4 years of college
Offer all sworn officers tuition reimbursement up to $2,000 per year
Raise starting salary from $31,700 to $36,000
Sources of Funding will come from exit financing and restructuring savings from the POA.
A Step Toward Competitive Wages After Proposed CBA
Starting Officers
Detroit Today
Detroit Proposed
Southfield
Sterling Hts.
Warren
Farm Hills
$31,700
$36,000 ($36,700 w/ educ)
$43,100
$43,800
$45,800
$49,600
5 Year Officers
Detroit Today
Detroit Proposed
Southfield
Sterling Hts.
Warren
Farm. Hills
$51,700
$53,800 ($55,000 w/ educ)
$62,200
$75,500
$64,900
$71,400
11/25/2015
Comparison of 2014 Police CBA’s with Tentative 2015 CBA’s
Collective Bargaining Agreements Entered into with Command Officers’ Association (COA),
Detroit Police Lieutenants and Sergeants Association (DPLSA), and Detroit Police Officers
Association (DPOA) during the bankruptcy process:
DCOA Base Pay Increases
2014 CBA
7/1/14 5.0%
7/1/16 2.5%
7/1/17 2.5%
7/1/18 2.5%
12.5% thru 6/30/19
Proposed 2015 CBA
7/1/14
1/1/16
7/1/16
7/1/17
7/1/18
7/1/19
5.0%
4.0%
2.5%
2.5%
2.5%
3.0%
19.5% over thru 6/30/20
DPLSA Base Pay Increases
2014 CBA
7/1/14 5.0%
7/1/16 2.5%
7/1/17 2.5%
7/1/18 2.5%
12.5% thru 6/30/19
Proposed 2015 CBA
7/1/14
1/1/16
7/1/16
7/1/17
7/1/18
7/1/19
5.0%
4.0%
2.5%
2.5%
2.5%
3.0%
19.5% over thru 6/30/20
DPOA Base Pay Increases
2014 CBA
10/1/14 8.0%
7/1/16 2.5%
7/1/17 2.5%
7/1/18 2.5%
15.5% thru 6/30/19
Proposed 2015 CBA
10/1/14
1/1/16
7/1/16
7/1/17
7/1/18
7/1/19
8.0%
4.0%
2.5%
2.5%
2.5%
3.0%
22.5% over thru 6/30/20
Note: Under the bankruptcy CBA, all unions also received 3% in one-time bonuses in 2015
DPCOA Contract Proposals
I.
Contract Extension
The Contract will be extended from
its current expiration date of June
30, 2019 to June 30, 2020.
II.
Wage Increases
a. 4% wage increase effective on
January 1, 2016. Future wage
increases remain the same as
currently in the contract.
-
Each course must grant college
level credits
-
Each member must receive at
least a “C” grade in the course
-
In pass/fail courses, member
must receive a “pass” grade
-
Proof of enrollment, tuition
payment
and
course
completion is required to
receive tuition reimbursement
-
Tuition will be reimbursed for
the following types of education:
b. 3% wage increase effective July 1,
2019.
III. Tuition Reimbursement
City agrees to provide tuition
reimbursement up to a maximum of
$2,000 per fiscal year to cover
classes necessary in securing an
Associate’s, Bachelor’s, Master’s,
Law or Doctorate Degree.
To Be Eligible for Reimbursement:
-
Member
must
have
successfully completed one (1)
year of continuous service
-
Each course must be taken
through an accredited college
or university
o Coursework that is
directly job-related or
expands the employee’s
overall job skills
IV. Employee Referral Incentive.
A member shall receive $250 for
every individual referred and hired
into uniformed and essential DPD
positions as identified by the Director
of Police Personnel, in conjunction
with the Chief of Police.
DPLSA Contract Proposals
I.
Contract Extension
The Contract will be extended from
its current expiration date of June
30, 2019 to June 30, 2020.
II.
Wage Increases
a. 4% wage increase effective on
January 1, 2016. Future wage
increases remain the same as
currently in the contract.
b. 3% wage increase effective July
1, 2019.
c. Stand By Time Compensation
Stand by time is defined as that time
a member is scheduled to be
available to work in case of
emergency.
The member is compensated for
being required to be available to
provide emergency services during
a specified period of time.
Scheduling is determined by
departmental procedures.
If
scheduled, a member can pursue
personal activities, but when
called must be able to promptly,
effectively carry out their duties
while designated to be on stand
by time.
-
In pass/fail courses, member
must receive a “pass” grade
All members scheduled pursuant to
department stand by procedures
will be compensated at the following
rate: one (1) hour of straight time
earned for every eight (8) hours of
stand by time. For the one (1) hour
of straight time the member shall
have the option of pay or
compensatory time.
-
Proof of enrollment, tuition
payment
and
course
completion is required to
receive tuition reimbursement
-
Tuition will be reimbursed for
the following types of education:
o Coursework that is
directly job-related or
expands the employee’s
overall job skills
III. Tuition Reimbursement
City agrees to provide tuition
reimbursement up to a maximum of
$2,000 per fiscal year to cover
classes necessary in securing an
Associate’s, Bachelor’s, Master’s,
Law or Doctorate Degree.
To Be Eligible for Reimbursement:
-
Member
must
have
successfully completed one (1)
year of continuous service
-
Each course must be taken
through an accredited college
or university
-
Each course must grant college
level credits
-
Each member must receive at
least a “C” grade in the course
IV. Employee Referral Incentive.
A member shall receive $250 for
every individual referred and hired
into uniform and essential DPD
position as identified by the Director
of Police Personnel, in conjunction
with the Chief of Police.
V. Wage-Differential Language
Beginning January 2016, any
member covered by this
Agreement who has attained at
least four (4) years of college
credits from an accredited
college or university shall
receive a 2% wage increase of
DPLSA Contract Proposals
their
base salary, upon
submission of transcripts.
Qualifications incentives are not
included in the wage differential
language.
VI. Work Rule Concessions.
a. 4 hour sick day language in
paragraph 35(c) of the contract will
be changed to be limited to one
occurrence per quarter of the
year.
DPOA Contract Proposals
I.
Contract Extension
The Contract will be extended from its
current expiration date of June 30, 2019
to June 30, 2020.
II.
Wage Increases
a. Starting salary for Police Officers will
increase to $36,000 effective January 1,
2016.
b.
Five Year Police Officer wages
increased by 4% wage effective January
1, 2016.
c. Steps increased accordingly to reflect
new starting salary and Five Year Police
Officer wages.
Scheduling
is
determined
by
departmental procedures. If scheduled,
a member can pursue personal
activities, but when called must be
able to promptly, effectively carry out
their duties while designated to be on
stand by time.
All members scheduled pursuant to
department stand by procedures will be
compensated at the following rate: one
(1) hour of straight time earned for every
eight (8) hours of stand by time. For the
one (1) hour of straight time the member
shall have the option of pay or
compensatory time.
III. Tuition Reimbursement
e. 3% wage increase effective July 1,
2019.
City agrees to provide tuition
reimbursement up to a maximum of
$2,000 per fiscal year to cover classes
necessary in securing an Associate’s,
Bachelor’s, Master’s, Law or Doctorate
Degree.
Stand By Time Compensation
To Be Eligible for Reimbursement:
Stand by time is defined as that time a
member is scheduled to be available
to work in case of emergency.
-
d. Future wage increases in current
contract remain.
The member is compensated for being
required to be available to provide
emergency services during a specified
period of time.
-
Member must have successfully
completed one (1) year of
continuous service after successful
completion of the Police Academy
Each course must be taken through
an accredited college or university
-
Each course must grant college
level credits
-
Each member must receive at least
a “C” grade in the course
-
In pass/fail courses, member must
receive a “pass” grade
-
Proof of enrollment, tuition payment
and course completion is required to
receive tuition reimbursement
-
Tuition will be reimbursed for the
following types of education:
o Coursework that is directly
job-related or expands the
employee’s overall job skills
IV. Employee Referral Incentive.
A member shall receive $250 for every
individual referred and hired into uniform
and essential DPD positions as identified
by the Director of Police Personnel, in
conjunction with the Chief of Police.
V. Wage-Differential Language
Beginning January 2016,
any
member covered by this Agreement
who has attained at least two(2)
years of college credits from an
accredited college or university
shall receive a 2% wage increase of
DPOA Contract Proposals
their base salary, upon submission
of transcripts.
VI. Work Rule Concessions.
a. 4 hour sick day language in
paragraph 34(c) of the contract will be
changed to be limited to one
occurrence per quarter of the year.
DWSD-R: POST BIFURCATION OVERVIEW
FRC DISCUSSION
12/21/2015
CONFIDENTIAL
1
The conditions precedent for the leasing of water and sewer operating assets
to GLWA have been completed; allowing for a January 1 bifurcation of DWSD
► Bondholder consents have been secured
► Shared services agreements between DWSDR and GLWA have been approved by the
BOWC, Mayor and the GLWA board
► Agreement on methodology for allocating pension funding and investment expenses to
GLWA / DWSDR has been completed
► Wholesale customers have agreed to the assignment of contracts from DWSDR to GLWA
CONFIDENTIAL
2
After the 1/1/2016 bifurcation of DWSD the remaining local system will be a
425 employee $466 million organization
DWSD Annual Revenue Distribution
City Equity
6%
Lease
Payments
11%
Water Rates
23%
DWSD Employee Base Distribution
Facility Ops
4%
Back Office
Supprt
13%
Meter Ops
11%
Field
Operations
45%
Sewer Rates
60%
Total Revenue ~ $466 MM
•
•
CONFIDENTIAL
Customer
Service
27%
Employees ~ 425 FTEs
Currently operating with approximately 394 FTE’s
Biggest headcount gaps in meter operations and customer
service
3
DWSD has assembled an executive team with a broad array of experience to
move the operations forward
Team Member
Position
Background
Gary Brown
• Executive
Director
•
•
•
•
•
•
•
•
•
BS Degree from Wayne State University
Master's Interdisciplinary Technology - Eastern Michigan University
26 Years - Detroit Police Executive
3.5 Years - President Pro Tem - Detroit City Council
18 Months Chief Operating Officer - City of Detroit (Bankruptcy)
2 Years Chief Operating Officer - Mayor Michael Duggan Administration
18 Months - Member of Root Cause Committee for DWSD under Judge Sean Cox
Vice Chair of Great Lakes Water Authority
Interim Director of DWSD
Rob Presnell
• Chief Operating
Officer
•
•
•
•
Tier One Consulting background in Strategy, Operations and Technology
MBA from Ross School of Business at the University of Michigan
Served as Chief of Staff and Special Projects for Detroit COO during bankruptcy
Experience with both public and private entities delivering multi-million dollar transformation projects
Palencia Mobley
• Deputy Director / • 15 Years of Engineering Planning, Design and Construction Experience for municipal water and
Chief Engineer
wastewater utilities
• Licensed for 10 Years as Professional Engineer in the State of Michigan
• BS Chemical Engineering (University of Michigan) and MS Civil Engineering (Wayne State University)
• Specializes in Asset Mgmt. and Capital Improvement Program Mgmt.
• Focused on data driven decision making for optimal organizational efficiency
Marcus Hudson
• Chief Financial
Officer
CONFIDENTIAL
•
•
•
•
•
23 Years of Financial, Operational, and Strategy experience
MBA from University of Michigan
Extensive restructuring experience
CPA, CMA, Certified Turnaround Professional, Certified Insolvency & Restructuring Advisor
Served as VP of Purchasing / Supply Chain and Treasurer for $1 billion public company
4
DWSD continues to collect retail revenues; however, collections are pledged to
GLWA and run through a “flow of funds” before DWSD can use for I&E
DWSD
Customer Payments:
• Kiosks
• Customer Service Cash
& Checks
• IVR Credit / Debit
• Lockbox
DWSD Bank Accounts
DWSD O&M Account
GLWA Trustee
Receiving Funds
DWSD O&M
Operating Pension
Debt Service
Non-Oper. Pension
WRAP Contribution
DWSD I&E Account
Budget Stabilization
DWSD Construction Account
ER&R
Available for I&E
CONFIDENTIAL
5
DWSD and GLWA will continue to share certain back office functions; each
party will pay the other for services received
GLWA vs. DWSD Shared Service Costs
GLWA Ops
DWSD Ops
(1)
$9.3 million
$5.8 million
$0.6 million
$3.5 million
$4.0 million
$3.4 million
GLWA Services
DWSD Services
Ops
IT
► On balance, DWSD will pay GLWA $5.3
million, most of this relates to IT
$10,000,000 services
– IT servers transferred to GLWA
$9,000,000
– Requisition and inventory
management systems transferred
$8,000,000
to GLWA
$7,000,000
– Required IT personnel support
$6,000,000 ► Payments for shared services will be
netted on a monthly basis
– Invoices will be created listing all
$5,000,000
shared service charges
$4,000,000
– CFO’s of GLWA and DWSDR will
confer on appropriate net payment
$3,000,000
for the month
$2,000,000 ► The shared services agreements
contain true-up provisions
$1,000,000
– Cost allocations will be evaluated
by an independent third party
$0
– Under or overpayments will be
settled in cash
(1) Excludes approximately $38,000 in payment for procurement services
CONFIDENTIAL
6
Cumulative Fund Availability
DWSD’s ability to generate funds for system improvement will ride on our
ability to improve and sustain our collection rate above 85%
► DWSD lease payments can be used for
Impact of Collection Rates on Lease Payment
one of three purposes
Availability & I&E Availability (1)
– Paydown of debt in support of rates
$120,000
World Class Rate
– Improvement & extension of the
~ 95%
local system
~
$88
million
$100,000
– Monetization for construction
available for I&E
► In FY 2016, DWSD used approximately
$22 million to support rates; without
$80,000
improvement in collection rates this
Current Rate ~
amount is likely to continue
$60,000
86%
– Volumes are flat to declining
~ $32 million
– Organization has already reduced
available for I&E
headcount significantly
$40,000
– Costs are likely to rise, not fall
going forward
$20,000
► World class collection rates exceed
95%; achieving this rate would raise an
$0
additional $56 million for investment
75% 78% 80% 83% 85% 88% 90% 93% 95% 98% 100%
– Cut system replacement time from
Population Shift
50 years to 20
Available Water Funds
Available Sewer Funds
– Improve self funding viability
Additional I&E Availability
– Improve pipe leakage issues;
reducing customer costs
(1) All figures calculated assuming 4% maximum rate increase
CONFIDENTIAL
7
Shut-offs will only take us so far – optimizing the collection rate requires
redefining DWSD as a customer oriented organization; this is our mission
Refocusing DWSD Priorties
► While shut-offs can be somewhat successful in driving increased collection; it’s limited in
its ability to drive sustainable value
– Expensive to conduct
– Promotes conflict between the utility and the customer and a desire to “beat the system”
– Doesn’t address root causes of non-payment including accessibility and affordability
► Reaching the goal of making DWSD a world class organization will require a different
approach: the customer has to be first. Accordingly, we are redefining the priorities of our
organization…
► …First priority: Improve customer service
► …Second priority: See our first priority
► …Third priority: See the first two priorities
CONFIDENTIAL
8
To hit the ground running, we have already begun formulating projects
around the “three A’s” of customer management to support our mission
DWSD Project Focus / Thought Starters
Three A’s
Purpose
Projects / Studies
Potential Impact
Accountability
• Drive personal
accountability to
customers that have an
ability to pay
• Upgrading of IT systems to
become PCI compliant
• Linking of accounts to names and
social security numbers
• Changes in account opening
process
• Examination of landlord / tenant
requirements
• Tie accounts to responsible
parties; decreasing ability to
“walk away” from bad debt
• Redirect bills to parties ultimately
responsible for properties
• Decrease bad debts built into
rate structure
Accessibility
• Improve convenience of
paying for customers
• Increase customers
ability to contact DWSD
• Leverage of DTE payment Kiosk
infrastructure
• Upgrading / improving of IVR
system
• Centralized complaint system
• Increased customer payment
touch points
• Quicker / focused response to
customer complaints
• Improvement in cash collections
Affordability
• Minimize cost of service
for all customer classes
and ensure equitable
allocation of costs
between classes
• Blue Ribbon Panel study
• Examination of rate allocations &
wholesale rate advocacy
• Investment in green infrastructure
• Investigation into broader fund
source for plumbing retrofit
• Revision of drainage charges
• Lower costs for low usage
customers
• Improve efficiency of system
• Improve efficiency of extended
infrastructure; i.e., housing stock
• Reduce allocation of fixed
charges to retail customers
CONFIDENTIAL
9
Though there is some low hanging fruit, implementation of projects and
“fixing” the department will take time
► Significant data clean-up issues must be resolved
– Billing / customer data
– Fixed asset data
► System upgrades / modifications required to billing system to support potential changes in
rate calculations
– Multiple rates blocks
– Impervious area charges
► System requirements for integration into DTE kiosks yet to be defined
► Cost studies required to support changes in rate structure and allocation methodology
► Legal review of any proposed changes in landlord / tenant arrangements and drainage
revisions
CONFIDENTIAL
10
Appendix: Detroit Resident Dynamics
CONFIDENTIAL
11
In hopes of facilitating an affordability solution, we have analyzed the Detroit
customer base to answer several basic questions
DETROIT RESIDENTIAL ANALYSIS OVERVIEW
The Data
Questions
• Monthly CCF usage of 128,000 Households out of 217,000 retail customers with focus on 1”
pipe size and lower
– Eliminated churches
– Eliminated residential businesses
– Eliminated outliers
• Households grouped into 1,017 census tracts for regression analysis
Why Its Important
What We Found
What are the drivers of
water usage?
• Determines focus, design, and potential
effectiveness of varying water affordability programs
• Income, household population,
structural age major drivers of usage
What is the basic level of
water use in the typical
Detroit?
• Points to most basic level of monthly usage; i.e.,
lifeline usage
• Determines potential starting point for inclining
blocks
• Base water usage appears to
approximate 2.5 CCF for a household
of two at the lowest income levels
What is the distribution of
water usage for Detroit
customers
• Determines reach of potential solutions; i.e., who is
aided by water affordability programs and who isn’t
• Determines magnitude of potential issues
• Highlights other issues that may be important to
providing affordable rates
• Wide distribution of water usage
across and within income classes
suggesting “cheap” water isn’t the
sole issue
What is the probability of
customer payment given
income and water prices?
• Highlights other issues that may be important to
providing affordable water
• Strong relationship between income
and probability to pay and days
outstanding
CONFIDENTIAL
12
89 (Rev. 04-15)
STATE OF MICHIGAN
DEPARTMENT OF TREASURY
LANSING
RICK SNYDER
GOVERNOR
NICK A. KHOURI
STATE TREASURER
DETROIT FINANCIAL REVIEW COMMISSION
RESOLUTION 2015-20
APPROVING THE CITY’S DECEMBER 2015 FISCAL YEAR 2016
BUDGET AMENDMENT REQUESTS
WHEREAS, Public Act 181 of 2014, the Michigan Financial Review Commission Act
(the “Act”), allows for the creation of the Detroit Financial Review Commission (the
“Commission”) within the Michigan Department of Treasury; and
WHEREAS, Section 6(1) of the Act empowers the Commission to provide oversight for
the City of Detroit (the “City”) beginning on the Effective Date of the Plan of Adjustment; and
WHEREAS, Section 7(c) of the Act provides that during the period of oversight, the
Commission review, modify, and approve the City’s proposed and amended operational budgets
and that a proposed budget or budget amendment does not take effect unless approved by the
Commission; and
WHEREAS, Section 6(3) of the Act further requires the Commission to ensure that the
City complies with the requirements of the Uniform Budgeting and Accounting Act; and
WHEREAS, the Uniform Budgeting and Accounting Act prevents the City from
deviating from its original general appropriations act without amending it and requires the City
to amend its general appropriations act as soon as it becomes apparent that a deviation from the
original general appropriations act is necessary and the amount of the deviation can be
determined; and
1
WHEREAS, at the Commission meeting on December 21, 2015, the City presented fiscal
year 2016 budget amendment requests, attached as Exhibit A to this Resolution, for the
Commission’s review and approval.
NOW THEREFORE, be it resolved by the Detroit Financial Review Commission as
follows:
1.
That the City’s December 2015 fiscal year 2016 budget amendment requests,
attached as Exhibit A to this Resolution but excluding any budget amendments a
majority of Commission members present has agreed to exclude as noted in the
minutes, are hereby approved.
2.
That the minutes of the Detroit Financial Review Commission meeting at which
this Resolution is adopted take notice of the adoption of this Resolution.
3.
This Resolution shall have immediate effect.
2
IN WITNESS WHEREOF, the members of the Commission, or their designees, have signed and
adopted this Resolution.
DETROIT FINANCIAL REVIEW COMMISSION
By
Darrell Burks, Detroit Financial Review Commission
Member
By
Michael Duggan, Detroit Financial Review
Commission Member
By
Stacy Fox, Detroit Financial Review Commission
Member
By
Lorron James, Detroit Financial Review Commission
Member
By
Brenda Jones, Detroit Financial Review Commission
Member
By
Nick A. Khouri, State Treasurer and Detroit Financial
Review Commission Member
By
William Martin, Detroit Financial Review
Commission Member
By
John S. Roberts, Detroit Financial Review
Commission Member
By
Tony Saunders, Detroit Financial Review Commission
Member
Date: ____________________
Detroit, Michigan
DETROIT 56620-1 1347403v2
3
City of Detroit Water & Sewerage Department
Local Water & Sewer System Budget
January 1, 2016 through June 30, 2016
Appropriation Categories (2)
Initial Budget for
New DWSD Funds (1)
Budget
FTEs
Exhibit A
Cash on Day 1
BOWC Approved Budget
FTEs
Budget
$
-
$
2
Water Revenues
20173 - WDWSD-R Operating Revenue
20176 - WDWSD-R Non-Operating Revenue
3
Total Water Revenues
$
-
$
49,703,100 $
49,703,100 $
$
4,342,006
18,404,738
2,194,735
860,259
4,412,992
27,169
30,241,900
1
Water Expenditures
20166 - WDWSD-R Administration
20167 - WDWSD-R Operations
20168 - WDWSD-R Compliance
20169 - WDWSD-R Finance
20170 - WDWSD-R Customer Svc
20171 - WDWSD-R Planning
Total Water O&M
$
-
$
-
14
20172 - WDWSD-R Debt Svc & Amort
20173 - WDWSD-R Operating Revenue
20174 - WDWSD-R Long-Term Planning
20175 - WDWSD-R Reserves
Total Water Non-O&M
15
Total Water Expenditures Budget
$
16
Capital Funds
13522 - Water Bond Fund Series 2011 Revenue
13522 - Water Bond Fund Series 2011 Expense
4
5
6
7
8
9
10
11
12
13
17
18
19
20
21
22
23
24
25
$
-
$
16,192,900
211,100
1,893,700
1,163,500
19,461,200
-
$
49,703,100
36,547,876 $
36,547,876 $
-
$
$
15,100,000
111,382
20,172,981
1,163,513
36,547,876
$
36,547,876
$
$
$
$
-
$
-
-
$
$
-
$
$
4,342,006
18,404,738
2,194,735
860,259
4,412,992
27,169
30,241,900
122,622,500
122,622,500
$
3,307,762
90,282,218
2,045,909
689,218
4,412,992
100,738,100
$
$
$
55,967,279
55,967,279
-
$
$
178,589,779
178,589,779
Includes Pension Reimbursement
Includes $82.3 million of Allocated Expenses
$
3,307,762
90,282,218
2,045,909
689,218
4,412,992
100,738,100
51,860,200
10,185,818
13,009,926
2,795,735
77,851,679
Includes $5.6 million of Budget Stabilization
Includes WRAP & Share of Lease Payment
Additional Reserves From Lease payment
$
16,760,200
3,643,300
1,480,900
21,884,400
$
30
-
35,100,000
6,542,518
11,529,026
2,795,735
55,967,279
31
Total Sewerage Expenditures Budget
$
-
$
122,622,500
$
55,967,279
$
178,589,778
32
Capital Funds
13723 - Water Bond Fund Series 2015 Revenue
13723 - Water Bond Fund Series 2015 Expense
$
$
92,515,154
$
$
130,980,000
133,860,754
28
29
33
35
Total Water & Sewer O&M
Total Water & Sewer Non-O&M
36
Total Budgeted Expenditures
34
Note 1: All amounts are zero as this is the initial budget.
Note 2: "R" indicates the local "retail" system.
-
-
$
$
-
-
$
$
130,980,000
41,345,600
172,325,600
WRAP payment
Net Lease Payment to I&E
Budget Stabilization
15,000,000
15,000,000
$
27
Includes Pension Reimbursement
Includes $5.65 million of Allocated Expenses
86,250,976
20183 - SDWSD-R Debt Svc & Amort
20184 - SDWSD-R Operating Revenue
20185 - SDWSD-R Long-Term Planning
20186 - SDWSD-R Reserves
Total Sewer Non-O&M
26
Comments
86,250,976
86,250,976
31,292,900
322,482
22,066,681
2,327,013
56,009,076
15,000,000
15,000,000
Sewer Revenues
20184 - SDWSD-R Operating Revenue
20187 - SDWSD-R Non-Operating Revenue
Total Sewerage Revenues
Sewer Expenditures
20177 - SDWSD-R Administration
20178 - SDWSD-R Operations
20179 - SDWSD-R Compliance
20180 - SDWSD-R Finance
20181 - SDWSD-R Customer Svc
Total Sewer O&M
-
$
Budget Submission to
FRC
92,515,154
264,840,754
City of Detroit Water & Sewerage Department
Comparison of FY16 Budgets
BOWC Approved Full Year
Budget
Budget
Exhibit A
Stub Year DWSD-R Budget***
DWSD Half Year Budget
Stub Year GLWA
Budget****
FTEs
1
2
3
4
5
6
7
8
9
10
11
13
14
15
16
17
18
19
20
21
22
Water Revenues
04826 - Revenue - Water Receiving
04827 - Revenue - Water Operation -Maintenance
00163 - Debt Service and Maintenance
00164 - Water System Improvements
00583 - Water Extraordinary Repair and Replacement
12140 - Water Bond Fund Series 2007
$
402,093,889
94,700
1,035,700
404,500
170,500
-
$
403,799,289
105
98
293
151
68
187
14
$
916
Total Water Revenues
Water Expenditures
00085 - Administration
00086 - Financial Services
00087 - Asset Maintenance
00088 - Water Operations
12448 - Information Technology & Systems Integration & Operations
12758 - Public Affairs
13314 - Process and Quality Control
Total Water O&M
00163 - Debt Service and Maintenance
00164 - Water System Improvements
04826 - Water Receiving
04827 - Water Operation -Maintenance
00583 - Water Extraordinary Repair and Replacement
05733 - Reserve Deposit
201,046,945
47,350
517,850
202,250
85,250
-
$
49,703,100
-
$
151,343,845
47,350
517,850
202,250
85,250
-
20173 - WDWSD-R Operating Revenue
20176 - WDWSD-R Non-Operating Revenue
$
201,899,645
$
49,703,100
$
152,196,545
Total Water Revenues
22,801,250
4,152,832
35,851,009
57,702,082
29,999,065
11,475,318
783,732
$
11,400,625.16
2,076,416
17,925,504
28,851,041
14,999,533
5,737,659
391,866
$
4,369,175
860,260
18,404,738
2,194,735
4,412,992
-
$
7,031,450
1,216,156.00
17,925,504.48
10,446,303.20
12,804,797.52
1,324,667.10
391,866.00
$
162,765,289
$
81,382,644.46
$
30,241,900
$
51,140,744
$
193,362,800
20,566,100
1,981,200
22,500,000
2,623,900
$
$
16,192,900
1,893,700
211,100
$
96,681,400.00
10,283,050
990,600
11,250,000
1,311,950.00
1,163,500
$
$
$
$
$
$
80,488,500
8,389,350
779,500
11,250,000
148,450
241,034,000
120,517,000.00
201,899,644
19,461,200
$
101,055,800
$
49,703,100
$
152,196,544
101,793,750.00
101,793,750.00
$
15,000,000
15,000,000
$
$
86,793,750
86,793,750
527,302,247
135,900
1,387,300
365,400
244,700
See 'Capital Fund' sectio
$
529,435,547
$
$
263,651,124
$
67,950
$
693,650
$
182,700
$
122,350
See 'Capital Fund' section
$
264,717,774
$
122,622,500
$
141,028,624
67,950
693,650
182,700
122,350
Sewer Revenues
20184 - SDWSD-R Operating Revenue
20187 - SDWSD-R Non-Operating Revenue
$
122,622,500
$
142,095,274
Total Sewerage Revenues
$
$
$
3,307,762
689,218
38,508,205
4,412,992
48,964,087
$
$
$
$
$
$
$
$
13,207,450
2,425,402
9,657,194
19,836,995
14,448,503
950,383
902,719
59,382,737
68,534,213
1,480,900
3,643,300
73,658,413
$
58,199,987
11,498,250
1,305,400
10,106,700
1,602,200
82,712,537
122,622,500
$
24
Total Water Expenditures Budget
$
403,799,289
$
$
$
25
Capital Funds**
13522 - Water Bond Fund Series 2011 - Revenue
13522 - Water Bond Fund Series 2011 - Expense
$
203,587,500
203,587,500
$
$
23
26
27
28
29
30
31
32
33
34
35
36
37
38
40
41
42
43
Total Water Non-O&M
Sewer Revenues
00838 - State Revenue Sharing - State Revolv
04828 - Revenue - Sewerage Receiving
04829 - Revenue - Sewerage Operation - Maintenance
00168 - Interest and Bond Redemption
00169 - Sewerage System Improvements
00443 - Extraordinary Repairs and Replacement
13723 - Sewerage Bond Fund Series 2015
Total Sewerage Revenues
Sewer Expenditures
00089 - Administration
00090 - Financial Services
00161 - Asset Maintenance
00162 - Wastewater Plant Operations
12449 - Information Technology & Systems Integration & Operations
12759 - Public Affairs
13315 - Process and Quality Control
Total Sewer O&M
$
442
442
$
$
33,030,424
6,229,241
19,314,387
116,690,401
28,897,005
10,726,750
1,805,438
216,693,647
$
16,515,212.24
3,114,621
9,657,194
58,345,200
14,448,503
5,363,375
902,719
108,346,823
253,468,400
25,958,300
2,610,800
27,500,000
3,204,400
312,741,900
$
$
$
$
$
$
$
126,734,200.00
12,979,150.00
1,305,400.00
13,750,000.00
1,602,200.00
156,370,950.00
$
$
$
50
00168 - Interest and Bond Redemption
00169 - Sewerage System Improvements
04828 -Sewerage Receiving
04829 - Sewerage Operation - Maintenance
05735 - Sewerage Reserve Deposit
12139 - Sewerage Bond Fund Series 2007
Total Sewer Non-O&M
51
Total Sewerage Expenditures Budget
$
529,435,547
$
264,717,773
$
52
Capital Funds**
13723 - Sewerage Bond Fund Series 2015 - Revenue
13723 - Sewerage Bond Fund Series 2015 - Expense
$
$
6,000,000
6,000,000
$
$
3,000,000
3,000,000
$
$
$
379,458,936
553,775,900
$
$
189,729,468
276,887,950
$
$
44
45
46
47
48
49
53
54
55
56
Total Water & Sewer O&M
Total Water & Sewer Non-O&M
1,358
Total Budgeted Expenditures
-
79,205,987
93,119,613
142,095,274
3,000,000
3,000,000
$
$
110,523,481
183,768,337
933,234,836
466,617,418
172,325,600
294,291,818
209,587,500
104,793,750
15,000,000
89,793,750
57
58
Water & Sewer Capital Funds**
* Noted that the Triennial Budget published by the City has discrepancies between the high-level summary and detailed amounts of FTEs. The total from the detailed listing is shown here for comparison. The
high-level summaries stated 1,161 FTEs for Water and 683 FTEs for Sewer.
**The capital funds are identified in a separate section of the BOWC approved budget. Capital funds were included in non-O&M expenditures budget in the FRC approved budget.
***This is a guideline only. There may be additional adjustments between appropriations.
****The GLWA budget represents the budget amount to be zeroed out.
Water Expenditures
20166 - WDWSD-R Administration
20169 - WDWSD-R Finance
20167 - WDWSD-R Operations
20168 - WDWSD-R Compliance
20170 - WDWSD-R Customer Svc
20171 - WDWSD-R Planning
Total Water O&M
20172 - WDWSD-R Debt Svc & Amort
20174 - WDWSD-R Long-Term Planning
20173 - WDWSD-R Operating Revenue
20175 - WDWSD-R Reserves
Total Water Non-O&M
Total Water Expenditures Budget
Capital Funds
13522 - Water Bond Fund Series 2011 Revenue
13522 - Water Bond Fund Series 2011 Expense
Sewer Expenditures
20177 - SDWSD-R Administration
20180 - SDWSD-R Finance
20178 - SDWSD-R Operations
20181 - SDWSD-R Customer Svc
Total Sewer O&M
20183 - SDWSD-R Debt Svc & Amort
20185 - SDWSD-R Long-Term Planning
20184 - SDWSD-R Operating Revenue
20186 - SDWSD-R Reserves
Total Sewer Non-O&M
Total Sewerage Expenditures Budget
Exhibit A
CITY OF DETROIT BUDGET AMENDMENTS
THE FOLLOWING BUDGET AMENDMENTS ARE BEING SENT TO THE FRC FOR REVIEW AND APPROVAL PURSUANT TO
THE MICHIGAN FINANCIAL REVIEW COMMISSION ACT
FOR DECEMBER 21, 2015 MEETING
Non-Grant Budget Amendments
No.
1
2
3
Department
Dept. of Transportation
Housing & Revitalization Dept. (HRD)
Police Department
Brief Description
To allow DDOT successful achievement of their operational goals.
Budget
Appropriation
Amendment
No.
Amount
(450,828.00)
00149
55,354.00
00146
395,474.00
00150
Reduce funding from sale of property for new international bridge to be used for demolition
activities
(750,000.00)
13168
Increase funding to reflect the use of proceeds from the sale of property for new international
bridge to establish Appropriation 14103 to demolish blighted structures in Delray.
750,000.00
14103
Monetary donation from The Parade Company to defray costs associated with the
Thanksgiving Day Parade.
100,000.00
00547
Page 1 of 8
Exhibit A
CITY OF DETROIT BUDGET AMENDMENTS
THE FOLLOWING BUDGET AMENDMENTS ARE BEING SENT TO THE FRC FOR REVIEW AND APPROVAL PURSUANT TO
THE MICHIGAN FINANCIAL REVIEW COMMISSION ACT
FOR DECEMBER 21, 2015 MEETING
Grant Budget Amendments
No.
Department
Brief Description
Grantor
4
Recreation Dept.
Detroit Recreation
Foundation
Brighter Future Summer Day Camp Program FY 2013-2014
5
Recreation Dept.
Detroit Recreation
Foundation
FY 2015 Brighter Future Summer Day Camp - Listed as $250,000 on resolution.
6
Dept. of Health and Wellness Michigan Dept. of
Promotion
Community Health
WIC breastfeeding program
7
Dept. of Health and Wellness Detroit Wayne Mental
Promotion
Health Authority
8
Dept. of Health and Wellness Michigan Dept. of
Promotion
Community Health
9
Recreation Dept.
Healthy Environments
Partnership (HEP)
Will allow the Recreation Dept. to purchase additional equipment
10
Recreation Dept.
Detroit International
Bridge Company
To complete renovations at Riverside Park
11
Mayor's Office
Skillman Foundation
Salary support for a Director of Youth Services
12
Recreation Dept.
Michigan Recreation &
Park Association
Pathway to A Healthier Michigan grant
13
Recreation Dept.
Recreation and Park
Association
2014-2015 MDCH Active Living Obesity Prevention Program Active Living Grant
Budget
Amendment
Amount
Appropriation
No.
80,516.18
13649
250,000.00
14101
3,900.00
20132
Increase appropriation for the Medicaid Substance Abuse Program
42,099.00
13445
Increase appropriation for Vision to reflect anticipated revenue from fees and collections for
vision screening services.
70,000.00
20148
2,000.00
14104
5,000,000.00
14106
90,000.00
14112
8,000.00
14109
1,600.00
14110
Page 2 of 8
Exhibit A
Grant Budget Amendments
No.
Department
Brief Description
Grantor
To grant AT&T an easement at Clark Park for the purpose of park improvements, equipment
and/or general recreation use.
14
Recreation Dept.
15
Recreation Dept.
National Recreation and
Park Association
NRPA 2015 Grow Your Park grant
16
Fire Dept.
Dept. of Homeland
Security
17
Homeland Security
Dept. of Homeland
Security
18
Police Dept.
Services, Training, Officers Providing first step statistical information on the investigations, arrest, prosecution and follow
and Prosecutors (STOP)
up for domestic violence.
19
Police Dept.
20
AT & T
Budget
Amendment
Amount
Appropriation
No.
3,000.00
14115
8,000.00
14116
The Department of Homeland Security has awarded the City of Detroit Fire Department a
grant for Assistance to Firefighters for $999,791.
999,791.00
20125
Purchase equipment to downlink aviation camera feed to Emergency Operation Center and
purchase equipment repair for fireboat
206,250.00
20189
50,741.00
00118
Marathon Petroleum
Company
The Marathon Petroleum Company (MPC) providing $250,000 to pay overtime costs to Detroit
Police Department Officers to provide traffic enforcement in the vicinity of the M-85 (Fort
Street) during the Bascule Bridge Replacement. 250,000.00
10082
Police Dept.
DTE Energy Company
Efforts to reduce copper and energy theft in the City of Detroit
200,000.00
00119
21
Dept. of Public Works
Dept. of Environmental
Quality
Increase residents understanding of the importance of recycling.
95,000.00
14111
22
Dept. of Health and Wellness Michigan Dept. of
Promotion
Community Health
Increase Appropriation for Food Safety & Environmental Services to reflect anticipated
revenue from license and inspection activities.
1,300,000.00
13765
23
Dept. of Health and Wellness Michigan Dept. of
Promotion
Community Health
Increase Appropriation for Food Safety & Environmental Services to reflect anticipated
revenue from license and inspection activities.
200,000.00
13919
24
United States
Buildings, Safety Engineering,
environmental Protection
and Environmental Dept.
Agency (EPA)
Brownsfield Site-specific Assessment grant. Assess hazardous materials at Riverside Park,
parcel #3 at 3085 W. Jefferson
350,000.00
14108
Page 3 of 8
Exhibit A
Grant Budget Amendments
No.
Department
Southeastern Michigan
council of Governments,
SEMCOG
To support transportation planning, studies and related activities.
HRD
HUD
Flood Management Grant - CDBG-DDR
HRD
NSP 3
Program Income - NSP3
HRD
HUD
HRD
HRD
25
Dept. of Transportation
26
27
28
Brief Description
Grantor
PDD
PDD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
Budget
Amendment
Amount
Appropriation
No.
314,304.00
20158
8,900,000.00
20239
725,493.89
13564
Increase Cass Community Social Services Public Service Grant Award
75,000.00
11838
HUD
Wayne State University Public Service Grant Reduction for Cass Community Social Services
(75,000.00)
11842
Community Dev Block
Grant
PDD - FRM Direct Staffing
82,492.00
13594
Sec 106 Clearances
115,280.00
14027
Sec 106 Clearances
(115,280.00)
13611
(2,738,209.00)
12945
1,000,000.00
13837
(1,782,253.00)
11507
Eight Mile Blvd. Assoc
100,000.00
05797
Techtown Detroit
230,000.00
20152
Alternatives for Girls
84,600.00
11784
Cass Community Social Services
84,600.00
11838
Coalition on Temporary Shelter (COTS)
84,600.00
11785
Community Social Services of Wayne County
84,600.00
11838
Covenant House Michigan
84,600.00
11786
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
UNASSIGNED PROJECTS
Economic Development Small Business Development
Economic Development
Page 4 of 8
Exhibit A
Grant Budget Amendments
No.
Department
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
Brief Description
Grantor
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Budget
Amendment
Amount
Appropriation
No.
Detroit Non-Profit Housing
100,000.00
05742
Detroit Rescue Mission Ministries
100,000.00
11882
(2,452,747.00)
12168
84,600.00
11791
100,000.00
6505
Mariners Inn
84,600.00
11798
Matrix Human Services
84,600.00
11893
Michigan Legal Services
187,347.00
11799
84,600.00
11800
NSO - Tumaini Center
200,000.00
11801
Neighborhood Legal Services
200,000.00
10663
Operation Get Down Inc.
100,000.00
11839
Salvation Army
84,600.00
13644
St. John Community Center
84,600.00
12426
Southwest Counseling Solutions
200,000.00
10626
The Noah Project (Central United Methodist Church)
150,000.00
11896
United Community Housing Coalition
100,000.00
11806
84,600.00
11809
(1,000,000.00)
13558
500,000.00
20153
2,184,089.00
13609
Homeless Public Service/Emmanuel House
Freedom House
Legal Aid and Defender Association
Michigan Veterans Foundation
YWCA Interim House
Emergency Home Repair
Conventional Home Repair
CDBG Housing Rehab Loan Program
Page 5 of 8
Exhibit A
Grant Budget Amendments
No.
Department
HRD
HRD
HRD
HRD
HRD
HRD
29
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
Brief Description
Grantor
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Budget
Amendment
Amount
Appropriation
No.
PDD - Housing Services - Staffing
(500,000.00)
13170
Adult Wellbeing Services
125,000.00
4735
Bridging Communities
130,000.00
10154
Chapel Hill MBC Non-Profit Hsg/Christian Social Outreach
105,000.00
5915
Detroit Central City Comm Mental Health
200,000.00
11787
East Michigan Environmental Action Council
100,000.00
20154
Elmhurst Home, Inc.
165,000.00
5661
Focus: HOPE
100,000.00
6698
Franklin-Wright Settlements
100,000.00
6514
Healthy Kidz, Inc.
100,000.00
Liberty Temple Baptist Church - Senior Project
105,000.00
13839
North Rosedale Civic Association
100,000.00
13645
75,000.00
13027
Samaritan Center
150,000.00
12432
SHAR, Inc.
100,000.00
20155
Urban Neighborhood Initiatives
200,000.00
13556
1,500,000.00
13837
Accounting Aid Society
61,000.00
7523
DAPCEP
61,000.00
4139
Dominican Literacy Center
61,000.00
5983
Green Door
61,000.00
13560
PW Community Development Non-Profit Hsg Corp
Summer Jobs Program (NRSA)
Page 6 of 8
Exhibit A
Grant Budget Amendments
No.
Department
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
HRD
Brief Description
Grantor
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Budget
Amendment
Amount
Appropriation
No.
Greening of Detroit
61,000.00
11167
Mack Alive
61,000.00
4279
Mercy Education Project
61,000.00
11554
Project SEED
61,000.00
11499
Siena Literacy Center
61,000.00
20156
YMCA
61,000.00
13646
Joy-Southfield CDC
67,600.00
12420
Greater Detroit Agency for Blind
67,600.00
12998
Greater Families for Detroit
67,600.00
20157
Muslim Center
67,600.00
4681
The Society of St. Vincent de Paul
67,600.00
12719
World Medical Relief
67,600.00
4178
Alkebu-lan Village
100,000.00
10105
Clark Park Coalition
50,000.00
11547
People's Community
100,000.00
5428
Police Athletic League
105,731.00
10113
50,000.00
13397
Jefferson Business Association
100,000.00
10620
Southwest Detroit Business Assoc
105,731.00
5544
Delray United Action Council
82,229.40
6403
L&L Adult Day Care
82,229.40
10621
Teen Hype
Page 7 of 8
Exhibit A
Grant Budget Amendments
No.
Department
HRD
HRD
HRD
HRD
HRD
HRD
Brief Description
Grantor
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Community Dev Block
Grant
Budget
Amendment
Amount
Appropriation
No.
LASED
82,229.00
5662
Matrix Human Services - Reuther Older Adult & Wellness Center
82,229.00
11893
St. Patrick Senior Center
82,229.00
5149
(2,324,088.00)
13529
General Services Dept. - Public Park Improvement
(400,956.00)
13635
Planning and Development Letter of Credit
744,083.00
6102
Section 108 Loans
Page 8 of 8
89 (Rev. 04-15)
RICK SNYDER
GOVERNOR
STATE OF MICHIGAN
DEPARTMENT OF TREASURY
LANSING
NICK A. KHOURI
STATE TREASURER
DETROIT FINANCIAL REVIEW COMMISSION
RESOLUTION 2015-21
APPROVING THE CITY’S DECEMBER 2015 CONTRACT REQUESTS
WHEREAS, Public Act 181 of 2014, the Michigan Financial Review Commission Act
(the “Act”), allows for the creation of the Detroit Financial Review Commission (the
“Commission”) within the Michigan Department of Treasury; and
WHEREAS, Section 6(1) of the Act empowers the Commission to provide oversight for
the City of Detroit (the “City”) beginning on the Effective Date of the Plan of Adjustment; and
WHEREAS, Section 6(6) of the Act provides that during the period of oversight, the
Commission review and approve the City’s applicable contracts, as defined by Section 3(a) of
the Act, and that an applicable contract does not take effect unless approved by the Commission;
and
WHEREAS, at the Commission meeting on December 21, 2015, the City presented
applicable contacts, attached as Exhibit A to this Resolution, for the Commission’s review and
approval.
NOW THEREFORE, be it resolved by the Detroit Financial Review Commission as
follows:
1.
That the City’s December 2015 contract requests, attached as Exhibit A to this
Resolution but excluding any contracts a majority of Commission members
present has agreed to exclude as noted in the minutes, are hereby approved.
1
2.
That the minutes of the Detroit Financial Review Commission meeting at which
this Resolution is adopted take notice of the adoption of this Resolution.
3.
This Resolution shall have immediate effect.
2
IN WITNESS WHEREOF, the members of the Commission, or their designees, have signed and
adopted this Resolution.
DETROIT FINANCIAL REVIEW COMMISSION
By
Darrell Burks, Detroit Financial Review Commission
Member
By
Michael Duggan, Detroit Financial Review
Commission Member
By
Stacy Fox, Detroit Financial Review Commission
Member
By
Lorron James, Detroit Financial Review Commission
Member
By
Brenda Jones, Detroit Financial Review Commission
Member
By
Nick A. Khouri, State Treasurer and Detroit Financial
Review Commission Member
By
William Martin, Detroit Financial Review
Commission Member
By
John S. Roberts, Detroit Financial Review
Commission Member
By
Tony Saunders, Detroit Financial Review Commission
Member
Date: ____________________
Detroit, Michigan
DETROIT 56620-1 1347403v2
3
Exhibit A
CITY OF DETROIT CONTRACT SUBMISSION TO FINANCIAL REVIEW COMMISSION
THE FOLLOWING CONTRACTS ARE BEING SENT TO THE FRC FOR REVIEW AND APPROVAL PURSUANT TO
SECTION 6, SUBSECTION 6 OF THE MICHIGAN FINANCIAL REVIEW COMMISSION ACT
For December 21, 2015 Meeting
Prepared By: Boysie Jackson, Chief Procurement Officer - 12/17/2015
City Council and Water Board Approvals Through December 17, 2015
Department
Contract
Number
Competitively Bid?
If not a New
Contract Request
contract, was the
Type
original contract
competitively bid?
Description
Lowest Bid? If
not bid, what
procedure was
used?
City Council
Approval Date
Office of the
Chief
Financial
Officer
Approval
Date
Renewal
11/24/2015
12/21/2015
Comments
CONTRACTS GREATER THAN $750K
1
2
3
4
GENERAL
SERVICES
TRANSPORTATION
TRANSPORTATION
TRANSPORTATION
2853050
2907326
2906651
2883536
Contract Amount: $1,716,981.00 (Renewal)
Contract Period: Upon FRC Approval through 11/30/2016
Source: 100% City Funding
Purpose: To Provide Security Guard Services
Contractor: LaGarda Security
Location: 2123 S. Canter Road, Burton, MI 48519
Renewal
Yes
Plan to Rebid in 2016
Wind-down of contract services. Contract was Rebid in
2015. Supplier selection underway. Extension needed
to finalize contract.
Contract Amount: $840,000.00 (Increase of Funds and Extension of Time)
Contract Period: Upon FRC Approval through 2/29/2016
Source: 100% City Funding
Purpose: To Provide Door-to-Door Paratransit Services
Contractor: S.W. Transport d/b/a/ Checker Cab Company
Location: 2128 Trumbull, Detroit, MI 4821
Time Extension
and Funds
Increase
Yes
Amendment
11/24/2015
12/21/2015
Total Contract Amount: $1,828,704.29
This Amendment #1 is for increase of funds and
extension of time. The original amount is $998,704.29
and original contract period is April 1, 2015 through
September 30, 2015
Wind-down of contract services. Contract was Rebid in
2015. Supplier selection underway. Extension needed
to finalize contract.
Contract Amount: $1,734,597.00 (Increase of Funds and Extension of Time)
Contract Period: 7/1/2015 through 2/29/2016
Source: 100% City Funding
Purpose: To Provide Door-to-Door Paratransit Services
Contractor: Enjoi Transportation
Location: 1545 Clay, Suite #1, Detroit, MI 48211
Time Extension
and Funds
Increase
Contract Amount: $4,770,000.00 (Increase of Funds Only)
Contract Period: Upon FRC Approval through 10/31/2016
Source: 100% Federal Funding
Purpose: To Provide Transportation Services for JARC/New Freedom Program
Contractor: S.W. Transport Co. d/b/a Checker Cab
Location: 2128 Trumbull, Detroit, MI 48216
Yes
Amendment
12/17/15
12/21/2015
Total Contract Amount: $2,484,542.00
This Amendment #1 is for increase of funds and
extension of time. Original contract amount is
$749,945.80, and original contract date is April 1, 2015
through June 30, 2015.
Plan is to Rebid in 2016. Contract already in place.
Funds Increase
Yes
Amendment
11/24/2015
12/21/2015
Total Contract Amount: $6,570,000.00
This Amendment #1 is for increase of funds only. The
original amount is $1,800,000.00
CONTRACTS GREATER THAN 2 YEARS
No Contracts Submitted for this Category
1 of 3
Exhibit A
Department
Contract
Number
Competitively Bid?
If not a New
Contract Request
contract, was the
Type
original contract
competitively bid?
Description
Lowest Bid? If
not bid, what
procedure was
used?
City Council
Approval Date
Office of the
Chief
Financial
Officer
Approval
Date
12/03/15
12/21/2015
Comments
WITH 1 ENTITY, WITHIN 1 YEAR, GREATER THAN $750K
5
FIRE
2916770
Contract Amount: $345,690.00 (New)
Contract Period: 11/30/2015 through 11/29/2016
Source: 100% City Funding
Purpose: To Provide Fire Equipment and Tools
Contractor: Apollo Fire Equipment Co.
Location: 12584 Lakeshore Drive, Romeo, MI 48065
New
Yes
Only One
Qualified Bid
Rec'd
2 Bids received. Quote was for 38 items, second
company quoted only 21 items.
Different contract #2909649, totaling $2,100,000.00
and approved by FRC on September 27, 2015.
WITH 1 ENTITY, WITHIN 1 YEAR, GREATER THAN $750K -- continued
6
7
LAW
LAW
2911447
Contract Amount: $57,007.00 (New)
Contract Period: One Time Purchase
Source: 100% City Funding
Purpose: To Provide Renovations at the Law Department and 36th District Court
(Carpentry - New Walls and Modifications, 14 Work Stations Installed, Data and Power
Relocation/New (Power Poles), Paint, Doors, Flooring Rubber Base at New Wall Carpet
Contractor: KEO and Associates, Inc.
Location: 18286 Wyoming St., Detroit, MI 48221
New
Yes
Yes
11/24/2015
12/21/2015
Different contract in 2014 #2895758, totaling
$2,500,000.00
2911449
Contract Amount: $125,000.00 (New)
Contract Period: One Time Purchase
Source: 100% City Funding
Purpose: To Provide and Install Tractable Partitions on the 5th Floor Law Department
(Provide and Install Tractable Partition; Steel Smart Track System with Steel Wheeled
Trolleys Structural Steel Support and Drywall Pocket Enclosure; Design of Support
Header Included)
Contractor: KEO and Associates, Inc.
Location: 18286 Wyoming St., Detroit, MI 48221
New
Yes
Yes
11/24/2015
12/21/2015
Different contract in 2014 #2895758, totaling
$2,500,000.00
2770652
Contract Amount: $300,000.00 (Increase of Funds and Extension of Time)
Contract Period: 9/10/2015 through 9/10/2016
Source: 100% City Funding
Purpose: To Provide Tire Repairs and Recapping
Contractor: Shrader Tire and Oil
Location: 25445 Outer Drive, Melvindale, MI 48122
Contract already in place. Plan to Rebid in 2016.
8
9
TRANSPORTATION
TRANSPORTATION
2897042
Contract Amount: $295,999.00 (Increase of Funds and Extension of Time)
Contract Period: 7/1/2015 through 2/29/2016
Source: 100% City Funding
Purpose: To Provide Door-to-Door Paratransit Services
Contractor: Lakeside Division
Location: 1990 Bagley, Detroit, MI 48216
Time Extension
and Funds
Increase
Total Contract Amount: $2,493,333.00
Yes
Amendment
12/03/15
12/21/2015
This Amendment #1 is for increase of funds only.
Original contract amount is $2,193,333.00 and original
contract period is January 1, 2009 through September
10, 2015..
Wind-down of contract services. Contract was Rebid in
2015. Supplier selection underway. Extension needed
to finalize contract.
Time Extension
and Funds
Increase
2 of 3
Yes
Amendment
11/24/2015
12/21/2015
Total Contract Amount: $1,336,412.00
This Amendment #1 is for increase of funds and
extension of time. The original amount is
$1,040,413.00 and original contract period is August 1,
2014 through October 31, 2015.
Exhibit A
Department
Contract
Number
Competitively Bid?
If not a New
Contract Request
contract, was the
Type
original contract
competitively bid?
Description
Lowest Bid? If
not bid, what
procedure was
used?
City Council
Approval Date
Office of the
Chief
Financial
Officer
Approval
Date
Comments
N/A
BOWC
Approval
12/16/15
CS-1512 Proposed Amendment No.1 is needed so
operational services can continue during the transition
of the Detroit Water and Sewerage Department
(DWSD) to the Great Lakes Water Authority (GLWA).
To continue this service, the staff required for the 24hour operation of the Imlay Pumping Station, other
operational support at the various pumping stations, and
Systems Control Center(SCC) are required. DWSD
Human Resources has been actively working to recruit
water operators. Upon hiring and training of the
appropriate staff, this contract will be ended.
DEPARTMENT OF WATER AND SEWAGE CONTRACTS
CONTRACTS GREATER THAN $750,000.00
10
Water and Sewerage
CS-1512
(Change order
#1)
Contract Amount Not to Exceed: $5,342,313.00 [$1,000,000.00 increase]
Initial Contract Period: 1/07/13 - 1/07/16 [New expiration 1/07/17]
Source: 100% Operation & Maintenance funding
Purpose: To provide experienced and licensed Operations Personnel services to assist
DWSD in its operation of the water and wastewater treatment systems
Contractor: Alfred Benesch & Company (formerly Tucker Young Jackson, Tull Inc.)
Location: 615 Griswold, Suite 600 Detroit, MI 48226
Time Extension
and Funds
Increase
Yes
CONTRACTS GREATER THAN 2 YEARS
No Contracts Submitted for this Category
WITH 1 ENTITY, WITHIN 1 YEAR, GREATER THAN $750K
No Contracts Submitted for this Category
3 of 3
Amendment
N/A; below $5
mil/yr approval
requirement for
contracts relative
to Construction
3500 (Rev. 04-15)
STATE OF MICHIGAN
DEPARTMENT OF TREASURY
RICK SNYDER
NICK A. KHOURI
GOVERNOR
STATE TREASURER
DATE:
December 18, 2015
TO:
Financial Review Commission members
FROM:
Ronald L. Rose, Executive Director
Steven C. Watson, Senior Analyst
Financial Review Commission
SUBJECT:
FRC December 2015 City of Detroit Contracts Review
The City is requesting 10 contract approvals at the December 21, 2015 FRC Meeting. The following is a
summary of the requests, which were reviewed by and discussed with the FRC Advisory Subcommittee
on Contracts and Procurement on December 15, 2015. Overall, the City’s December 2015 contract
requests reflect a continued commitment to competitively bid for ongoing City needs.
Contract Request
Type
Count
Contract List
Item #s
5, 6, 7
4
2, 3, 8, 9, 10
Competitively Bid? If
not a new contract, was
the original contract
competitively bid?
Yes
Yes
Yes
Lowest Bid? If not
competitively bid or
re-bid, what
procedure was used?
Yes
Amendment
Amendment
New Contracts
Funds Increase
Time Extension and
Funds Increase
Renewal
3
1
5
1
1
Yes
Renewal
All 3 new contracts were competitively bid, and the City selected the lowest bidder. The City is also
requesting approval of 6 contract amendments and 1 renewal. For all 7 of those requests, the original
contract was itself competitively bid, and the City plans to re-bid them in the near term. The City is not
re-bidding now because it needs additional time to evaluate, re-bid, and award new contracts over the next
year. Additional details are summarized below:
•
•
•
•
•
Citywide Security Guard Services renewal to 11/30/2016 (item #1)
Door-to-Door Paratransit Services extension to 2/29/2016 (items #2, 3, 9)
Transportation for Job Access and Reverse Commute/New Freedom Program extension to
10/31/2016 (item #4)
o Grant-funded contract, ridership substantially exceeding original expectations
Tire Repairs and Recapping for DDOT Vehicles extension to 9/10/2016 (item #8)
Operational Services for Water and Sewer Systems extension to 1/7/2017 (item #10)
o May be replaced with permanent staff, part of Great Lakes Water Authority transition
Last month, the subcommittee requested a summary of restructuring consultant contracts for reference
purposes. The City has provided that summary list, and it is attached to this memo.
Attachment:
City of Detroit Overview of Major Active Restructuring, Staff Augmentation and
Bankruptcy Consultant Contracts
www.michigan.gov/treasury
City of Detroit
Overview of Major Active Restructuring, Staff Augmentation and Bankruptcy Consultant Contracts
Consultant
Ernst &
Young
Restructuring
Dept.
OCFO
Contract
2916755
Role
Assist with Cash
Management, Departmental
Reviews, Forecasting, and
Bankruptcy Matters
Assist with ERP
implementation
Contract Terms
Time: 12/12/2015 to
12/31/2016
Contract Amt: $3,405,000 plus
expenses
Time: 1/4/2016 to 7/11/2016
Contract Amt: $1,553,000 plus
expenses
Ernst &
Young ERP
DoIT
2916757
Ernst &
Young HR
DoIT
2916756
Assist with HRIS
implementation
Time: 1/1/2016 to 3/30/2016
Contract Amt: $465,000 plus
expenses
Conway
Mackenzie
OCFO
2874390
Assist with OCFO, DoIT and
HRD/PDD restructuring; staff
support in Income Tax and
Financial Planning & Analysis
Time: 12/11/2014 to
6/30/2016
Contract Amt: $6,408,000
Miller
Canfield
Miller
Buckfire
Law
2870456
Bond and Claims Counsel
OCFO
2874157
Bond Advisor
Jones Day
Law
2877753
Bankruptcy Counsel
Foley &
Lardner
Public
Consulting
Group
Law
2883547
Claims Counsel
OCFO
2898266
Pierce
Monroe
OCFO
2895089
Assist in Grants
Management, Departmental
Financial Services, Income
Tax and Procurement
OCFO staff augmentation
and data cleansing to
support ERP implementation
Time: 1/1/2016 to 12/31/2016
Contract Amt: $1,200,000
Start Date: 12/10/2014 (no end
date)
Contract Amt: $200,000 per
month
Start Date: 7/1/2013 (no end
date)
Contract Amt: No limit
Time: 7/22/2013 to 6/30/2016
Contract Amt: $750,000
Time: 10/1/2015 to
10/31/2016
Contract Amt: $1,430,840
Kurtzman
Carson
Consultants
Randy Lane
Law
2884516
Claims Agent
OCFO
2913902
CAFR Audit Support
Plante Moran
OCFO
2911783
CAFR Audit Support
Allen Law
Group
Law,
HR
2909514
Restructuring Support, Labor
Strategies
Time: 10/1/2015 to 6/30/2016
Contract Amt: $3,730,300
Time: 6/26/2013 to
12/31/2016
Contract Amt: $4,539,295
Time: 7/1/2015 to 6/30/2016
Contract Amt: $190,000
Time: 11/23/15 to 6/30/2016
Contract Amt: $766,089
Time: 1/1/2015 to 6/30/2016
Contract Amt: $104,838
Future OCFO Staff Role?
Yes, workstreams will
transition to OCFO.
No, workstreams are
project-specific.
Knowledge transfer will
occur.
No, workstreams are
project-specific.
Knowledge transfer will
occur.
Partial. Restructuring
workstreams are projectspecific. Staff support in
Income Tax and Financial
Planning & Analysis will
transition to OCFO.
No, workstreams not
performed by OCFO staff.
No, workstreams not
performed by OCFO staff.
No, workstreams not
performed by OCFO staff.
No, workstreams not
performed by OCFO staff.
No, workstreams are
project-specific.
Knowledge transfer will
occur.
Partial. Staff augmentation
will transition to OCFO.
Data cleansing is projectspecific, knowledge
transfer will occur.
No, workstreams not
performed by OCFO staff.
Yes, workstreams will
transition to OCFO.
Yes, workstreams will
transition to OCFO.
No, workstreams not
performed by OCFO staff.