Production Budget

Looking for someone to check my work and make sure my answers are correct. Also looking for the final number under Q5

Michael Home Insert Page Layout Formulas Data Review View Help Calibri EE 89 Wiap test General Insert - 11-AA a. A CM Delete BIU FR Merge & Center $ -% 8-23 Conditional Format as Cell Formatting Table Styles Styles Format aboard Font Alignment Number CS B C D E o XYZ Company Production Budget 01 Q2 03 Q4 Q5 5,000 8,000 960 10,000 800 Expected unit sales (units) Required ending inventory Total required units Beginning inventory Required inventory (units to be produced) 7,000 420 7,420 950 12,000 600 12,600 8,960 5,000 420 4,580 10,800 600 800 8,160 7,540 10,200 #VALUE! 5,000 7,000 8,000 10,000 10,000 12% 8% 5% 5% DATA 1 Projected unit sales by quarter Ending inventory requirement based on "next month's" unit 2 sales 3 Ending inventory requirement for Q4 of prior year 4 Projected unit sales in Q1, next year 5 Projected unit sales in Q2, next year DATA Prod Budget Q Materials Purchase Budget Q 6% 7% 12,000 10,000 Type here to search C PE VT