Please give answers in excel form. B2-B1 etc. 17 Use formulas to assign overhead to each product using both activity rates and activity proportions (%).1819 Create if/then statements to verify that the two methods produce the same results.20Note: Use cell A2 from the given information to complete this question.212223 Activity Cost Pool24 Material Handling25 Machine Set-Ups26 Engineering Support27 Power and Space28 Total Overhead Cost2930314A Graded WorlOverhead Assigned Using Activity RatesEconomyDeluxeTotal3...+Overhead Assigned Using Activity Proportions(%)DeluxeEconomyTotalVerification: Create if/then statementsto determine if the two methodsproduce identical results by indicating"pass" or "fail"Economy DeluxepasspasspasspasspasspasspasspasspasspassTotalpasspasspasspasspass 1Sundial Company has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two2 products lines, Economy and Deluxe, are shown below.3Input formulas to solve for the various unknowns in the table below. The formulas may vary for each cost pool depending on what items4 are known and unknown.+56 16789Note: Use cell A2 from the given information to complete this question.10 Activity Cost Pool11 Material Handling12 Machine Set-Ups13 Engineering Support14Power and Space15 Total overhead cost+/Assign indirect costs to products or services using activity based costing.4ActivityOverhead Cost Cost Driver5,000$ 300,000$210,000$ 710,000ActivityRateMaterial movesper moveper set-upSet-upsEngineering hours $12.50 per hour20,000 square feet.per square feetEconomyModelActivity Requirements by Product LineActivityDeluxeProportion (%) Model3,0009002,0003002,00020%50%ActivityProportion (%)

This is the question which is all about the activity based costs which have to be assigned based…

1 Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. Activity Cost Pool Material Handling Machine Set-Ups Engineering Support Power and Space Total overhead cost Activity Overhead Cost Cost Driver 5,000 $ 300,000 $ 210,000 $ 710,000 Material moves Set-ups Engineering hours 20,000 square feet. Activity Rate per move per set-up 12.50 per hour per square feet Economy Model Activity Requirements by Product Line Deluxe Activity Model Proportion (%) 2,000 300 2,000 Activity Proportion (%) 20% 50% 3,000 900

1 Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. Activity Cost Pool Material Handling Machine Set-Ups Engineering Support Power and Space Total overhead cost Activity Overhead Cost Cost Driver 5,000 $ 300,000 $ 210,000 $ 710,000 Material moves Set-ups Engineering hours 20,000 square feet. Activity Rate per move per set-up 12.50 per hour per square feet Economy Model Activity Requirements by Product Line Deluxe Activity Model Proportion (%) 2,000 300 2,000 Activity Proportion (%) 20% 50% 3,000 900

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter6: Activity-based, Variable, And Absorption Costing

Section: Chapter Questions

Problem 13EA: Tri-bikes manufactures two different levels of bicycles: the Standard and the Extreme. The total...

See similar textbooks

Similar questions

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?
Identify cost graphs The following cost graphs illustrate various types of cost behavior: For each of the following costs, identify the cost graph that best illustrates its cost behavior as the number of units produced increases. a. Direct material cost per unit. b. Fees for using a patent of $500,000 plus $0.25 for each unit produced. c. Salary of quality control supervisor. d. Straight-line depreciation per unit on factory equipment. e. Total direct materials cost.
The following product costs are available for Kellee Company on the production of eyeglass frames: direct materials, $32,125; direct labor, $23.50; manufacturing overhead, applied at 225% of direct labor cost; selling expenses, $22,225; and administrative expenses, $31,125. The direct labor hours worked for the month are 3,200 hours. A. What are the prime costs? B. What are the conversion costs? C. What is the total product cost? D. What is the total period cost? E. If 6.425 equivalent units are produced, what is the equivalent material cost per unit? F. What is the equivalent conversion cost per unit?
Cool Pool has these costs associated with production of 20,000 units of accessory products: direct materials, $70; direct labor, $110; variable manufacturing overhead, $45; total fixed manufacturing overhead, $800,000. What is the cost per unit under both the variable and absorption methods?
The following product Costs are available for Haworth Company on the production of chairs: direct materials, $15,500; direct labor, $22.000; manufacturing overhead, $16.500; selling expenses, $6,900; and administrative expenses, $15,200. What are the prime costs? What are the conversion costs? What is the total product cost? What is the total period cost? If 7,750 equivalent units are produced, what is the equivalent material cost per unit? If 22,000 equivalent units are produced, what is the equivalent conversion cost per unit?
The following product costs are available for Stellis Company on the production of erasers: direct materials, $22,000; direct labor, $35,000; manufacturing overhead, $17,500; selling expenses, $17,600; and administrative expenses; $13,400. What are the prime costs? What are the conversion costs? What is the total product cost? What is the total period cost? If 13,750 equivalent units are produced, what is the equivalent material cost per unit? If 17,500 equivalent units are produced, what is the equivalent conversion cost per unit?
Rex Industries has two products. They manufactured 12,539 units of product A and 8.254 units of product B. The data are: What is the activity rate for each cost pool?
Tri-bikes manufactures two different levels of bicycles: the Standard and the Extreme. The total overhead of $300,000 has traditionally been allocated by direct labor hours, with 150.000 hours for the Standard and 50,000 hours for the Extreme. After analyzing and assigning costs to two cost pools, it was determined that machine hours is estimated to have $200,000 of overhead, with 4,000 hours used on the Standard product and 1,000 hours used on the Extreme product. k was also estimated that the setup cost pool would have $100000 of overhead, with 1,000 hours for the Standard and 1,500 hours for the Extreme. What is the overhead rate per product, under traditional and under ABC costing?
Refer to the data given in Problem 4.36 and suppose that the expected activity costs are reported as follows (all other data remain the same): The per unit overhead cost using the 14 activity-based drivers is 1,108 and 779 for Cylinder A and Cylinder B, respectively. Required: 1. Determine the percentage of total costs represented by the three most expensive activities. 2. Allocate the costs of all other activities to the three activities identified in Requirement 1. Allocate the other activity costs to the three activities in proportion to their individual activity costs. Now assign these total costs to the products using the drivers of the three chosen activities. 3. Using the costs assigned in Requirement 2, calculate the percentage error using the ABC costs as a benchmark. Comment on the value and advantages of this ABC simplification.
Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows: During the next production period the labor-hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are 25 for product 1, 28 for product 2, and 30 for product 3. a. Formulate a linear programming model for maximizing total profit contribution. b. Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution? c. After evaluating the solution obtained in part (b), one of the production supervisors noted that production setup costs had not been taken into account. She noted that setup costs are 400 for product 1, 550 for product 2, and 600 for product 3. If the solution developed in part (b) is to be used, what is the total profit contribution after taking into account the setup costs? d. Management realized that the optimal product mix, taking setup costs into account, might be different from the one recommended in part (b). Formulate a mixed-integer linear program that takes setup costs provided in part (c) into account. Management also stated that we should not consider making more than 175 units of product 1, 150 units of product 2, or 140 units of product 3. e. Solve the mixed-integer linear program formulated in part (d). How much of each product should be produced and what is the projected total profit contribution? Compare this profit contribution to that obtained in part (c).
SmokeCity, Inc., manufactures barbeque smokers. Based on past experience, SmokeCity has found that its total annual overhead costs can be represented by the following formula: Overhead cost = 543,000 + 1.34X, where X equals number of smokers. Last year, SmokeCity produced 20,000 smokers. Actual overhead costs for the year were as expected. Required: 1. What is the driver for the overhead activity? 2. What is the total overhead cost incurred by SmokeCity last year? 3. What is the total fixed overhead cost incurred by SmokeCity last year? 4. What is the total variable overhead cost incurred by SmokeCity last year? 5. What is the overhead cost per unit produced? 6. What is the fixed overhead cost per unit? 7. What is the variable overhead cost per unit? 8. Recalculate Requirements 5, 6, and 7 for the following levels of production: (a) 19,500 units and (b) 21,600 units. (Round your answers to the nearest cent.) Explain this outcome.
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