ABC Limited is preparing its departmental budgets and product cost estimates for the year ending 31 December 20X1. The company has three manufacturing departments Machining, Assembly and Finishing together with a production maintenance department.

The following costs and related data have been estimated for the year to 31 December 20X1:

Costs	Machining	Assembly	Finishing	Maintenance	Total
Direct wages	60	32	72	30	194
Indirect wages	10	6	8	-	24
Direct materials	80	10	4	-	94
Indirect materials	15	4	8	20	47
Power	-	-	-	-	102
Light and heat	-	-	-	-	10
Depreciation	-	-	-	-	7
Rent and rates	-	-	-	-	25
Personnel	-	-	-	-	63
Other data:
Direct labour hours	12 000	8 000	15 000	6 000	42 000
Machine hours	40 000	5 000	6 000	-	51 000
Employees	6	4	8	3	21
Floor area (m2)	1 000	400	300	300	2 000
Net book value of fixed assets	2 000	8 000	3 000	4 000	35 000

The maintenance department is expected to spend 60% of its time working for the machining department, with the remainder of its time being shared equally between assembly and finishing.

1. Prepare an overhead analysis sheet for ABC Limited for its year ending 31 December 20X1.

2. Calculate appropriate overhead absorption rates for the machining, assembly and finishing departments.

3. Briefly discuss why the need for the reallocation of the service department

4. Prepare a cost estimate, based on the following data, for a product which is to be manufactured in January 20X1:

	Machining	Assembly	Finishing
Direct materials ()	2500	400	250
Direct labour hours	800	350	140
Machine hours	1400	100	80