Case Study Assignment Part II

Words: 1388
Pages: 6
Open Document
Hi,

When you write the paper, please don’t use a excel spreadsheet, only use analysis of the data in Microsoft word sheet. I mean explain everything in words. Thanks!

Case Study Assignment Part II

Budget Analysis II | ABC Facility

This is your second budget analysis, but more detailed to review a skilled nursing facility based on a prior year budget. As a health care administrator/manager it will be your responsibility to analyze your current year’s budget based on your prior year’s budget. You will review what changes are projected for revenue and expenses as well as provide a sound precise reason for those changes.
Healthcare organizations must set rates at levels sufficient to maintain their financial viability. …show more content…
Column I: 2011 PPD- the prior year budget figures are to be calculated into PPD numbers
b. Column J: 2012 PPD- the current year budget figures are to be calculated onto PPD numbers
c. Column K: Diff- calculate the difference between the two budget years as PPD numbers
d. Column O: Administrative Comments Compare the Two Years- you will provide your analysis of the difference in the two years, such as: i. Was there and increase or decrease in the two years ii. What would be your projections of the differences (you can do a comparison by reviewing the census, revenue and pay mix, etc.). You may feel it could be a cost increase; more services may be required due to a projected increase in patients, etc.

3. Finally, review the complete budget summary by clicking on “Summary” tab. You will be calculating the highlighted areas in blue, which are: a. Column H: 2011 PPD
b. Column I: 2012 PPD
c. Column J: PPD Diff
d. Column K: PPD % Change

Conclusion
When finished with the spreadsheets, write a one page analysis of your findings with the ABC facility. Include the following:
1. Provide an overview of your findings from the Administrative Comments comparing the two budget years of your expense detail.
2. What were the expenses for both years both in dollars and in PPD
3. What was the total census and how many beds did this facility have? Break your census down into payer categories which total the projected census.

4. What were the
Show More

Related Documents: Case Study Assignment Part II

BU121 FINAL PART 2 Essays

Forecasting Financial Needs Short-term – cash flow forecast Long-term Integrated, work with other functional areas to see what is needed Developing Budgets to meet those needs Master Budget Operating Budget Capital Budget – building, major equipment Cash Budget – short term cash flow planning tool Establishing Financial Control Deviations from Budget Seeing if you have stuck to your plan, compare budgeted numbers with actual numbers and check deviations Advantages of Budgeting Planning Compels…

Words 6108 - Pages 25

Abc Mining Company Case Study

TO: ABC Mining Company FROM: T DATE: April 14, 2012 RE: Tax consequences and other risk factors associated with mining operations I. FACTS ABC Mining Company, Inc. is a publically traded, large domestic mining company with over 500 plants in the United States. ABC owns a tract of land in California upon which it has conducted a strip mining operation for coal. An unrelated party owns a tract of land adjacent to the tract of land in California, which is owned by ABC. This land is worth…

Words 7170 - Pages 29

My Own Essay

Study of -Computerized Maintenance Management System (CMMS) in Nanavati Hospital A Report submitted to Prof. J.M. Shah for the partial fulfillment of the requirements for the subject Information Systems for Management under NMIMS University Group 4: Shamsy Goyal 211 Anvesha Poswalia 228 Abhishek Singhal 237 Amar Bhartia 255 ShashanYagnick 259 Anand Madhusudan 260 Table of Contents Nanavati Hospital - The Organization and its…

Words 9284 - Pages 38

Accounting Information Systems Test Bank 10th Edition Essay

this area, the group formally created the designation known as a) the Certified Management Accountant. b) the Certified Information Technology Professional. c) the Certified Internal Auditor. d) the Certified Data Processing Professional. 30. An analysis conducted by the Institute of…

Words 41103 - Pages 165

Essay about H3 Hummer Marketing Plan

Situation…………………………………………………………………3 History/Background………………………………………………………………….3 Purpose/Mission……………………………………………………………………...4 Products Offered……………………………………………………………………..5 Financial Performance……………………………………………………………….5 Threats & Opportunity Analysis……………………………………………………………..6 Demographic Forces…………………………………………………………………6 Economic Forces…………………………………………………………………….8 Natural Forces……………………………………………………………………….8 Technological Forces……………………………………………………………….10 Political Forces………………………………………………………………………

Words 7385 - Pages 30

Marketing Audit Essay

Walt Disney Corporation Marketing Audit Max McKay Sabrina Coady Henrik Oiseth Principles of Marketing 308 Professor Simpson November 14, 2006 Walt Disney Corporation Founded in 1923, the Walt Disney Company has predicated itself as the world’s best in the family entertainment business. After 80 years in the business, who could argue with that statement? Today, Walt Disney Corporation dominates the market of family entertainment. An unparalleled experience is the direct affect…

Words 5818 - Pages 24

Managing Information Technology (7th Edition) Essay

CONTENTS: CASE STUDIES CASE STUDY 1 Midsouth Chamber of Commerce (A): The Role of the Operating Manager in Information Systems CASE STUDY I-1 IMT Custom Machine Company, Inc.: Selection of an Information Technology Platform CASE STUDY I-2 VoIP2.biz, Inc.: Deciding on the Next Steps for a VoIP Supplier CASE STUDY I-3 The VoIP Adoption at Butler University CASE STUDY I-4 Supporting Mobile Health Clinics: The Children’s Health Fund of New York City CASE STUDY I-5…

Words 239873 - Pages 960