Question

In: Accounting

Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in...

Below is the variance report

Prior year
Item Budget Actual Variance Variance % Actual
Days in time period 31 31 31
Staffed Beds 20 20 20
Patient days 527 498 (29.0) -5.5% 415
Total RN FTEs 45.1 50.1 (5.0) -11.1% 36.7
Revenue:
Gross patient revenue $460,450 $441.932 ($18,518) -4.0% $417,883
Personnel Expense:
Total salaries and wages $171,920 $192,845 ($20,925) -12.2% $141,552
Benefits $51,576 $52,797 ($1,221) -2.4% $42,466
Total personnel expenses $223,496 $245,642 ($22,146) -9.9% $184,018
Overtime wages % 2.0% 6.1% 3.2%
Personnel cost PPD $424 $493 ($69) -16.3% $327
Personnel cost FTE $4,960 $4,908 $52 1.1% $3,697
Non-personnel expense:
Medical Supplies $23,700 $23,498 $202 0.9% $21,839
Depreciation $10,000 $10,000 $0 0.0% $10,000
Other non-personnel $3,500 $2,899 $601 17.2% $2,734
Total non-personnel $37,200 $36,397 $803 2.2% $34,573
Total Expenses $260,696 $282,039 ($21,343) -8.2% $218,591

Review all components of the report and determine where variances occur, if any. Discuss your conclusions and recommendations as if you are the Nurse Executive reviewing this report with the unit manager

Solutions

Expert Solution

Revenue Variance

The actual revenue of current year is below its budgeted revenue. Thatis, 4% reduction. But while compareing to the actual prior year revenue, actual revenue of current year has been increased. The reason for this adverse revenue variance may be because of:

  • Sales volume variance: This is the difference between the actual and budgeted number of units sold, multiplied by the budgeted price per unit.
  • Selling price variance: This is the difference between the actual and budgeted price per units , multiplied by the actual number of unit.
  • Sales mix variance: This is the difference between the actual and budgeted number of units sold, multiplied by the budgeted contribution.

The reason why revenue variance occur are cannibalization, competition, price change, etc..

Labour Variance(Personnel Expense)

The total labour rate and benefits also shows an adverse variance. Both the total wages and salaries and the benefits are greater than budgeted. Thus the total labour expense is also greater than budgeted. Thus the labour variance is adverse.

But in the case of personnel cost FTE they have a favourable variance. Incase of of overtime wage % and personnel cost PPD they have an adverse variance.

The reasons for this variance may be because of;

  • Labour rate variance: The causes for this variance are change in basic rate, paying higher wages in seasonal and emergency operations, paying overtime for urgent works, application of different wage payment system, appointment of unskilled workers, etc..
  • Labour efficiency variance: The causes for this variance are appointing low grade workers, inadequate training to employees, incorrect instructions, increased labour turnover, poor working condition, poor scheduling of work, poor supervision, use of poor technology, etc..

Overhead Variance(Non-Personnel Expense)

All the non-personnel expenditure have an adverse variance. The actual medical supplies, depreciation and other personnel expense are greater than the budgted. Thus the actual total personnel expense is also greater than the budgeted. The reasons for this variance may be because of:

  • Overhead expenditure variance: The causes for this variance are seasonal conditions, poor standard setting, over or under utilization of services, non-availability of specific services,ineffective control of spending etc.
  • Overhead volume variance: The cause for this variance are over or under sales demand, loss of working hours, working days being more or less than budgeted, change in efficiency of labour and machines, change in the number of men employeed, number of shifts or machines used, etc..
  • Overhead efficiency variance: The cause of this variance are poor working conditions, inefficiency of labour, poor supervision, poor scheduling of production,use of inferior or defective tools, improperly set standards, etc..

Others

Other than the above variance they need to consider the variance in patient days and total RN FTEs. Both are showing an adverse variance. The reason for this adverse variance may be because of the adverse variation in the above variance.

Conclusions & Recommendations

From the above we can come to a conclusion that the firm is facing an adverse situation. All the variance are adverse for them. We had already dicussed the factors that causes adverse variance in the above pragraghs. An adverse variance can alter the management the firm's profit will be less than the expected. The sooner an adverse variance is detected, the sooner attention can be directed toward fixing any problem.

The recommendations to overcome this adverse situation are as follows;

  • Proper budget planning
  • Efficient production planning
  • Proper employee management
  • Constant wage payment system
  • Proper scheduling of work
  • Controlled spending
  • Use of good technology
  • Good supervision
  • Proper management of working hours

Related Solutions

Given the following information: Prior Year (Budget) Prior Year (Actual) Current Year (Budget) Current Year (Actual)...
Given the following information: Prior Year (Budget) Prior Year (Actual) Current Year (Budget) Current Year (Actual) Beginning Inventory (Units) 0 0 ? ? Sales (Units) 600,000 580,000 575,000 570,000 Manufactured (Units) 600,000 590,000 640,000 610,000 Selling Price ($/unit) 9.99 9.90 9.95 10.00 Variable Manufacturing Cost ($/unit) 4.92 4.90 5.00 4.95 Total Fixed Manufacturing Costs ($) 1,584,000 1,561,000 1,625,000 1,599,531 Variable Selling Cost ($/unit) 1.00 1.01 0.99 1.00 Total Fixed SG&A Costs ($) 350,000 353,000 352,850 348,000 Other information: The manufacturer...
1. Compute The Variance in the Budget vs Actual Report Below. Indicate in Column G whether...
1. Compute The Variance in the Budget vs Actual Report Below. Indicate in Column G whether the variance is Favorable (F) or Unfavorable (U) 2. Prepare a Flexible Budget to match the Actual Sales, Compute the Variance and again indicate whether Favorable or Unfavorable 3. Comment on the difference between the reports. Is the units produced variance important? What is the overall difference?, etc. Wireless Buds, LLC Performance Report - Budget vs Actual Quarter ended March 31, 2018 Static Budget...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory (Units) 0 ? Sales (Units) 600,000 575,000 Manufactured (Units) 600,000 640,000 Selling Price ($/unit) 9.90 10.00 Variable Manufacturing Cost ($/unit) 4.80 5.00 Total Fixed Manufacturing Costs ($) 1,560,000 1,600,000 Variable Selling Cost ($/unit) 1.00 1.00 Total Fixed SG&A Costs ($) 351,000 358,000 Other information: The manufacturer uses FIFO. All Variable costs are direct costs Required: Prepare an income statement for the Current Year based...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory (Units) 0 ? Sales (Units) 600,000 575,000 Manufactured (Units) 600,000 640,000 Selling Price ($/unit) 9.90 10.00 Variable Manufacturing Cost ($/unit) 4.80 5.00 Total Fixed Manufacturing Costs ($) 1,560,000 1,600,000 Variable Selling Cost ($/unit) 1.00 1.00 Total Fixed SG&A Costs ($) 351,000 358,000 Other information: The manufacturer uses FIFO. All Variable costs are direct costs Required: Prepare an income statement for the Current Year based...
You are given the following static budget report: Budget            Actual              Variance Unit Sales  &nbsp
You are given the following static budget report: Budget            Actual              Variance Unit Sales                                           10,000               15,000             5,000 F Variable Expenses:     Commissions                                  $30,000 $33,000 $3,000 U     Advertising                                      $1,000 $1,200 $200 U     Travel                                              $10,000 $11,000 $1,000 U     Samples                                          $2,500 $2,300 $200 F Total Variable                                     $43,500 47,500 $4,000 U Fixed Expenses     Rent                                                 $5,000 $5,000 0     Salaries – Sales                               $2,000 $2,000 0     Salaries – Office                              $1,200 $1,200 0     Depreciation                                    $1,500 $1,500 0 Total Fixed                                          $9,700 $9,700             0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled.  How do the results of...
Given the information below, What is the total variance in the actual and static budget? DeFleur...
Given the information below, What is the total variance in the actual and static budget? DeFleur manufactures bicycles. The bicycles are manufactured in two divisions. In the framing division, the carbon bicycle frames are manufactured. In the assembly division, the components are assembled to the frame and the bike is ready for sale. There is no market for the unassembled frames and all manufactured frames are transferred to the assembly division. For the purposes of performance evaluation, the framing division...
Deluca Manufacturing prepared the following cost control report for the prior month: Planning Budget Actual Results...
Deluca Manufacturing prepared the following cost control report for the prior month: Planning Budget Actual Results Variances Direct labor hours 30,000 33,000 Direct materials $45,000 $55,000 $10,000 U Direct labor wages $480,000 $520,000 $40,000 U Maintenance $125,000 $136,000 $11,000 U Utilities $82,000 $86,000 $4,000 U Rent $65,000 $65,000 $0 Depreciation $27,000 $27,000 $0 Total: $824,000 $889,000 $65,000 U Direct materials and direct labor wages are variable costs; rent and depreciation are fixed costs; and maintenance and utilities are mixed costs....
The table below reflects the actual and structural budget deficit as a percentage of GDP. Year...
The table below reflects the actual and structural budget deficit as a percentage of GDP. Year Actual Defect Structural Deficit As % of GDP As % of GDP 2010 2.8 2.9 2011 3.9 3.2 2012 4.6 3.4 2013 4.7 3.7 2014 3.9 3.7 2015 3.00 2.8 2016 2.3 2.6 2017 1.4 1.6 2018 0.3 1.0 a. Graph the above data with “years” in the horizontal axis, and “deficit as % of GDP” in vertical axis. b. From 2010 to 2014...
1) Describe an example of how an unfavorable variance between actual and budget amounts in a...
1) Describe an example of how an unfavorable variance between actual and budget amounts in a fixed static (master) budget can become a favorable variance in a flexible budget report. 2) Also, since flexible budget is more accurate in measuring performance, can company just develop flexible budget without the static budget? Why or why not?
Describe an example of how an unfavorable variance between actual and budget amounts in a fixed...
Describe an example of how an unfavorable variance between actual and budget amounts in a fixed static (master) budget can become a favorable variance in a flexible budget report. Also, since flexible budget is more accurate in measuring performance, can company just develop flexible budget without the static budget? Why or why not?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT