Page Layout For Data Rovsem View Help BLUEBEAM rom the intemes can contain wires. Unless you need to edit afer today in Practed Enable Editing 3 D E G 2 Data Yew 2 Quarter Yes Guarder 1 2 3 4 1 2 40.000 50,000 100,000 50,000 70 000 20.000 $8 30% of the budgeted unt sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds 50 80 per pound B 1 40,000 58 $320,000 Year 2 Quarter 2 3 60.000 100,000 50.000 $8 58 58 5480,000 $800,000 $100.000 Year 3 Quarter 2 70,000 80.000 58 $8 5560 000 $640,000 4 Budgeted unit sales 5 Selling price per unit 6.Desired ending finished goods inventory is 7 - Finished goods inventory beginning Raw materials required to produce one unit -Desired ending inventory of raw matenals is 10 Raw materials inventory beginning 11. Raw material costs 12 13 Construct the sales budget 14 J5 Budgeted unit sales 16 Selling price per unit 17 Total sales 18 19 Construct the production budget 20 21 Budgeted unit sales 22 Add desired ending finished goods inventory 23 Total needs 24 Less beginning finished goods inventory 25. Requited production in units 26 27 Construct the raw materials purchases budget 28 29 Required production (units) 30 Raw matenals required to produce one unit (pounds) 31 Production needs (pounds) 32. Add desired ending inventory of raw materials (pounds) 33 Total needs (pounds) 34 Less beginning inventory of raw materials (pounds) 35 Raw materials to be purchased (pounds) 36 Cost of raw materials per pound 37 Cost of raw materials to be purchased 38 29 40 1 40,000 18,000 58,000 (12 000 46.000 Year 2 Quarter 2 3 60.000 100,000 30 000 15,000 90.000 115,000 (18000) (30 000) 72000 85.000 4 50,000 21.000 71,000 (15 000 56,000 Year 250.000 21.000 271.000 (12.000) 259.000 Year 3 Quarter 2 70,000 80.000 24 000 90.000 (21000) 73 000 Year 3 Quarter 4 4 Year 2 2 ? ? 2 7 2 2 2 2 ? 2 2 Year 2 Quarter 2 3 ? ? 2 2 7 ? ? 2 ? 2 7 7 ? 7 7 2 7 ? 2 2 ? 2 7 2 ? 2 7 2 2 ? 2 2 42