I asked my professor about May sales and she said you dont need it to answer the question.

she said 36000 budgeted units for may

O - X Comments Share AutoSave ON 8 File Home Insert Draw X libri 11 - BTV - AA Paste Page Layout 1 5 Final Project (as bacel P Staige Brooklyn C Formulas Data Review View Help M General Conditional Formatting Insert - $ - % 9 Formatas Table Delete - 66 Cell Styles Format - - 212 Number Styles Editing G45 wwwwwwwwwwwwwwwwwwww 6 raw materials budget. Include the monthly budgets for January, February, and March as well as the company has the following invel 7 the total quarter. The company has the following inventory policies Desired units of ending finished goods inventory is 10% of the following month's sales in units. Desired units of ending raw materials inventory is 20% of the following month's units of raw materials needed to meet productio ary February December January March March April 24000 40000 34000 27000 36000 13 Budget unit sales: 15 Sales Price Units of raw materials needed per unit of 16 finished goods 17 Unit cost of raw materials 18 Beginnning finished goods inventory Calculate this based on the Inventory policy 19 Raw materials required to produce one unit 20 Beginning raw materials inventory Calculate this based on the inventory policy 21 22 Total Quarter 23 CONSTRUCT THE SALES BUDGET: March January February 24 25 40000 34000 27000 101000 26 Budeted Unit Sales SES S6 31 CONSTRUCT THE PRODUCTION BUDGET: January February March Total Quarter 33 Budgeted Unit Sales 34 Add desired units of ending FG Inventory 35 Total Needs 36 Less units of beginning FG Inventory 37 Required Production in units 40000 3400 43400 4000 39400 34000 2700 36700 3400 33300 27000 3600 30600 2700 27900 101000 9700 110700 10100 100600 40 CONSTRUCT THE RAW MATERIALS PURCHASE BUDGET: Total Quarter January February March 39400 33300 27900 100600 5 503000 139500 197000 33300 230300 166500 27900 194400 44 Required production in units 45 units of raw materials needed 46 units RM to meet production 47 add desired ending of raw material 48 Total Units of Raw materials needed 49 less units of beginning RM 50 Units of Raw materials to be purchased 51 Cost of Raw Materials per unit 52 Cost of raw materials to be purchased 53 Budgeting Flexible performance report Variance analysis . Ready