prepare cash collections for each month and first quarter

Smith Corporation has found that 80% of its sales in any given month are credit sales, while the remainder are cash sales of the credit sales, Smith Corporation has experienced the following collection pattom 25% received in the month of the sale 50% received in the month after the sale 16% colved two months after the sale 9% of the credit sales are never received November les for last year were 590,000, while Dembels were 125,000. Projectes for the next three months are folos January sales $ 150.000 February $135.000 March sales $185.000 Requirement Prepare a cash collections budget for the fruit quarter, wth a column for each month and for the quartier Round your answers to the nearest Wholedo Smith Corporation Cash Collections Budget For the Month of January through March January Cash salos Collections on credit salos 25% Month of sale 50% Month after 16% Two months after Totalcanh collections