XYZ Electronics manufactures two large-screen smart television models: the Elite which sells for OMR 160 and a new model, the Superior, which sells for OMR 130. Annual production is 2000 units for the Elite and 8000 units for the Superior. The company's managers identified five activity cost pools and related cost drivers and accumulated overhead by cost pool as follows. Cost Driver Estimated Overhead Cost Expected Use of Cost Driver Per Television Activity Expected Use of Cost Drivers Elite Superior 1 Material handling Machine setups Quality inspections Quality control |Number of requisitions 135,000 OMR 127,500 OMR |Number of inspections 127,000 OMR |Number of inspections 189,500 OMR Supervising production Number of supervisors 120,000 OMR 3 Number of setups 2 3 10 6 4 18 12 6. 19000 9,000 10,000 Requirements: 1. Prepare a schedule showing the computations of the activity-based overhead rates per cost driver. 2. Prepare a schedule assigning each activity's overhead cost to the two products.

XYZ Electronics manufactures two large-screen smart television models: the Elite which sells for OMR 160 and a new model, the Superior, which sells for OMR 130. Annual production is 2000 units for the Elite and 8000 units for the Superior. The company's managers identified five activity cost pools and related cost drivers and accumulated overhead by cost pool as follows. Cost Driver Estimated Overhead Cost Expected Use of Cost Driver Per Television Activity Expected Use of Cost Drivers Elite Superior 1 Material handling Machine setups Quality inspections Quality control |Number of requisitions 135,000 OMR 127,500 OMR |Number of inspections 127,000 OMR |Number of inspections 189,500 OMR Supervising production Number of supervisors 120,000 OMR 3 Number of setups 2 3 10 6 4 18 12 6. 19000 9,000 10,000 Requirements: 1. Prepare a schedule showing the computations of the activity-based overhead rates per cost driver. 2. Prepare a schedule assigning each activity's overhead cost to the two products.

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?
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: Required: 1. Calculate the global consumption ratios for the two products. 2. Using the activity consumption ratios for number of orders and number of setups, show that the same cost assignment can be achieved using these two drivers as that of the complete, four-driver ABC system.
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.
Cicleta Manufacturing has four activities: receiving materials, assembly, expediting products, and storing goods. Receiving and assembly are necessary activities; expediting and storing goods are unnecessary. The following data pertain to the four activities for the year ending 20x1 (actual price per unit of the activity driver is assumed to be equal to the standard price): Required: 1. Prepare a cost report for the year ending 20x1 that shows value-added costs, non-value-added costs, and total costs for each activity. 2. Explain why expediting products and storing goods are non-value-added activities. 3. What if receiving cost is a step-fixed cost with each step being 1,500 orders whereas assembly cost is a variable cost? What is the implication for reducing the cost of waste for each activity?
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.
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.
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?
Sanford, Inc., has developed value-added standards for four activities: purchasing parts, receiving parts, moving parts, and setting up equipment. The activities, the activity drivers, the standard and actual quantities, and the price standards for 20x1 are as follows: The actual prices paid per unit of each activity driver were equal to the standard prices. Required: 1. Prepare a cost report that lists the value-added, non-value-added, and actual costs for each activity. 2. Which activities are non-value-added? Explain why. Also, explain why value-added activities can have non-value-added costs.
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.
Privott, Inc., manufactures and sells two products: Product Z9 and Product N0. The company is considering adopting an activity-based costing system with the following activity cost pools, activity measures, and expected activity: Estimated Expected Activity Activity Cost Pools Activity Measures Overhead Cost Product Z9 Product N0 Total Labor-related DLHs $ 327,018 6,700 3,300 10,000 Product testing tests 47,247 550 650 1,200 Order size MHs 472,608 4,300 4,600 8,900 $ 846,873 The activity rate for the Labor-Related activity cost pool under activity-based costing is closest to: Multiple Choice A. $72.69 per DLH B. $705.73 per DLH C. $85.90 per DLH D. $32.70 per DLH
Chrzan, Incorporated, manufactures and sells two products: Product EO and Product NO. Data concerning the expected production of each product and the expected total direct labor-hours (DLHs) required to produce that output appear below: Product E0 Product Ne Total direct labor-hours Activity Cost Pools Labor-related Production orders Order size The company is considering adopting an activity-based costing system with the following activity cost pools, activity measures, and expected activity: Estimated Overhead Cost Multiple Choice $33.94 per MH $54.20 per MH Direct Expected Labor-Hours Production Per Unit 10.1 410 1,550 9.1 $51.98 per MH $21.40 per MH Activity Measures DLHS orders MHs Total Direct Labor- Hours $ 301,890 61,087 585,366 $948,343 The activity rate for the Order Size activity cost pool under activity-based costing is closest to: 4,141 14, 105 18,246 Product E 4,141 850 5,550 Expected Activity Product NO 14, 105 950 5,250 Total 18,246 1,800 10,800
The pool rate is defined as the cost per unit of the cost driver for a particular activity cost pool. Group of answer choices True False Rocket Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe. The company, which uses activity-based costing, has identified five activities (and related cost drivers). Each activity, its budgeted cost, and related cost driver is identified below. Activity Cost Cost Driver Material handling $ 225,000 Number of parts Material insertion 2,475,000 Number of parts Automated machinery 840,000 Machine hours Finishing 170,000 Direct labor hours Packaging 170,000 Orders shipped Total $ 3,880,000 The following information pertains to the three product lines for next year: Economy Standard Deluxe Units to be produced 10,000 5,000 2,000 Orders to be shipped 1,000 500 200 Number of parts per unit 10 15 25 Machine…