Question;DAY CARE COMES TO COLDVILLEColdville, a medium-sized city in the midwestern part of the United States, has experienced a significantchange in the composition of its municipal work force of 1,800 employees. Approximately thirty-fivepercent of the city employees are now female. In a recent survey of city employees, over forty percenthave said that "affordable day care for children" was important to them. Meanwhile Director of theOffice of Personnel Mary Lux has become increasingly convinced that the lack of affordable day care isone of the main reasons for absenteeism and lateness among city employees. Mayor Petula Spark, someof the members of the city council, and the leader of the major city employees' union, Denardo Legato, allagree that something should be done. The question they are trying to answer is, what should it be?Mayor Spark is in favor of doing something, in principle, but she is not in favor of incurring a major newexpense, given the many legitimate claims on the city's already strained budget. She has told Legato,who is negotiating the day care program on behalf of the city employees, "We?ll give you space andutilities for a year at no cost. It is up to you to come up with a suitable day care center that conforms tostate and federal law." Several regulatory mandates and non-discrimination laws fall into this category.The only requirements specific to day care centers are that (a) they be licensed and inspected once ayear, (b) all new day care workers take part in a three day state-certified training program and (c) thechild/day care giver ratio be no greater than 8 to 1. The annual inspection fee is $500. The total cost ofthe three-day training program is estimated to be $200 per employee.Mary Lux is responsible for planning the details of the day care program for the children of cityemployees. With Mr. Legato's approval, Ms. Lux has negotiated an arrangement with a local non-profitagency that is already providing day care services in the Coldville metropolitan area.Tiny Tots, Inc. has three locations, the contract with the City of Coldville would be a fourth center.The Director of Tiny Tots, Klara Nemet, is enthusiastic about the prospects of a new center specifically forcity employees. While discussing the proposed arrangements with Ms. Lux, Ms. Nemet said, "We will notneed any additional administrative staff, since Ms. Perfekt, my administrative secretary, and I couldcertainly handle the additional administrative work." Ms. Perfekt earns $1,300 a month. Ms. Nemet'ssalary is $2,400 a month. Tiny Tots, Inc. also must pay 7.15 percent of their salaries in the form of a socialsecurity contribution, 8 percent for unemployment and disability benefits, 6 percent of salaries goes to apension fund, and $60 per month for health benefits is paid for each of them. These fringe benefits applyto all employees of Tiny Tots, Inc.The additional details of the contract are as follows:? The day care center will be open 20 days every month. Parents pay a monthly fee based on an8- hour day (9:00 a.m. to 5:00 p.m.).? Fees do not vary if less than a full day or less than a month of day care is used by the parents.? Based on projected demand, it is expected that the day care center will open in January 2014with 120 children. Ms. Nemet has been successful in negotiating a ratio of 6 children to 1 day care workerfor the first year of operation.? Day care workers earn $7.00 per hour. They work from 9 to 5 and get paid for eight hours.? Children get a snack and lunch. The food cost is $3.00 per child per day. The cost of supplies is$1.50 per child per day. The City of Coldville has purchased certain equipment (such as cots and desks)for the first 120 children. However, these costs are estimated to increase by $50 per child as theenrollment at the day care center goes up. EXAMPLE: The City of Coldville will pay for the cots for 120children in January, if 10 children are added in a subsequent month, then 10 X $50 would be budgeted inthat month for the additional children.For the months of February through May, the enrollment growth is expected to grow by 10 % each month,effective June through December monthly enrollment growth equals 5% per month? Parents pay $200 per month per child.? In the first year, Coldville is "donating" space and utilities. Ms. Lux says that this city contributionis worth $2,000 a month. Mr. Legato says that the union will contribute to the cost of the city's new daycare center by providing $1.00 per child per day for the children of union members. It is estimated that 70percent of the children will be children of union members.? The state has a subsidized day care start-up grant for the first year of operation. This grant is$100,000 a year.REQUIRED:You are a budget analyst in the Budget Office of the City of Coldville. Mayor Spark just asked you to "runsome numbers" so that she can take a look at the arrangement that was just negotiated between Ms. Lux,Mr. Legato, and Ms. Nemet. You should prepare the budget in a spreadsheet. A well-designed (andflexible) spreadsheet will simplify your task later. Complete the following:1) Prepare the baseline 2014 monthly budget for the day care. (You can assume a calendar year.)Determine the total surplus (profit) and deficit (loss) for each month.
Paper#50658 | Written in 18-Jul-2015Price : $32