data given

have to make a cash budget in below excel sheet

Balance Sheet March 31, 2019 ASSEIS Cash Accounts Receivable ** Inventory *** Prepaid Insurance Property, Plant \& Equipment, net of accum depreciation Total Assets \begin{tabular}{|r|} \hline$14,000 \\ 216,000 \\ 157,500 \\ 14,400 \\ \hline 172,700 \\ \hline$574,600 \\ \hline \hline \end{tabular} LABILITIES \& STOCKHOLDERS' EQUITY LABILIIES: **Due from February Sales March Sales $48,000$168,000$216,000 ***Inventory Units 31,500 For the Three Months Ended June 30, 2019 Sales Budget: Budgeted Sales in Units Selling price per Unit Total Sales Nedder, Lally, Womble Company Schedule of Expected Cash Collections For the Three Months Ended June 30, 2019 February Sales March Sales April Sales May Sales June Sales Total Cash Collections Schedule of Expected Cash Disbursements for Merchandise Purchases For the Three Months Ended June 30, 2019 Accounts Payable, Beginning Balance April May Total Payments Selling and Administrative Expense Budget** Budgeted Sales in Units \begin{tabular}{|c|c|c|c|} \hline & Month & & Quarter \\ \hline April & May & June & Total \\ \hline 35,000 & 54,000 & 64,000 & 153,000 \\ \hline \end{tabular} Variable Expenses Sales Commision Total Variable Expenses \begin{tabular}{|llllllll} $35,000 & $ & 54,000 & $ & 64,000 & $ & 153,000 & \\ $35,000 & $ & 54,000 & $ & 64,000 & $ & 153,000 \end{tabular} Fixed Expenses Wages and Salaries Utilities Insurance Depreciation Miscellaneous Total Fixed Expenses Total Selling and Administrative Expenses \begin{tabular}{rrrrrrrr} $ & 22,000 & $ & 22,000 & $ & 22,000 & $ & 66,000 \\ $ & 14,000 & $ & 14,000 & $ & 14,000 & $ & 42,000 \\ $ & 1,200 & $ & 1,200 & $ & 1,200 & $ & 3,600 \\ $ & 1,500 & $ & 1,500 & $ & 1,500 & $ & 4,500 \\ $ & 3,000 & $ & 3,000 & $ & 3,000 & $ & 9,000 \\ \hline$ & 41,700 & $ & 41,700 & $ & 41,700 & $ & 125,100 \\ \hline$ & 76,700 & $ & 95,700 & $ & 105,700 & $ & 278,100 \\ \hline \end{tabular} "*Must show each account as well as totals on this budget. Cash Budget For the Three Months Ended June 30, 2019 Cash Balance, Beginning Balance Sheet March 31, 2019 ASSEIS Cash Accounts Receivable ** Inventory *** Prepaid Insurance Property, Plant \& Equipment, net of accum depreciation Total Assets \begin{tabular}{|r|} \hline$14,000 \\ 216,000 \\ 157,500 \\ 14,400 \\ \hline 172,700 \\ \hline$574,600 \\ \hline \hline \end{tabular} LABILITIES \& STOCKHOLDERS' EQUITY LABILIIES: **Due from February Sales March Sales $48,000$168,000$216,000 ***Inventory Units 31,500 For the Three Months Ended June 30, 2019 Sales Budget: Budgeted Sales in Units Selling price per Unit Total Sales Nedder, Lally, Womble Company Schedule of Expected Cash Collections For the Three Months Ended June 30, 2019 February Sales March Sales April Sales May Sales June Sales Total Cash Collections Schedule of Expected Cash Disbursements for Merchandise Purchases For the Three Months Ended June 30, 2019 Accounts Payable, Beginning Balance April May Total Payments Selling and Administrative Expense Budget** Budgeted Sales in Units \begin{tabular}{|c|c|c|c|} \hline & Month & & Quarter \\ \hline April & May & June & Total \\ \hline 35,000 & 54,000 & 64,000 & 153,000 \\ \hline \end{tabular} Variable Expenses Sales Commision Total Variable Expenses \begin{tabular}{|llllllll} $35,000 & $ & 54,000 & $ & 64,000 & $ & 153,000 & \\ $35,000 & $ & 54,000 & $ & 64,000 & $ & 153,000 \end{tabular} Fixed Expenses Wages and Salaries Utilities Insurance Depreciation Miscellaneous Total Fixed Expenses Total Selling and Administrative Expenses \begin{tabular}{rrrrrrrr} $ & 22,000 & $ & 22,000 & $ & 22,000 & $ & 66,000 \\ $ & 14,000 & $ & 14,000 & $ & 14,000 & $ & 42,000 \\ $ & 1,200 & $ & 1,200 & $ & 1,200 & $ & 3,600 \\ $ & 1,500 & $ & 1,500 & $ & 1,500 & $ & 4,500 \\ $ & 3,000 & $ & 3,000 & $ & 3,000 & $ & 9,000 \\ \hline$ & 41,700 & $ & 41,700 & $ & 41,700 & $ & 125,100 \\ \hline$ & 76,700 & $ & 95,700 & $ & 105,700 & $ & 278,100 \\ \hline \end{tabular} "*Must show each account as well as totals on this budget. Cash Budget For the Three Months Ended June 30, 2019 Cash Balance, Beginning