Consider the following

please answer with formulas

ex) =B1+B2

A1 fx S\&P Enterprises needs a cash budget for March. The following information is available. \begin{tabular}{|c|c|c|c|c|c|c|} \hline 4 & & B & c & D & E & F \\ \hline 1 & S\&P Enterprises needs a cash budget for March. The following information is available, & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & Data & Januory & February & March & & \\ \hline 4 & Actual January and February and expected March sales: & & & & & \\ \hline 5 & Cash sales & $1,600 & $3,750 & $5,100 & & \\ \hline 6 & Sales on account & 25,000 & 30,000 & 40,000 & & \\ \hline 7 & Total Sales & $26,600 & $33,750 & $45,100 & & \\ \hline 8 & & & & & & \\ \hline 9 & Accounts Receivable Collections: & & & & & \\ \hline 10 & Month of sale & 15% & & & & \\ \hline 11 & Month following sale & 60% & & & & \\ \hline 12 & Second month following sale & 22% & & & & \\ \hline 13 & Uncollectible & 3% & & & & \\ \hline 14 & Accounts payable for inventory purchases, March 1 balance & $10,500 & & . & & \\ \hline 15 & Budgeted inventory purchases in March & $23,500 & & & & \\ \hline 16 & Inventory payments: & & & & . & \\ \hline 17 & Month of purchase & 60% & & & & \\ \hline 18 & Month following purchase & 40% & & & & \\ \hline 19 & & & & 8 & & \\ \hline 20 & Total budgeted selling \& administrative expenses in March (including depreciation) & $12,500 & & & & \\ \hline 21 & Budgeted depreciation in March (included in total selling and admin exp) & $3,200 & & & & \\ \hline 22 & & & & & & \\ \hline 23 & Other budgeted cash disbursements in March & & & & & \\ \hline 24 & Equipment purchases & $14,000 & & & & \\ \hline 25 & Dividends to be paid & $2,000 & & & & \\ \hline 26 & ! & & & & & \\ \hline 8 & Budget Data 8 Schedules and Cash Budget + & & & & & \\ \hline \end{tabular} A1 fx S\&P Enterprises needs a cash budget for March. The following information is available