Question

In: Finance

Royal Hospital’s static nursing labour expense budget for the month of November 2012 was $64,800 (1,200...

Royal Hospital’s static nursing labour expense budget for the month of November 2012 was $64,800 (1,200 patients * 1.5 nursing labour hours per patient * $36 per nursing labour hour). During the month of November 2012 Rotary Hospital actually cared for 1,300 patients. The actual nurse labour expense for the month was $84,175 and 2,275 nursing hours were actually worked. Calculate Royal Hospital’s total variance between its budget and actual nurse labour expense. How much of this variance was due to: a. actual patient numbers being different from the budget? b. the hourly cost of nursing services being different from budget? c. the number of nursing hours used being different from budget? d. what factor caused the biggest difference between the actual and budgeted figures?

Solutions

Expert Solution

A Budgeted Nursing Labor Expense $64,800 (1200*1.5*36)
B Actual Nursing Labor expense $84,175
C=B-A Total Variance $19,375
Actual Number of patients 1300
D Flexible Budget for 1300 patients $70,200 (1300*1.5*36)
a E=D-A Variance due toactual patient numbers being different from the budget $5,400 (70200-64800)
SH Standard Nursing Labor hours for 1300 patients 1950 (1.5*1300)
AH Actual Nursing Hours 2275
SR Standard Hourly Rate $36.00
AR Actual Hourly Rate $37 (84175/2275)
b AH*(AR-SR) Variance due to difference in hourly Cost $2,275
c SR*(AH-SH) Variance due to difference in number of hours used $11,700
Total Variance =5400+2275+11700= $19,375
d The Factor Causing biggest difference:
Actual Hours far exceeding Standard Nursing Labor hours
Standard hour per patient =1.5
Actual Hours used per patient =(2275/1300)= 1.75
(1.75/1.5)-1= 16.67% More Labor hours per patient

Related Solutions

Question is in bold at the end of my worksheet For the month of: November Budget...
Question is in bold at the end of my worksheet For the month of: November Budget Data Fixed Variable Actual Portion Portion* Data Depreciation $4,000         -- $4,000 Maintenance $1,800 $0.70 4,730 Inspections $2,800 0.25 3,702 Utilities $4,000 0.20 4,900 Indirect material 0.25 1,125 Overtime 2.25 ** 260 *per direct labor hour **per monthly direct labor hours in excess of 4,000 Planned direct labor hours for the month 4,500 Actual direct labor hours for the month 4,100 Static Budget Budget...
Prepare a selling and administrative expenses budget. October November December Selling and Administrative Expense Budget Salary...
Prepare a selling and administrative expenses budget. October November December Selling and Administrative Expense Budget Salary expense Sales commissions Supplies expense Utilities Depreciation on store fixtures Rent Miscellaneous Total S&A expenses $0 $0 $0 Required information Problem 14-23 Preparing a master budget for retail company with no beginning account balances LO 14-2, 14-3, 14-4, 14-5, 14-6 [The following information applies to the questions displayed below.] Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company...
Sheridan Entertainment Corporation prepared a master budget for the month of November that was based on...
Sheridan Entertainment Corporation prepared a master budget for the month of November that was based on sales of 153,000 board games. The budgeted income statement for the period is as follows. Sales Revenue $2,601,000 Variable expenses   Direct materials $703,800   Direct labor 290,700   Variable overhead 397,800 Total variable expenses 1,392,300 Contribution margin 1,208,700    Fixed overhead 253,900    Fixed selling and administrative expenses 508,600 Total fixed expenses 762,500 Operating income $446,200 During November, Sheridan produced and sold 187,300 board games. Actual results for...
Assume that The AM Bakery is preparing a budget for the month ending November 30. Management...
Assume that The AM Bakery is preparing a budget for the month ending November 30. Management prepares the budget by starting with the actual results for August that is shown below. Then, management considers what the differences in costs will be between August and November. THE AM BAKERY Bakery sales Actual and Budgeted Costs For the Month Ending August 31 Actual Ingredients Flour $ 3,980 Butter 3,580 Oil 1,940 Fruit 1,540 Nuts 980 Chocolate 1,200 Other 800 Total ingredients $...
Garland Company Budget Performance Report—Supervisor, Chip Fabrication For the Month Ended November 30 Cost Actual Budget...
Garland Company Budget Performance Report—Supervisor, Chip Fabrication For the Month Ended November 30 Cost Actual Budget Over Budget Under Budget Factory wages $95,500 $82,000 $13,500 Materials 115,300 120,000 $(4,700) Power and light 49,950 45,000 4,950 Maintenance 37,200 28,000 9,200 $297,950 $275,000 $27,650 $(4,700) a. Complete the budget performance reports by determining the correct amounts for the lettered spaces (a-l) as marked above. a. $ g. $ b. $ h. $ c. $ i. $ d. $ j. $ e. $...
The following information relates to Tallman comma Inc.?'s overhead costs for the? month: Static budget variable...
The following information relates to Tallman comma Inc.?'s overhead costs for the? month: Static budget variable overhead - $8,000 Static budget fixed overhead - $3,000 Static budget direct labor hours - 1,000 hours Static budget number of units - 5,000 units Tallman allocates manufacturing overhead to production based on standard direct labor hours. Last? month, Tallman reported the following actual? results: actual variable? overhead, $ 10600?; actual fixed? overhead, $ 2780?; actual production of 7400 units at 0.25 direct labor...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT