excel spread sheet

please include formulas

- Rows 35 and beyond must be calculated amounts. Other than dividing by the numeral 4 to convert an annual amount to a quarterly amount there should not be any 'hard' numbers in your solution. - First quarter unit sales should be 35,100 with the expected quarterly increase in unit sales to be twelve percent. - Since you will have step by step guide late submissions with not be counted. - Use the supplied template only. - Disregard row \#30 - Dividends. There are no dividends in this semester's version of the problem. YOUR NAME HERE \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|c|}{ Either reforence another cell or enter a formula into each of the cells marked with a? } \\ \hline \multicolumn{8}{|c|}{ Data and Budgetary Assumptions } \\ \hline \multirow[t]{2}{*}{ - Expected Change in Unit Sales } & 0.0% & \multicolumn{2}{|c|}{ increase per quarter } & & \multirow{2}{*}{\multicolumn{3}{|c|}{ Year 2, Quarter }} \\ \hline & \multicolumn{3}{|c|}{ Year 1, Quarter } & & & & \\ \hline Quarters & 1 & 2 & 3 & & \multicolumn{3}{|c|}{\begin{tabular}{l} Year 2, Quarter \\ 1 \end{tabular}} \\ \hline - Budgeted unit sales & ? & ? & ? & ? & & & \\ \hline Selling price per unit & 515.00 & & & & & & \\ \hline - Accounts receivable, beginning balance & 0.00 & & & & & & \\ \hline - Sales collected in the quarter sales are made & 30% & & & & & & \\ \hline - Sales collected in the quarter after sales are made & 70% & & & & & & \\ \hline - Desired ending finished goods inventory is & 20% & of the bu & ed unit : & of th & & & \\ \hline - Finished goods inventory, beginning & 0 & units & & & & & \\ \hline - Raw materials required to produce one unit & 5.0 & pounds & & & & & \\ \hline - Desired ending inventory of raw materials is & 10% & of the ne & uarter's & & & & \\ \hline - Raw materials inventory, beginning & 0 & pounds & & & & & \\ \hline - Raw material costs & 0.75 & per poun & & & & & \\ \hline - Raw materials purchases are paid & 30% & in the qu & the pur & esa & & & \\ \hline and & 70% & in the qu & followin & teha & & & \\ \hline - Accounts payable for taw materials, beginning balance & & & & & & & \\ \hline \begin{tabular}{l} - Direct Labor Hours per Unit \\ - Cost per Direct Labor Hour \end{tabular} & \begin{tabular}{l} 0.350 \\ 15.00 \end{tabular} & & & & & & \\ \hline - Fixed Overhead Costs. & $600,000 & per year & & & & & \\ \hline - Variable Overhead Costs per Direct Labor Hour & $3.25 & & & & & & \\ \hline - Annual Depreciation & $100,000 & & & & & & \\ \hline - Selling \& Admin. Expenses per year & $250,000 & & & & & & \\ \hline - Beginning Cash balance & $65,000 & & & & & & \\ \hline - Bonds, issued 1/1/Year1 & $500,000 & Face am & & & & & \\ \hline - Annual interest on Bonds, Interest is paid semiannu & 5.0% & annual f & ate (cou & rate) & & & \\ \hline - Dividends paid in Quarter 4 & 10% & of budg & pretax & & & & \\ \hline \end{tabular} Eithar rofarance annthor call arantar a formila inta aach af the calle markad with o? Master Budget A30 \begin{tabular}{|l|l|} \hline 31 & \multicolumn{2}{|c|}{ Either reference another cell or on } \\ \hline 32 & Budget Schedules \\ 33 & \\ 34 & Construct the sales budget \\ 36 & \\ 37 & Budgeted unit sales \\ 38 & Selling price per unit \\ 39 & Total sales \\ 40 & \\ 41 & Construct the schedule of expected cash collections \\ 42 & \\ 43 & Boginning balance accounts teceivable \\ 44 & First-quarter sales \\ 45 & Second-quarter sales \\ 45 & Third-quarter sales \\ 47 & Fourth-quarter sales \\ 48 & Total cash collections \\ 49 & \\ 50 & Construct the production budget \\ 51 & \\ 52 & Budgeted unit sales \\ \hline 53 & Add desired ending finished goods inventory \\ 54 & Total needs \\ 55 & Less beginning finished goods inventory \\ 56 & Requited production in units \end{tabular} Construct the Direct Materials purchases budget Required production (units) Raw materials required to produce one unit (pounds) Production needs (pounds) Add desired ending inventory of raw materials (pounds) Total needs (pounds) Less beginning inventory of raw materials (pounds) Raw materials to be purchased (pounds) Cost of raw materials per pound Cost of raw materials to be purchased Construct the Direct Labor budget Required production in units Direct Labor Hours per unit Direct Labor Hours required for Production Cost por DuHr Total Cost of Direct Labor to be paid A30 :Xfx. Dividends paid in Quarter 4 A30 - Rows 35 and beyond must be calculated amounts. Other than dividing by the numeral 4 to convert an annual amount to a quarterly amount there should not be any 'hard' numbers in your solution. - First quarter unit sales should be 35,100 with the expected quarterly increase in unit sales to be twelve percent. - Since you will have step by step guide late submissions with not be counted. - Use the supplied template only. - Disregard row \#30 - Dividends. There are no dividends in this semester's version of the problem. YOUR NAME HERE \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|c|}{ Either reforence another cell or enter a formula into each of the cells marked with a? } \\ \hline \multicolumn{8}{|c|}{ Data and Budgetary Assumptions } \\ \hline \multirow[t]{2}{*}{ - Expected Change in Unit Sales } & 0.0% & \multicolumn{2}{|c|}{ increase per quarter } & & \multirow{2}{*}{\multicolumn{3}{|c|}{ Year 2, Quarter }} \\ \hline & \multicolumn{3}{|c|}{ Year 1, Quarter } & & & & \\ \hline Quarters & 1 & 2 & 3 & & \multicolumn{3}{|c|}{\begin{tabular}{l} Year 2, Quarter \\ 1 \end{tabular}} \\ \hline - Budgeted unit sales & ? & ? & ? & ? & & & \\ \hline Selling price per unit & 515.00 & & & & & & \\ \hline - Accounts receivable, beginning balance & 0.00 & & & & & & \\ \hline - Sales collected in the quarter sales are made & 30% & & & & & & \\ \hline - Sales collected in the quarter after sales are made & 70% & & & & & & \\ \hline - Desired ending finished goods inventory is & 20% & of the bu & ed unit : & of th & & & \\ \hline - Finished goods inventory, beginning & 0 & units & & & & & \\ \hline - Raw materials required to produce one unit & 5.0 & pounds & & & & & \\ \hline - Desired ending inventory of raw materials is & 10% & of the ne & uarter's & & & & \\ \hline - Raw materials inventory, beginning & 0 & pounds & & & & & \\ \hline - Raw material costs & 0.75 & per poun & & & & & \\ \hline - Raw materials purchases are paid & 30% & in the qu & the pur & esa & & & \\ \hline and & 70% & in the qu & followin & teha & & & \\ \hline - Accounts payable for taw materials, beginning balance & & & & & & & \\ \hline \begin{tabular}{l} - Direct Labor Hours per Unit \\ - Cost per Direct Labor Hour \end{tabular} & \begin{tabular}{l} 0.350 \\ 15.00 \end{tabular} & & & & & & \\ \hline - Fixed Overhead Costs. & $600,000 & per year & & & & & \\ \hline - Variable Overhead Costs per Direct Labor Hour & $3.25 & & & & & & \\ \hline - Annual Depreciation & $100,000 & & & & & & \\ \hline - Selling \& Admin. Expenses per year & $250,000 & & & & & & \\ \hline - Beginning Cash balance & $65,000 & & & & & & \\ \hline - Bonds, issued 1/1/Year1 & $500,000 & Face am & & & & & \\ \hline - Annual interest on Bonds, Interest is paid semiannu & 5.0% & annual f & ate (cou & rate) & & & \\ \hline - Dividends paid in Quarter 4 & 10% & of budg & pretax & & & & \\ \hline \end{tabular} Eithar rofarance annthor call arantar a formila inta aach af the calle markad with o? Master Budget A30 \begin{tabular}{|l|l|} \hline 31 & \multicolumn{2}{|c|}{ Either reference another cell or on } \\ \hline 32 & Budget Schedules \\ 33 & \\ 34 & Construct the sales budget \\ 36 & \\ 37 & Budgeted unit sales \\ 38 & Selling price per unit \\ 39 & Total sales \\ 40 & \\ 41 & Construct the schedule of expected cash collections \\ 42 & \\ 43 & Boginning balance accounts teceivable \\ 44 & First-quarter sales \\ 45 & Second-quarter sales \\ 45 & Third-quarter sales \\ 47 & Fourth-quarter sales \\ 48 & Total cash collections \\ 49 & \\ 50 & Construct the production budget \\ 51 & \\ 52 & Budgeted unit sales \\ \hline 53 & Add desired ending finished goods inventory \\ 54 & Total needs \\ 55 & Less beginning finished goods inventory \\ 56 & Requited production in units \end{tabular} Construct the Direct Materials purchases budget Required production (units) Raw materials required to produce one unit (pounds) Production needs (pounds) Add desired ending inventory of raw materials (pounds) Total needs (pounds) Less beginning inventory of raw materials (pounds) Raw materials to be purchased (pounds) Cost of raw materials per pound Cost of raw materials to be purchased Construct the Direct Labor budget Required production in units Direct Labor Hours per unit Direct Labor Hours required for Production Cost por DuHr Total Cost of Direct Labor to be paid A30 :Xfx. Dividends paid in Quarter 4 A30