Revenue and expense data for schumpert medical center

Assignment Help Accounting Basics
Reference no: EM139780

The subsequent two spreadsheets provide workload (expressed as relative weighted products (RWPs) for inpatient care), revenue, and expense data for Schumpert Medical Center covering their fiscal years 2010 and 2011. The data includes FY10 actual workload, revenues, and expenses; FY11 forecasted workload, revenues, and expenses; and FY11 year-to-date workload, revenues, and expenses. The Inpatient Product Lines worksheet provides further details on the types of services provided within each major service line. Using the available data, perform a variance analysis on Schumpert Medical Center and answer the following questions:

1. What was the hospital's original profit forecast (assume away any issues with depreciation, taxes, etc.)? Halfway through the fiscal year, what is the hospital's revised projection for FY11 profits?

2. Which inpatient service lines are overbudget? Which product lines are overbudget after accounting for workload increases?

3. What actions would you take at the mid-year point if you were a fee-for-service hospital? In other words, where are the problem areas on which you would focus your attention, and who might provide ideas for "best practices" based on their performance?

4. What actions would you take at the mid-year point if you were a capitated hospital? In this case, the revenue spreadsheet would be replaced with an overall budget of $50 million with which to operate (rather than being able to bill for each episode of patient care). Federal, state, county, and city hospitals normally operate under a capped budget. Additionally, many HMOs also operate under a fixed Per Member, Per Month (PMPM) capitated process.

Reference no: EM139780

Allowance method used to account for bad debits

On Oct. 29 of the current year, a company concluded that a customer's $4,400 account receivable was uncollectible and that account should be written off. What efect will thi

The inventory balances of tog designs

On May 31, the inventory balances of Tog Designs, a manufacturer of high quality children's clothing, were as follows: Materials Inventory, $21,360; Work in Process Invent

Corporations taxable income after drd

Included in this amount is dividend income of $60,000 from another corporation in which the taxpayer owns 90 percent of its stock outstanding. The corporation's taxable inco

Provide and explain missing closing entry

Retained earnings at 1/1/06 was $150,000 and at 12/31/06 it was $200,000. During 2006, cash dividends of $50,000 were paid and a stock dividend of $40,000 was issued. Both d

Recognized on liquidating distributions

Why do you think Congress requires the recognition of gain on the distribution of appreciated property but does not allow the recognition of loss on depreciated property in

Casey fisher and logan baylor formed a partnership

Casey Fisher and Logan Baylor formed a partnership in which the partnership agreement provided for salary allowances of $40,000 and $35,000, respectively. Determine the divisi

Problem regarding preferred stockholders

No dividends were paid the previous 2 years. If Koon declares $400,000 of dividends in the current year, how much will preferred stockholders receive if the preferred stock

Income and expenditure account and statement of financial

From the following balances relating to the accounts of a small football club as at 31 March 20X8 draw up the income and expenditure account and the statement of financial p


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd