Part #4: 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.