Michael Hoffstrom Email and Phone Number

- Manage all financial activities for the Office of Community and Economic Development (OCED), a unique organization within Washtenaw County government that receives 30+ grants from a variety of federal, state, and local sources. OCED works with local non-profit agencies to deliver a variety of services relating to Housing and Infrastructure Development, Workforce Development, Economic Development, and Human Services.- Manage OCED's Finance & Operations team, which is primarily responsible for all departmental financial activities, including financial reporting, payable processing, contracts processing, financial draws, accounting, audit preparation, expenditure tracking, and budget projections.- Provide frequent financial updates and presentations to department management team. Work with management team to identify budget or program delivery issues, analyze and evaluate potential solutions, and recommend and execute necessary adjustments.- Liaise with other county departments, including Finance, Facilities Management, IT Services, and Fleet Management. Represent the department's financial and operational interests to ensure that services are delivered to the community in the most efficient and cost effective manner.- Research and recommend improvements to departmental processes in order to meet key operational objectives. Consider feedback from department staff and present changes to standard procedures at all-staff meetings. Update policy manual to ensure consistency and accountability in departmental operations.- Manage and provide oversight to the Finance & Operations team, including balancing workloads, assisting with ad-hoc questions and requests, supporting staff professional development, and mediating disputes and disagreements.

- Provide detailed analysis for the School Aid budget. Specialize in a variety of issues, including charter schools, cyber and virtual education, and at-risk funding.- Use Microsoft Visual Foxpro (transitioning to SQL Server) to develop 3-year cost and pupil projections for charter and cyber schools in Michigan. Projections are essential part of School Aid budget development and are publicly presented at both the January and May Consensus Revenue Estimating Conferences (CREC).- Primary analyst for the Department of Education (MDE) budget. Develop budget plans, vet proposals, present ideas to State Budget Director, and provide feedback to department if further analysis is necessary.- Create month-by-month caseload projections for childcare subsidy program. Work with Senate and House Fiscal Agencies to create consensus caseload estimates, released publicly at the May CREC.- Track year-to-year budgetary adjustments using Microsoft Excel to reconcile department and School Aid budgets with statewide revenue and expenditure estimates.- After budget is finalized, set up profiles within MAIN accounting system, develop quarterly allotment schedule, and provide final checks to verify that system entries are accurate. Conduct quarterly expenditure reviews of the MDE budget to ensure allotment schedule is followed.- Reconcile School Aid budget on a monthly basis to ensure that line item expenditures do not exceed allowable amounts.- Track legislation relating to education policy issues. Draft detailed reports of committee meetings and provide analysis to predict impacts of potential policy changes.- Study national and industry-wide trends in education policy.- Study education policy issues specific to Michigan, particularly Proposal A, the Durant lawsuit, and charter school legislation.- Query State HR records using SAP Business Objects to collect department expenditure data and create salary & wage and employee benefit projections for the upcoming fiscal year.

Produced 60-minute documentary for WKAR-TV about the Eli & Edythe Broad Art Museum. Created and delivered RFPs for video production projects. Clients included Blue Cross Blue Shield Michigan and Michigan State University. Created and tracked project budgets. Interacted with clients on a daily basis to ensure that their needs were met, to clarify expectations, and to resolve creative and financial issues. Wrote and edited scripts, treatments, and grant proposal documents for client approval.