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,700 + $0.20 per machine-hour $38,100 + $1.30 per machine-hour $0.30 per machine-hour $94,500+ $1.60 per machine-hour $68,300 Actual Cost in March $ 23,500 $ 64,400 $ 7,300 $ 135,400 $ 70,000 During March, the company worked 23,000 machine-hours and produced 17,000 units. The company originally planned to work 25,000 machine-hours during March. Required: 1. Calculate the activity variances for March. 2. Calculate the spending variances for March.

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,700 + $0.20 per machine-hour $38,100 + $1.30 per machine-hour $0.30 per machine-hour $94,500+ $1.60 per machine-hour $68,300 Actual Cost in March $ 23,500 $ 64,400 $ 7,300 $ 135,400 $ 70,000 During March, the company worked 23,000 machine-hours and produced 17,000 units. The company originally planned to work 25,000 machine-hours during March. Required: 1. Calculate the activity variances for March. 2. Calculate the spending variances for March.

Name: You have just been hired by FAB Corporation, the manufacturer of a re
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: 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 controlof our manufacturing ove

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter5: Product And Service Costing: Job-order System

Section: Chapter Questions

Problem 27P: Firenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming...

See similar textbooks

Similar questions

Randy Harris, controller, has been given the charge to implement an advanced cost management system. As part of this process, he needs to identify activity drivers for the activities of the firm. During the past four months, Randy has spent considerable effort identifying activities, their associated costs, and possible drivers for the activities costs. Initially, Randy made his selections based on his own judgment using his experience and input from employees who perform the activities. Later, he used regression analysis to confirm his judgment. Randy prefers to use one driver per activity, provided that an R2 of at least 80 percent can be produced. Otherwise, multiple drivers will be used, based on evidence provided by multiple regression analysis. For example, the activity of inspecting finished goods produced an R2 of less than 80 percent for any single activity driver. Randy believes, however, that a satisfactory cost formula can be developed using two activity drivers: the number of batches and the number of inspection hours. Data collected for a 14-month period are as follows: Required: 1. Calculate the cost formula for inspection costs using the two drivers, inspection hours and number of batches. Are both activity drivers useful? What does the R2 indicate about the formula? 2. Using the formula developed in Requirement 1, calculate the inspection cost when 300 inspection hours are used and 30 batches are produced. Prepare a 90 percent confidence interval for this prediction.
Firenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming year is: Previously, Sanjay Bhatt, Firenza Companys controller, had applied overhead on the basis of machine hours. Expected machine hours for the coming year are 50,000. Sanjay has been reading about activity-based costing, and he wonders whether or not it might offer some advantages to his company. He decided that appropriate drivers for overhead activities are purchase orders for purchasing, number of setups for setup cost, engineering hours for engineering cost, and machine hours for other. Budgeted amounts for these drivers are 5,000 purchase orders, 500 setups, and 2,500 engineering hours. Sanjay has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 40 percent markup over full manufacturing cost. Required: 1. Calculate a plantwide rate for Firenza Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate activity rates for the four overhead activities. What is the bid price of each job using these rates? 3. Which bids are more accurate? Why?
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?
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?
Young Company is beginning operations and is considering three alternatives to allocate manufacturing overhead to individual units produced. Young can use a plantwide rate, departmental rates, or activity-based costing. Young will produce many types of products in its single plant, and not all products will be processed through all departments. In which one of the following independent situations would reported net income for the first year be the same regardless of which overhead allocation method had been selected? a. All production costs approach those costs that were budgeted. b. The sales mix does not vary from the mix that was budgeted. c. All manufacturing overhead is a fixed cost. d. All ending inventory balances are zero.
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?
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?
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?
Evans, Inc., has a unit-based costing system. Evanss Miami plant produces 10 different electronic products. The demand for each product is about the same. Although they differ in complexity, each product uses about the same labor time and materials. The plant has used direct labor hours for years to assign overhead to products. To help design engineers understand the assumed cost relationships, the Cost Accounting Department developed the following cost equation. (The equation describes the relationship between total manufacturing costs and direct labor hours; the equation is supported by a coefficient of determination of 60 percent.) Y=5,000,000+30X,whereX=directlaborhours The variable rate of 30 is broken down as follows: Because of competitive pressures, product engineering was given the charge to redesign products to reduce the total cost of manufacturing. Using the above cost relationships, product engineering adopted the strategy of redesigning to reduce direct labor content. As each design was completed, an engineering change order was cut, triggering a series of events such as design approval, vendor selection, bill of materials update, redrawing of schematic, test runs, changes in setup procedures, development of new inspection procedures, and so on. After one year of design changes, the normal volume of direct labor was reduced from 250,000 hours to 200,000 hours, with the same number of products being produced. Although each product differs in its labor content, the redesign efforts reduced the labor content for all products. On average, the labor content per unit of product dropped from 1.25 hours per unit to one hour per unit. Fixed overhead, however, increased from 5,000,000 to 6,600,000 per year. Suppose that a consultant was hired to explain the increase in fixed overhead costs. The consultants study revealed that the 30 per hour rate captured the unit-level variable costs; however, the cost behavior of other activities was quite different. For example, setting up equipment is a step-fixed cost, where each step is 2,000 setup hours, costing 90,000. The study also revealed that the cost of receiving goods is a function of the number of different components. This activity has a variable cost of 2,000 per component type and a fixed cost that follows a step-cost pattern. The step is defined by 20 components with a cost of 50,000 per step. Assume also that the consultant indicated that the design adopted by the engineers increased the demand for setups from 20,000 setup hours to 40,000 setup hours and the number of different components from 100 to 250. The demand for other non-unit-level activities remained unchanged. The consultant also recommended that management take a look at a rejected design for its products. This rejected design increased direct labor content from 250,000 hours to 260,000 hours, decreased the demand for setups from 20,000 hours to 10,000 hours, and decreased the demand for purchasing from 100 component types to 75 component types, while the demand for all other activities remained unchanged. Required: 1. Using normal volume, compute the manufacturing cost per labor hour before the year of design changes. What is the cost per unit of an average product? 2. Using normal volume after the one year of design changes, compute the manufacturing cost per hour. What is the cost per unit of an average product? 3. Before considering the consultants study, what do you think is the most likely explanation for the failure of the design changes to reduce manufacturing costs? Now use the information from the consultants study to explain the increase in the average cost per unit of product. What changes would you suggest to improve Evanss efforts to reduce costs? 4. Explain why the consultant recommended a second look at a rejected design. Provide computational support. What does this tell you about the strategic importance of cost management?
Leather Works is a family-owned maker of leather travel bags and briefcases located in the northeastern part of the United States. Foreign competition has forced its owner, Heather Gray, to explore new ways to meet the competition. One of her cousins, Wallace Hayes, who recently graduated from college with a major in accounting, told her about the use of cost variance analysis to learn about efficiencies of production. In May of last year, Heather asked Matt Jones, chief accountant, and Alfred Prudest, production manager, to implement a standard costing system. Matt and Alfred, in turn, retained Shannon Leikam, an accounting professor at Hardings College, to set up a standard costing system by using information supplied to her by Matts and Alfreds staff. To verify that the information was accurate, Shannon visited the plant and measured workers output using time and motion studies. During those visits, she was not accompanied by either Matt or Alfred, and the workers knew about Shannons schedule in advance. The cost system was implemented in June of last year. Recently, the following dialogue took place among Heather, Matt, and Alfred: HEATHER: How is the business performing? ALFRED: You know, we are producing a lot more than we used to, thanks to the contract that you helped obtain from Lean, Inc., for laptop covers. (Lean is a national supplier of computer accessories.) MATT: Thank goodness for that new product. It has kept us from sinking even more due to the inroads into our business made by those foreign suppliers of leather goods. HEATHER: What about the standard costing system? MATT: The variances are mostly favorable, except for the first few months when the supplier of leather started charging more. HEATHER: How did the union members take to the standards? ALFRED: Not bad. They grumbled a bit at first, but they have taken it in stride. Weve consistently shown favorable direct labor efficiency variances and direct materials usage variances. The direct labor rate variance has been flat. MATT: It should be since direct labor rates are negotiated by the union representative at the start of the year and remain the same for the entire year. HEATHER: Matt, would you send me the variance report for laptop covers immediately? The following chart summarizes the direct materials and direct labor variances from November of last year through April of this year (extracted from the report provided by Matt). Standards for each laptop cover are as follows: a. Three feet of direct materials at 7.50 per foot b. Forty-five minutes of direct labor at 14 per hour In addition, the data for May of this year, but not the variances for the month, are as follows: Actual direct labor cost per hour exceeded the budgeted rate by 0.10 per hour. Required: 1. For May of this year, calculate the price and quantity variances for direct labor and direct materials. 2. Discuss the trend of the direct materials and labor variances. 3. What type of actions must the workers have taken during the period they were being observed for the setting of standards? 4. What can be done to ensure that the standards are set correctly? (CMA adapted)
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?