Preparation of Performance Reports; Hospital
Rocky Mountain General Hospital serves three counties in Colorado. The hospital is a nonprofit organization that is supported by patient billings, county and state funds, and private donations. The hospital’s organization is shown in the following chart.
The following cost information has been compiled for August.
| Budget | Actual | ||
| August | Year to Date | August | Year to Date |
Cafeteria: | ||||
Food servers’ wages | $ 8,000 | $ 64,000 | $ 9,000 | $ 72,000 |
Paper products | 4,500 | 36,000 | 4,400 | 36,200 |
Utilities | 1,000 | 8,000 | 1,050 | 8,100 |
Maintenance | 400 | 3,200 | 100 | 1,100 |
Custodial | 1,100 | 8,800 | 1,100 | 8,600 |
Supplies | 1,200 | 9,600 | 900 | 9,600 |
Patient Food Service | 17,000 | 136,000 | 18,500 | 137,000 |
Registered Dietitians’ Section | 1,500 | 60,000 | 7,500 | 60,000 |
Kitchen | 31,000 | 248,000 | 29,400 | 246,000 |
Nursing Department | 70,000 | 560,000 | 75,000 | 580,000 |
Radiology and Laboratory Department | 18,000 | 144,000 | 18,100 | 144.000 |
Housekeeping Department | 10,000 | 30,000 | 11,600 | 86,000 |
Maintenance Department | 13,000 | 104,000 | 6,000 | 77,000 |
General Medicine Division | 210,000 | 1650,000 | 204,000 | 1,670,900 |
Surgical Division | 140,000 | 1,120,000 | 141,000 | 1,115,800 |
Administrative Division | 50,000 | 400,000 | 53,500 | 406,000 |
Required:
1. Prepare a set of cost performance reports similar to Exhibit 12-4. The report should have six columns, as in Exhibit 12-4. The first four columns will have the same headings as those used above. The last two columns will have the following headings: Variance– August, Variance–Year to Date.
Since all of the information in the performance reports for Rocky Mountain General Hospital is cost information, you do not need to show these data in parentheses. Use For U to denote whether each variance in the reports is favorable or unfavorable.
2. Using arrows, show the relationships between the numbers in your performance reports for Rocky Mountain General Hospital. Refer to Exhibit 12-4 for guidance.
3. Put yourself in the place of the hospital’s administrator. Which August variances in the performance reports would you want to investigate further? Why?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.