Financial Management for Public Health Assignment Solutions

Assignment Question
Question 1: 
Using a Pivot Table, calculate total Services, total Revenue, and total Expenditures for Comprehensive Child Health for each of FY 19 and FY 20. Also calculate Revenue per Service as well as the net revenues. Finally, calculate the change in Expenditures (in total and as percent change) from year to year.
Question 2:
The manager of the Comprehensive Child Health department has complained to you that their visit workload has increased in FY2020 but the number of devoted FTEs has remained at 4. She suggests that if the health department had listened to her and hired a full time Senior Registered Nurse at the beginning of FY2020, the number of visits per FTE would have been the same as it was in 2019.

Is this assertion true? Please show your steps justifying your conclusion.
How much would the additional staff cost? Assume fringe is 33% and the nurse would need a telephone (with installation) and computer but no other supplies. Also, don't forget that the Florida State indirect rate is 25%. See tabs 3-6 for the data you will need to complete your calculations.

More Info:

Are you in pursuit of effective solutions for your university or college assignments and coursework?

Our team of dedicated professional writers is at your service around the clock, offering a comprehensive array of benefits:

  • Competitive Pricing: We provide best quality contents at the most competitive rates in comparison to other online writing services. We have 1600+ Ph.D writers from different academic disciplines ready to work on your task for any subject.

  • Zero Plagiarism: We guarantee 100% originality in all our work, ensuring that your assignments are free from plagiarism.

  • Harvard (APA) Style Referencing: Our services include complimentary Harvard (APA) style referencing to enhance the quality and credibility of your assignments.

  • Unlimited Revisions: We offer free and unlimited revisions to perfect your work according to your requirements.

  • Secure Payment: Payment is only processed after your order is accepted by a writer, and we offer secure payment methods through credit or debit cards.

Trust us to provide you with exceptional assistance and support in your academic journey.

We Cares About Your Privacy

We use precise cookies and geolocation data to store and access information on a device and to provide personalised ads and content, ad and content measurement, audience insights and product development.

Privacy Policy