Question

In: Accounting

Here are the budgets of Brandon Surgery Center for the most recent historical quarter (thousands of...

Here are the budgets of Brandon Surgery Center for the most recent historical quarter (thousands of dollars?):

                                               Static                     Flexible                     Actual

Number of surgeries                1,200                       1,300                      1,300

Patient Revnue                        $2400                      $2600                      $2535

Salary Expense                        1200                        1300                          1365

non-salary expense                    600                         650                            585

profit                                           $600                       $650                            $585

The center assumes that all revenues and costs are variable and hence tied directly to patient volume.

A. Explain how each amount in the flexible budget was calculated (Hint: Examine the static budget to determine the relationship of each budget line to volume.)

B. Determine the variances for each line of the profit and loss statement, both in dollar terms and in percenage terms. (Hint: Each line has a total variance, a volume variance, and a price varianc (fro revenues) and mananagment variance (for expenses)

C. What do the Part b results tell Brandons managers about the surgery centers operations for the quarter?

Solutions

Expert Solution

A. Since all revenues and costs are variable, the per surgery revenue or cost is calculated based on the static budget by dividing the revenue or cost by the number of surgeries which is 1200. This per surgery rate is then multiplied by the number of surgeries for flexible budget i.e. 1300 to arrive at each amount in the flexible budget.

Static Budget Flexible Budget
Number of surgeries 1200 1300
Total Per unit
Patient revenue 2400 2 2600
Salary expense 1200 1 1300
Non-salary expense 600 0.5 650
Profit 600 0.5 650

B.

Static Budget Volume Variance Flexible Budget Price/Management Variance Actual Results Total Variance
% $ % $ % $
Patient revenue 2400 8.33F 200F 2600 2.50U 65U 2535 5.63F 135F
Salary expense 1200 8.33U 100U 1300 5.00U 65U 1365 13.67U 165U
Non-salary expense 600 8.33U 50U 650 10.00F 65F 585 2.50F 15F
Profit 600 8.33F 50F 650 10.00U 65U 585 2.50U 15U

C. The Part B results show that though there has been an increase in the number of surgeries, and the patient revenue and non-salary expense have a favorable variance, the overall profit shows an unfavorable variance due to an unfavorable salaries expense variance.


Related Solutions

The following information pertains to the most recent quarter at Precious Production Limited.      Purchases of...
The following information pertains to the most recent quarter at Precious Production Limited.      Purchases of raw materials $ 385,500     Raw materials inventory, beginning 46,800     Raw materials inventory, ending 76,500     Depreciation, factory 210,500     Insurance, factory 21,700     Direct labour 251,900     Maintenance, factory 126,800     Administrative expenses 293,600     Sales 2,208,000     Utilities, factory 116,500     Supplies, factory 4,170     Selling expenses 335,300     Indirect labour 271,900     Work in process inventory, beginning 28,850     Work in process inventory, ending 123,400     Finished goods inventory, beginning 42,550     Finished goods inventory, ending...
One of the most important recent discoveries in astronomy has been our finding thousands of exoplanets,...
One of the most important recent discoveries in astronomy has been our finding thousands of exoplanets, planets that orbit other stars besides the Sun. When a massive planet orbits a star, it will cause a wobble in its motion affecting the ____________ we measure over time. When a bigger planet blocks the light of the star as it _______, that can tell us the size of the planet and its __________. A type of planet that we don’t have in...
Excerpts from Candle Corporation's most recent balance sheet (in thousands of dollars) appear below:         Year...
Excerpts from Candle Corporation's most recent balance sheet (in thousands of dollars) appear below:         Year 2   Year 1   Current assets:      Cash $ 250 $ 110      Accounts receivable 250 260      Inventory 130 130      Prepaid expenses 59 69   Total current assets $ 689 $ 569   Current liabilities:      Accounts payable $ 180 $ 180      Accrued liabilities 90 89      Notes payable, short term 69 59   Total current liabilities $ 339 $ 328     Sales on account during the year totaled $1,570 thousand. Cost...
Excerpts from Candle Corporation's most recent balance sheet (in thousands of dollars) appear below:         Year...
Excerpts from Candle Corporation's most recent balance sheet (in thousands of dollars) appear below:         Year 2   Year 1   Current assets:      Cash $ 200 $ 140      Accounts receivable 200 210      Inventory 120 160      Prepaid expenses 54 64   Total current assets $ 574 $ 574   Current liabilities:      Accounts payable $ 130 $ 130      Accrued liabilities 80 84      Notes payable, short term 64 54   Total current liabilities $ 274 $ 268     Sales on account during the year totaled $1,400 thousand. Cost...
The most recent financial statements for Zoso, Inc., are shown here (assuming no income taxes):   Income...
The most recent financial statements for Zoso, Inc., are shown here (assuming no income taxes):   Income Statement Balance Sheet   Sales $4,200     Assets $15,300     Debt $11,000     Costs 3,390     Equity 4,300       Net income $810       Total $15,300       Total $15,300   Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year's sales are projected to be $5,976. Required: What is the external financing needed? (Do not round your intermediate calculations.)
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income...
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income Statement   Sales $5,683   Costs $4,258 Balance Sheet   Assets $16,387   Debt $8,882 Equity ? Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $7,885. What is the external financing needed?
The most recent financial statements for ABC, Inc. are shown here:                         Income Statement Balance Sheet...
The most recent financial statements for ABC, Inc. are shown here:                         Income Statement Balance Sheet Sales 4,800 Current assets 6,084 Current Liabilities 1,244 Costs 3,840 Fixed assets 5,183 Long-term debt 2,487 Taxable income 960 Equity 7,036 Taxes (35%) 336 Retained earnings 500 Net income 624 Total 11,267 Total 11,267 The company is running at full capacity and the company maintains a constant 50 percent dividend payout ratio. Like every other firm in its industry, next year's sales are projected...
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income...
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income Statement   Sales $7235   Costs $4280 Balance Sheet   Assets $16063   Debt $8972 Equity ? Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $7709. What is the external financing needed? (Negative amount should be indicated by a minus sign.) (Omit the "$" sign and commas in your response. Enter your answer...
The most recent financial statements for Suncrest Inc. are shown here: Statement of Comprehensive Income Statement...
The most recent financial statements for Suncrest Inc. are shown here: Statement of Comprehensive Income Statement of Financial Position   Sales $ 26,400   Assets $ 65,000   Debt $ 27,400   Costs 17,300   Equity 37,600   Taxable income $ 9,100     Total $ 65,000     Total $ 65,000   Taxes (40%) 3,640     Net income $ 5,460 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,300 was paid, and suncrest wishes to maintain a constant payout ratio. Next year’s sales are...
The most recent financial statements for Bello, Inc., are shown here:    Income Statement Balance Sheet...
The most recent financial statements for Bello, Inc., are shown here:    Income Statement Balance Sheet   Sales $ 40,200   Assets $ 148,000   Debt $ 43,500   Costs 27,300   Equity 104,500   Taxable income $ 12,900   Total $ 148,000   Total $ 148,000   Taxes (23%) 2,967   Net income $ 9,933    Assets and costs are proportional to sales; debt and equity are not. A dividend of $3,450 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT