Question: Please help me with this excel. It is about Master Budgeting. Insert the right numbers to the questions marks begin{tabular}{|c|c|c|c|c|c|c|c|} hline multicolumn{8}{|l|}{ Chapter 8: Applying

Please help me with this excel. It is about Master Budgeting. Insert the right numbers to the questions marksPlease help me with this excel. It is about Master Budgeting. Insertthe right numbers to the questions marks \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|l|}{ Chapter 8:

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|l|}{ Chapter 8: Applying Excel } \\ \hline \multirow[t]{2}{*}{ Data } & \multicolumn{4}{|c|}{ Year 2 Quarter } & \multicolumn{2}{|c|}{ Year 3 Quarter } & \\ \hline & 1 & 2 & F & & F & 2 & \\ \hline Budgeted unit sales & 40.000 & 60.000 & 100.000 & 50.000 & 70.000 & 80.000 & \\ \hline - Selling price per unit & $8 & per unit & & & & & \\ \hline - Accounts receivable, beginning balance & $65.000 & & & & & & \\ \hline - Sales collected in the quarter sales are made & 75% & & & & & & \\ \hline - Sales collected in the quarter after sales are made & 25% & & & & & & \\ \hline - Desired ending finished goods inventory is & 30% & \multicolumn{4}{|c|}{ of the budgeted unit sales of the next quarter } & & \\ \hline - Finished goods inventory, beginning & 12.000 & units & & & & & \\ \hline - Raw materials required to produce one unit & 5 & pounds & & & & & \\ \hline - Desired ending inventory of raw materials is & 10% & \multicolumn{3}{|c|}{ of the next quarter's production needs } & & & \\ \hline - Raw materials inventory, beginning & 23.000 & pounds & & & & & \\ \hline - Raw material costs & $0,80 & per pound & & & & & \\ \hline - Raw materials purchases are paid & 60% & \multicolumn{3}{|c|}{ in the quarter the purchases are made } & & & \\ \hline and & 40% & \multicolumn{3}{|c|}{ in the quarter following purchase } & & & \\ \hline - Accounts payable for raw materials, beginning balance & $81.500 & & & & & & \\ \hline \multicolumn{8}{|l|}{ Enter a formula into each of the cells marked with a ? below } \\ \hline \multicolumn{8}{|l|}{ Review Problem: Budget Schedules } \\ \hline \multirow[t]{2}{*}{ Construct the sales budget } & \multicolumn{4}{|c|}{ Year 2 Quarter } & \multicolumn{2}{|c|}{ Year 3 Quarter } & \\ \hline & 1 & F & 3 & 4 & F & F & \\ \hline Budgeted unit sales & ? & ? & ? & ? & ? & ? & \\ \hline Selling price per unit & ? & & ? & ? & ? & ? & \\ \hline Total sales & ? & ? & ? & ? & ? & ? & \\ \hline \multirow{2}{*}{ Construct the schedule of expected cash collections } & \multicolumn{4}{|c|}{ Year 2 Quarter } & & & \\ \hline & 1 & 2 & 3 & F & Year & & \\ \hline Accounts receivable, beginning balance & ? & & & & ? & & \\ \hline First-quarter sales & ? & ? & & & ? & & \\ \hline Second-quarter sales & & ? & ? & & ? & & \\ \hline Third-quarter sales & & & ? & ? & ? & & \\ \hline Fourth-quarter sales & & & & ? & ? & & \\ \hline Total cash collections & ? & ? & ? & ? & ? & & \\ \hline \multirow[t]{2}{*}{ Construct the production budget } & \multicolumn{4}{|c|}{ Year 2 Quarter } & & \multicolumn{2}{|c|}{ Year 3 Quarter } \\ \hline & 1 & 2 & & r & Year & 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}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!