Scenario
One year ago, Metropolitan Memorial expanded its operations into a rural community located approximated a hundred miles from its main facility. The clinic offers a wide array of outpatient services. As the Senior Accountant, you are reviewing the clinic’s operating budget from the previous year. You have been asked by the hospitalchief administrator to create a new six-month operations budget for the clinic.
Operating-Budget.xlsx – –See attached Excel Sheet
Instructions
Using an Excel spreadsheet, create a new six-month budget for the clinic that includes the following revenue and expense projections: (See the document, notes for how to add numbers to the spreadsheet)
- The clinicrevenue is projected to grow by approximately 3% as a result of a new managed care contract.
- The cost of expenses is expected to increase to 1.5%.
- The clinic will also be adding a new roof to the facility at a projected cost of $50,000.
Then prepare a memo for the chief administrator. The memo should include a review of the previous yearbudget, an analysis of the upcoming changes (figures above), and a discussion about the impacts that these changes will have on the budget for the upcoming year.
****REMEMBER – Create a new six-month operations budget for the clinic (Excel Spreadsheet) & THEN write a MEMO with that information.****
The post One year ago, Metropolitan Memorial expanded its operations into a rural community located approximated a hundred miles from its main facility first appeared on Courseside Kick.