In: Accounting
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $68,000 $46,000 $77,000 Square feet occupied 2,000 3,500 3,000 Number of employees 36 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,060 $120,090 Square feet occupied 2,100 1,400 Number of employees 42 18 Maintenance hours 6,400 1,600 Direct labor hours 20,000 18,000 Machine hours 10,000 15,000 Av-Y6 Company uses the sequential method of allocation. Information on the allocation bases and activities for each department are given below. Administration department costs are allocated on the basis of square feet occupied, maintenance department costs are allocated on the basis of maintenance hours, and personnel department costs are allocated on the basis of number of employees. In the second stage, assembly department overhead costs are assigned to products based on machine hours. Calculate the pre-determined overhead rate based on machine hours used in the assembly department.
we shall first allocate cost to product department in sequence given
Admin | Main | Person | Assembly | packaging | Total allocation base | |
Direct cost | $68,000 | $46,000 | $77,000 | $167,060 | Note relevant for our question | |
Administration cost | 23,800[3500/10,000]*68000 | 20,400[3000/10000]*68000 | 14280[2100/10000]*68000 | square feet 10,000[3500+3000+2100+1400] | ||
Total Maintenace cost to be allocated | $69,800[46000+23800] | |||||
Main cost | $23267[69,800/12,000]*4000 | $37,227[69,800/12,000]*6400 | Maintenance hours 12000[4000+6,400+1,600] | |||
Total Personnel cost to be allocated | $120,667[$77,000+20,400+23,267] | |||||
Personnel cost | $84,467[$120,667/60]*42 | 60Number of employees [42+18] | ||||
Total Assembly cost | $303,034[$84,467+37,227+14,280+167,060] |
predetermine OH rate (Assembly) = Total cost/ Estimated machine hours
=$303034/10,000
=$30.30 per Machin hour
Pleas eupvote if you find this helpful.Incase of query please comment.