Winslow Inc. developed the following data for the month of December.

Cash balance, December 1st		$ 61,500
Cash sales in December		300,000
Credit sales for the month of:
October		200,000
November		150,000
December		250,000
Purchases for the month of:
November		225,000
December		200,000
Other expenses in December:
Salaries		162,500
Utilities		16,500
Depreciation		50,000

70% of credit sales are collected in the month of sale, 15% in the following month, and 10% in the second month following the sale.

25% of purchases are paid in the month of purchase and the remaining 75% in the following month.

100% of other expenses are paid in the month recorded.

Required:

Prepare a cash collections and cash payment schedule as well as a cash budget for the month.

Total cash sales and collections on account for the month are $____________.

Total cash available for the month is $_______________.

Payments for purchases during the month are $______________.

Payments for other expenses during the month are $___________ .

The ending cash balance for the month is $__________________.