With the data attached below, please complete the excel portion listed below with steps on how to do it. Will give the biggest thumbs-up possible. Thank you!!

Requirements:

ERBs summary of ingredients, list of selling and administrative expenses, and the 2022 Balance Sheet are on an Excel file (ERB Information). Using this information, prepare a data input sheet for all data need for ERBs Master Budget. Note: a number, whether dollars, units, percentages, etc., should only be entered on this worksheet once and no other worksheet. You should use formulas to reference this data, even if repeated in the data input sheet. This sheet represents the assumptions that you will share with management. Do not perform calculations that are to be shown in budgets.

On the same Excel file (change file name for your group), prepare the following budgets, in good form (proper use of headings, dollar signs, formatting (numbers lined up, underlines, and double underlines), whole dollars except for per unit costs, same font size and type). You may show these all in one worksheet (not in the data input sheet) flowing vertically down or in separate worksheets (label tab for each):

Sales Budget for each product and total company (each quarter and total for 2024)

Sales Cash Collection Budget-total for company (each quarter and total for 2024)

Production Budget for each product (each quarter and total for 2024) Check figure: Total required production of muffins for the year is 161,290 units.

Direct Materials Needed Budget for each product and respective materials needed, beginning and ending inventories, units and cost (each quarter and total for 2024) Check figure: 1^st quarter total cost of direct materials to be purchased is $212,567.

Purchases Budget for Materials-total for company (each quarter and total for 2024)

Direct Labor Budget-labor hours and cost for each product line (including each department) and total cost for each department and total for company (each quarter and total for 2024)

Manufacturing Overhead Budget-variable and fixed accrual basis and cash basis (each quarter and total for 2024)

Ending Finished Goods Inventory-per unit production costs for each product and total cost per product line and total company at December 31, 2024

Selling and Administrative Budget- variable (by product line) and fixed (each line item) (each quarter and total for 2024)

Cash Budget (each quarter and total for 2024) Check figure: 3^rd Qtr. Ending cash balance is $126,978.

Income Statement (each quarter and total for 2024)

Balance Sheet (as of December 31, 2024) Check figure: Total Assets $2,565,819

Winter 2023 Exhibit 1 Summary of Ingredients Exhibit 2 List of S \& A Expenses Per Quarter Exhibit 3 ERB Balance Sheet As of 12-31-2023 Assets Current Assets: Liabilities and Stock Holder's Equity Liabilities \begin{tabular}{l|r|r} \hline Accounts Payable & $31,648 & \\ \hline Mortgage Payable & 1,109,969 & \\ \cline { 1 - 2 } Total Liabilities & & $1,141,617 \end{tabular} Stockholder's Equity Common Stock (no par value; Winter 2023 Exhibit 1 Summary of Ingredients Exhibit 2 List of S \& A Expenses Per Quarter Exhibit 3 ERB Balance Sheet As of 12-31-2023 Assets Current Assets: Liabilities and Stock Holder's Equity Liabilities \begin{tabular}{l|r|r} \hline Accounts Payable & $31,648 & \\ \hline Mortgage Payable & 1,109,969 & \\ \cline { 1 - 2 } Total Liabilities & & $1,141,617 \end{tabular} Stockholder's Equity Common Stock (no par value