excel formula

21 Enter a formula into each of the cells miarked whe a 7 bolow 22 Review Problem: Budget Schedules 24 Construct the sales budget 26 Construct the sales 27. Selling price per unit 28 Total sales 29 30 Construct the schedule of expected cash collections 32 Accounts recelvable, beginning balance 33. First-quarter sales 34 Second-quarter sales 35. Third-quarter sales 36 Fourth-quarter sales 37. Total cash collections 39 Construct the production budget 41 Budgeted unit sales 41 Budgeted unt sales 42 Add desired finished goods imentory 38 Construct the production budget 41 Budgeted unit sales 42 Add desired finished goods imventory 43 Total needs 44 Less beginning imventory 45 Required production 47 Construct the raw materials purchases budget 48 49 Required production (units) 50 Raw materials required to produce one unit 51 Production needs (pounds) 52 Add desired ending inventory of raw materiats (pounds) 53. Total needs (pounds) 54 Less beginning inventory of raw materials (pounds) 55 Raw materials to be purchased 56 Cost of raw materials per pound 57 Cost of raw materials to be purchased \begin{tabular}{rrrrrrrrr} & Year 2 Quarter & r & & & & Year 3 Quarter \\ 1 & 2 & ? & ? & ? & ? & ? \\ ? & ? & ? & ? & ? & ? \\ ?? & ? & ? & ? & ? & ? \\ ? & ? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? & ? \\ \hline \end{tabular} ? \begin{tabular}{rrrrrrr} \hline & Year 2 Quarter & & & Year 3 Quarter \\ \hline? & ? & ? & ? & ? & ? \\ ? & ? & ? & ? & ? & ? \\ ? & ? & ? & ? & ? & ? \\ ? & ? & ? & ? & ? & \\ ? & ? & ? & ? & ? \\ ? & ? & ? & ? & ? \\ ? & ? & ? & ? & ? \\ ? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline \end{tabular} 58 Construct the schedule of expected cash payments Year 2 Quarter. Construct the schedule of expected cash payments 1 Accounts payable, beginning balance 2 First-quarter purchases 3 Second-quarter purchases 4 Third-quarter purchases Fourth-quarter purchases Total cash disbursements \begin{tabular}{cccccc} \hline & Year 2 Quarter & 2 & 3 & & \\ & ? & & & & Year \\ & ? & ? & ? & & ? \\ & & ? & ? & ? & ? \\ & & & & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline \end{tabular}