Hansen_4e_Ex04-22 example worked

.xlsx

School

american national university *

*We aren’t endorsed by this school

Course

ACC203

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

3

Uploaded by kagordon192648

Report
Exercise 4.22 Name: example Enter appropriate answers in the gray-shaded cells. The essay answer will not be graded. 1. Activity Rates Total Cost Activity Capacity Activity Rate Setting up equipment $126,000 ÷ 150 = $840 per setup Ordering materials $18,000 ÷ 900 = $20 per order Machining $126,000 ÷ 10,500 = $12 per machin Receiving $30,000 ÷ 1,250 = $24 per receivin Overhead Cost Assignment Activity Activity Rate × Usage Model X Model Y Setting up equipment: Model X $840 × 100 $ 84,000 Model Y $840 × 50 $ 42,000 Ordering materials: Model X $20 × 300 6,000 Model Y $20 × 600 12,000 Machining: Model X $12 × 6,000 72,000 Model Y $12 × 4,500 54,000 Receiving: Model X $24 × 375 9,000 Model Y $24 × 875 21,000 Total OH assigned $ 171,000 $ 129,000 2. New Cost Pools + = Setting up equipment $126,000 + $24,000 = $150,000 Machining $126,000 + $24,000 = $150,000 New Activity Rates Total Cost Activity Capacity Activity Rate Setting up equipment $150,000 ÷ 150 = $1,000 per setup Machining $150,000 ÷ 10,500 = $14.29 per hour Overhead Cost Assignment Model X Model Y Setting up equipment: $1,000 × 100 $ 100,000 Total Cost Proration of Least Expensive Activities New Cost Pool
$1,000 × 50 $ 50,000 Machining: $14.29 × 6,000 85,740 $14.29 × 4,500 64,305 Total $185,740 $114,305 3. Percentage Error Model X Model Y Overhead cost assignment from (1) $ 185,740 $ 114,305 Overhead cost assignment from (2) 171,000 129,000 Difference $ 14,740 $ (14,695) ÷ Overhead cost assignment from (1) 171,000 129,000 Percentage error 8.6% -11.4% [Key essay answer here]
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help