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.

WPS Office [ Chapter_8_Appl...|_Student_Form _ X + 1 Sign in Go Premium X = Menu v Home Insert Page Layout Formulas Data Review View Tools Q Click to find commands A1 fx Chapter 8: Applying Excel A B C D E F G H J K L M N O 2 Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 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 9 . Sales collected in the quarter sales are made 75% 10 . Sales collected in the quarter after sales are made 25% 11 . Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter 12 . Finished goods inventory, beginning 12,000 units 13 . Raw materials required to produce one unit 5 pounds 14 . Desired ending inventory of raw materials is 10% of the next quarter's production needs 15 . Raw materials inventory, beginning 23,000 pounds 16 . Raw material costs $0.80 per pound 17 . Raw materials purchases are paid 60% in the quarter the purchases are made 18 and 40% in the quarter following purchase 19 . Accounts payable for raw materials, beginning balance $81,500 20 21 Enter a formula into each of the cells marked with a ? below 22 Review Problem: Budget Schedules 23 24 Construct the sales budget Year 2 Quarter Year 3 Quarter 25 1 3 1 2 26 Budgeted unit sales ? 27 Selling price per unit 28 Total sales 2 29 30 Construct the schedule of expected cash collection: Year 2 Quarter 31 2 3 4 Year 32 Accounts receivable, beginning balance 33 First-quarter sales ? 1 >1 1 Chapter 8 Form + 11 4 100% * - + a V7 10:09 PM Search A DO (ENG 5/27/2021