Master Budget Project (1) AutoSave OFF @y Tell me Data Review View Draw Formulas Home Insert Page Layout 9 lil General Calibri (Body) 11 X 2 Wrap Test Merge Center $ %) Conditional Format Formatting as Table 1 Paste A BIU C10 oxfx 1. Operating budgets Link to tab Checkpoints to verify your work 23. Sales budget 1 b. Production budget (Manufacturers only) / Purchases budget (Retailers only) Total for 2022} budgeted production=53,582 c Direct materials budget (Manufacturers only) 5 d. Direct labor budget (Monufacturers only) 1d e Manufacturing overhead budgets (Manufacturers only) 1 Cost of goods sold budget Total Mor 2022) cost of goods sold-51.315.25 Selling, general and administrative budget h Budgeted income statement 15 Net income $47,929 2. Financial budgets 11. Cash receipts budget 23 De not complete the budgets 1 b. Capital expenditures budget 20 1) C Cash disbursements budget 25 14 d. Cash budget 20 15 e Budgeted balance sheet 17 You must editing all cells that are yellow throughout the spreadsheet. All other values are automatically calculated based on inputs 1 Monagement assumption to help you determine the inputs are grey throughout the preachheet 10 16 19 20 21 27 10 20 2 26 22 20 29 10 31 32 34 35 30 th + 10 11 Te 10 te 18 16 Mey Heady Master Budget Project (1) AutoSave OF fo BC- Page Layout Formulas Data Review View Tell me Home Insert Draw Custom X Calibr (Body) 11 & A A 29 Wrap Text Merge & Center $ % ) 8-98 Conditions Formattin Tali A Paste Xfx =SUM(C7:F7) L M G H C D Palpe Monroe Company Sales budget For the year ended December 31, 2022 Asumptions for inputs Prior of units sold in 04 Sales growth rate per quarter Unit selling price 5 12,500 2% 40.00 4 Quarter1 Quarter 2 Quarter 3 Quarter 4 Total For 2022) Sales forecast xUnit selling price Budgeted sales revenue 's s 9 10 17 12 15 14 15 16 12 18 19 30 21 22 23 24 25 Master Budget Project (1) AutoSave OFF Formulas Review Data View Tell me Home Draw Insert Page Layout General Calibri (Body! = ~AA A 2 Wrap Text Merge & Center L $ % ) 293 Conditional Format ce Formatting as Table Style Paste IM ilil B H11 Xfx 1 E 1 H G Paige Monroe Company Production budget (Manufacturers only/Purchases budget (Retailers only For the year ended December 31, 2022 Assumptions for inputs Desired ending inventory ofret aterales Beginning inventory 3% of current Quarter's sales Quarter 1 Quarter 2 Quarter Quarter 4 Total For 2022] Salesforecast Dessed into Total units needed Beginning inventory Buderted production/Buded purcha 10 11 13 Badan Second growth rate 14 15 16 17 Additional calculation 01 2023 Sale Forecast Q1 2027 Begited Goods very 19 20 22 23 Master Budget Project (1) Data Formulas Review View Tell me Insert Draw Page Layout 19 Wap Test General Calibr (Body) 11 - A A Insent Delete Fom Conditional Format Ce Formatting Styles $ % Merge Center B1 WA G Monroe com Direct For the warded December 3, 2013 Ammo bar input mempert Ditory of materials for reduction Catchinch of 5155 M Marly 1.062 Quart Qw Quatre Tour 2032) Quat 3,303 pro wy Det for go To Big Otwo Coinch 16 13 30 22 11 IG BIU Paste IMO IM TEH $ % ) Merge & Center Cond Form V G11 XVfx G K 1 2 Paige Monroe Company Direct labor budget For the year ended December 31, 2022 Assumptions for inputs DL hours per unit 0.50 DL cost per hour $ 12 4 3 Quarter Quarter 2 Quarter Quarter Total Vor 2022) Budgeted production Direct labor hours per unit 9 Total direct labor hours required 10 Cost of each labor hour 11 Muted director 12 13 14 15 16 17 13 15 20 21 22 21 AutoSave OFF Master Budget Project (1) Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri Body 11 IN 2 29 Wrap Text Custom IMG Pau BTU 3 18 = = = ins $ % 9 Merge & Center Conditional Format Cel Formatting Table Styles 619 X G7 G U Psi Monroe Company Manufacturing overhead budget For the yewended December 11, 2022 Assumptions for inputs Variatie overhead cost per unit 5 9 Depreciation per month $ 1200 Supervisare per quarter $ 6,000 Coster DE hours Quarter Quarter Quarter Quarter Total For 2032) Hured production Valconi Budgetil Bunge wa Deprec SV Tuled overhead Bugaturing overhead 10 11 13 11 14 15 LE 12 13 19 20 15 27 Additional landed FedOverhead Total Production Overhead To be the letter Cost of Goods Sold Budget 16 25 26 - N 7 2. 1 3 5 D Q W E R T P Y 0 U F G D H K 1 L S