please help solve. we are going over budgets. all one problem, just really long.

Prepare the Budgets for second quarter!! 1) Sales Budgat with expected Cash Collections All sales are on account. The compary collects 60% in month of sale and 35% in the following month. The remairing 5% is uncollectable. March 31AR is 40,000 and all is collectable \begin{tabular}{|l|r|} \hline Month of sale Collections & 60% \\ \hline Following month collections & 35% \\ \hline \end{tabular} Sales Budget Production budget does not have a total column, instead does an extra period. The compary desires to have inventory on hand at the end of each month Variable Selling and Administrative expenses are $.60 per unit SOLD. Fixed Seling and Admiristrative expenses is $50,000 per month. The Fixed expenses include $20,000 of depreciation that is a non cash outtlow. \begin{tabular}{l} \hline Variable S \& A \\ \hline Fixed S \& A \\ \hline Depreciation \\ \hline SALES in unit \\ Variable S \& \\ Variable S \& \\ Plus Fixed S \\ Total S \& A e \\ Less noncast \\ \hline Cash paid for \\ \hline Cash Budget \end{tabular} Other cash expenses and information for the month include A) An open line of credit allows our company to borrow up to $75,000 per quarter B) We must have a minimum cash balance each month of $40,000 C) All borrowing is done at beginning of month, repayments at end of month D) Interest is paid at 10% per year on all amounts borrowed E) Cash dividends to be paid in April are (cell E187): F) Cash equipment purchases in May (cell E188) and in June (Cell F188) G) Cash balance at beginning of April is $60,000 Less Disbursements: \begin{tabular}{ll|l|l|l|l|} \hline & Material Purchases (Budget 3) & & & & \\ \hline & Direct labor (Budget 4) & & & & \\ \hline & MOH (Budget 5) & & & \\ \hline & Selling and Adm. (budges 6) & & & \\ \hline & Dividends (Letter E) & & & \\ \hline & Equipment purchases (letter F) & & & & \\ \hline & Total Disbursements & & & & \\ \hline \end{tabular} Excess (deficiency) of cash Financing (if needed)