fill in the "?'s" please include formulas! thank you so much.

1 Ler SF ADDIVIna Excel \begin{tabular}{|l|l|} \hline 2 & \\ 3 & \\ 4 & \\ 5 & leted unit sales \end{tabular} 7 ing price per unit 8 ounts recelvable, beginning balance 9 es collected in the quarter sales are made 10 es collected in the quarter after sales are made 11 ired ending finished goods inventory is 12 shed goods inventory, beginning 13 v materials required to produce one unit 14 tred ending inventory of raw materials is 15v materials inventory, beginning 16 material costs 17v materials purchases are paid 18d 19 ounts payabla for raw materials, beginning balance 20 21 a fomula into oach of the colls marked with a ? Below 22 sw Problem: Budget Schedules 23 truct the sales budget 25 jeted unit sales 27 ig pice per unit 28 sales 31. truct the schedule of expected cash collections 31 unts recelvable, beginning balance 33 quarter soles 34 ind-quarter sales 35 -quarter sales 36 h-quarter sales 37 cash collections 38 39 truct the production budget 40 \[ \begin{array}{|c|c|c|c|c|c|} \hline & \text { Year2 Quartor } & \multicolumn{2}{c}{\text { Yoar 3 Quarter }} \\ \hline 4 & 2 & 3 & 4 & 1 & 2 \\ \hline 40,000 & 60,000 & 100,000 & 50,000 & 70,000 & 80,000 \\ \hline \end{array} \] $8 perunit $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 guarter following purchase 581,500 joled unit sales Year 2 Quarter 2 3 ? ? Yoar Yoar 3 Quartor 2 ? ? 35 Third-quarter sales 36 Fourth-quarter sales 37 Total cash collections 39 Construct the production budget 40 Budgeted unit sales 42 Add desked finiahod goods inventory 43 Total needs 44 Less beginning inventory 45 Required production 46 48 48 49 Requived production (units) 50 Raw materials required to produce one unit 51 Production needs (pounds) 52 Add desred ending kventory of raw malerials (pounds) 53 Total needs (pounds) 54 Less beginning inventory of raw materials (pounds) 55. Raw matorials to be purchased 56 Cost of naw matorals per pound 57 Cost of raw materials to be purchased 58 Construct the schedule of expected cash payments 61 Accounts payabie, beginning balance 62 Fint-quarter purchases 63. Second-quarter purchases 64 Third-quartor purchases 65 Fourth-quarter purchases 66 Total cash disbursements \begin{tabular}{|lrrrr|} & & ? & ? & ? \\ \hline? & & & ? & ? \\ \hline \hline \end{tabular}