Health Care Administrator Case Study

Question Description
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).

Read the Case Study 13.3: North Side HospitalPreview the document
Use the Excel workbook you downloaded in Module 1 titled: HSC/NUR414 Finance Workbook
Open the tab “M6A2” – Cash Budget Form.
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

HSC/NUR 414 Excel Assignment Rubric

Criteria Ratings Pts
This criterion is linked to a Learning OutcomeCompleteness of Assignment

50.0 pts
A: All data, and formulas in Excel worksheet are present and accurate.

43.0 pts
B: One data component, or formula is missing or incorrect in Excel worksheet.

38.0 pts
C: 2-3 data components, and/or formulas are missing or incorrect in Excel worksheet.

32.0 pts
D: 50-75% of the data components, and/or formulas in Excel worksheet are missing or incorrect.

27.0 pts
F: 75% or more of data components, and/or formulas in Excel worksheet are missing or inaccurate,

0.0 pts
0: Did not use Excel, Or No assignment was submitted.

50.0 pts

This criterion is linked to a Learning OutcomeAccuracy of Assignment

50.0 pts
A: All data, and formulas in Excel worksheet are accurate.

43.0 pts
B: One data component, or formula in Excel worksheet is incorrect.

38.0 pts
C: 2-3 data components, and/or formulas are incorrect in Excel worksheet.

32.0 pts
D: 50-75% of the data components, and/or formulas are incorrect in Excel worksheet.

27.0 pts
F: 75% or more of data components, and/or formulas in Excel worksheet are inaccurate.

0.0 pts
0: Did not use Excel, Or No assignment was submitted.

50.0 pts

Total Points: 100.0

Kristin, please do the best you can and submit as soon as you can. I will give you the completed budget to be used in your part 2 of the case study project. Thanks, Lisa

 

24/7 Nursing Homework Help

Stuck with your nursing assignment? From Essays to Complicated Dissertations? Our accredited nursing paper writers can answer it all!