need help with the revised part
\begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{l} 86 \\ 87 \end{tabular}} & z2 & & & & & \multirow[b]{3}{*}{ Quarter 4} \\ \hline & & & \multicolumn{3}{|c|}{ Budgeted Cash Recelpts/Collection } & \\ \hline 88 & & September & October & November & December & \\ \hline 89 & Budgeted Sales (\$) & $17,000.00 & $14,000.00 & $13,000,00 & $14,400,00 & $58,400.00 \\ \hline 90 & Current month's sales collected in cash & $10,200.00 & $8,400.00 & $7,800.00 & $8,640.00 & $24,840.00 \\ \hline 91 & Current month's sales credit sales collected & $3,400.00 & $2,800.00 & $2,600.00 & $2,880.00 & $8,280.00 \\ \hline 92 & Prior month's credit sales collected & & $3,400.00 & $2,800,00 & $2,600.00 & $8,800.00 \\ \hline 93 & Budgeted Total Cash collection/receipt & & $14,600.00 & $13,200.00 & $14,120.00 & $41,920.00 \\ \hline \\ \hline 95 & & & \multicolumn{2}{|c|}{ Budgeted Cash Payments } & & \\ \hline 96 & & September & October & November & December & Quarter 4 \\ \hline 97 & Budgeted Rlaw Materials Purchase (\$) & $800.00 & $818.64 & $824.88 & $917.04 & $2,560.56 \\ \hline 98 & Bud. Cash payment in month of purchase & $480.00 & $491 & $495 & $550 & $1,53634 \\ \hline 99 & Bud. Total Cash payment in month following purchase & & $32000 & $327.46 & $329.95 & $977.41 \\ \hline 100 & Bud. Cash payment towards DL cost & & $2,740.00 & $2,684.00 & $3,012.00 & $8.A36.00 \\ \hline 101 & Budgeted MOH costs & & $1,024.00 & $1,018.40 & $1,051.20 & $3,093.60 \\ \hline 102 & Depreciation & & ($280.00) & ($280.00) & ($280.00) & ($840.00) \\ \hline 103 & Budgeted S\&A Expenses & & $1,345.00 & $1,30750 & $1,36000 & $4,012.50 \\ \hline 104 & Budgeted Capital Expenditure & & $15,000.00 & & & $15,000 \\ \hline 105 & Budgeted Total Cash Payments & & $20,640.18 & $5,552.28 & $6,023.38 & $32,215.84 \\ \hline 106 & & & & = & & \\ \hline 107 & & & Cash Budget & & E & \\ \hline 108 & & September & October & November & December & Quarter 4 \\ \hline 109 & Beginning Cash Balance & & $12,200 & $10,159.82 & $13,80754 & $12,200 \\ \hline 110 & Budgeted Cash Collection/Receipts & & $14,600,00 & $13,200.00 & $14,120.00 & $41,920.00 \\ \hline 111 & Less: Budgeted Cash Payments & & ($20,640.18) & (55,552.28) & (56,023.38) & ($32,215.84) \\ \hline 112 & Preliminary Cash Balance & & $6,159.82 & $17,80754 & $21,904.16 & $21,904.16 \\ \hline 113 & & & & & & \\ \hline 114 & Borrowings ond Repeyments: & 8 & & & & \\ \hline 115 & Borrowing & & 54,000 & -. & & \\ \hline 116 & Repayment of Principal & & - & ($4,000) & & \\ \hline 117 & Ending Cash ealance & & $10,15982 & $13,80754 & $21,904.16 & $21,904.16 \\ \hline 118 & & & & & & \\ \hline \end{tabular} 4. After completing requirements 13 above revise the budget spreadsheet in a new worksheet to include the following changes (you can copy and paste the current spreadsheet in a new worksheet to incorporate the following changes): Natsu Corp. is contemplating increasing the selling price of the Scarves by 10% during the high sales months of October and November. The management of Natsu believes that it would affect unit sales marginally only, thereby, reducing unit sales by 5% in those two months. How would these two changes affect the net income of Quarter 4? What is the net income from the original data and the net income on the revised data? What is the net income difference between the original and revised data? Based on the analysis, should Natsu Corp. temporarily increase the price of scarves during those high-demand months? Include a short explanation in the Excel file itself. (You must revise your Excel spreadsheet to determine the effect on the income statement. If you used your formulas correctly for requirements 1-3, you will not need to make a whole lot of changes to your spreadsheet)
