Refer to Exercise E19-24. The president of Western suspects that her allocation of indirect costs could be giving misleading results, so she decides to develop an ABC system. She identifies three activities: documentation preparation, information technology support, and training. She figures that documentation costs are driven by the number of pages, information technology support costs are driven by the number of software applications used, and training costs are driven by the number of direct laborhours worked. Estimates of the costs and quantities of the allocation bases follow:
Compute the predetermined
Want to see the full answer?
Check out a sample textbook solutionChapter 19 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
- Data Performance, a computer software consulting company, has three major functional areas: computer programming, information systems consulting, and software training. Carol Bingham, a pricing analyst, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Carol is considering three different methods of the departmental allocation approach to allocate overhead costs: the direct method, the step method, and the reciprocal method. She assembled the following data from the two service departments, information systems and facilities: Service Departments Production Departments Information Systems Facilities Computer Programming Information Systems Consulting Software Training Total Budgeted overhead (base) $ 368,000 $ 184,000 $ 736,000 $ 874,000 $ 575,000 $ 2,737,000 Information Systems (computer hours) 600 1,200 300 900 3,000 Facilities (square feet) 240 960 600 600…arrow_forwardRequired information [The following information applies to the questions displayed below.] Data Performance, a computer software consulting company, has three major functional areas: computer programming, information systems consulting, and software training. Carol Bingham, a pricing analyst, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Carol is considering three different methods of the departmental allocation approach to allocate overhead costs: the direct method, the step method, and the reciprocal method. She assembled the following data from the two service departments, information systems and facilities: a. b. Budgeted overhead (base) Information Systems (computer hours) Facilities (square feet) C. Service Departments Information Systems $ 368,000 240 Direct Method Step Method (Information Systems Goes First) Step Method (Facilities Goes First) Reciprocal method Computer…arrow_forwardConsider the business application," filing excess capacity 'below cost'. As noted there, the determination of cost depends on the way in which cost of delivery services are allocated to different customers. Assume that USPS has to customers people who made first class letters and business that ship packages to customers. Management at USPS wants to understand how profitable each customer Group is. how would you recommend the costs of the USPS network (Trucks,buildings,carriers and so on)be allocated to these two customers to answer that question?arrow_forward
- Garrell Corporation is conducting a time-driven activity-based costing study in its Customer Support Department. The company has provided the following data to aid in that study: Time-driven activity rate (cost per unit of activity) Activity cost pool: Receiving Calls Resolving Issues Settling Disputes Cost Object Data: Number of calls received Number of issues resolved Number of disputes settled Customer P 31 17 1 $5.46 $8.58 $13.26 Customer Q 21 10 Required: Using time-driven activity-based costing, determine the total Customer Support Department cost assigned to cach customer.arrow_forwardRandy 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.arrow_forwardWhich of the following is a reason a company would implement activity-based costing? A. The cost of record keeping is high. B. The additional data obtained through traditional allocation are not worth the cost. C. They want to improve the data on which decisions are made. D. A company only has one cost driver.arrow_forward
- Auflegger, Inc., manufactures a product that experiences the following activities (and times): Required: 1. Compute the MCE for this product. 2. A study lists the following root causes of the inefficiencies: poor quality components from suppliers, lack of skilled workers, and plant layout. Suggest a possible cost reduction strategy, expressed as a series of if-then statements that will reduce MCE and lower costs. Finally, prepare a strategy map that illustrates the causal paths. In preparing the map, use only three perspectives: learning and growth, process, and financial. 3. Is MCE a lag or a lead measure? If and when MCE acts as a lag measure, what lead measures would affect it?arrow_forwardThe 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?arrow_forwardAs you learned in the previous chapters, Current Designs has two main product lines-composite kayaks, which are handmade and very labor-intensive, and rotomolded kayaks, which require less labor but employ more expensive equipment. Current Designs' controller, Diane Buswell, is now evaluating several different methods of assigning overhead to these products. It is important to ensure that costs are appropriately assigned to the company's products. At the same time, the system that is used must not be so complex that its costs are greater than its benefits. Diane has decided to use the following activities and costs to evaluate the methods of assigning overhead. Activities Designing new models Creating and testing prototypes Creating molds for kayaks Cost $124,000 144,000 182,000 Operating oven for the rotomolded kayaks 41,000 Operating the vacuum line for the composite kayaks 28,000 Supervising production employees 168,000 Curing time (the time that is needed for the chemical processes…arrow_forward
- The president of Mission Inc. has been concerned about the growth in costs over the last several years. The president asked the controller to perform an activity analysis to gain a better insight into these costs. The activity analysis revealed the following:arrow_forwardSnowden Industries produces two electronic decoders, P and Q. Decoder P is more sophisticated and requires more programming and testing than does Decoder Q. Because of these product differences, the company wants to use activity-based costing to allocate overhead costs. It has identified four activity pools. Relevant information follows. *Need help for informatio going into excel*arrow_forwardArklan Production is upgrading its manufacturing process from a manual process to a highly automated system. Management believes that the new system will result in greater efficiencies and a better finished product. Arklan is also working on a plan to downsize staff after the implementation of the new system. Arklan has used a traditional absorption costing system to calculate unit product costs for external financial reporting. In the past, Arklan has allocated its manufacturing overhead costs using a predetermined plant-wide overhead rate based on direct labor hours. The controller realizes that the new system may require changing the overhead allocation process. Management plans to take the opportunity to reconsider other improvements to the costing system. Identify and explain three benefits of using departmental overhead rates to allocate overhead costs. Explain the difference between absorption costing and variable costing. Identify which is more suitable for internal…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College