Prepare the cash receipts budget for the second quarter. (Enter answers in necessary fields only. Leave other fields blank. Do not enter .) Cash Receipts Budget May June April 401040 Total Cash Receipts 401040 February sales March sales 543300 905500 362200 695580 April sales 463720 1159300 May sales 755340 755340 Totals $ 944340 $ 1057780 $ 1219060 $ 3221180 Accounts Receivable balance at the end of second quarter of 2015 $ $ 1909560 1909560 LINK TO TEXT LINK TO VIDEO Prepare the purchases budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Purchases Budget May June Total Purchases April 139116 151068 April COGS$ May COGS June COGS July COGS 393680 168720 420840 Totals 403485 1 51068 $ 393680 $ 589560 Prepare the cash payments budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Cash Payments Budget April May June March purchases April purchases 302614 100871 May purchases 113301 37767 June purchases 295260 333027 302614 $ 214172 $ Accounts Payable balance at the end of second quarter of 2015 $ 98420 Cash Budget April May 59200 Quarter Beginning Cash balance Collection from Sales Total cash available to spend Less: disbursements Wages 347790 421800 1147260 Salaries 27208 377670 27208 31333 27208 27208 Advertising 31333 31333 31333 Property taxes 35750 35750 Insurance 16533 16533 16533 16533 Utilities 15150 15150 15150 15150 Income taxes Payments for inventory Total cash disbursements Cash excess (deficiency) Minimum cash balance Cash excess (needed) Financing: Borrowings Repayments Interest Total financing Ending Cash Balance Prepare the cash receipts budget for the second quarter. (Enter answers in necessary fields only. Leave other fields blank. Do not enter .) Cash Receipts Budget May June April 401040 Total Cash Receipts 401040 February sales March sales 543300 905500 362200 695580 April sales 463720 1159300 May sales 755340 755340 Totals $ 944340 $ 1057780 $ 1219060 $ 3221180 Accounts Receivable balance at the end of second quarter of 2015 $ $ 1909560 1909560 LINK TO TEXT LINK TO VIDEO Prepare the purchases budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Purchases Budget May June Total Purchases April 139116 151068 April COGS$ May COGS June COGS July COGS 393680 168720 420840 Totals 403485 1 51068 $ 393680 $ 589560 Prepare the cash payments budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Cash Payments Budget April May June March purchases April purchases 302614 100871 May purchases 113301 37767 June purchases 295260 333027 302614 $ 214172 $ Accounts Payable balance at the end of second quarter of 2015 $ 98420 Cash Budget April May 59200 Quarter Beginning Cash balance Collection from Sales Total cash available to spend Less: disbursements Wages 347790 421800 1147260 Salaries 27208 377670 27208 31333 27208 27208 Advertising 31333 31333 31333 Property taxes 35750 35750 Insurance 16533 16533 16533 16533 Utilities 15150 15150 15150 15150 Income taxes Payments for inventory Total cash disbursements Cash excess (deficiency) Minimum cash balance Cash excess (needed) Financing: Borrowings Repayments Interest Total financing Ending Cash Balance