Show work for January, February, March, and the Quarter

Alderman Corporation has found that 70% of its sales in any given November sales for last year were $80,000, while December sales month are credit sales, while the remainder are cash sales. Of the credit were $110,000. Projected sales for the next three months are as sales, Alderman Corporation has experienced the following collection follows: pattern: January sales....... ......... $ 160,000 20% received in the month of the sale February sales ............... $ 115,000 40% received in the month after the sale March sales ................. $ 170,000 22% received two months after the sale Requirement 18% of the credit sales are never received Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter. (Round your answers to the nearest whole dollar.) Alderman Corporation Cash Collections Budget For the Months of January through March January Cash sales Collections on credit sales: 20% Month of sale 40% Month after 22% Two months after Total cash collections