Section C The programs at Denison consume the services of departments as follows: That is, oncology patients

Question:

Section C
The programs at Denison consume the services of departments as follows:

That is, oncology patients consume 80 percent of the services of the radiology department but only 50 percent of the nursing services provided.
Note that Denison classifies rent, depreciation, and bad debts expenses as €œGeneral Expenses€ rather than assigning them to any specific department. However, if equipment can be specifically traced to a program, the depreciation on that equipment is charged to that program.
Section C Requirements:
1. In Part I, Section B, number 2, you prepared a line- item expense budget on an accrual basis. Prepare the expense budget again as a responsibility center bud-get, showing the projected costs for each department (Radiology, Nursing, and Administration).
2. Prepare an expense budget with expenses shown by program (Oncology, Cardiac, Rhinoplasty). For simplicity, assume that bad debts are not assigned to specific programs.
Section D
The hospital usually prepares a flexible budget as part of its annual master budget to assess the likely impact of patient volume variations on revenues and expenses.
The salaries of managers are all fixed costs. That type of expense does not change as patient volume changes. The staff salaries are variable costs (expenses) in all areas except in the administration department, where they are fixed. All salaries are paid in equal amounts each month. Variable salaries vary in direct proportion to patient volume. Supplies vary in direct proportion to patient volume.
Section D Requirement:
1. Prepare a flexible budget assuming patient volumes are 10 percent and 20 per-cent higher and 10 percent and 20 percent lower than expected. Also include the expected patient volume level in the flexible budget. Prepare the flexible budget before doing the cash flow budget in Section E.
Section E
Patients are expected to be treated and discharged throughout the year as follows:

Historically, Denison has found that private insurance pays in the quarter after patient discharge. Medicare/ Medicaid pays half in the quarter after discharge and half in the following quarter. Twenty- five percent of all self- pay revenue is collected each quarter for three quarters following discharge. Twenty- five percent is never collected. Also, charity care is never collected. For simplicity, assume that the current year€™s patient flow, payment rates, staffing, and supplies purchases are the same as those projected in the budget for the coming year. Supplies are expected to be purchased in the following months:

The supplies are paid for in the quarter after purchase.
Assume that all interest and dividends on endowment investments are received on the first day of the seventh month of the year. Assume that gift shop revenue is received equally each quarter. (This may be an unrealistic assumption.) Assume that salaries are paid equally each quarter.
Denison plans to start next year with $ 50,000 of cash and likes to end every quarter with at least $ 50,000 in its cash account. If necessary, it will borrow from the bank at a rate of 12 percent per year. Each quarter it must pay interest on any outstanding loan balance from the end of the previous quarter. When it has extra cash, it repays its outstanding bank loan. If it has extra cash beyond that, it simply leaves it in its non- interest- bearing cash account. Denison prepares its operating budget ( revenues and expenses) on an accrual basis. The hospital expects to buy the oncology equipment as described in Part I of the case.
Section E Requirements:
1. Prepare a cash budget for the coming year. It will help if you prepare it in the following order:
a. Determine patient revenues by quarter by type of payer for the coming year. That is, determine private insurance revenues for each quarter, Medicare/ Medicaid revenues by quarter, and so on.
b. Determine patient revenues by quarter for the current year. Since many payers pay with a lag, some of the coming year€™s cash receipts come from current year€™s revenues.
c. Determine patient cash collections by quarter for the coming year, using revenue information from parts a and b, and payment lag information provided in the narrative of the problem.
d. Develop the cash budget by quarter.
Start with the beginning cash, add cash receipts shown by source (e. g., patient revenue by payer, endowment). Calculate the available cash. (Note that it will be necessary to determine other cash receipts and payments by quarter. For example, determine how much is received from endowment each quarter and how much is paid for supplies.)
Deduct cash payments by line- item (e. g., salaries). Be sure to include interest payments. Assume Denison does not owe any money at the beginning of the year. Subtract cash payments (called disbursements) from available amount to get a subtotal.
Based on the subtotal, calculate the amount to be borrowed or repaid. Combine the amount borrowed or repaid with the subtotal to get ending cash balance for quarter.
Show loan payable amount on cash budget below the ending cash balance. It is easier to develop a correct cash budget if you work one quarter at a time.
2. Based on your cash budget, prepare a revised operating budget. That is, take the operating budget Part I, Section B, number 3, and incorporate the interest expense from the cash budget. Do not prepare a revised flexible budget.
3. As an advisor to the Denison Hospital, you are certain of one thing: the Board of Trustees of the hospital will not approve a budget that projects an operating deficit. If the operating budget projects a deficit, what do you suggest that Denison do aboutit?

Cash Budget
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment. Its primary purpose is to provide the...