I-CAN Company makes three products: Jump, Slow, and Speed. The company presently applies overhead using a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
I-CAN Company makes three products: Jump, Slow, and Speed. The company presently applies overhead using a predetermined rate based on direct-labour hours. The CFO of the company recommended that I-CAN switch to activity-based costing (ABC) and identified the following activities, cost drivers, estimated costs, and estimated cost-driver units for 2023 for each activity center. Table 1:1 Activity Order processing Production setup Material handling Equipment depreciation and maintenance Quality management Product Testing Indirect Labor Shipping Recommended Cost-Driver Base Number of orders Number of production runs Number of pounds of material Number of machine hours Number of inspections Number of tests Number of Hours Number of units shipped Administrative Expenses Number of units produced Number of units produced. Direct material costs... Direct-labour hours.. Number of orders. Number of production runs. Number of pounds of material.. Number of machine hours... Number of inspections... Product Testing..... Indirect Labor (Secretary, Driver, etc...)..... Estimated Costs Number of units shipped.. Direct-labour costs were $18 per hour. $600,000 300,000 80,000 In addition, management estimated 10,000 direct-labour hours (DLH) for 2023. Assume that the following activities occurred in February of 2023: Table 2: 200,000 90,000 40,000 30,000 300,000 5.000 Jump 2,200 $30,000 2000 10 7 400 800 1 1000 700 Estimated Cost- Driver Units am 200 orders 350 runs 10,000 pounds 10,000 hours 1,000 1,000 tests 3,000 hours 20,000 units 10,000 units Slow 40 inspections 1000 $50,000 4000 10 15 300 500 1 500 800 400 Speed 1.500 $35,000 3000 5 20 300 400 1 300 1000 300 A. (1) Compute a predetermined overhead rate for 2023 for each cost driver recommended by the CFO. (2) Also compute a predetermined overhead rate using direct-labour hours as the allocation base. (11 points) B. Compute the production costs for each product for February using direct-labour hours as the allocation base and the predetermined rate computed in requirement (a.2). (15 points) C. Compute the production costs for each product for February using the cost drivers recommended by the CFO and the predetermined rates computed in requirement (a.1). (Note: Do not assume that total overhead applied to products in February will be the same for activity-based costing as it was for the labour-hour-based allocation.) (15 points) D. Management has seen your numbers and wants to know how you account for the discrepancy between the product costs using direct-labour hours as the allocation base and the product costs using activity-based costing. Write a brief response to management. (4 points) E. The company marks its products by 20%. Calculate the price for each product using both methods, traditional and ABC. Comment on the difference in prices. (3 points) F. Calculate the Net Operating Income (NOI) for each product under both traditional and ABC allocation methods. You must present NOI using the contribution margin income statement (18 points) and Traditional Income Statement Formats (18 points). G. Do both statements produce the same NOI for each product? What is the focus of each income statement? Which one would be recommended for Internal decision making? Are they both allowed under Generally Accepted Accounting Principle? (4 points) H. For 2024, 1-CAN is planning to ship 1,500 units of Jump, 800 units of Slow, and 500 units of Speed. The company expects an increase in product selling prices by 15% in response to an increase in costs by 10% in 2024. Based on this information, reproduce "Required A, B and C" assuming an estimated 10,500 DLH in 2024. (9 points, 15 points, 15 points, respectively). 1 J. For 2024, calculate the Budgeted Net Operating Income using the contribution margin and traditional income statement formats for each product and under both (traditional (18 points) and CM (18 points) methods as in F. Based on your answers in G, which product is more profitable? Why? And, is it a good strategy to increase the selling price in 2024? (7 points) The End. I-CAN Company makes three products: Jump, Slow, and Speed. The company presently applies overhead using a predetermined rate based on direct-labour hours. The CFO of the company recommended that I-CAN switch to activity-based costing (ABC) and identified the following activities, cost drivers, estimated costs, and estimated cost-driver units for 2023 for each activity center. Table 1:1 Activity Order processing Production setup Material handling Equipment depreciation and maintenance Quality management Product Testing Indirect Labor Shipping Recommended Cost-Driver Base Number of orders Number of production runs Number of pounds of material Number of machine hours Number of inspections Number of tests Number of Hours Number of units shipped Administrative Expenses Number of units produced Number of units produced. Direct material costs... Direct-labour hours.. Number of orders. Number of production runs. Number of pounds of material.. Number of machine hours... Number of inspections... Product Testing..... Indirect Labor (Secretary, Driver, etc...)..... Estimated Costs Number of units shipped.. Direct-labour costs were $18 per hour. $600,000 300,000 80,000 In addition, management estimated 10,000 direct-labour hours (DLH) for 2023. Assume that the following activities occurred in February of 2023: Table 2: 200,000 90,000 40,000 30,000 300,000 5.000 Jump 2,200 $30,000 2000 10 7 400 800 1 1000 700 Estimated Cost- Driver Units am 200 orders 350 runs 10,000 pounds 10,000 hours 1,000 1,000 tests 3,000 hours 20,000 units 10,000 units Slow 40 inspections 1000 $50,000 4000 10 15 300 500 1 500 800 400 Speed 1.500 $35,000 3000 5 20 300 400 1 300 1000 300 A. (1) Compute a predetermined overhead rate for 2023 for each cost driver recommended by the CFO. (2) Also compute a predetermined overhead rate using direct-labour hours as the allocation base. (11 points) B. Compute the production costs for each product for February using direct-labour hours as the allocation base and the predetermined rate computed in requirement (a.2). (15 points) C. Compute the production costs for each product for February using the cost drivers recommended by the CFO and the predetermined rates computed in requirement (a.1). (Note: Do not assume that total overhead applied to products in February will be the same for activity-based costing as it was for the labour-hour-based allocation.) (15 points) D. Management has seen your numbers and wants to know how you account for the discrepancy between the product costs using direct-labour hours as the allocation base and the product costs using activity-based costing. Write a brief response to management. (4 points) E. The company marks its products by 20%. Calculate the price for each product using both methods, traditional and ABC. Comment on the difference in prices. (3 points) F. Calculate the Net Operating Income (NOI) for each product under both traditional and ABC allocation methods. You must present NOI using the contribution margin income statement (18 points) and Traditional Income Statement Formats (18 points). G. Do both statements produce the same NOI for each product? What is the focus of each income statement? Which one would be recommended for Internal decision making? Are they both allowed under Generally Accepted Accounting Principle? (4 points) H. For 2024, 1-CAN is planning to ship 1,500 units of Jump, 800 units of Slow, and 500 units of Speed. The company expects an increase in product selling prices by 15% in response to an increase in costs by 10% in 2024. Based on this information, reproduce "Required A, B and C" assuming an estimated 10,500 DLH in 2024. (9 points, 15 points, 15 points, respectively). 1 J. For 2024, calculate the Budgeted Net Operating Income using the contribution margin and traditional income statement formats for each product and under both (traditional (18 points) and CM (18 points) methods as in F. Based on your answers in G, which product is more profitable? Why? And, is it a good strategy to increase the selling price in 2024? (7 points) The End.
Expert Answer:
Answer rating: 100% (QA)
Answer 1 General guidance The answer provided below has been developed in a clear step by step manner 2 Step By Step Step 1 Solution As per given data Requirement A Computation of predetermined overhe... View the full answer
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0077398194
3rd Edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these accounting questions
-
A plantwide predetermined overhead rate based on direct labor-hours results in low overhead costs for products with a high direct labor-hour content and high overhead costs for products with a low...
-
Jameson Corporation uses a predetermined overhead rate based on direct labor-hours to apply manufacturing overhead to jobs. The Corporation has provided the following estimated costs for the next...
-
Walker Company makes three products in its factory: plastic cups, plastic tablecloths, and plastic bottles. The expected overhead costs for the next fiscal year include the following. Walker uses...
-
I am learning intermediate accounting and how to account for leases. I have a question about the calculation of present value for the right to use of the lease. my example specifically has a...
-
Retailers often use psychological pricing as a price-adjustment strategy. Explain this pricing strategy. How do reference prices affect psychological pricing decisions?
-
A particle is moving with the given data. Find the position of the particle. v(t) t 2 - 3 t, s(4) = 8
-
Environment regulations require investments in end-of-pipe technology to clean up pollutants: Explain whether you agree with this statement. Does this mean that a company should not undertake an...
-
Comparative data from the balance sheet of BlackBerry Limited are shown below. Instructions (a) Using horizontal analysis, calculate the percentage change between 2014 and 2015. (b) Using vertical...
-
Your company makes and sells shaving cream. You're thinking of replacing one of your packaging machines. Both the new and the old machine would last another 5 years. Your annual sales will remain...
-
(a) A homogeneous solid body of arbitrary shape is initially at temperature T, throughout. At t = 0 it is immersed in a fluid medium of temperature T. Let L be a characteristic length in the solid....
-
ABC Company had sales of 2,000 this year and ended up with A R 200 A P 220 INV 140 and bank loan 200. What is the change in the amount of each item if sales are projected to increase to 3,000 next...
-
Using one of the queries you created in BITS from previous assignments, create a report. You will need to use a different font, include a logo; ensure that your report "looks good" (using appropriate...
-
What happens when the following C++ processes? int pay = 15; if(pay > 15 && pay < 3) { cout < < "Hi"; } Nothing will display The pay rate will be updated A compiler error will occur The word Hi will...
-
Differentiate between a Sensitivity Analysis, Scenario Analysis, and Monte Carlo Simulation. Also, what type of risk do these techniques measure?
-
Will cyber espionage become the primary intelligence collection INT of the future using hybrid HUMINT-SIGINT collection techniques, or be considered a modification of traditional SIGINT collection?
-
Magenta Corporation has 1,000 shares of stock outstanding. Julie owns 400 of these shares, and unrelated individuals own the remaining 600 shares. Magenta redeems 100 of Julie's shares for $200,000....
-
Azure Retail Corporation is a U.S.-based parent company with an Italian subsidiary, Omega Solutions. Omega's records are maintained in its local currency. However, Azure's CFO believes that its...
-
Consider a closed, rigid tank with a volume of 0.8L, filled with cold water initially at 27C. The tank is filled such that there are no voids (air pockets) within. The initial pressure within the...
-
Assume that you have been asked to paint the inside walls of an apartment. State specifically how you would estimate the cost of that job. Include payment for your own labor.
-
There is no reason to investigate favorable variances; only unfavorable variances indicate problems. Do you agree?
-
On what three main factors does the theory of constraints focus?
-
What is the most common reason for closing or terminating a project? A. addition B. integration C. extinction D. starvation
-
Perform the closing tasks for one of the case studies provided in Appendix C. If you are working on a real team project, create relevant closing documents, such as a final project report and...
-
Find an article or video that provides a good example of closing a project. See the What Went Right? passage for ideas, but find your own unique example. Document your findings in a one-page paper,...
Study smarter with the SolutionInn App