Eddie's Bar and Restaurant Supplies Expects Its Revenues and Payments

Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year to be:
$\begin{array} { l r r } & \underline { \text { Sales } } & \underline{\text { Payments }} \\\text { Jan. } & \$ 14,000 & \$ 18,000 \\\text { Feb. } & 20,000 & 21,300 \\\text { Mar. } & 26,000 & 19,100 \\\text { April } & 22,000 & 22,400 \\\text { May } & 18,000 & 14,700\end{array}$ Seventy percent of the firm's sales are on credit.Past experience shows that 40 percent of accounts receivable are collected in the month after sale,and the remainder are collected in the second month after sale.Prepare a schedule of cash receipts for March,April,and May.Eddie's pays its payments in the following month.Eddie's had a cash balance of $2,000 on March 1,which is also its minimum required cash balance.There is an outstanding loan of $2,000 on March 1.Prepare a cash budget for March,April,and May.