I attached the data as well please do itThanks The following information is provided for Orbit Antenna Corp., which manufactures two products: Lo-Gain antennas and Hi-Gain antennas for use in remote areas.(Click the icon to view the information.)Orbit Antenna plans to produce 125 Lo-Gain antennas and 225 Hi-Gain antennas.Read the requirements.Requirement 1. Compute the indirect manufacturing cost per unit using direct labor hours for the single plantwide predetermined overhead allocation rate.First, compute the predetermined overhead (OH) allocation rate. (Round your answer to the nearest cent.)The predetermined overhead (OH) allocation rate isCompute the manufacturing cost allocated to Lo-Gain antennas, and then compute the indirect manufacturing cost per unit for Lo-Gain antennas. Next, compute the manufacturing cost allocated to Hi-Gainantennas and the indirect manufacturing cost per unit for Hi-Gain. (Round your cost per unit to the nearest cent.)Lo-GainHi-GainTotal indirect costs allocatedNumber of unitsIndirect cost per unitRequirement 2. Compute the ABC indirect manufacturing cost per unit for each product.Begin by selecting the formula to calculate the predetermined overhead (OH) allocation rate. Then enter the amounts to compute the allocation rate for each activity. (Abbreviation used: Qty = Quantity. Roundyour allocation rate to the nearest cent.)SetupMachine maintenanceNext, select the formula to allocate overhead (OH) costs.+SetupMachine maintenanceTotal activity-based costsNumber of unitsActivity-based cost per unitAllocated mfg.overhead costsPredetermined OHallocation rate=Compute the total activity-based costs allocated to Lo-Gain antennas, and then compute the cost per unit for Lo-Gain antennas. Finally, compute the total activity-based costs allocated to Hi-Gain antennas,then compute the cost per unit for Hi-Gain antennas. (Round the cost per unit to the nearest cent.)Lo-GainHi-Gain Data tableActivitySetupMachine maintenanceTotal indirect manufacturing costsDirect labor hoursNumber of setupsNumber of machine hoursPrintCost$ 58,000 Number of setups30,000 Number of machine hours$ 88,000Lo-Gain1,200403,000Allocation BaseDoneHi-Gain3,800402,000-Total5,000805,000X

The overhead is applied to the production on the basis of predetermined overhead rate. The…

Data table Activity Setup Machine maintenance Total indirect manufacturing costs Direct labor hours Number of setups Number of machine hours Print Cost $ 58,000 Number of setups 30,000 Number of machine hours $ 88,000 Allocation Base Lo-Gain 1,200 40 3,000 Done Hi-Gain 3,800 40 2,000 Total 5,000 80 5,000

Data table Activity Setup Machine maintenance Total indirect manufacturing costs Direct labor hours Number of setups Number of machine hours Print Cost $ 58,000 Number of setups 30,000 Number of machine hours $ 88,000 Allocation Base Lo-Gain 1,200 40 3,000 Done Hi-Gain 3,800 40 2,000 Total 5,000 80 5,000

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 3CE: Lansing. Inc., provided the following data for its two producing departments: Machine hours are used...

See similar textbooks

Similar questions

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?
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?
Stacks manufactures two different levels of hockey sticks: the Standard and the Slap Shot. The total overhead of $600,000 has traditionally been allocated by direct labor hours, with 400,000 hours for the Standard and 200.000 hours for the Slap Shot. After analyzing and assigning costs to two cost pools, it was determined that machine hours is estimated to have $450.000 of overhead, with 30,000 hours used on the Standard product and 15,000 hours used on the Slap Shot product. It was also estimated that the inspection cost pool would have $150,000 of overhead, with 25,000 hours for the Standard and 5,000 hours for the Slap Shot. What is the overhead rate per product, under traditional and under ABC costing?
Box Springs. Inc., makes two sizes of box springs: queen and king. The direct material for the queen is $35 per unit and $55 is used in direct labor, while the direct material for the king is $55 per unit, and the labor cost is $70 per unit. Box Springs estimates it will make 4,300 queens and 3,000 kings in the next year. It estimates the overhead for each cost pool and cost driver activities as follows: How much does each unit cost to manufacture?
Eclipse Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential motor, through two production departments, Assembly and Testing. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering using the multiple production department factory overhead rate method. The following factory overhead was budgeted for Eclipse: Direct machine hours were estimated as follows: In addition, the direct machine hours (dmh) used to produce a unit of each product in each department were determined from engineering records, as follows: a. Determine the per-unit factory overhead allocated to the commercial and residential motors under the single plantwide factory overhead rate method, using direct machine hours as the allocation base. b. Determine the per-unit factory overhead allocated to the commercial and residential motors under the multiple production department factory overhead rate method, using direct machine hours as the allocation base for each department. c. Recommend to management a product costing approach, based on your analyses in (a) and (b). Support your recommendation.
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
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?
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)
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?
Box Springs, Inc., makes two sizes of box springs: twin and double. The direct material for the twin is $25 per unit and $40 s used in direct labor, while the direct material for the double is $40 per unit, and the labor cost is $50 per unit. Box Springs estimates it will make 5,000 twins and 9,000 doubles in the next year. It estimates the overhead for each cost pool and cost driver activities as follows: How much does each unit cost to manufacture?
Patterson Company produces wafers for integrated circuits. Data for the most recent year are provided: aCalculated using number of dies as the single unit-level driver. bCalculated by multiplying the consumption ratio of each product by the cost of each activity. Required: 1. Using the five most expensive activities, calculate the overhead cost assigned to each product. Assume that the costs of the other activities are assigned in proportion to the cost of the five activities. 2. Calculate the error relative to the fully specified ABC product cost and comment on the outcome. 3. What if activities 1, 2, 5, and 8 each had a cost of 650,000 and the remaining activities had a cost of 50,000? Calculate the cost assigned to Wafer A by a fully specified ABC system and then by an approximately relevant ABC approach. Comment on the implications for the approximately relevant approach.
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.