Rosemonth Hill Health Center
Assignment:Prepare and submit two stepdown spreadsheets for this case to determine the cost per visit as follows:
1. By allocating the cost of nursing, social services, laboratory, record-keeping, administration and rent, utilities and cleaning to the Pediatrics, Family Planning, Adult Medicine, Nursing, Mental Health, Social Services, Community Health, and Dental Services Department. To check your work for accuracy you should find that the cost per visit to Adult Medicine is a surprising $47.51 given its $11.00 fee
2. For this somewhat more realistic stepdown analysis, treat the laboratory and social service departments as separate cost centers. Here the social service department charges separately regardless of where it offers services while the laboratory charges on an hourly basis. To check your work for accuracy you should find that the cost per hour for the Laboratory is $8.77 (Well, it was 1975 after all!).
Use the following Exhibit to calculate the above: Separate in two spreadsheets:
Exhibit 1 Financial Statements for 1975
As of December 31,1975
Liabilities and Fund Balances
Furniture & Equipment
Designated by board for
Special Outreach Project
Purchases of new equip.
Total Fund balances
Total Liabilities and Fund
Revenue from patient fees
General and Administrative
Exhibit 2 Costs and Patient Visits1 for 1975, By Department
Number Patient Visits
Number of Patient Visits
Average Cost per Visit
1Patient visits rounded to nearest 100; Expenses rounded to nearest 1,000
2Includes fringe benefits
3Materials, supplies, contracted services, depreciation and other non-personnel expenses
Exhibit 3 Floor Space and Laboratory Usage1 by Department
1Rounded to nearest 100
2 In Square Feet
Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more