Edit View Insert Format Tools Data Window Help AutoSave OFF me Insert Draw Page Layout Master Budget Project (1) Formulas Data Review View Tell me X ID 11 Calibri (Body B I U A A Este Custom 29 Wrap Text Merge & Center 1 x v $ % ) fx 13403 UNIT Conditional Form Formatting as the A B G H Pale Monroe Company Production budget Manufacturers only/Purchases budget Retailers only! For the year ended December 31, 2022 Asumptions for inputs Desired ending inventory 3% of next quarter's sales Beginning inventory of current caters Salesforecast Desired ending inventory Total units needed Beginning inventory Budgeted production / Budgeted purchases Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total (For 2022) 12500 UNIT 12750 UNIT 13005 UNIT 51520 UNIT 383 UNIT 390 UNIT 398 UNIT 406 UNIT 406 UNIT 12883 UNIT 13140 UNIT 13403 UNIT 13671 UNIT 51926 UNIT 373 UNIT 383 UNIT 390 UNIT 398 UNIT 373 UNIT 12508 UNIT 12758UNT 13013 UNIT-13273 UNT 51551 UNIT Additional calculations needed Q1 2023 Sale Forecast units) Q1 2022 Be Finished Goods Inventory - Based on 4 Sales and growth rate Insert Draw Page Layout Formulas Data Review View Tell me X ID Calibri (Body) Wrap Text General v V 11 ' ' a.A 10 10 l B I ilil Merge & Center $ % ) V Conditional Fo Formatting x fx D E Link to tab Checkpoints to verify your work Total for 2022} budgeted production=52,582 16 10 10 le Total for 2022) cost of goods sold $1,315,354 1. Operating budgets Sales budget Production budget (Manufacturers only) / Purchases budget (Retailers only) Direct materials budget (Manufacturers only) Direct labor budget (Manufacturers only) Manufacturing overhead budgets (Manufacturers only) Cost of goods sold budget Selling, general, and administrative budget Budgeted income statement 2. Financial budgets Cash receipts budget b. Capital expenditures budget C.Cash disbursements budget d. Cash budget c. Budgeted balance sheet 1 11 Net Income $472.929 Do not complete these budget! ZE Zd 2 You must edit (input) all cells that are yellow throughout the spreadsheet. All other values are outomatically calculated losed on inguts Monagement assumptions to help you determine the inputs are grey throughout the spreadsheet Edit View Insert Format Tools Data Window Help AutoSave OFF me Insert Draw Page Layout Master Budget Project (1) Formulas Data Review View Tell me X ID 11 Calibri (Body B I U A A Este Custom 29 Wrap Text Merge & Center 1 x v $ % ) fx 13403 UNIT Conditional Form Formatting as the A B G H Pale Monroe Company Production budget Manufacturers only/Purchases budget Retailers only! For the year ended December 31, 2022 Asumptions for inputs Desired ending inventory 3% of next quarter's sales Beginning inventory of current caters Salesforecast Desired ending inventory Total units needed Beginning inventory Budgeted production / Budgeted purchases Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total (For 2022) 12500 UNIT 12750 UNIT 13005 UNIT 51520 UNIT 383 UNIT 390 UNIT 398 UNIT 406 UNIT 406 UNIT 12883 UNIT 13140 UNIT 13403 UNIT 13671 UNIT 51926 UNIT 373 UNIT 383 UNIT 390 UNIT 398 UNIT 373 UNIT 12508 UNIT 12758UNT 13013 UNIT-13273 UNT 51551 UNIT Additional calculations needed Q1 2023 Sale Forecast units) Q1 2022 Be Finished Goods Inventory - Based on 4 Sales and growth rate Insert Draw Page Layout Formulas Data Review View Tell me X ID Calibri (Body) Wrap Text General v V 11 ' ' a.A 10 10 l B I ilil Merge & Center $ % ) V Conditional Fo Formatting x fx D E Link to tab Checkpoints to verify your work Total for 2022} budgeted production=52,582 16 10 10 le Total for 2022) cost of goods sold $1,315,354 1. Operating budgets Sales budget Production budget (Manufacturers only) / Purchases budget (Retailers only) Direct materials budget (Manufacturers only) Direct labor budget (Manufacturers only) Manufacturing overhead budgets (Manufacturers only) Cost of goods sold budget Selling, general, and administrative budget Budgeted income statement 2. Financial budgets Cash receipts budget b. Capital expenditures budget C.Cash disbursements budget d. Cash budget c. Budgeted balance sheet 1 11 Net Income $472.929 Do not complete these budget! ZE Zd 2 You must edit (input) all cells that are yellow throughout the spreadsheet. All other values are outomatically calculated losed on inguts Monagement assumptions to help you determine the inputs are grey throughout the spreadsheet