complete eveything with (?).

3. Data Budgeted unit shler \begin{tabular}{|c|c|c|} \hline \multicolumn{1}{|c|}{ Year2 Ouarter } \\ \hline 1 & 2 & 3 \\ \hline 40,000 & 60,000 & 100,000 \\ \hline & & \\ \hline 58 & per unit & \\ \hline 565,000 & & \\ \hline 75% & & \\ \hline 25% & & \\ \hline \end{tabular} - Eelline pricen per unit - Accounts recoivable, beginning balance - Sales collected in the quarter sales are made - Salos 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 + Row materials inventory, begirning - Raw material costs - Rinw materials purchases ace paid and 30% of the budgeted unt sales of the next quarier 12.000 wills 5 pounds 10\% of the next quarters production needs 23.000 pounds $0.80 per pound 60% in the quarter the purchases are made - Acoounts peyable for raw materials, beginning balance 40% in the quarter following purchase $31,500 Enter a formula info each of the cells manked with a ? Delow Review Problem: Budget Schedules Construct the sales budget Budgeted unit sales Selling price per unit Total sales Year 2 Ouarter Your 3 Quaviler 50,000 70000 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 Year 2 Ouarter Construct the production budget Budgeted unit sales Add desired finished goods inventory Total needs Less beginning imventory Required production Construct the raw materials purchases budget Required production (units) Raw materials reguired to produce one unit 51. Production needs (pounds) 52. Add desired ending imertory of rew materials (pounds) 53. Total needs (pounds). 54 Less beginning inventory of raw materials (pounds) 55. Rarw materials to be purchased 56. Cost of raw materials per pound 57. Cost of raw materiais to be purchased 58. Construct the schedule of expected cash payments 69. Construct the schedule of expected cash payments 6) Accounts payable, begining balance 62. Firstquanter purchases 6. Second-guarter purchaves fA. Thirdquarter purchaves Foumhinarter purchases Total cash distursements 5 565,000 2 3 \begin{tabular}{|r|r|r|r|} \hline ? & & & 55,000 \\ \hline$480,000 & ? & & ? \\ & $800,000 & ? & ? \\ \hline? & ? & 5400,000 & ? \\ \hline \end{tabular} Year 2 Quarter 2 3 ? \begin{tabular}{rrrrrr} ? & ? & ? & ? & ? & ? \\ ?? & ? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? & ? \end{tabular} Year 3 Ouarter \begin{tabular}{|rrrrr|} \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline \end{tabular} 3. Data Budgeted unit shler \begin{tabular}{|c|c|c|} \hline \multicolumn{1}{|c|}{ Year2 Ouarter } \\ \hline 1 & 2 & 3 \\ \hline 40,000 & 60,000 & 100,000 \\ \hline & & \\ \hline 58 & per unit & \\ \hline 565,000 & & \\ \hline 75% & & \\ \hline 25% & & \\ \hline \end{tabular} - Eelline pricen per unit - Accounts recoivable, beginning balance - Sales collected in the quarter sales are made - Salos 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 + Row materials inventory, begirning - Raw material costs - Rinw materials purchases ace paid and 30% of the budgeted unt sales of the next quarier 12.000 wills 5 pounds 10\% of the next quarters production needs 23.000 pounds $0.80 per pound 60% in the quarter the purchases are made - Acoounts peyable for raw materials, beginning balance 40% in the quarter following purchase $31,500 Enter a formula info each of the cells manked with a ? Delow Review Problem: Budget Schedules Construct the sales budget Budgeted unit sales Selling price per unit Total sales Year 2 Ouarter Your 3 Quaviler 50,000 70000 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 Year 2 Ouarter Construct the production budget Budgeted unit sales Add desired finished goods inventory Total needs Less beginning imventory Required production Construct the raw materials purchases budget Required production (units) Raw materials reguired to produce one unit 51. Production needs (pounds) 52. Add desired ending imertory of rew materials (pounds) 53. Total needs (pounds). 54 Less beginning inventory of raw materials (pounds) 55. Rarw materials to be purchased 56. Cost of raw materials per pound 57. Cost of raw materiais to be purchased 58. Construct the schedule of expected cash payments 69. Construct the schedule of expected cash payments 6) Accounts payable, begining balance 62. Firstquanter purchases 6. Second-guarter purchaves fA. Thirdquarter purchaves Foumhinarter purchases Total cash distursements 5 565,000 2 3 \begin{tabular}{|r|r|r|r|} \hline ? & & & 55,000 \\ \hline$480,000 & ? & & ? \\ & $800,000 & ? & ? \\ \hline? & ? & 5400,000 & ? \\ \hline \end{tabular} Year 2 Quarter 2 3 ? \begin{tabular}{rrrrrr} ? & ? & ? & ? & ? & ? \\ ?? & ? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? & ? \end{tabular} Year 3 Ouarter \begin{tabular}{|rrrrr|} \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline \end{tabular}