Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 marksimage text in transcribedimage text in transcribed

\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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Finance For Non Specialists

Authors: Eddie McLaney

9th Edition

1292062711, 9781292062716

More Books

Students also viewed these Accounting questions

Question

Did you offer hard data that is verifiable? [D]

Answered: 1 week ago