Question

In: Accounting

Case 3 – Westside Hospital The Westside Hospital radiology department is preparing a budget for the...

Case 3 – Westside Hospital

The Westside Hospital radiology department is preparing a budget for the following year. A major budget category is hand, foot, and forearm imaging. Current year admissions for these imaging categories totaled 2,000, which breaks down as follows:

Procedure

Time Required

Volume Proportion

Rate

Hand imaging

10 minutes

60%

$100

Foot imaging

20 minutes

30%

$300

Forearm imaging

30 minutes

10%

$400

The radiology department head thinks there will be a 10% increase in volume for next year. This additional volume is expected to have the same procedure mix as the current year. Rates are not expected to change.

The controller projects the payer analysis to be 50% Medicare (reimbursement % of charges), 20% Medicaid (reimbursement % percent of charges), 20% managed care (% of charges), and 10% self-pay (full charges, but 20% of self-pay results in charity care).

These three procedures account for 20% of the radiology department’s current $1,225,000 labor, imaging materials, and overhead expenses, which can be broken down in the following manner:

Labor

$425,000

Imaging materials

$300,000

Overhead

$500,000

Total

$1,225,000

The department’s labor expenses are expected to increase 5% next year due to an anticipated across-the-board pay raise. Imaging materials expenses are expected to increase 6%, primarily due to increase in precious metals costs. The department’s overhead expenses are forecasted to remain constant for the next year.

In addition to their individual cost increases, all three expenses are expected to increase by 10% due to the overall volume increase.

Prepare a budget for the next year by completing the following steps:

(a) Calculate the current volume for each imaging procedure by multiplying the total volume of 2,000 by the proportion for each procedure.

(b) Increase the current volumes by 10% to get the project volume for each procedure.

(c) Multiply the projected volume for each procedure by the rates to get gross projected revenues.

(d) Use the reimbursement rates to convert gross projected revenues to net projected revenue.

(e) Divide the current expenses in each category by current volume in that category to calculate current expense per procedure.

(f) Forecast expenses per procedure using individual expense increase information.

(g) Multiply the forecasted per-procedure expenses by the projected volume to get total expenses for the procedure.

(h) Prepare a summary income statement for overall revenues and expenses.

Solutions

Expert Solution


Related Solutions

The Radiology Department provides imaging services for Emergency Medical Center. One important activity in the Radiology...
The Radiology Department provides imaging services for Emergency Medical Center. One important activity in the Radiology Department is transcribing digitally recorded analyses of images into a written report. The manager of the Radiology Department determined that the average transcriptionist could type 700 lines of a report in an hour. The plan for the first week in May called for 81,900 typed lines to be written. The Radiology Department has three transcriptionists. Each transcriptionist is hired from an employment firm that...
Assume that you are preparing a budget for your department or organization. Outline the steps you...
Assume that you are preparing a budget for your department or organization. Outline the steps you would take to prepare the budget, providing specific examples for each step.
CHAPTER 3: RADIOLOGY Case 3-1 Interventional radiologists perform both the procedure and the radiologic services, so...
CHAPTER 3: RADIOLOGY Case 3-1 Interventional radiologists perform both the procedure and the radiologic services, so you will report both the procedure and radiology services. LOCATION: Outpatient, Hospital PATIENT: Mike Morgan PRIMARY CARE PHYSICIAN: Ronald Green, MD INTERVENTIONAL RADIOLOGIST: Edward Riddle, MD EXAMINATION: CT-guided liver biopsy. CLINICAL SYMPTOMS: Liver mass. CT-GUIDED LIVER BIOPSY: Informed consent was obtained. The patient was placed supine on the CT table, and axial CT was performed to localize the low-density lesion within the dome of...
Archer Electronics is preparing its annual budget, and your department is working on the cash flow...
Archer Electronics is preparing its annual budget, and your department is working on the cash flow budget. Here is selected information you have: Description June July August Sales $348,000 $438,000 $450,000 The company makes 10% of its sales for cash and 90% on credit. Of the credit sales, 20% are collected in the month after the sale and 80% are collected two months after. The cash receipts for August are: A. Not enough information to solve the problem B. $326,000...
You are the Administrator of the Radiology Department responsible for the day to day operation as...
You are the Administrator of the Radiology Department responsible for the day to day operation as well as developing the capital budget. Your capital budget for fiscal year 2015(July 1, 2014 to June 30, 2015)is $1 million. You have received two capital requests. One from the Medical Director of Mammography requesting a new state of the art digital mammogram machine at the cost of $800,000. This department has won awards for its outreach to poor and low income women who...
Q.1 The budget department of ABC Ltd., gathered the following information for preparing its budgets for...
Q.1 The budget department of ABC Ltd., gathered the following information for preparing its budgets for forthcoming period. 1. Sales forecast. Product Sales Quantity Selling price Inventories 01-01-2019 31-12-2019 Product-A 30,000 units Rs. 30 per unit. 5,000 units 10,000 units Product-B 40,000 units Rs. 40 per unit. 10,000 units 15,000 units Materials Purchase budget. 2. Material Product Inventories A B 01-01-2019 31-12-2019 Price per kg Materials-X 2kg 1kg 25,000kg 30,000kg Rs.2.0 Materials-Y 1kg 3kg 10,000 kg 15,000 kg Rs.1.0 3....
Complete a driver diagram on improving patient satisfaction in the radiology department or on a current...
Complete a driver diagram on improving patient satisfaction in the radiology department or on a current issue you are dealing with at work. I work at Cvs Health Minute Clinic , a current issue is wait time Complete a flow chart on one of the processes in the issues you did your driver diagram on.
1.Choose a major capital piece of equipment to be used in the radiology department of a...
1.Choose a major capital piece of equipment to be used in the radiology department of a hospital (e.g., CAT scan, MRI, nuclear medicine camera, etc.). Next, research and choose a vendor. Vendors such as GE, Siemens, or others can be located on the Internet. 2.Request information on cost justification and ROI from the vendor. 3.Write a justification for capital purchase (750-1,000 words) to your vice president as to why this would be a good investment for the hospital. Include the...
You are the director of a radiology department. During a routine individual meeting with one of...
You are the director of a radiology department. During a routine individual meeting with one of your male staff, the employee tells you that a female employee has been making suggestive remarks to him, and occasionally grabbed and fondled him in a sexual manner. He said he asked her several times to stop this behavior as he was married and did not appreciate the behavior, particularly in a work setting. The behavior continued anyway. The male employee asks you not...
A company is preparing the production budget
A company is preparing the production budget for the second quarter Projected sales (in units) are as follows: • April 600 Units • May 680 units • June 750 units The company policy decided at the start of the period on 1 April to have an ending finished goods stocks of 20% of the next month's projected sales. Assuming that there was no opening stock for April, what should be the production quota for May? Select one: O a. 680 units O b. 666 units O c....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT