Reference no: EM13912510

Cash receipts budget. Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows:

Actual:

July . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 98,000
August . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105,000

Forecast:

September . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114,000
October . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94,000
November . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122,000
December . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107,000

Based on past experience, it is estimated that 30% of a month's sales are collected in the month of sale, 55% are collected in the month following the sale, and 10% are collected in the second month following the sale.

Required:

Calculate the estimated cash receipts for September, October, and November.