project Master Budget project Attached Files: Master Budget Project xlsx 27.938 KB) UPDATED FILE: Please see the check answers on the first tab for revised values. Also, tab 1() make sure you sum all four production costs (cells LS:LB) Instructions: You will be completing a master budget for this project (Refer to Chapter 8 of the textbook and your lecture notes). First, you 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 (all 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 yellow (as you enter calculations/inputs, the yellow color in the cell will 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 300 ili z A OS stv F 12 Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF A Master Budget Project (1) me Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 ' 29 Wrap Text Custom Paste B TU 1000 A Merge & Center $ %) 88 Conditional Forn Formatting as Xfx H 1 K Paige Monroe Company Selling general, and administrative (SGA) budget For the year ended December 31, 2022 Quartet Quarter 2 Quarter) Quarter 4 Total Vor 2022) Assumptions for inputs Sales commissions of sales revenue Delivery cost per unit sold (per sales forecast) Salaries per quarter Rent per month Depreciation per year 3X $ 2.50 5 8,500 $ 5.000 $ 20,000 Sales commissions Delivery expenses Salaries openses Officerent Depreciation expenses Total SG. A expenses b 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 33 36 Key 16 10 id 11 10 IN Ready 12 tv ST project Master Budget project Attached Files: Master Budget Project xlsx 27.938 KB) UPDATED FILE: Please see the check answers on the first tab for revised values. Also, tab 1() make sure you sum all four production costs (cells LS:LB) Instructions: You will be completing a master budget for this project (Refer to Chapter 8 of the textbook and your lecture notes). First, you 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 (all 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 yellow (as you enter calculations/inputs, the yellow color in the cell will 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 300 ili z A OS stv F 12 Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF A Master Budget Project (1) me Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 ' 29 Wrap Text Custom Paste B TU 1000 A Merge & Center $ %) 88 Conditional Forn Formatting as Xfx H 1 K Paige Monroe Company Selling general, and administrative (SGA) budget For the year ended December 31, 2022 Quartet Quarter 2 Quarter) Quarter 4 Total Vor 2022) Assumptions for inputs Sales commissions of sales revenue Delivery cost per unit sold (per sales forecast) Salaries per quarter Rent per month Depreciation per year 3X $ 2.50 5 8,500 $ 5.000 $ 20,000 Sales commissions Delivery expenses Salaries openses Officerent Depreciation expenses Total SG. A expenses b 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 33 36 Key 16 10 id 11 10 IN Ready 12 tv ST