90.2K

Verified Solution

Link Copied!

NEED EXCEL FORMULAS

____________________

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline A & B40% & in the quarter & \begin{tabular}{c} D \\ Tonowing purch \end{tabular} & inase & E & f & G & H \\ \hline 19 - Accounts payable for raw materials, beginning balance & $81,500 & & & & & & & \\ \hline & & & & & & & & \\ \hline 1 Enter a formula into each of the cells marked with a ? be & & & & & & & & \\ \hline 22. Review Problem: Budget Schedules & & & & & & & & \\ \hline & & & & & & & & \\ \hline 24 Construct the sales budget & & Year 2Q & Quarter & & & Year 3 & 3 Quarter & \\ \hline 25 & 1 & 2 & 3 & r & 4 & 1 & 2 & \\ \hline 26. Budgered unt sales & ? & ? & ? & & ? & & ? & \\ \hline 27 Selling price per unit & ? & ? & ? & & ? & & ? & \\ \hline 28 Total sales & ? & ? & ? & & ? & & ? & 31 \\ \hline Y & & & & & & & & \\ \hline 30 Construct the schedule of expected cash collections & & Year 20 & Quarter & & & & & \\ \hline & 1 & 2 & 3 & r & 4 & Year & & \\ \hline 32 Accounts receivable, beginning balance & ? & & & & & ? & & \\ \hline 33 First-quarter sales & ? & ? & & & & ? & & \\ \hline 34 Second-quarter saies & & ? & ? & & & ? & & \\ \hline 35 Third-quarter saies & & & ? & & ? & ? & & \\ \hline 36 Fourth-quarter saies & & & & & ? & ? & & \\ \hline Total cash collections & ? & ? & ? & & ? & ? & & \\ \hline & & & & & & & & \\ \hline 9. Construct the production budget & & Year 2Q & Quarter & & & & Year 30 & Quarter \\ \hline & 1 & 2 & 3 & r & 4. & Yoar & 1 & 2 \\ \hline Budgeted unit sales & ? & ? & ? & & ? & ? & ? & ? \\ \hline Add desired finished goods inventory & ? & ? & ? & & ? & ? & ? & \\ \hline Total needs & ? & ? & ? & & ? & ? & ? & \\ \hline Less beginning inventory & ? & ? & ? & & ? & ? & ? & \\ \hline Required production & ? & ? & ? & & ? & ? & ? & \\ \hline \end{tabular} A1 f4 Chapter 8: Applving Excel Chapter B: Applying Excel 76. Selling price per unit 8. - Accounts receivable, beginning balance 9 - Sales collected in the quarter sales are made 10 - Sales collected in the quarter affer sales are made- 11 . Desired ending finished goods inventory is 12 . Finished goods inventory, beginning 13 - Raw materials required to produce one unit 14 - Desired ending inventory of raw materials is 15 - Ranw materials inventory, beginning 16 . Raw material costs 17 - Raw materials purchases are paid 18 and 19 . Accounts payabie for raw materials, beginning balance

Answer & Explanation Solved by verified expert

See Answer