Please include explanation and formulas. Thank you!

A cash budget: by quarters; is given below (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Assume that if the company has a loan and cash above the minimum cash balance it will repay the maximum amount without going below the minimum cash balance Fill in the missing amounts in the following table. Enter 0 for any amounts that are zero. Beginning cash balance Collections from customers Total available cash Disbursements Direct materials Direct labor Cash Budget mber 31 Quarter 1 7 88 40 2019 Quarter 2 31 21 3 7 62 11 0 0 Quarter 3 Quarter 4 Total go 28 7 32 0 50 3 0 0 321 106 12 Manufacturing overhead less depreciation Selling and administrative expenses less depreciation Total disbursements Excess (deficiency) of available cash Financing Borrowings Repayments including interest Ending cash balance 6 3 12 0