A company has three production departments A, B, and C and one service department D. Planned...

A company has three production departments A, B, and C and one service department D. Planned overhead costs for the quarter are as follows:

Overheads	£	Absorption basis
Quality Control	3000	Direct Labour Hours
Depreciation	3750	Machine value
Insurance	1250	Machine value
Rates and Rent	7500	Floor area
Utility bills	625	Floor area

The following information is available for each department:

Absorption basis	A	B	C	D
Machine Value (£)	5000	2500	3500	1500
Budgeted Direct Labour hours	1000	500	1500	1000
Floor Area Occupied (Square metres)	1500	400	500	100

Of the total overhead costs allocated to service department D, 25% is charged to A; 30% to B; and the remainder is charged to C.

Required:

Prepare an overhead analysis sheet showing the total overhead cost budgeted for all four departments. You must show all your workings clearly.

Allocate the services department D costs to all production departments.

(Total 40 marks)

Expert Solution

					Amount $
a.)	Overheads	A	B	C	D	Total
	Quality Control	750	375	1,125	750	3,000
	Depreciation	1,500	750	1,050	450	3,750
	Insurance	500	250	350	150	1,250
	Rates and Rent	4,500	1,200	1,500	300	7,500
	Utility bills	375	100	125	25	625
	Total	7,625	2,675	4,150	1,675

	Working
	Overheads	A	B	C	D
	Quality Control	=3000*1000/4000	=3000*500/4000	=3000*1500/4000	=3000*1000/4000
	Depreciation	=3750*5000/12500	=3750*2500/12500	=3750*3500/12500	=3750*1500/12500
	Insurance	=1250*5000/12500	=1250*2500/12500	=1250*3500/12500	=1250*1500/12500
	Rates and Rent	=7500*1500/2500	=7500*400/2500	=7500*500/2500	=7500*100/2500
	Utility bills	=625*1500/2500	=625*400/2500	=625*500/2500	=625*100/2500
	Total	7,625	2,675	4,150	1,675



b.)	Service Department D	Allocation
		Amount $
	A	419	(1,675 x 25% )
	B	502	(1,675 x 30% )
	C	754	(1,675 x 45% )
	Total	1,675

ekkarill92 answered 2 years ago

Company XYZ Sdn Bhd has two production departments; Department A and Department B.

Company XYZ Sdn Bhd has two production departments; Department A and Department B. The company uses the basis direct labor hour to determine predetermine overhead rate. A total of 3 500 units were produced on Job 3113.The following information relates to both departments for the year 2019:Department ADepartment BBudgeted manufacturing overheadRM 500 000RM 250 000Budgeted direct labor hours32 00025 500Budgeted machine hours3 00018 000The company shows the following information relates to Job 3113:Materials requisitioned RM 20 000Direct labor cost RM...

Matt limited has two production, departments, machine department and assembly department. There are two service departments,...

Matt limited has two production, departments, machine department and assembly department. There are two service departments, stores and maintenance. The budgeted overheads of each department along with overheads that have yet to be apportioned are listed below, along with details which can be used for appointment. Total Machine Dept Assembly Dept Stores Maintenance K’000 K’000 K’000 K’000 K’000 Indirect labour 1 125 000 400 000 650 000 40 000 35 000 Indirect material 310 000 160 000 120 000 10...

Brownley Company has two service departments and two operating (production) departments. The Payroll Department services all...

Brownley Company has two service departments and two operating (production) departments. The Payroll Department services all three of the other departments in proportion to the number of employees in each. The Maintenance Department costs are allocated to the two operating departments in proportion to the floor space used by each. Listed below are the operating data for the current period: Service Depts. Production Depts. Payroll Maintenance Milling Assembly Direct costs $ 24,200 $ 35,000 $ 95,500 $ 143,400 No. of...

1. Brownley Company has two service departments and two operating (production) departments. The Payroll Department services...

1. Brownley Company has two service departments and two operating (production) departments. The Payroll Department services all three of the other departments in proportion to the number of employees in each. The Maintenance Department costs are allocated to the two operating departments in proportion to the floor space used by each. Listed below are the operating data for the current period: Service Depts. Production Depts. Payroll Maintenance Cutting Assembly Direct costs $ 32,400 $ 37,500 $ 88,500 $ 117,400 No....

Motorcade Company has three service departments (S1, S2, and S3) and two production departments (P1 and...

Motorcade Company has three service departments (S1, S2, and S3) and two production departments (P1 and P2). The following data relate to Motorcade's allocation of service department costs: Round to two decimal places. Budgeted Costs Nbr of Employees S1 $3,120,000 75 S2 2,060,000 50 S3 1,000,000 25 P1 150 P2 225 Service department costs are allocated by the direct method. The number of employees is used as the allocation base for all service department costs Calculate the total service department...

Bens Corporation has three service departments (Repairs, HR, and IT) and two production departments (M1 and...

Bens Corporation has three service departments (Repairs, HR, and IT) and two production departments (M1 and M2). The following usage data for each of the service departments for the previous period follow. Repairs HR IT M1 M2 Repairs — 0 % 0 % 40 % 60 % HR 10 % — 20 % 35 % 35 % IT 0 % 10 % — 20 % 70 % The direct costs of the service departments in the previous period were $24,000...

Warren Ltd. has two production departments, Building A and Building B, and two service departments, Maintenance...

Warren Ltd. has two production departments, Building A and Building B, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of June follow: Proportion of Services Used by Department Direct Costs Maintenance Cafeteria Building A Building B Building A $ 480,000 Building B 327,000 Maintenance 182,000 — 0.1 0.7 0.2 Cafeteria 178,000 0.7 — 0.2 0.1 Required: (a) Use the step method...

Question 2 Alexia Muchala Ltd has two production departments, A and B, and two service departments,...

Question 2 Alexia Muchala Ltd has two production departments, A and B, and two service departments, X and Y. The budgeted activity levels for June 2020 were thus: A 2000 hours N$ 80,000 B 12,000 hours N$ 48,000 The service departments are apportioned thus: X 70% to A 20% to B 10% to Y Y 50% to A 30% to B 20% to X During June 2020 the actual results were: A 2100 hours N$ 60,000 B 11,500 hours N$...

ABC Corporation has three service departments with the following costs and activity base: Service Department Cost...

ABC Corporation has three service departments with the following costs and activity base: Service Department Cost Activity Base for Allocation Graphics Production $200,000 # of copies Accounting $500,000 # of invoices processed Personnel Department $400,000 # of employees ABC has three operating divisions, Micro, Macro and Super. Their revenue, cost and activity information for December 31, 2017 are as follows: Micro Macro Super Direct Revenues $700,000 $850,000 $650,000 Direct Operating Expenses $50,000 $70,000 $100,000 # of copies made 20,000 30,000...

Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...

Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 40 % 0 15 % 45 % Administration 20 % 0 25 % 45 % 10 % Maintenance 0 30 % 0 15 % 55 % Direct cost $ 42,000 $ 248,550 $ 45,000 $ 230,000 $ 80,000 Required: Allocate...

Question