I need the formulas not the answers!!!!!!!!

Chapter 8: Excel Case Data Budgeted unit sales - Selling price per unit - Accounts receivable, beginning balance - Sales collected in the quarter sales are made - Sales collected in the quarter after sales are made - Desired ending finished goods inventory is - Finished goods inventory, beginning - Raw materials required to produce one unit - Desired ending inventory of raw materials is - Raw materials inventory, beginning - Raw material costs - Raw materials purchases are paid and - Accounts payable for raw materials, beginning balance \begin{tabular}{|c|c|} \hline Year 2 Quarter \\ \hline 2 & 3 \\ \hline 60,000 & 100,000 \\ \hline \end{tabular} 40,000 \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Year 2 Quarter } \\ \hline 1 & 2 & 3 & 4 \\ \hline 40,000 & 60,000 & 100,000 & 50,000 \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline \multicolumn{2}{|c|}{ Year 3 Quarter } \\ \hline 1 & 2 \\ \hline 70,000 & 80,000 \\ \hline \end{tabular} $8 per unit $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 Enter a formula into each of the cells marked with a ? below Review Problem: Budget Schedules Construct the sales budget Budgeted unit sales Selling price per unit Total sales Construct the schedule of expected cash collections Accounts receivable, beginning balance First-quarter sales Second-quarter sales Third-quarter sales Fourth-quarter sales Total cash collections \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Year 2 Quarter } & \multicolumn{2}{|c|}{ Year 3 Quarter } \\ \hline 1 & 2 & 3 & 4 & 1 & 2 \\ \hline 40,000 & 60,000 & 100,000 & 50,000 & 70,000 & 80,000 \\ \hline$8 & $8 & $8 & $8 & $8 & $8 \\ \hline$320,000 & $480,000 & $800,000 & $400,000 & $560,000 & $640,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Year 2 Quarter } & \multirow[b]{2}{*}{ Year } \\ \hline \multicolumn{2}{|r|}{1} & \multirow{2}{*}{\multicolumn{2}{|c|}{2}} & \multirow[t]{2}{*}{3} & \multirow[t]{2}{*}{4} & \\ \hline$ & 65,000 & & & & & 65,000 \\ \hline \multirow{4}{*}{\multicolumn{2}{|c|}{240,000}} & $ & 80,000 & & & $320,000 \\ \hline & & & 360,000 & $120,000 & & $480,000 \\ \hline & & & & 600,000 & $200,000 & $800,000 \\ \hline & & & & & 300,000 & $300,000 \\ \hline$ & 305,000 & $ & 440,000 & $720,000 & $500,000 & $1,965,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{ Construct the production budget } & \multicolumn{4}{|c|}{ Year 2 Quarter } & \multicolumn{3}{|c|}{ Year 3 Quarter } \\ \hline & 1 & 2 & 3 & 4 & Year & 1 & 2 \\ \hline Budgeted unit sales & ? & ? & ? & ? & ? & ? & ? \\ \hline Add desired finished goods inventory & ? & ? & ? & ? & ? & ? & \\ \hline Total needs & ? & ? & ? & ? & ? & ? & \\ \hline Less beginning inventory & ? & ? & ? & ? & ? & ? & \\ \hline Required production & ? & ? & ? & ? & ? & ? & \\ \hline \multirow[t]{2}{*}{ Construct the raw materials purchases budget } & \multicolumn{4}{|c|}{ Year 2 Quarter } & \multicolumn{3}{|c|}{ Year 3 Quarter } \\ \hline & 1 & 2 & 3 & 4 & Year & 1 & \\ \hline Required production (units) & ? & ? & ? & ? & ? & ? & \\ \hline Raw materials required to produce one unit & ? & ? & ? & ? & ? & ? & \\ \hline Production needs (pounds) & ? & ? & ? & ? & ? & ? & \\ \hline Add desired ending inventory of raw materials (pounds) & ? & ? & ? & ? & ? & & \\ \hline Total needs (pounds) & ? & ? & ? & ? & ? & & \\ \hline Less beginning inventory of raw materials (pounds) & ? & ? & ? & ? & ? & & \\ \hline Raw materials to be purchased & ? & ? & ? & ? & ? & & \\ \hline Cost of raw materials per pound & ? & ? & ? & ? & ? & & \\ \hline Cost of raw materials to be purchased & ? & ? & ? & ? & ? & & \\ \hline \multirow[t]{2}{*}{ Construct the schedule of expected cash payments } & \multicolumn{4}{|c|}{ Year 2 Quarter } & & & \\ \hline & 1 & 2 & 3 & 4 & Year & & \\ \hline Accounts payable, beginning balance & ? & & & & ? & & \\ \hline First-quarter purchases & ? & ? & & & ? & & \\ \hline Second-quarter purchases & & ? & ? & & ? & & \\ \hline Third-quarter purchases & & & ? & ? & ? & & \\ \hline Fourth-quarter purchases & & & & ? & ? & & \\ \hline Total cash disbursements & ? & ? & ? & ? & ? & & \\ \hline \end{tabular}