Coronado, Inc. prepared the following cash budget for the fourth quarter Fill in the missing amounts, assuming that Coronado desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Beginning cash balance $15,540 16,230 Collections from sales 82.150 242,010 Total cash available 73,070 7,690 24,290 258,240 Less disbursements 9,670 13,570 8,070 22,190 34,670 19,470 65,340 Materials purchases 11.430 5,020 19,970 29,110 Direct labor 23,180 Selling & administrative expenses 29,110 119,480 Equipment purchase 15,080 5,260 5,260 Total disbursements 65,530 1 39,820 Excess (deficiency) of cash .540 18,520 Minimum cash balance 15,000 15,000 15,000 15,000 Cash available (needed) 7,460 13,520 8,000 Total financing Ending cash balance 15,540 Click if you would like to Show Work for this question: Open Show Work