Question

In: Finance

Consider the following 2016 data for Newark Hospital (in millions of dollars) Simple Budget Flexible Budget...

Consider the following 2016 data for Newark Hospital (in millions of dollars)

Simple Budget Flexible Budget Actual Results
Revenues $4.7 $4.8 $4.5
Costs 4.1 4.1 4.2
Profit 0.6 0.7 0.3

a. Calculate and interpret the two profit variances

b. Calculate and interpret the two revenue variances.

c. Calculate and interpret the two cost variances.

d. how are the variances related

Answer a-d.

Solutions

Expert Solution

a. Profit variance in case of simple budget = 0.6 - 0.3 = 0.3 (unfavorable)

Profit variance in case of flexible budget = 0.7 - 0.3 = 0.4 (unfavorable)

Flexible budget calculates the profit at the actual output level, using the budgeted costs and revenue per unit. Simple budget does not consider the actual output, but the budgeted output.

b. Revenue variance in case of simple budget = 4.7 - 4.5 = 0.2 (unfavorable)

This means that the hospital is earning lesser revenue than budgeted.

Revenue variance in case of flexible budget = 4.8 - 4.5 = 0.3 (unfavorable)

This means that at the actual level of output i.e the number of patients treated, is more than the budgeted patients, causing an increase in flexible budget revenue.

c. Simple budget cost variance = 4.1 - 4.2 = 0.1 (unfavorable)

Flexible budget cost variance = 4.1 - 4.2 = 0.1 (unfavorable)

The simple budget cost variance is unfavorable, meaning that at the budgeted levels of output, actual cost is more than the budgeted cost.

The flexible budget cost variance is also unfavorable, meaning that at the actual level of output, actual cost is more than the budgeted cost.

d. The 2 variances are related in the sense that that the level of output is different in case of simple and flexible budget, while the per unit revenue or cost is same in both the budgets.

Suppose the hospital treats 10 patients actally, with revenue per patient = $5. Actual total revenue = 10*5 = 50.

Budgeted patients to be treated = 11. Budgeted revenue per patient = $4.5

Simple budget revenue = 11*4.5

Flexible budget revenue = 10*4.5

Actual revenue = 10*5

Simple variance = 11*4.5 -10*5

Flexible variance = 10*4.5 - 10*5

Thus the only part changing between the simple variance and flexible variance is that simple variance is using 11 patients for budgeted revenue, while fexible variance is using 10 patients for budgeted revenue.


Related Solutions

The budget​ (in millions of​ dollars) and worldwide gross​ (in millions of​ dollars) for eight movies...
The budget​ (in millions of​ dollars) and worldwide gross​ (in millions of​ dollars) for eight movies are shown below. Complete parts​ (a) through​ (c). Budget, x Gross, y 206 253 205 302 200 423 199 688 182 688 175 1035 173 1878 168 1225 (a) Display the data in a scatter plot ​(b) Calculate the correlation coefficient r. (c) Make a conclusion about the type of correlation.
Consider the following data on the estimated cost (in millions of dollars) resulting from traffic congestion...
Consider the following data on the estimated cost (in millions of dollars) resulting from traffic congestion for different urban areas. The following are the data for the 13 largest U.S. urban areas. Urban Area Total Cost (millions of dollars) New York 16 Los Angeles 13 Chicago 7 Washington, D.C. 5 Houston 5 Dallas, Fort Worth 4 Detroit 4 Miami 4 Phoenix 4 Philadelphia 4 San Francisco 3 Boston 3 Atlanta 3 (a) Calculate the mean and standard deviation for this...
Consider the following data ( in millions of dollars): Year Real DI Real C 0 1900...
Consider the following data ( in millions of dollars): Year Real DI Real C 0 1900 1839 1 2000 1935 2 1700 1647 For now, assume that no other variable ( besides disposable income) that could affect real consumption has changed between Year 0, Year 1, and Year 2. a.) Draw the general shape of the consumption function. b.) Solve for the marginal propensity to consume ( show your work). c.) What is the slope of this consumption function (...
6 Consider the following data from the past year for the BSU General Hospital Static Flexible...
6 Consider the following data from the past year for the BSU General Hospital Static Flexible Actual Budget Budget Results Revenues 9,400,000 9,200,000 9,100,000 Costs 5,200,000 5,300,000 5,500,000 Profits ? ? ? a) Calculate and interpret the profit variance b) Calculate and interpret the revenue variance c) Calculate and interpret the cost variance d) Calculate and interpret the volume and price variances on revenue side e) Calculate and interpret the volume and management variances on cost side f) How are...
Given the following data (in millions of dollars): contributedcapital in excess of par,    $70;...
Given the following data (in millions of dollars): contributed capital in excess of par,    $70; depreciation expense, $13; interest expense, $10; earnings after taxes, $32;    common stock ($1 par), $8; earnings before interest and taxes, $50; fixed assets, $73;    retained earnings, $82. The common stock price is $56. Compute the numerical    values of net fixed assets, earnings per share, price-earnings ratio, interest coverage    ratio, book value per share, and after-tax cash flow.
The following data represent a sample of the assets (in millions of dollars) of 28 credit...
The following data represent a sample of the assets (in millions of dollars) of 28 credit unions in a state. Assume that the population in this state is normally distributed with σ=3.5 million dollars. Use Excel to find the 99% confidence interval of the mean assets in millions of dollars. Round your answers to three decimal places and use ascending order. Assets 12.23 2.89 13.19 73.25 11.59 8.74 7.92 40.22 5.01 2.27 16.56 1.24 9.16 1.91 6.69 3.17 4.78 2.42...
Consider Fisher & Company’s financial data as follows (unit: millions of dollars except ratio and time...
Consider Fisher & Company’s financial data as follows (unit: millions of dollars except ratio and time figures): Cash and marketable securities $100 Fixed assets $280 Sales $1,200 Net income $358 Inventory $180 Current ratio 3.2 Average collection periods 45 days Average common equity $500 Find Fisher’s accounts receivable Calculate the amount of current assets Determine the amount of current liabilities Determine the amount of total assets Calculate the amount of the long-term debt Calculate the net profit margin
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 15% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 60% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 20% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 75% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 30% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 60% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT