In Class Assignment 1 AlSaleh has assigned overhead on a plantwide basis to its two products (Tables and Chairs) using direct labor hours which are estimated to be 200,000 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are Ordering and receiving (cost driver is Purchase orders) and machine setup (cost driver is number of setups). Overhead allocated to the ordering and receiving cost pool is $200,000, and $800,000 is allocated to the machine setup cost pool. Additional information related to these pools is as follows: Cost Drivers Tables Chairs Purchase orders 30,000 10,000 number of setups 10,000 30,000 a. Determine the amount of overhead assigned to the table product line and the chairs product line using activity-based costing. b. What amount of overhead would be assigned to the tables and chairs product lines using the traditional approach, assuming direct labor hours were incurred as follow: 80% for the tables and 20% for the chairs.

In Class Assignment 1 AlSaleh has assigned overhead on a plantwide basis to its two products (Tables and Chairs) using direct labor hours which are estimated to be 200,000 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are Ordering and receiving (cost driver is Purchase orders) and machine setup (cost driver is number of setups). Overhead allocated to the ordering and receiving cost pool is $200,000, and $800,000 is allocated to the machine setup cost pool. Additional information related to these pools is as follows: Cost Drivers Tables Chairs Purchase orders 30,000 10,000 number of setups 10,000 30,000 a. Determine the amount of overhead assigned to the table product line and the chairs product line using activity-based costing. b. What amount of overhead would be assigned to the tables and chairs product lines using the traditional approach, assuming direct labor hours were incurred as follow: 80% for the tables and 20% for the chairs.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter20: Activity-based Costing (abc)

Section: Chapter Questions

Problem 1R: Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following...

See similar textbooks

Similar questions

Medical Tape makes two products: Generic and Label. It estimates it will produce 423,694 units of Generic and 652,200 of Label, and the overhead for each of its cost pools is as follows: It has also estimated the activities for each cost driver as follows: How much is the overhead allocated to each unit of Generic and Label?
Plata Company has identified the following overhead activities, costs, and activity drivers for the coming year: Plata produces two models of microwave ovens with the following activity demands: The companys normal activity is 21,000 machine hours. Calculate the total overhead cost that would be assigned to Model X using an activity-based costing system: a. 230,000 b. 240,000 c. 280,000 d. 190,000
Lansing. Inc., provided the following data for its two producing departments: Machine hours are used to assign the overhead of the Molding Department, and direct labor hours are used to assign the overhead of the Polishing Department. There are 30,000 units of Form A produced and sold and 50,000 of Form B. Required: 1. Calculate the overhead rates for each department. 2. Using departmental rates, assign overhead to live two products and calculate the overhead cost per unit. How does this compare with the plantwide rate unit cost, using direct labor hours? 3. What if the machine hours in Molding were 1,200 for Form A and 3,800 for Form B and the direct labor hours used in Polishing were 5,000 and 15,000, respectively? Calculate the overhead cost per unit for each product using departmental rates, and compare with the plantwide rate unit costs calculated in Requirement 2. What can you conclude from this outcome?
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?
Silven Company has identified the following overhead activities, costs, and activity drivers for the coming year: Silven produces two models of cell phones with the following expected activity demands: 1. Determine the total overhead assigned to each product using the four activity drivers. 2. Determine the total overhead assigned to each model using the two most expensive activities. The costs of the two relatively inexpensive activities are allocated to the two expensive activities in proportion to their costs. 3. Using ABC as the benchmark, calculate the percentage error and comment on the accuracy of the reduced system. Explain why this approach may be desirable.
Primera Company produces two products and uses a predetermined overhead rate to apply overhead. Primera currently applies overhead using a plantwide rate based on direct labor hours. Consideration is being given to the use of departmental overhead rates where overhead would be applied on the basis of direct labor hours in Department 1 and on the basis of machine hours in Department 2. At the beginning of the year, the following estimates are provided: Actual results reported by department and product during the year are as follows: Required: 1. Compute the plantwide predetermined overhead rate and calculate the overhead assigned to each product. 2. Calculate the predetermined departmental overhead rates and calculate the overhead assigned to each product. 3. Using departmental rates, compute the applied overhead for the year. What is the under- or overapplied overhead for the firm? 4. Prepare the journal entry that disposes of the overhead variance calculated in Requirement 3, assuming it is not material in amount. What additional information would you need if the variance is material to make the appropriate journal entry?
Wrappers Tape makes two products: Simple and Removable. It estimates it will produce 369,991 units of Simple and 146,100 of Removable, and the overhead for each of its cost pools is as follows: It has also estimated the activities for each cost driver as follows: Â How much is the overhead allocated to each unit of Simple and Removable?
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.
A manufacturing company has two service and two production departments. Building Maintenance and Factory Office are the service departments. The production departments are Assembly and Machining. The following data have been estimated for next years operations: The direct charges identified with each of the departments are as follows: The building maintenance department services all departments of the company, and its costs are allocated using floor space occupied, while factory office costs are allocable to Assembly and Machining on the basis of direct labor hours. 1. Distribute the service department costs, using the direct method. 2. Distribute the service department costs, using the sequential distribution method, with the department servicing the greatest number of other departments distributed first.
Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.
Use the following information for Brief Exercises 4-34 and 4-35: Sanjay Company manufactures a product in a factory that has two producing departments, Assembly and Painting, and two support departments, S1 and S2. The activity driver for S1 is square footage, and the activity driver for S2 is number of machine hours. The following data pertain to Sanjay: Brief Exercises 4-34 (Appendix 4B) Assigning Support Department Costs by Using the Direct Method Refer to the information for Sanjay Company above. Required: 1. Calculate the cost assignment ratios to be used under the direct method for Departments S1 and S2. (Note: Each support department will have two ratiosone for Assembly and the other for Painting.) 2. Allocate the support department costs to the producing departments by using the direct method.
Geneva, Inc., makes two products, X and Y, that require allocation of indirect manufacturing costs. The following data were compiled by the accountants before making any allocations: The total cost of purchasing and receiving parts used in manufacturing is 60,000. The company uses a job-costing system with a single indirect cost rate. Under this system, allocated costs were 48,000 and 12,000 for X and Y, respectively. If an activity-based system is used, what would be the allocated costs for each product?