from $$8$ to $$7.$ The marketing manager would like to use the following projections in the budget: Year $2$ Quarter Year $3$ Quarter Data Budgeted unit sales Selling price per unit $45,000$ $$770,000115,00060,00085,00095,000$ References D E Chapter $9$: Applying Excel $2$ Data Year $3$ Quarter $2$ Budgeted unit sales $45,00070,000115,00060\mathrm{.}00085,00095,000$ Selling price per unit $ $7$ per unit $$ Accounts receivable, beginning balance $ $65,000$ 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 materal costs $0\mathrm{.}80$ per pound $1718$ Raw materials purchases are paid $60\%$ in the quarter the purchases are made and $40\%$ in the quarter following purchase $19$ Accounts payable for raw materials, beginning balance $81,500$