Materials cost budget

please fill in the blanks

BIU Accounting a. A Merge & Center $ - %) 68-8 d Font Alignment Conditional Format as Cell Formatting Table Styles Styles Number X for 3 C D E F M N XYZ Company Materials Cost Budget Q1 Q2 03 24 Units to be produced Q5 Materials required Pounds of sugar needed for production Pounds per unit Total pounds needed for production Pounds of sugar needed for ending inventory Less beginning inventory Pounds of sugar to be purchased Price/pound Cost of sugar to be used in production $ S $ $ $ $ s $ $ $ DATA Prod Budget Materials Purchase Budget Q Type here to search C Number & 17 X for A B G H 11 K C D E F Total pounds needed for production Pounds of sugar needed for ending inventory 2 - 3 4 5 6 . Less beginning inventory Pounds of sugar to be purchased Price/pound Cost of sugar to be used in production $ $ $ $ 7 $ $ $ 8 0 4 oz. 1 2 8 4 DATA 1 Ounces of sugar per unit of production 2 Cost of sugar/pound 3 Ending inventory requirement $ 1.25 10% of pounds needed for next quarter production 7 DATA Prod Budget Materials Purchase Budget Q Type here to search C Galibri 11 JA A == 29 Wrap Text A. Merge & Center General BIU Insert $ %, 8-68 Delete Font Alignment Conditional Format as Cell Formatting Table Styles Styles Format Number X for Cells B D E F G H STRUCTIONS: Use the information below to prepare, for the XYZ COMPANY: (1) a production budget, and (2) a cost of terials budget 1 Q2 Projected unit sales by quarter Ending inventory requirement based on "next month's" unit sales Q1 5,000 Q4 Q3 8,000 7,000 Q5 12,000 2 10,000 696 12% 8% 5% 5% 3 5 Ending inventory requirement for Q4 of prio gear Projected unit sales in Q1, next year Projected unit sales in Q2, next year Ounces of sugar per unit of production Cost of sugar/pound Ending inventory requirement 6 7% 12,000 10,000 4 oz. $ 1.25 10% of pounds needed for next quarter production 3 Prod Budget Materials Purchase Budget here to search e D