ACCT 3310 Excel Budgeting Assignment Given the assumptions on the following page, develop a spreadsheet using Excel that will generate the following: (1) The Operating Budgets (Sales Budget, Production Budget, Direct Materials Budget, Direct Labor Budget, Manufacturing/Factory Overhcad Budget, and Selling & Administrative Expense Budget) by quarter and with a column for total year 2) The Financial Budgets (Budgeted Income Statement, Cash Budget, and Budgeted Balance Sheet). Prepare the Cash Budget by quarter and with a column for total year. Prepare only one Budgeted Income Statement for the entire year, and one Budgeted Balance Sheet for the end of the year (end of quarter 4 Use the template provided as a guide, along with the illustrations provided in Chapter 10 Important: When developing this spreadsheet, set it up to easily accommodate changes to the attached assumptions; I guarantee you that I will ask you to make changes to these assumptions eventually ACCT 3310 Excel Budgeting Assignment Given the assumptions on the following page, develop a spreadsheet using Excel that will generate the following: (1) The Operating Budgets (Sales Budget, Production Budget, Direct Materials Budget, Direct Labor Budget, Manufacturing/Factory Overhcad Budget, and Selling & Administrative Expense Budget) by quarter and with a column for total year 2) The Financial Budgets (Budgeted Income Statement, Cash Budget, and Budgeted Balance Sheet). Prepare the Cash Budget by quarter and with a column for total year. Prepare only one Budgeted Income Statement for the entire year, and one Budgeted Balance Sheet for the end of the year (end of quarter 4 Use the template provided as a guide, along with the illustrations provided in Chapter 10 Important: When developing this spreadsheet, set it up to easily accommodate changes to the attached assumptions; I guarantee you that I will ask you to make changes to these assumptions eventually