MGMT 0475- Eddie's Bar and Restaurant Supplies expects its revenues and payments

Please help!

Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year to be:

Sales Payments

January $24,000 $18,000

February 20,000 21,300

March 35,000 19,100

April 22,000 22,400

May 28,000 14,700

Eighty 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 is 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 $6,000 on March 1. Prepare a cash budget for March, April, and May.