Managerial Accounting

Are these the correct numbers for the question?

Save Production budgeting 1130 - Excel Home Insert Page Layout Formulas Data Review View Help X Calibri - A A ' ' -A- Accounting 2 Wrap Text Es Merge & Centut BI HR insert Delete Format Conditional Format as Formatting Table Styles Styles $ - % 948-88 and Font Alignment Number Cels X fi 960 D E G H M N o XYZ Company Production Budget Q1 Q2 Q3 Q4 05 5,000 12,000 8,000 420 350 800 Expected unit sales (units) Required ending inventory Total required units Beginning inventory Required inventory (units to be produced) 7,000 350 7,350 420 5,350 350 10,000 960 10,960 800 10.160 8,420 960 12,800 600 5,000 6,930 7,460 12,200 5,000 7,000 8,000 10,000 10,000 6% 12% 8% 596 5% DATA 1 Projected unit sales by quarter 2 Ending inventory requirement based on "next month's" unit sales 3 Ending inventory requirement for Q4 of prior year 4 Projected unit sales in Q1, next year 5 Projected unit sales in a2, next year DATA Prod BudgetQ Materials Purchase Budget a 7% 12,000 10,000 Type here to search G OH