Current Attempt in ProgressSheffield Company's budgeted sales and direct materials purchases are as follows:Budgeted SalesBudgeted D$.$M$.$PurchasesApril$$316\mathrm{.}000$$$47,000$May$347\mathrm{.}00049\mathrm{.}000$June$403\mathrm{.}00054,000$Sheffield's sales are $40\%$ cash and $60\%$ credit. Credit sales are collected $20\%$ in the month of sale, $50\%$ in the month following sale, and $26\%$ in the second month following sale; $4\%$ are uncollectible. Sheffield's purchases are $50\%$ cash and $50\%$ on account. Purchases on account are paid $40\%$ in the month following the purchase and $60\%$ in the second month following the purchase.

$($a$)$

Prepare a schedule of expected collections from customers for April, May, and June.