Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter Budgeted unit sales 100 70,000 80,000 $8 . Selling price per unit Accounts 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 is Finished goods inventory, beginning Raw materials required to produce one unit $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 Desired ending inventory of raw materials is Raw materials inventory, beginning Raw material costs 23,000 pounds 50.80 per pound 60% in the quarter the purchases are made 40% 1 in the quarter following purchase 7Raw materials purchases are paid and Accounts payable for raw materials, beginning bala 81.500 ? below :1 Enter a formula into each of the cells marked with 2 Review Problem: Budget Schedules 23 24 Construct the sales budget Year 2 Quarter Year 3 Quarter 26 Budgeted unit sales 27 Selling price per unit 28 Total sales 29 30 Construct the schedule of expected cash collecti 31 32 Beginning balance accounts receivable 33 First-quarter sales 34 Second-quarter sales 35 Third-quarter sales 36 Fourth-quarter sales Year 2 Quarter Year