enter formulas in all cells that contain question marks.

For example, in cell B26 enter the formula "= B5".

Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The total expected cash collections for the year should now be $2,085,000. If you do not get this answer, find the errors in your worksheet and correct them.

ear 2 Quarter Year 3 6000 600 Budgeted urit sales 100,000 0,000 80 Selling price per uni S8 per u 985,000 75% 25% 30% ocounts 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 s of the budgeted unit sales of the next quarter Finshed gcods inventary,beginning 12,000 units 5 pourds 10% of the next guarter's production needs Raw materials required to produce ore unit Desred ending inventory of raw materia's Raw materals inventory 23,000 pourds 80.80 per pourd 60% in the quarter the purchases are made 40% in the quarter following purchase Raw materal costs Raw materials purchases are paid Accounts payable for raw materials, beginning balance $81,500 Enter a formula into each of the cells marked with a? below Review Problem: Budget Schedules Construct the sales budge ear 2 Quarter Year 3 Quarter udgeted unit sales Seling price per u Total sales Construct the schedule of expected cash coliections ear 2 Quarter Accounts receivable, beginning First quarter saies Second quarter sales Third quarter sales Fourth quarter sales Total cash collections Construct the production budget ear 2 Quarter Year 3 Budgeted unit sales Add desired finished goods Total needs Less begninning Recuired production Construct the raw materials purchases budget ear 2 Quarter Year 3 Required production (units) Raw materials required to produce one unit Production needs (pounds Add desired endirg mventory of raw materials Total needs (pounds Less beginning inventory of raw materials aw materials to be purchased Cost of raw materials per paund Cost of raw materials ta be purchased Construct the schedule of expected cash payments ear 2 Quarter Accounts payable, beginning First-quarter purchases Third-quarter purchases Total cash disbursements