Woh Che Co. has four departments: materials, personnel, manufacturing, and packaging. In a recent month, the...

Free

80.2K

Verified Solution

Question

Accounting

Woh Che Co. has four departments: materials, personnel,manufacturing, and packaging. In a recent month, the fourdepartments incurred three shared indirect expenses. The amounts ofthese indirect expenses and the bases used to allocate themfollow.

Indirect ExpenseCostAllocation Base
Supervision$82,500Number ofemployees
Utilities50,000Square feet occupied
Insurance22,500Value of assets in use
Total$155,000


Departmental data for the company’s recent reporting periodfollow.

DepartmentEmployeesSquare FeetAsset Values
Materials2725,000$6,000
Personnel95,0001,200
Manufacturing6355,00037,800
Packaging5115,00015,000
Total150100,000$60,000


1. Use this information to allocate each of thethree indirect expenses across the four departments.
2. Prepare a summary table that reports theindirect expenses assigned to each of the four departments.

Supervision expensesAllocation BasePercent of Allocation BaseCost to be AllocatedAllocated Cost
DepartmentNumber of employeesNumeratorDenominator% ofTotal
Materials0
Personnel0
Manufacturing00
Packaging0
Totals0
UtilitiesAllocation BasePercent of Allocation BaseCost to be AllocatedAllocated Cost
DepartmentNumeratorDenominator% of Total
Materials0
Personnel0
Manufacturing00
Packaging0
Totals0
InsuranceAllocation BasePercent of Allocation BaseCost to be AllocatedAllocated Cost
DepartmentNumeratorDenominator% of Total
Materials0
Personnel0
Manufacturing00
Packaging0
Totals0


SupervisionUtilitiesInsuranceTotal
Materials$0
Personnel0
Manufacturing0
Packaging0
Totals$0$0$0$0

Answer & Explanation Solved by verified expert
3.6 Ratings (610 Votes)

Solution 1:

Supervision Expenses Allocation Base Percentage of allocation base Cost to be allocated Allocated cost
Numerator Denominator % of Total
Materials Number of employees 27 150 18.00% $82,500.00 $14,850.00
Personnel Number of employees 9 150 6.00% $82,500.00 $4,950.00
Manufacturing Number of employees 63 150 42.00% $82,500.00 $34,650.00
Packaging Number of employees 51 150 34.00% $82,500.00 $28,050.00
Total 100.00% $82,500.00
Utilities Allocation Base Percentage of allocation base Cost to be allocated Allocated cost
Numerator Denominator % of Total
Materials Square feet occupied 25000 100000 25.00% $50,000.00 $12,500.00
Personnel Square feet occupied 5000 100000 5.00% $50,000.00 $2,500.00
Manufacturing Square feet occupied 55000 100000 55.00% $50,000.00 $27,500.00
Packaging Square feet occupied 15000 100000 15.00% $50,000.00 $7,500.00
Total 100.00% $50,000.00
Insurance Allocation Base Percentage of allocation base Cost to be allocated Allocated cost
Numerator Denominator % of Total
Materials Value of assets in use 6000 60000 10.00% $22,500.00 $2,250.00
Personnel Value of assets in use 1200 60000 2.00% $22,500.00 $450.00
Manufacturing Value of assets in use 37800 60000 63.00% $22,500.00 $14,175.00
Packaging Value of assets in use 15000 60000 25.00% $22,500.00 $5,625.00
Total 100.00% $22,500.00

Solution 2:

Summary Report
Supervision Utilities Insurance Total
Materials $14,850.00 $12,500.00 $2,250.00 $29,600.00
Personnel $4,950.00 $2,500.00 $450.00 $7,900.00
Manufacturing $34,650.00 $27,500.00 $14,175.00 $76,325.00
Packaging $28,050.00 $7,500.00 $5,625.00 $41,175.00
Total $82,500.00 $50,000.00 $22,500.00 $155,000.00

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students