Chapte$\_8\_$Applying$\_$Excel$\_$Student$\_$Form $(7)-1$

$\backslash$table$[[$Chapter $8$: Apply ing Excel,,,,$],[,,4_{?},sin,],[$Data$,$Year $2$ Quarter$],[,1,2,3,4],[$Budgeted unit sales,$40,000,60,000,100,000,50,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 qu$],[-$ Finished goods inventory, beginning,$12,000,$units,,$],[-$ Raw mater ials required to produce one unit,$5,$pounds,,$],[-$ Des ired ending inventory of raw mater isk is$,10\%,$of the next quarter's production needs$],[-$ Raw mater isls inventory, beginning,$23,000,$pounds,,$],[-$ Raw material costs,$$0\mathrm{.}80,$per pound,$($I$.,],[-$ Raw mater ials purchas es are paid,$60\%,$in the quarter the purchas es are made$],[$and$,40\%,$in the quarter follow ing purchase$],[-$ Accounts payable for raw materials, beginning balance,$$81,500,,,],[,,,,],[$Enter a form ula into each of the cells $m$ arked with a $?$ below$],[$Review Problem: Budget Schedules$],[,,,,],[$Construct the sales budget,Year $2$ Quarter$],[1,2,3,4],[$Budgeted unit sales,$40,000,60,000,100,000,50,000],[$Selling price per unit,$$9,$$$8,$$$8,$$$8$