Got stuck and need help anything helps thanks.

oration is projecting a cash balance of $32,700 in its December 31, 2019, balance sheet. Deitz's schedule of expected collections from customers for the first quarter of 202 of 2020 shows total collections of $201,950. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $46,870. Other information gathered for the first quarter of 2020 is sale of equipment $3,270; direct labor $76,300, manufacturing overhead $38,150, selling and administrative expenses $49,050; and purchase of securities $15,260. Deitz wants to maintain a balance of at least $27,250 cash at the end at the end of each quarter. Prepare a cash budget for the first quarter. DEITZ CORPORATION Cash Budget for the Month Ended March 31, 2020 ov Beginning Cash Balance Add Collections from Customers Sale of Equipment Total Available Cash Direct Materials Manufacturing Overhead Less v Selling and Administrative Expenses Purchase of Securities Total Disbursements JO JO Less v Selling and Administrative Expenses Purchase of Securities Total Disbursements Excess of Available Cash Over Cash Disbursements Borrowings Add Borrowings Ending Cash Balance