In this question, you will use the information provided to calculate the cash budget components for a company, Aviation Excellence, which provides engineering consultation services to airports.

The company gets 60% of their revenue in the form of cash, and collect the remaining balance as credit as follows:

• 70% in the month directly after the sale
• 20% in the second month after the sale
• 10% is written off as bad debt

The table below shows the expected revenue that Aviation Excellence may collect from June to October. Using the information provided, complete the table below by calculating the amounts for the components marked with an asterisk. Show your calculation and the answer.

	June	July	August	September	October
Revenue	500,000	500,000	650,000	800,000	900,000
Cash receipt	*	*	*	*	*
Debtor collection (June)		*	*
Debtor collection (July)			*	*
Debtor collection (August)				*	*
Debtor collection (September)					*
TOTAL CASH FROM SALES	*	*	*	*	*