The budgeted sales for Milton Machine, Inc. are shown below:

August............................$12,000

September......................$10,000

October..........................$20,000

November...................... $15,000

December.........................$9,000

From past experience, the company has collected 20% of the cash in the month of the sale, 50% in the month after the sale, and 30% two months after the sale occurred.

Prepare a schedule of expected cash collections from sales, by month and in total for the fourth quarter of the year.