Spendthrift Ltd provides 4 weeks (20 days) of accumulating vested annual leave for each year of service. The company policy is that annual leave must be taken within 6 months of the end of the period in which it accrues. Annual leave is paid at the base salary rate (which excludes commissions, bonuses and overtime). A 17.5% loading is applied to annual leave payments. The following summary data is derived from Spendthrift Ltds payroll records for the year ended 30 June 2020. The amounts shown are applicable at 30 June 2020. (7 marks)

Employee category	Base pay/day $	Annual leave
		Balance 1 July 2019 (days)	Accumulated during year (days)	Taken during year (days)
Managers	700	180	210	230
Sales staff	400	200	540	600
Drivers	250	150	310	360
Admin staff	220	140	230	280

Additional information

After leave taken during the year had been recorded, Spendthrift Ltds trial balance revealed that the provision for annual leave had a credit balance of $77,480 at 30 June 2020.

Required 1. Calculate the provision for annual leave at 30 June 2020 by completing the following table