Question

E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for July, and $160,000 for August. To prepare a cash budget, the company must determine the budgeted cash collections from sales. Generally the trend has been 55 percent collected in the month of sale, 25 percent collected in the month following sale, 18 percent collected in the second month following sale, and 2 percent uncollectible. Also, E Company grants a 2 percent cash discount to customers who pay in the month of sale (so they only collect 98 percent of the total amount for those sales instead of the usual 100 percent). Prepare a schedule of cash collections for the month of July only.

Answer 1

Schedule of cash collections for the month of July:

Particulars	Calculation	Amount(in $)
Cash Received for:
Sales related to May	= 170,000 * 18%	30,600
Sales related to June	= 215,000 * 25%	53,750
Sales related to July	= (240,000 * 55%) * 98%	129,360
Total cash collections for the month		213,710

Notes:

i) For sales of the month May, 55% would have been realised in "may" itself, 25% would have been realised in june and 18% would be realised in july. Therefore, 18% of sales of the month "may" are taken.

ii) For sales of the month June, 55% would have been realised in "june" itself and 25% would be realised in july.  Therefore, 25% of sales of the month "june" are taken.

iii) For sales of the month July, 55% would be realised in "july" on which a cash discount of 2% is there.Therefore, net realisation would be (sales of july * 55%) * 98%.