1 Chapter 8: Applying Excel Data Budgeted unit sales - Selting price per unt - Accounts recelvable, 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 materats required to produce one unit - Desired ending inventory of raw materials is - Raw materials inventory, beginning - Raw materlal costs - Raw moterials purchases are pald and - Accounts payable for raw materials, beginning balance 40,0001 - Yoar2 Quartor 260,0003 se per unit $65,000 75% 25% 30% of the budgeted uns sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 \begin{tabular}{|c|c|} \hline Year 3 Quarter \\ \hline 1 & 2 \\ 70,000 & 80,000 \end{tabular} 50,000 \begin{tabular}{l} 1 \\ 70,000 \\ \hline \end{tabular} 80,000 Enter a formula into each of the colls marked with a ? below Review Problem: Budget Schedules