T. Prepare a master budget for the year ended December 31, 2024 that includes the following: Projected Sales Budgot, Expected Cash Colloctions Budget, Production Budget, Variable Product Cost per Unit Caleulation, Raw Materials Budget, Direct Laber Budget, Manufacturing Overhead Budget, Solling \& Administrative Budget, Cash Budget, Budgeted Income Statement, \& Budgeted Balance Sheet. Each budget should be completed as it appears in your template. There is a template provided to you in the ossionments link in the Excel Prolect folder with en INPUIS tab you MUE use. Complete the vellow shaded areas of the tomplate only All of your spreadsheets must be formula drivenl This means that EVERY cell should contain either a value referenced from the input worksheet or a formula manually entered into the cell using the referenced values or the input values. You should NOT type a number the entire fime you are werking on this proiest. Any typed numbers will cost you 2 points per instance. There is a purpose to this requirement that we hope you understand. The beauty (usefulness) of linking your spreadsheets to an inputs page is when something changes, such as the cost per unit of raw materials, you don't have to go through the entire budget to fix every cell that used that value. Instead, when you change it on the inputs tab, it will automatically change every cell which used that value within your entire budget. This becomes even more useful as your spreadsheets become more complex. 1 2 3 5 \begin{tabular}{|l|c|c|} \hline \multicolumn{3}{|c|}{ Projected Sales Budge } \\ \hline & Quarter 1 & Quarter 2 \\ \hline & & \\ \hline Total Pouns of Butter Sold & & \\ \hline Selling Price per Pound of Butter & & \\ \hline Total Sales & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ CHECK TOTALS } \\ \hline \multicolumn{4}{|l|}{ Sales: } \\ \hline Sum across 4 quarters & $ & - & \\ \hline Working down Total column & $ & - & \\ \hline Difference & $ & & (should be 50 ) \\ \hline Provided Check Figure & & 1,787,300,000 & (check for match) \\ \hline \multicolumn{4}{|l|}{ Cash Collections: } \\ \hline Sum across 4 quarters & $ & - & \\ \hline Working down Total column & $ & - & \\ \hline Difference & $ & & (should be \$0) \\ \hline Provided Check Figure & & 1,769,310,000 & (check for match) \\ \hline \end{tabular} Quarter 1 \begin{tabular}{|l|} \hline Quarter 2 \\ \hline \\ \hline \end{tabular} E G H Collections of Current Quarter Sales Collections of Prior Quarter Sales sh Collections 19 2322 25 2725 26 29 30 31 32 33 34 Cash Collections: Sum across 4 quarters Working down Total column Difference Provided Check Fiqure Expected Cash Collections Budget 2024 Quarter 4 Total
