Chapter 8: Applying Excel Data Budgeted unit sales - 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 Year 2 Quarter Year 3 Quarter 2 40,000 60,000 3 USS 11 per unt USS 63,050 75% 25% 25% of the budgeted unit sales of the next quarter Enter a formula into each of the cells marked with a ? beiow Review Problem: Budget Schedules Construct the sales budget Budgeted unit saies Selling price per unh Total sales Construct the schedule of expected cash collections Accounts receivable, begnning bulance First-quarter sales Second-quarter sales Third-quarter sales Fourth-quarter sales Total cash collections Construct the production budget Budgeted unit sales Add desired finished goods inventory Total needs Less beginning inventory Required production 1 70,000 2 80,000 Year 2 Quarter 2 ? ? ? 3 4 50,000 7 7 Year 2 Quarter 1 2 ? ? ? ? ? ? ? ? ? ? Year 2 Quarter 3 ? 4 ? ? ? 4 Year ? ? ? ? ? ? ? ? ? ? ? ? 4 ? Year