Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help, I dont understand what to do with the numbers. My textbook doesnt go into depth on how to even use excel dor this.

Please help, I dont understand what to do with the numbers. My textbook doesnt go into depth on how to even use excel dor this.

image text in transcribedimage text in transcribed EXERCISE \#1 (worth 4 points): : Mordica Company identifies three activities in its manufacturing process: machine setups, machining, and inspections. Estimated annual overhead cost for each activity is $250,000, $300,000, and $90,000, respectively. The cost driver for each activity and the expected annual usage are number of setups 2,500, machine hours 25,000 , and number of inspections 1,500 . Instructions Please use an Excel spreadsheet to compute the overhead rate for each activity and upload it into Canvas. Clearly mark each activity's answer. EXERCISE \#2 (worth 7 points): Schultz Electronics manufactures two large-screen television models: the Royale which sells for $1,600, and a new model, the Majestic, which sells for $1,300. The production cost computed per unit under traditional costing for each model in 2022 was as follows. Assign overhead to products using ABC and evaluate decision. In 2022, Schultz manufactured 25,000 units of the Royale and 10,000 units of the Majestic. The overhead rate of $38 per direct labor hour was determined by dividing total expected manufacturing overhead of $7,600,000 by the total direct labor hours (200,000) for the two models. Under traditional costing, the gross profit on the models was Royale $542 or ($1,600$1,058), and Majestic $580 or ($1,300$720). Because of this difference, management is considering phasing out the Royale model and increasing the production of the Majestic model. Before finalizing its decision, management asks Schultz's controller to prepare an analysis using activity-based costing (ABC). The controller accumulates the following information about overhead for the year ended December 31, 2021. In 2022 , Schultz manufactured 25,000 units of the Royale and 10,000 units of the Majestic. The overhead rate of $38 per direct labor hour was determined by dividing total expected manufacturing overhead of $7,600,000 by the total direct labor hours (200,000) for the two models. Under traditional costing, the gross profit on the models was Royale $542 or ($1,600$1,058), and Majestic $580 or ($1,300$720). Because of this difference, management is considering phasing out the Royale model and increasing the production of the Majestic model. Before finalizing its decision, management asks Schultz's controller to prepare an analysis using activity-based costing (ABC). The controller accumulates the following information about overhead for the year ended December 31, 2021. The cost drivers used for each product were: Instructions Please use an Excel spreadsheet for your answers, clearly marking the answers to each requirement (a) - (c) and upload into Canvas a. Assign the total 2022 manufacturing overhead costs to the two products using activity-based costing (ABC) and determine the overhead cost per unit. b. What was the total cost per unit (DM+DL+ estimated OH ) and gross profit of each model using ABC ? c. Are management's future plans for the two models sound? Explain

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Accounting Concepts Principles And Procedures Volume 2

Authors: Gregory Mostyn, Worthy And James

2nd Edition

0991423119, 9780991423118

More Books

Students also viewed these Accounting questions

Question

=+ Interviews with key people. Which people?

Answered: 1 week ago

Question

=+ Judgmental assessment: personal experience or outside experts?

Answered: 1 week ago

Question

=+ On what criteria should the program be judged? 9

Answered: 1 week ago