Question
Metropolitan Nashville General Hospital Partial 2023 Expenses & 2024 Budget Task #1: Please annualise the given data from 2023. Task #2: Please standarise the data
Metropolitan Nashville General Hospital Partial 2023 Expenses & 2024 Budget
Task #1: Please annualise the given data from 2023.
Task #2: Please standarise the data (% Common Size) 2023 & 2024
Task #3: Based on the standarised data for the Operating Rooms account only: What is the difference (weight or %) between actual sales and the Budget? Are the sales aligned with the budget? Justify your rational.
| 11 month (given) | Annualised (Es) 2023 | % Common Size | Budget 2023 (given) | % Common Size | |||
| Salaries (pensions) | $ 128,240,000.00 | $ 125,200,345.00 | |||||
| Laboratory | $ 10,900,000.00 | $ 11,110,000.00 | |||||
| Radiology | $ 13,300,000.00 | $ 13,505,300.00 | |||||
| Pharmacy | $ 14,100,200.00 | $ 14,800,500.00 | |||||
| Emergency Depart | $ 7,000,000.00 | $ 7,100,125.00 | |||||
| Operating Rooms | $ 9,700,560.00 | $ 10,825,036.00 | |||||
| Physical Therapy | $ 3,505,600.00 | $ 3,060,087.00 | |||||
| Houskeeping | $ 450,000.00 | $ 487,000.00 | |||||
| Community Relations | $ 41,512.00 | $ 48,813.00 | |||||
| Maintenance | $ 990,000.00 | $ 1,115,000.00 | |||||
| Nursing Administration | $ 67,830.00 | $ 97,835.00 | |||||
| Telephone | $ 8,422.00 | $ 9,355.00 | |||||
| Utilities | $ 17,135,033.00 | $ 18,137,778.00 | |||||
| Laundry | $ 245,000.00 | $ 218,000.00 | |||||
| Data processing | $ 37,874.00 | $ 48,976.00 | |||||
| Environmental Services | $ 90,765.00 | $ 82,442.00 | |||||
| Safety | $ 3,500.00 | $ 4,600.00 | |||||
| EE Health | $ 1,850.00 | $ 2,125.00 | |||||
| Insurance | $ 274,350.00 | $ 284,350.00 | |||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing Principles Practice And Problems
Authors: Jagdish Prakash
1st Edition
9327244745, 978-9327244748
