Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF Master Budget Project (1) Home Formulas Data Review View Tell me ' ' = 2Wrap Text Custom Insert Draw Page Layout Calibri (Body) 11 18 BIU * fx Paste Merge & Center $ % Conditional Form Formatting as Tol A G H 1 2 Paige Monroe Company Selling general, and administrative (GRA) budget For the year ended December 31, 2022 4 5 Assumptions for inputs Sales commission as of sales revence Delivery cost per unitsold per sales forecast) Salaries per quarter Rent per month Depreciation per yew Quarter 1 Quarter 2 Quarter Quarter 4 Total Vor 2022) IN $2.50 $3,500 55.000 5.20,000 2 Sales common Delivery open Salaries expenses Onicerent Depreciation expenses Total SOBA expenses 10 31 12 13 14 15 16 17 18 19 20 21 22 21 26 25 26 27 29 30 11 12 31 34 15 10 10 1d 11 Te 1 10 Key Ready 12 : dtv S1 . MacBook Pro Eing Course Content Budget project Budget project Master Budget project Attached Files: Master Budget Project xlsx 127.938 KB) UPDATED FILE: Please see the "check answers" on the first tab for revised values. Also, tab 10 make sure you sum all four production costs (cells LS:La) Instructions: You will be completing a master budget for this project (Refer to Chapter 8 of the textbook and your lecture notes). Frstyou will want to open the Excel file below in the Excel file you will find the following: Key: A list of all the operating and financial budgets included in the Excel file and a link to each tab, some general comments about color coding throughout the spreadsheet, AS WELL AS a few checkpoint numbers to check your work as you move along A tab for each budget (al of the information required to complete the budgets is included throughout the spreadsheet Required: Complete each budget by using Excel formulas to fill in calculate each coll that is highlighted yelow (as you enter calculations inputs, the yelow color in the cell wil disappear). Some calculations, formulas, or numbers are already filled in for you throughout the sheet. Finally, turn in your completed excel sheet **Open and save the file as Lastname_Firstname ** You will not manually type numbers into the yellow cells. In order to obtain full credit, you must use a formula for EACH AND EVERY input into the yellow cells." **Submitted files that are not in a Microsoft Excel format will not be graded." Master Budget Submit your completed Master Budget project here Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF Master Budget Project (1) Home Formulas Data Review View Tell me ' ' = 2Wrap Text Custom Insert Draw Page Layout Calibri (Body) 11 18 BIU * fx Paste Merge & Center $ % Conditional Form Formatting as Tol A G H 1 2 Paige Monroe Company Selling general, and administrative (GRA) budget For the year ended December 31, 2022 4 5 Assumptions for inputs Sales commission as of sales revence Delivery cost per unitsold per sales forecast) Salaries per quarter Rent per month Depreciation per yew Quarter 1 Quarter 2 Quarter Quarter 4 Total Vor 2022) IN $2.50 $3,500 55.000 5.20,000 2 Sales common Delivery open Salaries expenses Onicerent Depreciation expenses Total SOBA expenses 10 31 12 13 14 15 16 17 18 19 20 21 22 21 26 25 26 27 29 30 11 12 31 34 15 10 10 1d 11 Te 1 10 Key Ready 12 : dtv S1 . MacBook Pro Eing Course Content Budget project Budget project Master Budget project Attached Files: Master Budget Project xlsx 127.938 KB) UPDATED FILE: Please see the "check answers" on the first tab for revised values. Also, tab 10 make sure you sum all four production costs (cells LS:La) Instructions: You will be completing a master budget for this project (Refer to Chapter 8 of the textbook and your lecture notes). Frstyou will want to open the Excel file below in the Excel file you will find the following: Key: A list of all the operating and financial budgets included in the Excel file and a link to each tab, some general comments about color coding throughout the spreadsheet, AS WELL AS a few checkpoint numbers to check your work as you move along A tab for each budget (al of the information required to complete the budgets is included throughout the spreadsheet Required: Complete each budget by using Excel formulas to fill in calculate each coll that is highlighted yelow (as you enter calculations inputs, the yelow color in the cell wil disappear). Some calculations, formulas, or numbers are already filled in for you throughout the sheet. Finally, turn in your completed excel sheet **Open and save the file as Lastname_Firstname ** You will not manually type numbers into the yellow cells. In order to obtain full credit, you must use a formula for EACH AND EVERY input into the yellow cells." **Submitted files that are not in a Microsoft Excel format will not be graded." Master Budget Submit your completed Master Budget project here