QS 22-24 (Algo) Manufacturing: Cash budget LO P2 Using the following information: a. Beginning cash balance on March 1, $76,000. b. Cash receipts from sales, $308,000. c. Cash payments for direct materials, $136,000. d. Cash payments for direct labor, $77,000. e. Cash payments for overhead, $41,000. f. Cash payments for sales commissions, $7,000 g. Cash payments for interest, $180 ( 1% of beginning loan balance of $18,000) h. Cash repayment of loan, $18,000. Prepare a cash budget for March for Gado Company. \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ GADO COMPANY } \\ \hline & Cash Budget \\ \hline & & \\ \hline & & \\ \hline Total cash available & & \\ \hline Less: Cash payments for & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline Total cash payments & & \\ \hline Preliminary cash balance & \\ \hline Loan activity & & \\ \hline & & \\ \hline Ending cash balance & & \\ \hline Loan balance, end of month & & \\ \hline \end{tabular}