The Tree Wood Products manufactures small tables. The overhead incurred in manufacturing the tables have both a fixed component and a variable component. The company's management wishes to explain variable overhead as a percentage of direct labor costs. Management has obtained the following cost data pertaining to the production of the small tables: Units Produced Direct Labor Costs ($) Overhead Costs ($) 300 3200 2400 400 5000 2600 1000 8000 6000 600 5400 2800 2400 2200 100 Compute the fixed and variable components of the overhead costs using the high-low method.

The Tree Wood Products manufactures small tables. The overhead incurred in manufacturing the tables have both a fixed component and a variable component. The company's management wishes to explain variable overhead as a percentage of direct labor costs. Management has obtained the following cost data pertaining to the production of the small tables: Units Produced Direct Labor Costs ($) Overhead Costs ($) 300 3200 2400 400 5000 2600 1000 8000 6000 600 5400 2800 2400 2200 100 Compute the fixed and variable components of the overhead costs using the high-low method.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 4CE: Larsen, Inc., produces two types of electronic parts and has provided the following data: There are...

See similar textbooks

Similar questions

Potterii sells its products to large box stores and recently added a retail line of products to sell directly to consumers. These estimates are to be used in determining the overhead allocation rate for ABC: What would be the predetermined rate for each cost pool?
Lampierre makes brass and gold frames. The company computed this information to decide whether to switch from the traditional allocation method to ABC: The estimated overhead for the material cost pool is estimated as $12,500, and the estimate for the machine setup pool is $35,000. Calculate the allocation rate per unit of brass and per unit of gold using: A. The traditional allocation method B. The activity-based costing method
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?
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?
Lampierre makes silver and gold candlesticks. The company computed this information to decide whether to switch from the traditional allocation method to ABC. The estimated overhead for the material cost pool is estimated as $45,000, and the estimate for the machine setup pool is $55,000. Calculate the allocation rate per unit of silver and per unit of gold using: A. The traditional allocation method B. The activity-based costing method
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?
Classify each of the following items of factory overhead as either a fixed or a variable cost. (Include any costs that you consider to be semivariable within the variable category. Remember that variable costs change in total as the volume of production changes.) Indirect labor Indirect materials Insurance on building Overtime premium pay Depreciation of building (straight-line method) Polishing compounds Depreciation of machinery (units-of-production method) Employer’s payroll taxes Property taxes Machine lubricants Employees’ hospital insurance (paid by employer) Labor for machine repairs Vacation pay Janitor’s wages Rent Small tools Plant manager’s salary Factory electricity Product inspector’s wages
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?
San Mateo Optics, Inc., specializes in manufacturing lenses for large telescopes and cameras used in space exploration. As the specifications for the lenses are determined by the customer and vary considerably, the company uses a job-order costing system. Manufacturing overhead is applied to jobs on the basis of direct labor hours, utilizing the absorption- or full-costing method. San Mateos predetermined overhead rates for 20x1 and 20x2 were based on the following estimates. Jim Cimino, San Mateos controller, would like to use variable (direct) costing for internal reporting purposes as he believes statements prepared using variable costing are more appropriate for making product decisions. In order to explain the benefits of variable costing to the other members of San Mateos management team, Cimino plans to convert the companys income statement from absorption costing to variable costing. He has gathered the following information for this purpose, along with a copy of San Mateos 20x1 and 20x2 comparative income statement. San Mateo Optics, Inc. Comparative Income Statement For the Years 20x1 and 20x2 San Mateos actual manufacturing data for the two years are as follows: The companys actual inventory balances were as follows: For both years, all administrative expenses were fixed, while a portion of the selling expenses resulting from an 8 percent commission on net sales was variable. San Mateo reports any over-or underapplied overhead as an adjustment to the cost of goods sold. Required: 1. For the year ended December 31, 20x2, prepare the revised income statement for San Mateo Optics, Inc., utilizing the variable-costing method. Be sure to include the contribution margin on the revised income statement. 2. Describe two advantages of using variable costing rather than absorption costing. (CMA adapted)
Roberts Company produces two weed eaters: basic and advanced. The company has four activities: machining, engineering, receiving, and inspection. Information on these activities and their drivers is given below. Overhead costs: Required: 1. Calculate the four activity rates. 2. Calculate the unit costs using activity rates. Also, calculate the overhead cost per unit. 3. What if consumption ratios instead of activity rates were used to assign costs instead of activity rates? Show the cost assignment for the inspection activity.
Electan Company produces two types of printers. The company uses ABC, and all activity drivers are duration drivers. Electan Company is considering using DBC and has gathered the following data to help with its decision. A. Activities with duration drivers: B. Activities with consumption ratios and costs: C. Products with cycle time and practical capacity: Required: 1. Using cycle time and practical capacity for each product, calculate the total time for all primary activities. Comment on the relationship to ABC. 2. Calculate the overhead rate that DBC uses to assign costs. Comment on the relationship to a unit-based plantwide overhead rate. 3. Use the overhead rate calculated in Requirement 2 to calculate (a) the overhead cost per unit for each product, and (b) the total overhead assigned to each product. How does this compare to the ABC assignments shown in Part B of the Information set? 4. What if the units actually produced were 10,000 for Printer A and 18,000 for Printer B. Using DBC, calculate the cost of unused capacity.
Please help me