1 / 59

Flexible Budgets and Overhead Analysis

Chapter 9. Flexible Budgets and Overhead Analysis. Hmm! Comparing static budgets with actual costs is like comparing apples and oranges. Let’s look at CheeseCo. Static Budgets and Performance Reports. Static budgets are prepared for a single, planned level of activity.

evangeline-sweeney
Download Presentation

Flexible Budgets and Overhead Analysis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter9 Flexible Budgets and Overhead Analysis

  2. Hmm! Comparingstatic budgets withactual costs is likecomparing applesand oranges. Let’s look at CheeseCo. Static Budgets and Performance Reports Static budgets are prepared for a single, planned levelof activity. Performance evaluation is difficult when actual activity differs from the planned level of activity.

  3. Static Budgets and Performance Reports CheeseCo Static Actual Budget Results Variances Machine hours 10,000 8,000 Variable costs Indirect labor $ 40,000 $ 34,000 Indirect materials 30,000 25,500 Power 5,000 3,800 Fixed costs Depreciation 12,000 12,000 Insurance 2,000 2,050 Total overhead costs $ 89,000 $ 77,350

  4. U = Unfavorable variance CheeseCo was unable to achieve the budgeted level of activity. Static Budgets and Performance Reports CheeseCo Static Actual Budget Results Variances Machine hours 10,000 8,000 2,000 U Variable costs Indirect labor $ 40,000 $ 34,000 Indirect materials 30,000 25,500 Power 5,000 3,800 Fixed costs Depreciation 12,000 12,000 Insurance 2,000 2,050 Total overhead costs $ 89,000 $ 77,350

  5. Static Actual Budget Results Variances Machine hours 10,000 8,000 2,000 U Variable costs F = Favorable variance Actual cost is less than budgeted cost. Indirect labor $ 40,000 $ 34,000 $6,000 F Indirect materials 30,000 25,500 Power 5,000 3,800 Fixed costs Depreciation 12,000 12,000 Insurance 2,000 2,050 Total overhead costs $ 89,000 $ 77,350 Static Budgets and Performance Reports CheeseCo

  6. Static Actual Budget Results Variances Machine hours 10,000 8,000 2,000 U Variable costs Indirect labor $ 40,000 $ 34,000 $6,000 F Indirect materials 30,000 25,500 4,500 F Power 5,000 3,800 1,200 F Fixed costs Depreciation 12,000 12,000 0 Insurance 2,000 2,050 50 U $11,650 F Total overhead costs $ 89,000 $ 77,350 Static Budgets and Performance Reports CheeseCo

  7. Static Actual Budget Results Variances Machine hours 10,000 8,000 2,000 U Variable costs Ind irect labor $ 40,000 $ 34,000 $6,000 F Indirect materials 30,000 25,500 4,500 F Power 5,000 3,800 1,200 F Fixed costs Depreciation 12,000 12,000 0 Insurance 2,000 2,050 50 U $11,650 F Total overhead costs $ 89,000 $ 77,350 Static Budgets and Performance Reports CheeseCo Since cost variances are favorable, havewe done a good job controlling costs?

  8. Actual activity is belowbudgeted activity. So, shouldn’t variable costsbe lower if actual activityis lower? Static Budgets and Performance Reports I don’t think Ican answer thequestion usinga static budget.

  9. Static Budgets and Performance Reports • The relevant question is . . . “How much of the favorable cost variance isdue to lower activity, and how much is due to good cost control?” • To answer the question,we mustthe budget to theactual level of activity.

  10. Show revenues and expensesthat should have occurred at theactual level of activity. May be prepared for any activity level in the relevant range. Reveal variances due to good cost control or lack of cost control. Improve performance evaluation. Flexible Budgets

  11. Flexible Budgets Central Concept If you can tell me what your activity wasfor the period, I will tell you what your costs and revenue should have been.

  12. Preparing a Flexible Budget To a budget we need to know that: • Total variablecosts changein direct proportion to changes in activity. • Total fixedcosts remainunchanged within therelevant range. Variable Fixed

  13. Preparing a Flexible Budget Let’s prepare budgets for CheeseCo.

  14. Preparing a Flexible Budget CheeseCo Cost Total Flexible Budgets Formula Fixed 8,000 10,000 12,000 Per Hour Cost Hours Hours Hours Machine hours 8,000 10,000 12,000 Variable costs are expressed as a constant amount per hour. $40,000 ÷ 10,000 hours is$4.00 per hour. Variable costs Indirect labor 4.00 $ 32,000 Indirect material 3.00 24,000 Power 0.50 4,000 Total variable cost $ 7.50 $ 60,000 Fixed costs Fixed costs areexpressed as atotal amount. Depreciation $ 12,000 Insurance 2,000 Total fixed cost Total overhead costs

  15. Cost Total Flexible Budgets Formula Fixed 8,000 10,000 12,000 Per Hour Cost Hours Hours Hours Machine hours 8,000 10,000 12,000 Variable costs Indirect labor 4.00 $ 32,000 Indirect material 3.00 24,000 Power 0.50 4,000 Total variable cost $ 7.50 $ 60,000 Fixed costs $4.00 per hour × 8,000 hours = $32,000 Depreciation $ 12,000 Insurance 2,000 Total fixed cost Total overhead costs Preparing a Flexible Budget CheeseCo

  16. Cost Total Flexible Budgets Formula Fixed 8,000 10,000 12,000 Per Hour Cost Hours Hours Hours Machine hours 8,000 10,000 12,000 Variable costs Indirect labor 4.00 $ 32,000 Indirect material 3.00 24,000 Power 0.50 4,000 Total variable cost $ 7.50 $ 60,000 Fixed costs Depreciation $ 12,000 $ 12,000 Insurance 2,000 2,000 Total fixed cost $ 14,000 Total overhead costs $ 74,000 ? Preparing a Flexible Budget CheeseCo

  17. Quick Check  What should be the total overhead costs for the Flexible Budget at 10,000 hours? a. $92,500. b. $74,000. c. $89,000. d. $94,000.

  18. Quick Check  What should be the total overhead costs for the Flexible Budget at 12,000 hours? a. $92,500. b. $89,000. c. $106,800. d. $104,000.

  19. Flexible BudgetPerformance Report Let’s prepare a budget performance report for CheeseCo.

  20. Flexible BudgetPerformance Report CheeseCo Cost Total Flexible budget is prepared for thesame activity level (8,000 hours) as actually achieved. Formula Fixed Flexible Actual Per Hour Costs Budget Results Variances Machine hours 8,000 8,000 0 Variable costs Indirect labor $ 4.00 $ 34,000 Indirect material 3.00 25,500 Power 0.50 3,800 Total variable costs $ 7.50 $ 63,300 Fixed Expenses Depreciation $ 12,000 $ 12,000 Insurance 2,000 2,050 Total fixed costs $ 14,050 Total overhead costs $ 77,350

  21. Flexible BudgetPerformance Report CheeseCo Cost Total Formula Fixed Flexible Actual Per Hour Costs Budget Results Variances Machine hours 8,000 8,000 0 Variable costs Indirect labor $ 4.00 $ 34,000 Indirect material 3.00 25,500 Power 0.50 3,800 Total variable costs $ 7.50 $ 63,300 Fixed Expenses Depreciation $ 12,000 $ 12,000 Insurance 2,000 2,050 Total fixed costs $ 14,050 Total overhead costs $ 77,350

  22. Quick Check  What is the variance for indirect labor when the flexible budget for 8,000 hours is compared to the actual results? a. $2,000 U b. $2,000 F c. $6,000 U d. $6,000 F

  23. Quick Check  What is the variance for indirect materials when the flexible budget for 8,000 hours is compared to the actual results? a. $1,500 U b. $1,500 F c. $4,500 U d. $4,500 F

  24. Quick Check  What is the variance for depreciation when the flexible budget for 8,000 hours is compared to the actual results? a. $0 b. $1,000 F c. $2,000 U d. $2,000 F

  25. Flexible BudgetPerformance Report Remember the question: “How much of the total variance is due to activityand how much is due tocost control?”

  26. Static Actual Budget Results Variances Machine hours 10,000 8,000 2,000 U Variable costs Ind irect labor $ 40,000 $ 34,000 $6,000 F Indirect materials 30,000 25,500 4,500 F Power 5,000 3,800 1,200 F Fixed costs Depreciation 12,000 12,000 0 Insurance 2,000 2,050 50 U $11,650 F Total overhead costs $ 89,000 $ 77,350 Static Budgets and Performance How much of the $11,650 is due to activity and how much is due to cost control?

  27. Flexible BudgetPerformance Report Overhead Variance Analysis Let’s place the flexible budget for 8,000 hours here. Difference between original static budgetand actual overhead = $11,650 F.

  28. Flexible BudgetPerformance Report Overhead Variance Analysis Activity Cost control This $15,000F variance is due to lower activity. This $3,350U flexiblebudget variance is dueto poor cost control.

  29. There are two primaryreasons for unfavorablevariable overhead variances: 1.Spendingtoo much for resources. 2. Using the resources inefficiently. What causesthe costcontrol variance? Flexible BudgetPerformance Report

  30. Overhead Rates and Overhead Analysis Recall that overhead costs are assigned to products and services using a predetermined overhead rate (POHR): Assigned Overhead = POHR × Standard Activity Overhead from theflexible budget for thedenominator level of activity POHR = Denominator level of activity

  31. Overhead Rates and Overhead Analysis – Example Let’s look at overhead rates in abudget for ColaCo.

  32. Overhead Rates and Overhead Analysis – Example ColaCo prepared this budget for overhead: Total Variable Total Fixed Machine Variable Overhead Fixed Overhead Hours Overhead Rate Overhead Rate 2,000 $ 4,000 ? $ 9,000 ? 4,000 8,000 ? 9,000 ? Let’s calculate overhead rates. ColaCo applies overhead basedon machine hour activity.

  33. Total Variable Total Fixed Machine Variable Overhead Fixed Overhead Hours Overhead Rate Overhead Rate 2,000 $ 4,000 $ 2.00 $ 9,000 ? 4,000 8,000 2.00 9,000 ? Overhead Rates and Overhead Analysis – Example ColaCo prepared this budget for overhead: Rate = TotalVariable Overhead ÷ Machine Hours This rate is constant at all levels of activity.

  34. Total Variable Total Fixed Machine Variable Overhead Fixed Overhead Hours Overhead Rate Overhead Rate 2,000 $ 4,000 $ 2.00 $ 9,000 $ 4.50 4,000 8,000 2.00 9,000 2.25 Overhead Rates and Overhead Analysis – Example ColaCo prepared this budget for overhead: Rate = TotalFixedOverhead ÷ Machine Hours This rate decreases when activity increases.

  35. Total Variable Total Fixed Machine Variable Overhead Fixed Overhead Hours Overhead Rate Overhead Rate 2,000 $ 4,000 $ 2.00 $ 9,000 $ 4.50 4,000 8,000 2.00 9,000 2.25 The total POHR is the sum ofthe fixed and variable ratesfor a given activity level. Overhead Rates and Overhead Analysis – Example ColaCo prepared this budget for overhead:

  36. Overhead Variances Let’s use the overhead rates, to determine variable and fixed overhead variances.

  37. Variable Overhead Variances – Example ColaCo’s actual production for the period required 3,200 standard machine hours. Actual variable overhead incurred for the period was $6,740. Actual machine hours worked were 3,300. Compute the variable overhead spending and efficiency variances.

  38. Variable Overhead Variances Actual Flexible Budget Flexible Budget Variable for Variable for Variable Overhead Overhead at Overhead at Incurred Actual Hours Standard Hours AH × AR AH × SR SH × SR Spending Variance EfficiencyVariance Spending variance =AH(AR - SR) Efficiency variance =SR(AH - SH)

  39. Variable Overhead Variances – Example Actual Flexible Budget Flexible Budget Variable for Variable for Variable Overhead Overhead at Overhead at Incurred Actual Hours Standard Hours 3,300 hours 3,200 hours × × $2.00 per hour $2.00 per hour $6,740 $6,600 $6,400 Spending variance$140 unfavorable Efficiency variance$200 unfavorable $340 unfavorable flexible budget total variance

  40. Quick Check  Yoder Enterprises’ actual production for the period required 2,100 standard direct labor hours. Actual variable overhead for the period was $10,950. Actual direct labor hours worked were 2,050. The predetermined variable overhead rate is $5 per direct labor hour. What was the spending variance? a. $450 U b. $450 F c. $700 F d. $700 U

  41. Quick Check  Yoder Enterprises’ actual production for the period required 2,100 standard direct labor hours. Actual variable overhead for the period was $10,950. Actual direct labor hours worked were 2,050. The predetermined variable overhead rate is $5 per direct labor hour. What was the efficiency variance? a. $450 U b. $450 F c. $250 F d. $250 U

  42. Spending Variance Efficiency Variance Variable Overhead Variances – A Closer Look Results from paying moreor less than expected foroverhead items and from excessive usage ofoverhead items. Controlled bymanaging theoverhead cost driver.

  43. Overhead Variances Now let’s turn our attention tofixed overhead.

  44. Total Variable Total Fixed Machine Variable Overhead Fixed Overhead Hours Overhead Rate Overhead Rate 2,000 $ 4,000 $ 2.00 $ 9,000 $ 4.50 4,000 8,000 2.00 9,000 2.25 Overhead Rates and Overhead Analysis – Example ColaCo prepared this budget for overhead: What is ColaCo’s fixed overhead rate for an estimated activity of 3,000 machine hours?

  45. Total Variable Total Fixed Machine Variable Overhead Fixed Overhead Hours Overhead Rate Overhead Rate 2,000 $ 4,000 $ 2.00 $ 9,000 $ 4.50 4,000 8,000 2.00 9,000 2.25 Overhead Rates and Overhead Analysis – Example ColaCo prepared this budget for overhead: What is ColaCo’s fixed overhead rate for an estimated activity of 3,000 machine hours? Fixed Overhead Rate FR = $9,000 ÷ 3,000 machine hours FR = $3.00 per machine hour

  46. Fixed Overhead Variances – Example ColaCo’s actual production required 3,200 standard machine hours. Actual fixed overhead was $8,450. Compute the fixed overhead budget and volume variances.

  47. Fixed Overhead Variances Actual Fixed Fixed Fixed Overhead Overhead Overhead Incurred Budget Applied SH × FR Budget Variance VolumeVariance FR = Standard Fixed Overhead RateSH = Standard Hours Allowed

  48. Fixed Overhead Variances – Example Actual Fixed Fixed Fixed Overhead Overhead Overhead Incurred Budget Applied SH × FR 3,200 hours × $3.00 per hour $8,450 $9,000 $9,600 Budget variance$550 favorable Volume variance$600 favorable

  49. Quick Check  Yoder Enterprises’ actual production for the period required 2,100 standard direct labor hours. Actual fixed overhead for the period was $14,800. The budgeted fixed overhead was $14,450. The predetermined fixed overhead rate was $7 per direct labor hour. What was the budget variance? a. $350 U b. $350 F c. $100 F d. $100 U

  50. Quick Check  Yoder Enterprises’ actual production for the period required 2,100 standard direct labor hours. Actual fixed overhead for the period was $14,800. The budgeted fixed overhead was $14,450. The predetermined fixed overhead rate was $7 per direct labor hour. What was the volume variance? a. $250 U b. $250 F c. $100 F d. $100 U

More Related