0 M Paige Monroe Company Manufacturing overhead budget for the year ended December 31, 2022 Quarter 1 Quarter 2 Quarter Quarter Total For 20221 12508 UNIT 12758 UNIT 13013 UNIT 13273 UNIT 51551 UNIT 5 95 95 95 95 9 $ 112.5685 114,6195 117, 1155 119.4585 463,999 Assumptions for inputs Variable overhead cost per unit 5 9 Depreciation per month $ 1.200 Supervisionare per quarter $6.000 Cost driver DL hou 10 11 1 buted production Vico Hudorable read buted overhead Depreciation Superior Tot ved Bedructuring overtas $ 5 5 5 1,700 6.000 7,700 120.2685 1.100 6.000 7,700 122,519 1.700 5 6,000 7,700 5 114,8155 1,7005 6,000 5 7.700 S 127.158 6.100 24000 30.800 10 17 18 19 20 21 23 23 Additional calatonede Overhe tutation 6 53551 UNIT FedOverhead location per te este und Ord Anteon the Cold 25 Data Window Help Master Budget Project (1) Excel File Edit View Insert Format Tools AutoSave OFF 2.C. Home Insert Draw Page Layout Formulas Data X Calibri (Body) 11 ' ' . Paste Uv a Review View Tell me y 2Wrap Text General Merge & Center $ % v to 98 C10 XVfx Link to tab 10 1h 1 1. Operating budgets Checkpoints to verify your work ? a. Sales budget ta b. Production budget (Manufacturers only) / Purchases budget (Retailers only) Total for 2022) budgeted production -52,582 + c Direct materials budget (Manufacturers only) sd. Direct labor budget (Manufacturers only) id 6e. Manufacturing overhead budgets (Manufacturers only) le f. Cost of goods sold budget 11 Total for 2022) cost of goods sold $1,315,354 B. Selling general, and administrative budget 1s 9 h. Budgeted income statement Net Income $472,929 10 2. Financial budgets 1:a. Cash receipts budget 2 Do not complete these budgets! 1.2 b. Capital expenditures budget 26 13 c. Cash disbursements budget 20 14 d. Cash budget 2d 15 e. Budgeted balance sheet 16 2 17 You must edit (input) all cells that are yellow throughout the spreadsheet. All other values are automatically calculated based on inputs 18 Monagement assumptions to help you determine the inputs are gray throughout the spreadsheet 19 20 21 22 0 M Paige Monroe Company Manufacturing overhead budget for the year ended December 31, 2022 Quarter 1 Quarter 2 Quarter Quarter Total For 20221 12508 UNIT 12758 UNIT 13013 UNIT 13273 UNIT 51551 UNIT 5 95 95 95 95 9 $ 112.5685 114,6195 117, 1155 119.4585 463,999 Assumptions for inputs Variable overhead cost per unit 5 9 Depreciation per month $ 1.200 Supervisionare per quarter $6.000 Cost driver DL hou 10 11 1 buted production Vico Hudorable read buted overhead Depreciation Superior Tot ved Bedructuring overtas $ 5 5 5 1,700 6.000 7,700 120.2685 1.100 6.000 7,700 122,519 1.700 5 6,000 7,700 5 114,8155 1,7005 6,000 5 7.700 S 127.158 6.100 24000 30.800 10 17 18 19 20 21 23 23 Additional calatonede Overhe tutation 6 53551 UNIT FedOverhead location per te este und Ord Anteon the Cold 25 Data Window Help Master Budget Project (1) Excel File Edit View Insert Format Tools AutoSave OFF 2.C. Home Insert Draw Page Layout Formulas Data X Calibri (Body) 11 ' ' . Paste Uv a Review View Tell me y 2Wrap Text General Merge & Center $ % v to 98 C10 XVfx Link to tab 10 1h 1 1. Operating budgets Checkpoints to verify your work ? a. Sales budget ta b. Production budget (Manufacturers only) / Purchases budget (Retailers only) Total for 2022) budgeted production -52,582 + c Direct materials budget (Manufacturers only) sd. Direct labor budget (Manufacturers only) id 6e. Manufacturing overhead budgets (Manufacturers only) le f. Cost of goods sold budget 11 Total for 2022) cost of goods sold $1,315,354 B. Selling general, and administrative budget 1s 9 h. Budgeted income statement Net Income $472,929 10 2. Financial budgets 1:a. Cash receipts budget 2 Do not complete these budgets! 1.2 b. Capital expenditures budget 26 13 c. Cash disbursements budget 20 14 d. Cash budget 2d 15 e. Budgeted balance sheet 16 2 17 You must edit (input) all cells that are yellow throughout the spreadsheet. All other values are automatically calculated based on inputs 18 Monagement assumptions to help you determine the inputs are gray throughout the spreadsheet 19 20 21 22