Finance Questions

Module 8: Sensitivity Analysis
The Winterville homeless shelters, including the potential new facility, are located in the same neighborhood as a facility that provides evening meals at no cost for needy individuals all week, year-round. The cost per meal is $7. Historically, all families and 70% of the single individuals have taken advantage of this service. Others come as well, and the facility has found it effective to plan for usage to be a total of 110% of the capacity of the family shelter and 90% of the capacity of the single-person shelter. With the new shelter’s capacity for 200 more individuals, the 110% ratio is uncertain. In Worksheet 8.1, examine the effect if the ratio falls by 10 percentage points or increases by 10 percentage points for each group. Show the change from the current annual cost.

Module 9: Integrating Budgeting With Performance
The state department of health (DOH) is considering implementing several performance measures. In a meeting with the central budget office, DOH officials are discussing their options and seeking advice on which measures to include. Identify the type of measure each statement represents and indicate whether you would recommend it be implemented or not, and why.
(a) Number of measles-mumps-rubella (MMR) shots given to 2-year-olds
(b) Percentage of 2-year-olds who are up-to-date on MMR vaccinations
(c) Number of smoking-cessation classes provided
(d) Number of teens attending smoking-cessation classes
(e) Number of workshop materials copied for classes
(f) Percent of high school students who smoke two cigarettes or more per week
(g) Percent of state population diagnosed with lung cancer
(h) Percent of class attendees who indicated satisfaction with the smoking-cessation class

Module 10: The Budget Process
Find and compare the budget calendar of two jurisdictions of your choosing. (Hint: Often the budget calendar can be found in an appendix of a published budget document.)

Module 11: The Budget Document
Find the budget for your governmental or nonprofit employer. If you are not employed or your employer will not share the budget, find a typical governmental budget such as that of a university, hospital, or museum (locate online). Then address topics:
(a) Determine its format.
(b) Identify three of its characteristics and give the page number for each
(c) Discuss whether the budget is useful and informative. Explain your reasoning.
(d) Identify any missing information and say why it would be useful

Module 12: Determining the Baseline Budget
Non-personnel expenses: You have been tasked with computing baseline budget targets for the upcoming budget cycle. Using Table 12.2 as your starting point, make the following adjustments:
(a) Solar panels have been installed with an expected 5% decrease in utility cost, for a savings of about $7,611
(b) Inflation is expected to be 2% except for utilities, which will see no increase, and for leased space, which by contract will have a 3% inflationary increase.

Table 12.2 Non-personnel Expenses
Expense Type FY 2014
General Supplies $ 69,532
Utilities 152,227
Leased Space 720,000
Fuel 50,571
Inspection Supplies 327,595
Inspection Start-up 125,000
Total Non-personnel $ 1,444,925

Module 13: Decision Packages: Cost Estimates
FluQ Case

Instruction: After reading the following case prepare a cost estimate using the format of Appendix A to this module (page 136 of your textbook)

You have been invited to a department meeting to help develop a budget request for upcoming legislative session. A new strain of the flu has been sweeping your region, and the vaccine FluQ has just been approved for children under age 12. The public health department you work for is taking the lead in vaccinating children in 30 elementary schools in the region. During the meeting, the program manager presents the following information.
The program will have three components. First, education is needed in each of the schools. The program manager wants to do a series of five in-person, 2-hour meetings—with one doctor, two nurses, and two administrative staff per meeting—as well as providing each child with an educational coloring book. Each school has 1,200 children.
Second, the vaccination clinics will be held at the schools. Children will be vaccinated when their parent or guardian signs the permission slip. Some health conditions rule out certain children as good candidates for vaccination. It is estimated that each school has 1,000 children who should receive the FluQ vaccination. In other states similar to yours, approximately 8% of parents refuse to have their child vaccinated. Vaccinations and associated supplies cost $2 per dose. On each vaccination clinic day, a doctor must be present. Nurses will be responsible for administering the vaccine. On average, it takes approximately 6 minutes to process a child and administer the vaccination.
Lastly, federal and state regulations require the reporting of all FluQ vaccinations administered. Additionally, the school administration and the parents have requested aggregated reports regarding the vaccination coverage in the region. It is estimated that for each child receiving the vaccination, 10 minutes will be required to record and save the necessary data in the various databases. For children not receiving the vaccine (either because of parental refusal or because the child was not a good candidate for the vaccine), it will take 5 minutes to record and save the necessary data. An additional 3 weeks of analysis and reporting are estimated to be required at the conclusion of each FluQ vaccination season to meet reporting requirements. Assume two administrative staff are working on the entire reporting segment.
While FluQ is a new vaccination, it is anticipated that it will need to be administered every year for the next 3 years to the same group of children. Population growth in your region has been stable for some years and is expected to remain stable in the near future.
You have the following information:
(a) The average wages for department staff are as follows: doctors—$95/hour; nurses—$64/hour; administrative staff—$32/hour.
(b) Because these are temporary roles, the only benefits are the legally required FICA, HI, workers’ comp, and unemployment benefits. The last two are estimated at 2% of payroll.
(c) Coloring books (including design and printing) had a cost of about $1.75 per book when used in another project that was similar to this one.
(d) Based on other vaccination campaigns, the cost of this campaign will be about $10,000 for database administration and computer setup for the program each year.

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.