Brookside Hospital's imaging for hand, foot and forearm is a sub-unit of the Radiology department. They...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Brookside Hospital's imaging for hand, foot and forearm is a sub-unit of the Radiology department. They project ending the current year (2017) with 2,000 total procedures broken down as follows: Procedure Hand imaging Time Required 10 minutes Volume Rate proportion (Charge) 60% $100 Foot imaging 20 minutes 30% $300 30 minutes 10% $400 Prepare a professional document to present to the VP of Radiology which will include separate tables for each of the following: 1. Prepare a statistics budget summary by procedure and payer 2. Prepare a gross and net revenue worksheet by procedure and payer. Hint: prepare a table for each procedure and then one for the total of all procedures. 3. Prepare an expense worksheet based on the volume increases and the rate increases for each of the three types of expenses. Do not separate the expenses by procedure only by type of expense. 4. Prepare a summary income statement for overall revenues and expenses. Include appropriate header. Forearm imaging This sub-unit accounts for 20% of the Radiology department's current expenses of $1,225,000 broken down as follows: Expense Amount Labor $425,000 Imaging Materials $300,000 Overhead $500,000 Total $1,225,000 Payer Mix and Reimbursement is as follows: Volume Payer proportion Reimbursement Medicare 50% 70% of charges Medicaid 20% 50% of charges Managed care Self Pay 20% 80% of charges 10% 100% of charges * 20% of the self pay result in charity care Budget Assumptions for 2018: Volume increase is expected to be 10% with the same procedure mix . Due to volume increase, all three expenses are expected to increase 10%, in addition: Labor rates are expected to increase 5% due to merit increases The cost of Imaging materials are expected to increase 6% Overhead rate is expected to stay the same Required: Brookside Hospital's imaging for hand, foot and forearm is a sub-unit of the Radiology department. They project ending the current year (2017) with 2,000 total procedures broken down as follows: Procedure Hand imaging Time Required 10 minutes Volume Rate proportion (Charge) 60% $100 Foot imaging 20 minutes 30% $300 30 minutes 10% $400 Prepare a professional document to present to the VP of Radiology which will include separate tables for each of the following: 1. Prepare a statistics budget summary by procedure and payer 2. Prepare a gross and net revenue worksheet by procedure and payer. Hint: prepare a table for each procedure and then one for the total of all procedures. 3. Prepare an expense worksheet based on the volume increases and the rate increases for each of the three types of expenses. Do not separate the expenses by procedure only by type of expense. 4. Prepare a summary income statement for overall revenues and expenses. Include appropriate header. Forearm imaging This sub-unit accounts for 20% of the Radiology department's current expenses of $1,225,000 broken down as follows: Expense Amount Labor $425,000 Imaging Materials $300,000 Overhead $500,000 Total $1,225,000 Payer Mix and Reimbursement is as follows: Volume Payer proportion Reimbursement Medicare 50% 70% of charges Medicaid 20% 50% of charges Managed care Self Pay 20% 80% of charges 10% 100% of charges * 20% of the self pay result in charity care Budget Assumptions for 2018: Volume increase is expected to be 10% with the same procedure mix . Due to volume increase, all three expenses are expected to increase 10%, in addition: Labor rates are expected to increase 5% due to merit increases The cost of Imaging materials are expected to increase 6% Overhead rate is expected to stay the same Required:
Expert Answer:
Answer rating: 100% (QA)
To present the information effectively to the VP of Radiology well create a professional document wi... View the full answer
Related Book For
Accounting
ISBN: 978-0324662962
23rd Edition
Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren
Posted Date:
Students also viewed these accounting questions
-
Full-time employees at Canadian Western Bank can purchase company stock with the Bank contributing 50 cents for every $1 the employee pays, up to a maximum amount. What type of performance-based pay...
-
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...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
In the automobile parts supplier's hypothesis test of H0: = 3 versus Ha: 3 (as discussed in Exercise 9.48) find the sample size needed to make the probability of a Type I error equal to .05 and...
-
In a small country, why does growth in only one factor lead to either an ultra-protrade or an ultra-antitrade production effect?
-
The coils in Fig. 13.75 have L1 = 40 mH, L2 = 5 mH, and coupling coefficient k = 0.6. Find i1 (t) and v2(t), given that v1(t) = 10 cos Ï t and i2(t) = 2 sin Ï t, Ï = 2000 rad/s. in 2
-
From the balance sheet, what are the total assets?
-
Assume the same facts as in Problem 2-55. In problem 2-55 On June 3 of the current year, Eric, Florence, and George form Wildcat Corporation and transfer the following items: Item Transferred Eric...
-
Military Test. The Armed Services Vocational Aptitude Battery is multiple-aptitude test battery used to assess the skills of applicants to the U.S. Armed Services. A group of military officers are...
-
Discussion: Video Case Study - Anderson Hicks What Do I Do? In the Video Case Study: Anderson Hicks (after chapter 9), find the Case File and Video. Read and explore the resources found there....
-
On June 8, James Company sold merchandise listing for \(\$ 1,850\) to Dalton Company, terms \(3 / 10, n / 30\). On June \(12, \$ 550\) worth of the merchandise was returned because it was the wrong...
-
The Claremont Company's ending inventory is composed of 50 units that had cost \(\$ 20\) each and 100 units that had cost \(\$ 15\) each. If all 150 units have an NRV of \(\$ 16\) each, what value...
-
Revenue Recognition Standard-Adjusting Journal Entries Prime sold \(\$ 2,000,000\) of merchandise on account during the current year. The cost for this merchandise to Prime was \(\$ 800,000\). To...
-
In a sequential convergence multicomponent simulation program for distillation, the loops are nested. The outermost loop is mole fractions, next is flow rates, and the innermost loop is temperature....
-
The following are selected transactions of Candy, Inc., during the month of June: June 18 Sold and shipped on account to Dante Company \(\$ 5,000\) ( \(\$ 3,000\) cost) of merchandise, with terms of...
-
Describe the intent of establishing response standards. o Discuss the importance of terminology. o Describe the impact of SOPs and SOGs in developing response standards
-
Explain five different cases of income exempt from tax with clear examples.
-
Assume that United Technologies Corporation is evaluating a proposal to change the companys manual design system to a computer-aided design (CAD) system. The proposed system is expected to save...
-
In 2008 the City of Chicago agreed to lease 35,000 parking meters to a Morgan Stanley-led partnership Morgan Stanley for a one-time sum of \($1.15\) billion. The lease has been criticized as an...
-
Pure White Automatic Laundry must either have a complete overhaul of its current dry-cleaning system or purchase a new one. Its cost of capital is 18 percent. Pure Whites accountant has developed the...
Study smarter with the SolutionInn App