Answer sheet Consumable material Saff costs Rent and rates Content insurance Heating & lighting I Depreciation M Total Secondary allocation Q U V OVERHEADS RATE Department Amount Applied overheads Over/ under applied overheads Residential 1400 1600 A E Catering 2 300 1300 B F N R W Z BB DD FF Housekeeping 2 700 1 100 G K 0 S X Maintenance Total 900 7300 500 4 500 4 440 1680 2160 4 440 24 520 D H L 0 T Y AA EE GG The Vaal Residence hotel is developing a cost accounting system. Initially it has been decided to create four cost centres: Residential and Catering deals directly with customers, Housekeeping and Maintenance are internal service cost centres. The following overheads details have been estimated for the next period: Total Residential 1400 Catering 2300 | Housekeeping| Maintenance 2700 900 Consumable 7 300 material Saff costs 1600 1300 1100 500 4 500 Rent and rates 4 440 1680 Content insurance 2 160 Heating & lighting Depreciation 4440 24 520 Total The following information is also available Residential Total Catering 1620 Maintenance 360 3 300 Housekeeping 720 90 000 Area (m) Value of equipment 6 000 420 000 300 000 90 000 900 000 24 24 18 6 72 Number of employees In the period it is estimated that there will be 2 800 guest-nights and 16 000 meals will be served. Housekeeping works 70% for residential and 30% for Catering, and Maintenance works 20% for housekeeping, 30% for Catering and 50% for Residential. Required: 1. Prepare overheads statement showing clearly allocations and apportionments to each department. 2. Calculate appropriate overheads absorption rate for Residential and Catering. 3. Calculate the under or over-absorption overheads if actual results were as follows: a. Residential: 3 050 guest nights with overheads of R13 200 b. Catering: 15 250 meals with overheads of R9 800. NB: Round off cost per unit to two decimals and total amounts to the nearest value