Bounce Athletics Ltd, which develops and runs athletics training programs for primary schools, has budgeted revenue for the first 6 months of 2017 as follows:

Month		Budgeted revenue
January February March April May June		$10000  50000  80000  25000  80000  60000

All revenue is provided on account and Bounce Athletics Ltd posts out the account statements on the last day of each month for that month’s services. Schools are given 14 days to pay and 70% of schools pay within the month. The other 30% usually pay the following month. In December 2016 Bounce Athletics Ltd provided no training programs as the schools were preparing for the end-of-year break. The company also made sure that all outstanding balances owed by schools from November were paid before the end of December 2016.

Required

Prepare a schedule of estimated cash collections from revenue for the first 6 months of 2017 for Bounce Athletics Ltd.