Question

Financial Versus Activity Flexible Budgeting Kelly Gray, production manager, was upset with the latest performance report,...

Financial Versus Activity Flexible Budgeting

Kelly Gray, production manager, was upset with the latest performance report, which indicated that she was $100,000 over budget. Given the efforts that she and her workers had made, she was confident that they had met or beat the budget. Now, she was not only upset but also genuinely puzzled over the results. Three items—direct labor, power, and setups—were over budget. The actual costs for these three items follow:

Actual Costs
Direct labor $188,330     
Power 135,310     
Setups 142,038     
   Total $465,678     

Kelly knew that her operation had produced more units than originally had been budgeted, so more power and labor had naturally been used. She also knew that the uncertainty in scheduling had led to more setups than planned. When she pointed this out to John Huang, the controller, he assured her that the budgeted costs had been adjusted for the increase in productive activity. Curious, Kelly questioned John about the methods used to make the adjustment.

JOHN: If the actual level of activity differs from the original planned level, we adjust the budget by using budget formulas—formulas that allow us to predict what the costs will be for different levels of activity.

KELLY: The approach sounds reasonable. However, I'm sure something is wrong here. Tell me exactly how you adjusted the costs of labor, power, and setups.

JOHN: First, we obtain formulas for the individual items in the budget by using the method of least squares. We assume that cost variations can be explained by variations in productive activity where activity is measured by direct labor hours. Here is a list of the cost formulas for the three items you mentioned. The variable X is the number of direct labor hours:

Labor cost = $9X
Power cost = $5,000 + $3.8X
Setup cost = $95,100

KELLY: I think I see the problem. Power costs don't have a lot to do with direct labor hours. They have more to do with machine hours. As production increases, machine hours increase more rapidly than direct labor hours. Also, …

JOHN: You know, you have a point. The coefficient of determination for power cost is only about 50 percent. That leaves a lot of unexplained cost variation. The coefficient for labor, however, is much better—it explains about 96 percent of the cost variation. Setup costs, of course, are fixed.

KELLY: Well, as I was about to say, setup costs also have very little to do with direct labor hours. And I might add that they certainly are not fixed—at least not all of them. We had to do more setups than our original plan called for because of the scheduling changes. And we have to pay our people when they work extra hours. It seems as if we are always paying overtime. I wonder if we simply do not have enough people for the setup activity. Supplies are used for each setup, and these are not cheap. Did you build these extra costs of increased setup activity into your budget?

JOHN: No, we assumed that setup costs were fixed. I see now that some of them could vary as the number of setups increases. Kelly, let me see if I can develop some cost formulas based on better explanatory variables. I'll get back with you in a few days.

Assume that after a few days' work, John developed the following cost formulas, all with a coefficient of determination greater than 90 percent:

Labor cost = $9X; where X = Direct labor hours
Power cost = $67,800 + 0.90Y; where Y = Machine hours
Setup cost = $97,920 + $402Z; where Z = Number of setups

The actual measures of each of the activity drivers are as follows:

Direct labor hours 20,000
Machine hours 90,400
Number of setups 114

Required:

1. Prepare a performance report for direct labor, power, and setups using the direct-labor-based formulas.

Performance Report
Actual Costs Budgeted Costs Budget Variance Favorable (F) or Unfavorable (U)
Direct labor $ $ $ Unfavorable
Power Unfavorable
Setups Unfavorable
Total $ $ $ Unfavorable

Feedback

1. Review what you have learned in the chapter.

2. Prepare a performance report for direct labor, power, and setups using the multiple cost driver formulas that John developed.

Performance Report
Actual Costs Budgeted Costs Budget Variance Favorable (F) or Unfavorable (U)
Direct labor $ $ $ Unfavorable
Power Favorable
Setups Favorable
Total $ $ $ Favorable

Homework Answers

Answer #1


Budgeted Cost as per direct labour hours:
Direct labour: $9 * 20000 hrs = $180000
Power = 5000 + (3.8*20000) = $81000
Setup = $95100

Budgeted cost as per multi cost driver:
Direct labour: $9 * 20000 hrs = $180000
Power = 67800 + (0.90*90400) = $149160
Setup = 97920 + (420*114) = $143748

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of $14,000 per year per unit Six welding employees each paid a salary of $55,000 per year (A total of 12,000 welding hours are supplied by the six workers.) Welding supplies: $400 per job Welding hours: 4 hours used per job During the year, the...
Performance Report for Variable Overhead Variances Anker Company had the data below for its most recent...
Performance Report for Variable Overhead Variances Anker Company had the data below for its most recent year, ended December 31: Actual costs: Variable overhead standards: Indirect labor $36,000 Indirect labor 0.15 hr. @ $24.00 Supplies $3,800 Supplies 0.15 hr. @ $2.40 Actual hours worked 1,490 hours Standard variable overhead rate $26.40 per direct labor hour Units produced 10,000 units Hours allowed for production 1,500 hours Required: Prepare a performance report that shows the variances on an item-by-item basis. Enter a...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $12,000 per year per unit • Six welding employees each paid a salary of $52,000 per year (A total of 9,000 welding hours are supplied by the six workers.) • Welding supplies: $300 per job • Welding hours: 3 hours used per job...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of $14,000 per year per unit Six welding employees each paid a salary of $45,000 per year (A total of 12,000 welding hours are supplied by the six workers.) Welding supplies: $400 per job Welding hours: 4 hours used per job During the year, the...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 300,000 units of the standard model and 120,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas...
Birkner Corporation's flexible budget performance report for last month shows that actual indirect materials cost, a...
Birkner Corporation's flexible budget performance report for last month shows that actual indirect materials cost, a variable cost, was $30,444 and that the spending variance for indirect materials cost was $8,142 favorable. During that month, the company worked 17,700 machine-hours. Budgeted activity for the month had been 18,200 machine-hours. The cost formula per machine-hour for indirect materials cost must have been closest to: Kerekes Manufacturing Corporation has prepared the following overhead budget for next month. Activity level 2,400 machine-hours Variable...
1. Given the following performance report, determine the total amount of variance and if it is...
1. Given the following performance report, determine the total amount of variance and if it is favorable or unfavorable. Actual costs: Maintenance is $50,000; Power is $80,000; and Indirect Labor is $10,000. Budgeted costs: Maintenance is $45,000; Power is 81,000; and Indirect Labor is $8,000. a. 6,000 U b. 6,000 F c. 12,000 U d.12,000F 2. We prepare a budget based on manufacturing 20,000 chairs this month. Budgeted costs are: Fixed manufacturing costs = $50,000 per month; Variable manufacturing costs...
Total Direct Labor Variance: X Budget Performance Report Sarah has learned a lot from you over...
Total Direct Labor Variance: X Budget Performance Report Sarah has learned a lot from you over the past two months, and has compiled the following data for Sole Purpose Shoe Company for September using the techniques you taught her. She would like your help in preparing a Budget Performance Report for September. The company produced 3,000 pairs of shoes that required 10,500 units of material purchased at $8.20 per unit and 8,100 hours of labor at an hourly rate of...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead:   Supplies 0.23   Maintenance 0.19   Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. In March, Nashler Company produced 160,000 units and had the following actual costs: Direct materials $1,148,000 Direct labor 252,900 Supplies 37,300 Maintenance 30,340 Power 28,730 Supervision 99,400 Depreciation 76,000 Other...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead:   Supplies 0.23   Maintenance 0.19   Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. In March, Nashler Company produced 170,000 units and had the following actual costs: Direct materials $1,220,000 Direct labor 268,300 Supplies 39,600 Maintenance 32,240 Power 30,520 Supervision 99,500 Depreciation 76,000 Other...