Lesson 4: Budgets and Variance Analysis
Activity 4: Budgeting (100 Points)
Part A (50 points)
Complete Problem 8-44 (p. 341) on the Lucerne Chocolate Company. (A 1½-page response is required.)
| Flexible Budget: | ||
| Standard Input Quantities | ||
| Cost Incurred: | Allowed for Outputs | |
| Actual Inputs × | Actual Input Quantities | Achieved × |
| Actual Prices | × Standard Prices | Standard Prices |
Direct Materials:
| 3,400 lbs. × 17.3CHF | 3,400 lbs × 18CHF | 2,900 lbs. × 18CHF | |||
| =58,820CHF | = 61,200CHF | = 52,200CHF | |||
| 3,400 × .7CHF= Price variance, | 500 × 18CHF = Quantity variance, | ||||
| 2,380CHF F | 9,000CHF U | ||||
| Flexible-budget variance, 6,620 CHF U
ex |
|||||
Direct Labor:
| 3,925 hrs. × 38.6CHF | 3,925 hrs. × 38CHF | 3,625 hrs. × 38CHF | |||
| = 151,505CHF | = 149,150CHF | = 137,750CHF | |||
| 3,925 × .6CHF | 300 × 38CHF | ||||
| = Price variance, | Quantity variance, | ||||
| 2,355CHF U | 11,400CHF U | ||||
| Flexible-budget variance, 13,755 CHF U | |||||
Manufacturing Overhead:
| Predicted | Flexible Budget: | ||||
| Overhead Based | Standard Driver Use | ||||
| on Actual | Allowed for Outputs | ||||
| Actual Overhead | Driver Use | Achieved × | |||
| Costs Incurred | × Standard Prices | Standard Prices | |||
| 3,925 hrs. × 11CHF | 3,625 hrs. × 11CHF | ||||
| 46,675CHF | = 43,175CHF | = 39,875CHF | |||
| Spending variance, 46,675 – 43,175 = 3,500CHF U | 300 × 11CHF
= Efficiency variance, 3,300CHF U |
||||
| Flexible-budget variance, 6,800CHF U | |||||
The flexible-budget allowance for any variable cost is the same as (is equal to) the total standard quantity allowed for the good units produced times the standard price.
The budget allowance under standard costing for variable costs always depends on output, the units produced. Therefore, the direct labor budget for 2,900 units is, as shown above, 2,900 units × 1.25 hours × 38CHF = 137,750CHF. For 3,900 units, the budgetary allowance would be 3,900 units × 1.25 hours × 38CHF = 185,250CHF. Note again that a budget can be established after the fact — after the number of units produced is known.
Part B (50 points)
Case 8-54 (pp. 346-347) is an application to assess your ability to work with flexible budgets. This case provides budgetary information about Hopkins Community Hospital, an outpatient clinic. This is a good example of the use of a flexible budget for analyzing performance at a service sector organization. Use the information in the narrative and the supporting schedules to answer the “Required” questions. (A 1½-page response is required.)
