The owner of a construction supply company has requested a cash budget for April. After examining the records of the company, you find the following: - Cash balance on Am. 1 is $1,000. - Actual sales for February and March are as follows: - Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. - Inventory purchases average 60% of a month's total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. - Salaries and wages total $11,750 per month, including a $4,500 salary paid to the owner. - Rent is $4,000; depreciation is $2,000 per month. - Taxes to be paid in April are $6,000. The owner also expects cash sales of $18,000 and eredit sales of $54,000 for April. No minimum cash balance is required. The owner of the company doesn't have access to short-term loans. Required:Data 1. Prepare a schedule for cash collection in April