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 $240,00060,0003$ USS $11$ per unt USS $63,050\backslash (75\backslash \%\backslash )\backslash (25\backslash \%\backslash )\backslash (25\backslash \%\backslash )$ 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 $170,000280,000$ Year $2$ Quarter $2\backslash (?\backslash )\backslash (?\backslash )\backslash (?\backslash )3450,00077$ Year $2$ Quarter $12\backslash (?\backslash )\backslash (?\backslash )?\backslash (?\backslash )\backslash (?\backslash )\backslash (?\backslash )\backslash (?\backslash )\backslash (?\backslash )?\backslash (?\backslash )$ Year $2$ Quarter $3?4\backslash (?\backslash )\backslash (?\backslash )\backslash (?\backslash )4$ Year $???????????\backslash (?\backslash )4?$ Year