You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president asked you to review the company's costing system and "do what you can to help us get better control of our manufacturing overhead costs." You find the company has never used a flexible budget, and you suggest preparing such a budget would be an excellent first step in overhead planning and control. After much effort and analysis, you estimated the following cost formulas and gathered the following actual cost data for March: Utilities Maintenance Supplies Indirect labor Depreciation Cost Formula $16,900 + $0.16 per machine-hour $38,000 + $1.50 per machine-hour $0.50 per machine-hour $94,100 + $1.20 per machine-hour $68,400 Actual Cost in March $ 21,740 $ 60,300 $ 9,300 $ 117,800 $ 70,100 During March, the company worked 17,000 machine-hours and produced 11,000 units. The company originally planned to work 19,000 machine-hours during March. Required: 1. Calculate the activity variances for March. 2. Calculate the spending variances for March.

Anderson Company has the following departmental manufacturing structure for one of its products: After some study, the production manager of Anderson recommended the following revised cellular manufacturing approach: Required: 1. Calculate the total time it takes to produce a batch of 20 units using Andersons traditional departmental structure. 2. Using cellular manufacturing, how much time is saved producing the same batch of 20 units? Assuming the cell operates continuously, what is the production rate? Which process controls this production rate? 3. What if the processing times of molding, welding, and assembly are all reduced to six minutes each? What is the production rate now, and how long will it take to produce a batch of 20 units?

The management of Wheeler Company has decided to develop cost formulas for its major overhead activities. Wheeler uses a highly automated manufacturing process, and power costs are a significant manufacturing cost. Cost analysts have decided that power costs are mixed; thus, they must be broken into their fixed and variable elements so that the cost behavior of the power usage activity can be properly described. Machine hours have been selected as the activity driver for power costs. The following data for the past eight quarters have been collected: Required: 1. Prepare a scattergraph by plotting power costs against machine hours. Does the scatter-graph show a linear relationship between machine hours and power cost? 2. Using the high and low points, compute a power cost formula. 3. Use the method of least squares to compute a power cost formula. Evaluate the coefficient of determination. 4. Rerun the regression and drop the point (20,000; 26,000) as an outlier. Compare the results from this regression to those for the regression in Requirement 3. Which is better?

Gumbrecht Company has the following departmental manufacturing layout for one of its plants: A consulting firm has recommended a value stream with the following manufacturing cell: Required: 1. Calculate the total time it takes to produce a batch of 20 units using the traditional departmental manufacturing layout. 2. Using cellular manufacturing, how much time is saved producing the same batch of 20 units? Assuming the cell operates continuously, what is the production rate? Which process controls this production rate? 3. Assume the processing time of Casting is reduced to 9 minutes, while the times of the other processes stay the same. What is the production rate now, and how long will it take to produce a batch of 20 units if the cell is in a continuous production mode?

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 itemsdirect labor, power, and setupswere over budget. The actual costs for these three items follow: 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 formulasformulas that allow us to predict what the costs will be for different levels of activity. KELLY: The approach sounds reasonable. However, Im 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 = 10X Power cost = 5,000 + 4X Setup cost = 100,000 KELLY: I think I see the problem. Power costs dont 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 betterit 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 fixedat 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. Ill 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 = 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 measures of each of the activity drivers are as follows: 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 John developed. 3. Of the two approaches, which provides the most accurate picture of Kellys performance? Why? 4. After reviewing the approach to performance measurement, a consultant remarked that non-value-added cost trend reports would be a much better performance measurement approach than comparing actual costs with budgeted costseven if activity flexible budgets were used. Do you agree or disagree? Explain.

Jolene Askew, manager of Feagan Company, has committed her company to a strategically sound cost reduction program. Emphasizing life-cycle cost management is a major part of this effort. Jolene is convinced that production costs can be reduced by paying more attention to the relationships between design and manufacturing. Design engineers need to know what causes manufacturing costs. She instructed her controller to develop a manufacturing cost formula for a newly proposed product. Marketing had already projected sales of 25,000 units for the new product. (The life cycle was estimated to be 18 months. The company expected to have 50 percent of the market and priced its product to achieve this goal.) The projected selling price was 20 per unit. The following cost formula was developed: Y=200,000+10X1 where X1=Machinehours(Theproductisexpectedtouseonemachinehourforeveryunitproduced.) Upon seeing the cost formula, Jolene quickly calculated the projected gross profit to be 50,000. This produced a gross profit of 2 per unit, well below the targeted gross profit of 4 per unit. Jolene then sent a memo to the Engineering Department, instructing them to search for a new design that would lower the costs of production by at least 50,000 so that the target profit could be met. Within two days, the Engineering Department proposed a new design that would reduce unit-variable cost from 10 per machine hour to 8 per machine hour (Design Z). The chief engineer, upon reviewing the design, questioned the validity of the controllers cost formula. He suggested a more careful assessment of the proposed designs effect on activities other than machining. Based on this suggestion, the following revised cost formula was developed. This cost formula reflected the cost relationships of the most recent design (Design Z). Y=140,000+8X1+5,000X2+2,000X3 where X1=MachinehoursX2=NumberofbatchesX3=Numberofengineeringchangeorders Based on scheduling and inventory considerations, the product would be produced in batches of 1,000; thus, 25 batches would be needed over the products life cycle. Furthermore, based on past experience, the product would likely generate about 20 engineering change orders. This new insight into the linkage of the product with its underlying activities led to a different design (Design W). This second design also lowered the unit-level cost by 2 per unit but decreased the number of design support requirements from 20 orders to 10 orders. Attention was also given to the setup activity, and the design engineer assigned to the product created a design that reduced setup time and lowered variable setup costs from 5,000 to 3,000 per setup. Furthermore, Design W also creates excess activity capacity for the setup activity, and resource spending for setup activity capacity can be decreased by 40,000, reducing the fixed cost component in the equation by this amount. Design W was recommended and accepted. As prototypes of the design were tested, an additional benefit emerged. Based on test results, the post-purchase costs dropped from an estimated 0.70 per unit sold to 0.40 per unit sold. Using this information, the Marketing Department revised the projected market share upward from 50 percent to 60 percent (with no price decrease). Required: 1. Calculate the expected gross profit per unit for Design Z using the controllers original cost formula. According to this outcome, does Design Z reach the targeted unit profit? Repeat, using the engineers revised cost formula. Explain why Design Z failed to meet the targeted profit. What does this say about the use of unit-based costing for life-cycle cost management? 2. Calculate the expected profit per unit using Design W. Comment on the value of activity information for life-cycle cost management. 3. The benefit of the post-purchase cost reduction of Design W was discovered in testing. What direct benefit did it create for Feagan Company (in dollars)? Reducing post-purchase costs was not a specific design objective. Should it have been? Are there any other design objectives that should have been considered?

Kagle design engineers are in the process of developing a new green product, one that will significantly reduce impact on the environment and yet still provide the desired customer functionality. Currently, two designs are being considered. The manager of Kagle has told the engineers that the cost for the new product cannot exceed 550 per unit (target cost). In the past, the Cost Accounting Department has given estimated costs using a unit-based system. At the request of the Engineering Department, Cost Accounting is providing both unit-and activity-based accounting information (made possible by a recent pilot study producing the activity-based data). Unit-based system: Variable conversion activity rate: 100 per direct labor hour Material usage rate: 20 per part ABC system: Labor usage: 15 per direct labor hour Material usage (direct materials): 20 per part Machining: 75 per machine hour Purchasing activity: 150 per purchase order Setup activity: 3,000 per setup hour Warranty activity: 500 per returned unit (usually requires extensive rework) Customer repair cost: 25 per repair hour (average) Required: 1. Select the lower-cost design using unit-based costing. Are logistical and post-purchase activities considered in this analysis? 2. Select the lower-cost design using ABC analysis. Explain why the analysis differs from the unit-based analysis. 3. What if the post-purchase cost was an environmental contaminant and amounted to 10 per unit for Design A and 40 per unit for Design B? Assume that the environmental cost is borne by society. Now which is the better design?

Big Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?

A local picnic table manufacturer has budgeted these overhead costs: They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown: Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities:

Mabbut Company has the following departmental manufacturing layout for one of its plants: A consulting firm recommended a value stream with the following manufacturing cell: Required: 1. Calculate the total time it takes to produce a batch of 10 units using the traditional departmental manufacturing layout. 2. Using cellular manufacturing, how much time is saved producing the same batch of 10 units? Assuming the cell operates continuously, what is the production rate? Which process controls this production rate? 3. Assume the processing time of Welding is reduced to 6 minutes, while the times of the other processes stay the same. What is the production rate now, and how long will it take to produce a batch of 10 units if the cell is in a continuous production mode?