Booklet 3 Job Costing Solutions.xls - 2.69

Back to sheets

Overhead Absorption Rate Unnamed: 1 Unnamed: 2 Unnamed: 3
Department X Total Overhead
Total Direct Machine Hours
26000
8000
3.25
Department Y Total Overhead
Total Direct Labour Hours
37500
25000
1.5
Angus Carpenters Plc
Job Costing Statement - Job No 55
£ £
Direct Materials
Dept X (50 m @ £18.00) 900
Dept X (45m @ £4.10) 184.49999999999997
Dept Y (20m @ £1.20) 24 1108.5
Direct Labour
Dept X (10 hrs x £14.20) 142
Dept X (6 hrs x £16.00) 96
Dept Y (20 hrs x £13.40) 268 506
Direct Expenses 24
PRIME COST 1638.5
Overheads
Dept X (12 hrs x £3.25) 39
Dept Y (20 hrs x £1.50) 30 69
TOTAL COST 1707.5
Profit (40% Profit Margin) 1138.333333333333
SELLING PRICE OF JOB NO 55 2845.833333333333