Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF @@@ Master Budget Project (1) ome Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) ' = Wrap Text General LO BTU OA Merge & Center $ % 9 11 ce Paste Conditional Formatting a 010 x fx D E 1 10 1. Operating budgets Link to tab Checkpoints to verify your work Sales budget 18 b. Production budget (Manufacturers only) / Purchases budget (Retailers only) 16 Total (for 2022) budgeted production -52.582 4 c. Direct materials budget (Manufacturers only) d. Direct labor budget (Monufacturers only) Ad 6. Manufacturing overhead budgets (Manufacturers only) 10 7. Cost of goods sold budget Total for 2022) cost of goods sold $1,315,154 & Selling, general, and administrative budget 1 h. Budgeted income statement Net Income: 5472.920 2. Financial budgets 21 Cash receipts budget 20 Do not complete these budgetul 12 b. Capital expenditures budget 26 11 c. Cash disbursements budget 26 14 d. Cash budget 20 13. Budgeted balance sheet 26 17 You must et input) all cells that are yellow throughout the spreadsheet All other values are automatically calculated based on inputs 15 Management assumptions to help you determine the inputs are gray throughout the seadsheet 19 20 21 22 23 34 25 20 27 16 29 30 22 15 10 10 10 TO th Foudy 13 dtv F N ili z AV ister Budget Project (1) :)) Wed Apr 1 Share General $ % VO V 00 > 0 Dv Conditional Format Cell Formatting as Table Styles Insert Delete Format Sort & v Filter Find & Select M N o P Q 5 Per Unit Assumptions for inputs Amount Cost DM cost per unit sold DL cost per unit sold Var. Overhead cost per unit Fixed Overhead cost per unit COGS per unit -> Budgeted variable overhead rate -> Predetermined overhead rate table)x#of DL hours per unit tab id) Excel File Edit View AutoSave Insert Format Tools Data Window Help 2 OFF Home Insert Draw Page Layout Formulas Master E Data X Review View Calibri (Body) Tell me 11 Paste == BIU 2 Wrap Text v V G G14 x fx hil Merge & Center $ D E 1 2 3 4 S G H Palge Monroe Company Cost of goods sold (COGS) budget For the year ended December 31, 2022 6 7 Salesforecast 8XCOGS per unit 9 Budgeted cost of goods sold 10 11 12 13 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total (For 2022) 12500 UNIT 12750 UNIT 13005 UNIT 13265 UNIT 51250 UNIT $ 24.90 $ 24.90 $ 24.90 $ 24.90 $ 24.90 S 311,250 $ 317,475 $ 323,825 $ 330,301 $ 1,282,850 DM Cost DL cost pe Var. Over Fixed Over COGS per 15 16 17 18 19 20 21 22 23 24 25 26 Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF @@@ Master Budget Project (1) ome Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) ' = Wrap Text General LO BTU OA Merge & Center $ % 9 11 ce Paste Conditional Formatting a 010 x fx D E 1 10 1. Operating budgets Link to tab Checkpoints to verify your work Sales budget 18 b. Production budget (Manufacturers only) / Purchases budget (Retailers only) 16 Total (for 2022) budgeted production -52.582 4 c. Direct materials budget (Manufacturers only) d. Direct labor budget (Monufacturers only) Ad 6. Manufacturing overhead budgets (Manufacturers only) 10 7. Cost of goods sold budget Total for 2022) cost of goods sold $1,315,154 & Selling, general, and administrative budget 1 h. Budgeted income statement Net Income: 5472.920 2. Financial budgets 21 Cash receipts budget 20 Do not complete these budgetul 12 b. Capital expenditures budget 26 11 c. Cash disbursements budget 26 14 d. Cash budget 20 13. Budgeted balance sheet 26 17 You must et input) all cells that are yellow throughout the spreadsheet All other values are automatically calculated based on inputs 15 Management assumptions to help you determine the inputs are gray throughout the seadsheet 19 20 21 22 23 34 25 20 27 16 29 30 22 15 10 10 10 TO th Foudy 13 dtv F N ili z AV ister Budget Project (1) :)) Wed Apr 1 Share General $ % VO V 00 > 0 Dv Conditional Format Cell Formatting as Table Styles Insert Delete Format Sort & v Filter Find & Select M N o P Q 5 Per Unit Assumptions for inputs Amount Cost DM cost per unit sold DL cost per unit sold Var. Overhead cost per unit Fixed Overhead cost per unit COGS per unit -> Budgeted variable overhead rate -> Predetermined overhead rate table)x#of DL hours per unit tab id) Excel File Edit View AutoSave Insert Format Tools Data Window Help 2 OFF Home Insert Draw Page Layout Formulas Master E Data X Review View Calibri (Body) Tell me 11 Paste == BIU 2 Wrap Text v V G G14 x fx hil Merge & Center $ D E 1 2 3 4 S G H Palge Monroe Company Cost of goods sold (COGS) budget For the year ended December 31, 2022 6 7 Salesforecast 8XCOGS per unit 9 Budgeted cost of goods sold 10 11 12 13 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total (For 2022) 12500 UNIT 12750 UNIT 13005 UNIT 13265 UNIT 51250 UNIT $ 24.90 $ 24.90 $ 24.90 $ 24.90 $ 24.90 S 311,250 $ 317,475 $ 323,825 $ 330,301 $ 1,282,850 DM Cost DL cost pe Var. Over Fixed Over COGS per 15 16 17 18 19 20 21 22 23 24 25 26
