B D E UL G H $140 A 1 Relevant Forecasted Data 2 Selling price 3 4 Units in beginning inventory 5 Units produced 6 Units sold 7 Units in ending inventory 0 6500 6500 300 8 9 Variable costs per unit: 10 Direct materials 11 Direct labor 12 Variable manufacturing overhead 13 Variable selling and administrative $50 $40 $8 $15 14 15 Fixed costs: 16 Fixed manufacturing overhead 17 Fixed selling and administrative $10,800 $74,500 18 19 Purchase of raw materials S47,500 20 Purchase of finished goods $400 21 Raw materials returned to suppliers $4,900 22 Carriage outwards $450 23 Carriage inwards $650 24 Direct wages $23,500 25 Administrative salaries $10,900 26 Supervisors' wages $5.600 27 Royalties payable $7.800 28 Electricity used in factory $2,500 29 Light and heat for administrative offices $1,000 2 Cananlarinnar cocon Relevant Forecasted Data Balance Sheet Cash Flow + Type here to search RE E Painter Center Text X M.A. Assignment Q2.docxlsx F G MA2 sales budget.xlsx E38 Qfx 3800 B D E 13 Variable selling and administrative $15 14 15 Fixed costs: 16 Fixed manufacturing overhead $10.800 17 Fixed selling and administrative $74.500 18 19 Purchase of raw materials $47,500 20 Purchase of finished goods $400 21 Raw materials returned to suppliers $4,900 22 Carriage outwards $450 23 Carriage inwards S650 24 Direct wages $23.500 25 Administrative salaries $10.900 26 Supervisors' wages $5.600 27 Royalties payable $7,800 28 Electricity used in factory $2.500 29 Light and heat for administrative offices $1,000 30 Sales staff salaries and commission $8,500 31 Bad debts $730 32 Discount received $2,300 33 Discount allowed $1.500 34 Rent and rates $4,500 35 Delivery expenses $590 36 Postage and telephone $700 37 Advertising $630 38 Depreciation of delivery vehicles $3.800 39 Depreciation of office fixtures $2.000 40 41 Relevant forecasted Data Balance Sheet Cash Flow + Type here to search BI 3 E W MA2 sales budget.dsx MA.A 17 B A 1 Sales Budget D E F G 2 3 Unit Sold 4 Selling Price 5 Total Revenue 6500unit $140 $910,000 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 30 Type here to search B Copy Format Painter U E.A.A. EZ Merge Cente w MA2 sales budget.xlsx MA. Assignment E17 D E G H unit 6500 B 1 Production Budget 2 Sales Unit 3 Ending Inventory Total Production Required Beginning Inventory Unit to be produced 300 4 5 6 6800 0 6800 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 25 26 27 28 29 Sheets Type here to search i Calculate Operating Budget: (i) Direct Materials Budget (ii) Direct Labor Budget (iii) Direct Manufacture Overhead Budget ords: 13 Spell Check