(b)Activity-based budget for the central warehouse for YE 30 June 20X6

Answer
Comments on variance analysis
The total expected cost for receipts into goods inwards for July 20X5 was $19,825 ($30·50 budgeted cost per receipt x 650 receipts).The actual cost was $18,000 giving a favourable variance of $1,825.It cannot be identified, on the basis of the information available, the cause of the $1,825 variance, as the breakdown of the $18,000 actual cost would be required.
100,000 items were processed in July 20X5 which is the same as the budgeted amount.However, the number of receipts budgeted was 750 (9,000/12), whereas the actual number of receipts was only 650, equivalent to $27·69 ($18,000/650)per receipt.This is a favourable variance of $2·81 per receipt.
It appears that the favourable variance may be due to the receipt of larger quantities of items from suppliers in each delivery.If some of the goods inwards costs are variable with the number of items this would result in a cost saving.This could be because of the reduction in the number of suppliers, with fewer suppliers individually supplying more items.
W1 – RFID tagging
Expected volume of items received in the month = 100,000
Each member of staff can tag 35,000 items per month, so 2·86 (100/30)staff are required – say 3
Annual wages cost is 3 x $24,000 = $72,000
W2 – Warehouse staff wages
Number of staff required in budget year = 14 (12 + 2)
Total warehouse staff wages = 14 x $22,500 = $315,000
Of which $157,500 (50% of $315,000)relate to each of goods inwards and goods outwards
W3 – Heating and lighting
As inflation is zero the cost included in the budget should be $10,000.