HSC 528 Excelsior College Health Care Administrator Case Study

Throughout the course we have focused on financial matters of the health care administrator. Budgeting is an integral part of any organizations ability to forecast revenues and expenses for profit maximization. You will follow McKee & Mckee’, (2017) Case Study 13.3: North Side Hospital in preparing a three-month cash forecast (budget).

1. Read the Case Study 13.3: North Side Hospital
2. Use the Excel workbook you downloaded in Module 1 titled: HSC/NUR414 Finance Workbook
3. Open the tab “M6A2” – Cash Budget Form.
4. Complete the form to prepare a cash forecast (budget) for the months of January, February, and March using the case study as a guide.

Remember to save this file as a .xls or .xlsx file, using your last name and module number as the file name, e.g. Smith5.xlsx. Be sure to check your work and correct any spelling or grammatical errors before you submit it for grading.

When you are ready to submit your work, click “Submit Assignment” in the upper right corner. Click on “Browse,” browse your computer, and select your file. Click “Open” and verify the correct file name has appeared next to the Browse button. Enter your comments, if any, in the Comments area. Click on “Submit Assignment.”

Evaluation

This assignment will be graded using the rubric displayed below. Please review this rubric prior to beginning your work. You can also access the rubric on the Course Rubrics page within the Start Here module. Collectively the case study assignments are worth 25% of your final grade.

Reference: McKee, T. & Mckee, L. (2017). Healthcare Applications: A casebook in Accounting and Financial Management., Case Study 13.3: North Side Hospital. Chicago, IL: Health Administration Press

This assignment assesses the following module outcomes:

• Prepare a budget. (CO5)

Rubric

HSC/NUR 414 Excel Assignment Rubric