Ex_7-41

xlsx

School

Brock University *

*We aren’t endorsed by this school

Course

5P06

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

10

Uploaded by DeaconDugongMaster1026

Report
Ex 7-4 Data Section Data from Ex 7-3 Overhead costs to be assigned using ABC: Indirect factory salaries $ 520,000 Delivery crew wages expense $ 140,000 delivery vehicle operating expenses and depreciation $ 95,000 $ 103,000 office expenses $ 25,000 other administrative expenses $ 225,000 Indirect factory salaries 50% 25% Delivery crew wages expense 0% 75% delivery vehicle operating expenses and depreciation 0% 80% 10% 10% office expenses 15% 15% other administrative expenses 15% 5% Data from Ex 7-4 Cost pools and activity units Activity Total activity Quality control & Inspection 4,800 units produced Delivery & Installation 1,200 deliveries procurement and order processing salaries and expenses Distribution of resource consumption across the activity cost pools Quality control & Inspection Delivery & Installation procurement and order processing salaries and expenses
Order processing 920 orders processed Other - Activity data for the leather recliner product line Activity Total activity Quality control & Inspection 1,200 units produced Delivery & Installation 300 deliveries Order processing 230 orders processed
Other 20% 5% 10% 15% 10% 10% 65% 15% 35% 35% 40% 40% Order processing
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
Ex 7-4 Computations Total of overhead costs to be assigned using ABC: Indirect factory salaries $ 520,000 Delivery crew wages expense $ 140,000 delivery vehicle operating expenses and depre $ 95,000 procurement and order processing salaries a $ 103,000 office expenses $ 25,000 other administrative expenses $ 225,000 Total $ 1,108,000
Distribution of resource consumption across the activity cost pools:totals Other Indirect factory salaries 50% 25% 20% 5% Delivery crew wages expense 0% 75% 10% 15% delivery vehicle operating expenses and depreciatio 0% 80% 10% 10% procurement and order processing salaries and exp 10% 10% 65% 15% office expenses 15% 15% 35% 35% other administrative expenses 15% 5% 40% 40% Quality control & Inspection Delivery & Installatio n Order processing
Total 100% 100% 100% 100% 100% 100%
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
Ex 7-4 Part 1 First stage allocation of costs to activity pools: Indirect factory salaries $ 260,000 $ 130,000 Delivery crew wages expense $ - $ 105,000 delivery vehicle operating expenses and depreciation $ - $ 76,000 procurement and order processing salaries and expenses $ 10,300 $ 10,300 office expenses $ 3,750 $ 3,750 other administrative expenses $ 33,750 $ 11,250 Totals $ 307,800 $ 336,300 Activity rates for the ABC system: Activity cost pool Total cost Total activity Quality control & Inspection $ 307,800 4,800 Delivery & Installation $ 336,300 1,200 Order processing $ 293,200 920 Quality control & Inspection Delivery & Installation
Order processing Other Totals $ 104,000 $ 26,000 $ 520,000 $ 14,000 $ 21,000 $ 140,000 $ 9,500 $ 9,500 $ 95,000 $ 66,950 $ 15,450 $ 103,000 $ 8,750 $ 8,750 $ 25,000 $ 90,000 $ 90,000 $ 225,000 $ 293,200 $ 170,700 $ 1,108,000 Activity Rate units produced $ 64.13 per unit deliveries $ 280.25 per delivery orders processed $ 318.70 per order
Ex 7-4 Part 2 Total overhead cost assigned to the leather recliner product line: Activity cost pool Activity Rate Activity units Quality control & Inspection $ 64.13 per unit 1,200 Delivery & Installation $ 280.25 per delivery 300 Order processing $ 318.70 per order 230 Total overhead cost $ 663.07
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
ABC cost units produced $ 76,950.00 deliveries $ 84,075.00 orders processed $ 73,300.00 $ 234,325.00