Prepare a performance report for direct labor and power

Assignment Help Financial Accounting

Reference no: EM13938738

FUNCTIONAL VERSUS ACTIVITY FLEXIBLE BUDGETING

Amy Bunker, 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:

Direct labor	$210,000
Power	135,000
Setups	140,000
Total	$485,000

Amy 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 Gary Grant, the controller, he assured her that the budgeted costs had been adjusted for the increase in productive activity. Curious, Amy questioned Gary about the methods used to make the adjustment.

Gary: 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 the costs for dif- ferent levels of activity.

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

Gary: 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.

Direct labor cost ¼ $10X Power cost ¼ $5,000 þ $4X Setup cost ¼ $100,000

Amy: 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, . . .

Gary: 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.

Amy: Well, as I was about to say, setup costs also have 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 like we are always paying overtime. I wonder if we simply do not have enough people for the setup activity. Also, there are supplies that are used for each setup, and these are not cheap. Did you build these extra costs of increased setup activity into your budget?

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

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

Direct labor cost ¼ $10X, where X ¼ Direct labor hours Power cost ¼ $68,000 þ 0.9Y, where Y ¼ Machine hours Setup cost ¼ $98,000 þ $400Z, where Z ¼ Number of setups

The actual measure of each activity driver is as follows:

Direct labor hours 20,000

Machine hours 90,000

Number of setups 110

Required:

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

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

3. Of the two approaches, which provides the more accurate picture of Amy's performance? Why?

Reference no: EM13938738

Questions Cloud

Would expect severe injury to medulla oblongata cause death : After a severe blow to the head, a patient suddenly does not produce sensations of hunger and seems unable to tell if he is dehydrated. The attending physician should suspect damage to a or a lesion within what general region of the brain?

Design an eco-optimized container for fizzy drinks : The objective of the class assignment is to design an eco-optimized container for fizzy drinks using eco design tool (CES)

Determine whether or not there is data pertaining : For each employee you are to compute the number of overtime hours worked by that employee, the salary, and the overtime pay. An employee earns straight time for the first forty hours of work, time-and-a-half for up to the first 10 hours in excess ..

Design an eco-optimised container for fizzy drinks : The opjective of the assignment is to design an Eco-optimised container for fizzy drinks using an eco-design tool (CES). Select three different container types and formulate a product specification. Explain and show the different design ..

Prepare a performance report for direct labor and power : Prepare a performance report for direct labor, power, and setups using the direct labor-based formulas. Prepare a performance report for direct labor, power, and setups using the multiple cost driver formulas that Gary developed.

Analyse the internationalisation process of an mnc : Select and then analyse the internationalisation process of an MNC in ONE country (e.g. MMG in Laos). (Approximately 1,500 words)

Basic principles of consumer behaviour : Demonstrate their knowledge of the basic principles of consumer behaviour and the students' ability to apply the knowledge to real life consumer behaviour cases.

The standpoint of vertical and horizontal equity : Explain what is meant by the terms, vertical equity, horizontal equity and the Ramsey rule. A city is considering imposing excise taxes on the following items to raise revenue to finance the construction of a new stadium for the major league baseball..

What changes would happen in my body : I have just had a very frightening experience. What changes would happen in my body (neural and endocrine systems) and do these systems effect other body systems? Once the fright has passed, how do the different physiological systems of the body i..

User Account

All Pages