Hello question is attached, thanks. After reviewing the new activity-based costing system that Nancy Chen has implemented at IVC's CenterPoint manufacturing facility,Tom Spencer, the production supervisor, believes that he can reduce production costs by reducing the time spent on machine setups.He has spent the last month working with employees in the plant to change over the machines more quickly with the same reliability.He plans to produce 100,000 units of the Sport model and 40,000 units of the Pro model in the first quarter. He believes that with hismore efficient setup routine, he can reduce the number of setup hours for both the Sport and the Pro products by 25 percent.Cost Drivers and Cost Driver Volumes-CenterPoint Manufacturing FacilityCost Driver VolumeActivityCost DriverSportProTotalAssembly buildingAssemblingSetting up machinesHandling materialPackaging buildingInspecting and packing Direct labor-hoursShipping6,0004030,0004004036,000440Machine-hoursSetup hoursProduction runs4860,00010022,80020082,800300Number of shipments Third Quarter Unit Cost Report, Activity-Based Costing-CenterPoint Manufacturing FacilitySport$1,500,000ProDirect material$2,400,000Direct laborAssemblyPackagingTotal direct labor$ 750,000990,000$1,740,000$3,240,000$ 600,000360,000$ 960,000$3,360,000Direct costsOverheadAssembly buildingAssembling (@ $30 per MH)Setting up machine (@ $900 per setup hour)Handling material (@ $3,000 per run)Packaging buildingInspecting and packing (@ $5_per direct labor-hour)Shipping (@ $1,320 per shipment)Total ABC overhead$ 180,00036,00024,000$ 900,000360,000120,000300,000132,000$ 672,000114,000264,000$1,758,000$5,118,000Total ABC cost$3,912,000Number of units100,00039.1240,000127.95Unit costRequired:a. Compute the amount of overhead allocated to the Sport and the Pro drones for the first quarter using activity-based costing.Assume that all events are the same in the first quarter as in the third quarter except for the number of setup hours. Assume the cost ofa setup hour remains at $900.Total ABCModelOverheadSportPro

Activity Based Costing: It a costing method that identifies all the activities in the organization…

Third Quarter Unit Cost Report, Activity-Based Costing-CenterPoint Manufacturing Facility Sport $1,500,000 Pro $2,400,000 Direct material Direct labor Assembly Packaging Total direct labor Direct costs Overhead Assembly building Assembling (@ $30 per MH) Setting up machine (@ $900 per setup hour) Handling material (@ $3, 000 per run) Packaging building Inspecting and packing (@ $5_per direct labor-hour) Shipping (@ $1,320 per shipment) Total ABC overhead $ 750,000 990,000 $1,740,000 $3,240,000 600,000 360,000 $ 960,000 $3,360,000 $ $ 180,000 36,000 24,000 $ 900,000 360,000 120,000 300,000 132,000 $ 672,000 114,000 264,000 $1,758,000 $5,118,000 40,000 $ Total ABC cost $3,912,000 100,000 Number of units Unit cost $ 39.12 127.95 Required: a. Compute the amount of overhead allocated to the Sport and the Pro drones for the first quarter using activity-based costing. Assume that all events are the same in the first quarter as in the third quarter except for the number of setup hours. Assume the cost of a setup hour remains at $900. Total ABC Model Overhead Sport Pro

Third Quarter Unit Cost Report, Activity-Based Costing-CenterPoint Manufacturing Facility Sport $1,500,000 Pro $2,400,000 Direct material Direct labor Assembly Packaging Total direct labor Direct costs Overhead Assembly building Assembling (@ $30 per MH) Setting up machine (@ $900 per setup hour) Handling material (@ $3, 000 per run) Packaging building Inspecting and packing (@ $5_per direct labor-hour) Shipping (@ $1,320 per shipment) Total ABC overhead $ 750,000 990,000 $1,740,000 $3,240,000 600,000 360,000 $ 960,000 $3,360,000 $ $ 180,000 36,000 24,000 $ 900,000 360,000 120,000 300,000 132,000 $ 672,000 114,000 264,000 $1,758,000 $5,118,000 40,000 $ Total ABC cost $3,912,000 100,000 Number of units Unit cost $ 39.12 127.95 Required: a. Compute the amount of overhead allocated to the Sport and the Pro drones for the first quarter using activity-based costing. Assume that all events are the same in the first quarter as in the third quarter except for the number of setup hours. Assume the cost of a setup hour remains at $900. Total ABC Model Overhead Sport Pro

Financial And Managerial Accounting

15th Edition

ISBN:9781337902663

Author:WARREN, Carl S.

Publisher:WARREN, Carl S.

Chapter18: Activity-based Costing

Section: Chapter Questions

Problem 13E: Handbrain Inc. is considering a change to activity-based product costing. The company produces two...

See similar textbooks

Similar questions

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?
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?
Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 2,000 direct labor hours. The total indirect labor is budgeted to be 200,000. Time records from indirect labor employees revealed that they spent 30% of their time setting up production runs and 70% of their time supporting actual production. The following information about cell phones and tablet PCs was determined from the corporate records: a. Determine the indirect labor cost per unit allocated to cell phones and tablet PCs under a single plantwide factory overhead rate system using the direct labor hours as the allocation base. b. Determine the budgeted activity costs and activity rates for the indirect labor under activity-based costing. Assume two activitiesone for setup and the other for production support. c. Determine the activity cost per unit for indirect labor allocated to each product under activity-based costing. d. Why are the per-unit allocated costs in (a) different from the per-unit activity cost assigned to the products in (c)?
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?
Mott Company recently implemented a JIT manufacturing system. After one year of operation, Heidi Burrows, president of the company, wanted to compare product cost under the JIT system with product cost under the old system. Motts two products are weed eaters and lawn edgers. The unit prime costs under the old system are as follows: Under the old manufacturing system, the company operated three service centers and two production departments. Overhead was applied using departmental overhead rates. The direct overhead costs associated with each department for the year preceding the installation of JIT are as follows: Under the old system, the overhead costs of the service departments were allocated directly to the producing departments and then to the products passing through them. (Both products passed through each producing department.) The overhead rate for the Machining Department was based on machine hours, and the overhead rate for assembly was based on direct labor hours. During the last year of operations for the old system, the Machining Department used 80,000 machine hours, and the Assembly Department used 20,000 direct labor hours. Each weed eater required 1.0 machine hour in Machining and 0.25 direct labor hour in Assembly. Each lawn edger required 2.0 machine hours in Machining and 0.5 hour in Assembly. Bases for allocation of the service costs are as follows: Upon implementing JIT, a manufacturing cell for each product was created to replace the departmental structure. Each cell occupied 40,000 square feet. Maintenance and materials handling were both decentralized to the cell level. Essentially, cell workers were trained to operate the machines in each cell, assemble the components, maintain the machines, and move the partially completed units from one point to the next within the cell. During the first year of the JIT system, the company produced and sold 20,000 weed eaters and 30,000 lawn edgers. This output was identical to that for the last year of operations under the old system. The following costs have been assigned to the manufacturing cells: Required: 1. Compute the unit cost for each product under the old manufacturing system. 2. Compute the unit cost for each product under the JIT system. 3. Which of the unit costs is more accurate? Explain. Include in your explanation a discussion of how the computational approaches differ. 4. Calculate the decrease in overhead costs under JIT, and provide some possible reasons that explain the decrease.
Salley is developing material and labor standards for her company. She finds that it costs $0.55 per pound of material per widget. Each widget requires 6 pounds of material per widget. Salley is also working with the operations manager to determine what the standard labor cost is for a widget. Upon observation, Salley notes that it takes 3 hours in the assembly department and 1 hour in the finishing department to complete one widget. All employees are paid $10.50 per hour. A. What is the standard materials cost per unit for a widget? 8. What is the standard labor cost per unit for a widget?
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?
Computador has a manufacturing plant in Des Moines that has the theoretical capability to produce 243,000 laptops per quarter but currently produces 91,125 units. The conversion cost per quarter is 7,290,000. There are 60,750 production hours available within the plant per quarter. In addition to the processing minutes per unit used, the production of the laptops uses 10 minutes of move time, 20 minutes of wait time, and 5 minutes of rework time. (All work is done by cell workers.) Required: 1. Compute the theoretical and actual velocities (per hour) and the theoretical and actual cycle times (minutes per unit produced). 2. Compute the ideal and actual amounts of conversion cost assigned per laptop. 3. Calculate MCE. How does MCE relate to the conversion cost per laptop?
Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next months sales are in the finished goods inventory. Ingles also purchases sufficient materials to ensure that materials inventory is 60 percent of the following months scheduled production. Ingless sales budget in units for the next quarter is as follows: Ingless ending inventories in units for July 31 are as follows: Required: 1. Calculate the number of tables to be produced during August. 2. Disregarding your response to Requirement 1, assume the required production units for August and September are 2,100 and 1,900, respectively, and the July 31 materials inventory is 4,000 units. Compute the number of table legs to be purchased in August. 3. Assume that Ingles Corporation will produce 2,340 units in September. How many employees will be required for the Assembly Department in September? (Fractional employees are acceptable since employees can be hired on a part-time basis. Assume a 40-hour week and a 4-week month.) (CMA adapted)
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?
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.
Brees, Inc., a manufacturer of golf carts, has just received an offer from a supplier to provide 2,600 units of a component used in its main product. The component is a track assembly that is currently produced internally. The supplier has offered to sell the track assembly for 66 per unit. Brees is currently using a traditional, unit-based costing system that assigns overhead to jobs on the basis of direct labor hours. The estimated traditional full cost of producing the track assembly is as follows: Prior to making a decision, the companys CEO commissioned a special study to see whether there would be any decrease in the fixed overhead costs. The results of the study revealed the following: 3 setups1,160 each (The setups would be avoided, and total spending could be reduced by 1,160 per setup.) One half-time inspector is needed. The company already uses part-time inspectors hired through a temporary employment agency. The yearly cost of the part-time inspectors for the track assembly operation is 12,300 and could be totally avoided if the part were purchased. Engineering work: 470 hours, 45/hour. (Although the work decreases by 470 hours, the engineer assigned to the track assembly line also spends time on other products, and there would be no reduction in his salary.) 75 fewer material moves at 30 per move. Required: 1. Ignore the special study, and determine whether the track assembly should be produced internally or purchased from the supplier. 2. Now, using the special study data, repeat the analysis. 3. Discuss the qualitative factors that would affect the decision, including strategic implications. 4. After reviewing the special study, the controller made the following remark: This study ignores the additional activity demands that purchasing would cause. For example, although the demand for inspecting the part on the production floor decreases, we may need to inspect the incoming parts in the receiving area. Will we actually save any inspection costs? Is the controller right?