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 required production for the year should be 274,000 units. The cost of raw materials to be purchased for the year should be $1,106,800, whereas the total cash disbursements for the year should be $1,095,980. If you do not get this answer, find the errors in your worksheet and correct them.

A B C E F G H I Chapter 8: Applying Excel Datz Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 - Selling price per unit $8 per unit Accounts receivable, beginning balance $65,000 . Sales collected in the quarter sales are made 75% - Sales collected in the quarter after sales are made 25% Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter - Finished goods inventory, beginning 12,000 units - Raw materials required to produce one unit 5 pounds - Desired ending inventory of raw materials is 10% of the next quarter's production needs - Raw materials inventory, beginning 23,000 pounds - Raw material costs 10.80 per pound Raw materials purchases are paid 60% in the quarter the purchases are made and 40% in the quarter following purchase to payable for raw materials, beginning baland $81,500 Enter s formwis into each of the calls marked with a Fewem Review Problem: Budget Schedules Construct the sales braget F Budgeted unit sales Selling price per unit 18 Total sales Construct the schedule of expected cast c 4 Accounts receivable, beginning balance First-quarter sales Second-quarter sales 35 Third-quarter sales 36 Fourth-quarter sales 17 Total cash collections 38 39 Construct the production brager 4 41 Budgeted unit sales Add desired finished goods inventory 13 Total needs 14 Less beginning inventory 45 Required production Cosstreet de raw materials percloses bra 4 Year Required production [ unitel Raw materials required to produce one unit Production needs ( pounds) Add desired ending inventory of raw materials [ pound 13 Total needs [ poundel 04 Less beginning inventory of raw materials ( pounds) 15 Raw materials to be purchased 16 Cost of raw materials per pound Cost of raw materials to be purchased 19 Construct the schedule of expected cast g F Accounts payable, beginning balance First-quarter purchases Second-quarter purchases Third-quarter purchase: i Fourth-quarter purchases Total cash disbursements