This paper develops and analyzes a monthly operating budget for the proposed Northville City employee daycare center for fiscal year 2012–13. Beginning with a scenario in which a mid-western city's workforce survey identifies affordable childcare as a key concern, the paper constructs a baseline budget (Appendix 1) that reveals a $164,992 annual deficit across all twelve months. It then proposes three corrective measures: adjusting the child-to-caregiver ratio to a realistic 8:1, increasing the union contribution rate from $1.00 to $1.50 per day, and raising the monthly per-child fee from $200 to $240. The revised budget (Appendix 2) converts the deficit into a $59,498 annual surplus, demonstrating a path to long-term financial sustainability for the program.
Northville, located in the mid-western United States, has experienced a significant change in the composition of its workforce. The city currently employs 1,800 workers, of whom 35% are female. Based on findings from a recent employee survey, over 40% of employees agreed that "affordable daycare for children is important for them" (Hallway, 2000, p. 1). These results led the Director of the Office of Personnel to conclude that the lack of affordable daycare in the city is a major cause of lateness and absenteeism among city employees.
Mayor Spark supports the new initiative but is unwilling to incur additional expenses from the city government's already strained budget. With the Mayor's approval to provide "space and utilities for a year at no cost," the next step is to prepare a budget for the daycare center in order to determine its profitability (Hallway, 2000, p. 1). The objective of this paper is to prepare a balanced budget for the daycare and to determine the total surplus or deficit for each month.
The plan to provide a childcare center for Northville city employees is ambitious and worthwhile; however, before proceeding with implementation it is important to assess whether the program can achieve long-term sustainability. The data in Appendix 1 show that total monthly expenditures exceed total revenue in every one of the twelve months from January through December, meaning the daycare would operate at a deficit throughout the fiscal year.
The monthly total revenue in the proposed budget consists of fees collected per child, a union contribution, a start-up grant, and a facility subsidy. From January through December, the total annual revenue is $599,780. Monthly expenditures include the salary of the director, the salary of the administrative secretary, and the salaries of full-time (FT) daycare workers. As shown in Appendix 1, total salary expenditures for FY 2012–13 amount to $410,460.
Additional expenditure categories include employee benefits — covering Social Security, unemployment/disability insurance, health insurance, and pension contributions — as well as operational costs for food, supplies, capital equipment, employee training, facility rental, and annual inspection. The total expenditure for FY 2012–13 is $764,772. Based on the data in Appendix 1, the annual deficit is $164,992, spread across each month from January to December. Because the proposed budget results in a deficit, adjustments are necessary to achieve financial sustainability.
One method used to balance the budget is to recalculate the revenue from child enrollment fees based on a corrected child-to-caregiver ratio of 8:1, as shown in Appendix 2. The ratio is adjusted by dividing the number of enrolled children by the number of daycare workers. This correction is necessary because the child-to-caregiver ratio in Appendix 1 is unrealistic. For example, in March, Appendix 1 records 146 children and 25 daycare workers, producing a ratio of 5.84:1. Since it is impossible to have a fractional caregiver, this figure is not statistically meaningful. Rounding to a whole-number ratio of 8:1 brings the figure in line with standard practice and increases the total yearly revenue from child fees from $454,000 to $737,280.
A second adjustment involves negotiating an increase in the union contribution rate from $1.00 per day to $1.50 per day. This change raises total annual union contributions from $31,780 to $47,670 (see Appendix 2).
A third adjustment increases the monthly fee charged to parents from $200 to $240 per child. This change, combined with the ratio correction, drives the increase in child-fee revenue from $454,000 to $737,280. Together, these three modifications produce a yearly budget surplus of $59,498 for the Northville Day Care Center FY 2012–13 (see the summary table below and Appendices 1 and 2).
"Revised budget yields $59,498 annual surplus"
The proposed Northville daycare center can achieve long-term financial sustainability through targeted revenue adjustments. By correcting the child-to-caregiver ratio to the realistic standard of 8:1, increasing the union contribution from $1.00 to $1.50 per day, and raising the monthly per-child fee from $200 to $240, the program moves from a $164,992 annual deficit to a $59,498 surplus. These findings demonstrate that a public-sector childcare initiative can be self-sustaining when its budget parameters are set realistically. Providing affordable, accessible daycare will help reduce employee absenteeism and lateness while supporting the well-being of Northville's workforce — goals that align with sound public administration practice.
You’re 69% through this paper. Sign up to read the remaining 1 section.
Sign Up Now — Instant Access Already a member? Log inAlways verify citation format against your institution’s current style guide requirements.