everything i got wrong please

Castor Incorporated is preparing its master budget. Budgeted sales and cash payments for merchandise purchases for the next three months follow. Budgeted April May June Sales $ 31,900 $ 40,100 $ 24,100 Cash payments for merchandise purchases 20,400 16,700 17,100 Sales are 60% cash and 40% on credit. Sales in March were $24,100. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $12,100 in cash and $2,100 in loans payable. A minimum cash balance of $12,100 is required. Loans are obtained at the end of any month when the preliminary cash balance is below $12,000. Interest is 2% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If a preliminary cash balance above $12,000 at month-end exists, loans are repaid from the excess. Expenses are paid in the month incurred and include sales commissions (5% of sales), shipping (4% of sales), office salaries ($5,100 per month), and rent ($3,100 per month) (a) Prepare a schedule of cash receipts from sales for April, May, and June. (b) Prepare a cash budget for each of April, May, and June. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) June 24,100 Answer is not complete. CASTOR INCORPORATED Schedule of Cash Receipts from Sales April May $ 31,900 $ 40,100 $ Cash receipts from Cash sales $ 19,140 $ 24,060 $ Collections of prior period sales 12,100 & 12,760 Total cash receipts $ 31,240 36,820 CASTOR, INCORPORATED Cash Budget April May Beginning cash balance s 12,100 $ 12,100 $ Add: Cash receipts from sales 42 X 47 X Total cash available 12.142 12,147 Less: Cash payments for: Merchandise 20,400 16.700 14,460 16,040 30,500 June 17.991 0 17,991 17,100 June 24,100 14,460 16,040 30,500 CASTOR INCORPORATED Schedule of Cash Receipts from Sales April May $ 31,900 $ 40,100 $ Cash receipts from Cash sales 19,140$ 24,060$ Collections of prior period sales 12,100 12,760 Total cash receipts $ 31,240 $ 36,820 CASTOR, INCORPORATED Cash Budget April May Beginning cash balance $ 12,100 12,100 $ Add: Cash receipts from sales 42 47 X Total cash available 12,142 12,147 Less: Cash payments for: Merchandise 20,400 16,700 Sales commissions 1,595 2,005 Shipping 1,276 1,604 Office salaries X 3,100 3,100 Rent x 5,100 5,100 June 17,991 0 17,991 O 17.100 1,205 964 3,100 5,100 42 47 X 0 27,469 Interest on loan Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance 31,513 11,827 21,022 28,556 20,364 (2,373) 17,991 273 0 21,022 June 12,100 Loan balance April $ 2,100 273 $ 2,373 $ Loan balance - Beginning of month Additional loan (loan repayment) Loan balance - End of month May 2,373 (2,373) 0 0 0