F H $140 1 Relevant Forecasted Data 2 Selling price 3 4 Units in beginning inventory 5 Units produced 6 Units sold 7 Units in ending inventory 8 9 Variable costs per unit: 10 Direct materials 11 Direct labor 12 Variable manufacturing overhead 13 Variable selling and administrative 0 6500 6500 300 $50 $40 $8 $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 $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 20 Colac ntafanlarinn and namiccion con Relevant Forecasted Data Balance Sheet Cash Flow F G E38 Q fx 3800 B C D 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 $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 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 $ $ $ 330000 450000 120000 5000 2500 2500 332500 1 Balance Sheet 2 Fixed Assets 3 Factory and machinery 4 Less: Depreciation 5 Computer 6 Less: Depreciation 7 Current Assets 8 Prepayment: 9 Insurance 10 Telephone 11 Cash in hand 12 13 Current Liabilities 14 Creditors 15 Rates accrual 16 Electricity accrual 17 18 Capital 19 Balance at 1 Jan 2020 20 Net profit 21 Less: Drawings 700 350 650 1700 4000 2500 600 7100 5400 327100 215000 125000 12900 327100 22 23 24 25 26 27 28 29 E G H $ $ 22500 4150 26650 200 4500 -9600 -4900 21750 F 1 Cash Flow 2 Operating activites 3 Profit from operations 4 Adjustments for: 5 Depreciation 6 Operating cash flows before movements in working capital 7 Decrease in stock 8 Decrease in debtors 9 Decrease in creditors 10 11 Cash generated by operations 12 Tax paid 13 Interest paid 14 Net cash from operating activites 15 Investing activities 16 Payments to acquire tangible fixed assets 17 Net cash used in investing activities 18 Financing activities 19 Loan received 20 Drawings 21 Net cash from financing activities 22 Net increase in cash and cash equivalents 23 Cash and cash equivalents at beginning of year 24 25 Cash and cash equivalents at end of year 26 Bank balances and cash 27 21750 -6000 -6000 25000 -20000 5000 20750 - 15750 5000 5000 28 29 Find the Operating Budget - DM (Direct Materials), DL (Direct Labour) and MOH (Manufacturing Overhead) 1 F H $140 1 Relevant Forecasted Data 2 Selling price 3 4 Units in beginning inventory 5 Units produced 6 Units sold 7 Units in ending inventory 8 9 Variable costs per unit: 10 Direct materials 11 Direct labor 12 Variable manufacturing overhead 13 Variable selling and administrative 0 6500 6500 300 $50 $40 $8 $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 $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 20 Colac ntafanlarinn and namiccion con Relevant Forecasted Data Balance Sheet Cash Flow F G E38 Q fx 3800 B C D 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 $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 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 $ $ $ 330000 450000 120000 5000 2500 2500 332500 1 Balance Sheet 2 Fixed Assets 3 Factory and machinery 4 Less: Depreciation 5 Computer 6 Less: Depreciation 7 Current Assets 8 Prepayment: 9 Insurance 10 Telephone 11 Cash in hand 12 13 Current Liabilities 14 Creditors 15 Rates accrual 16 Electricity accrual 17 18 Capital 19 Balance at 1 Jan 2020 20 Net profit 21 Less: Drawings 700 350 650 1700 4000 2500 600 7100 5400 327100 215000 125000 12900 327100 22 23 24 25 26 27 28 29 E G H $ $ 22500 4150 26650 200 4500 -9600 -4900 21750 F 1 Cash Flow 2 Operating activites 3 Profit from operations 4 Adjustments for: 5 Depreciation 6 Operating cash flows before movements in working capital 7 Decrease in stock 8 Decrease in debtors 9 Decrease in creditors 10 11 Cash generated by operations 12 Tax paid 13 Interest paid 14 Net cash from operating activites 15 Investing activities 16 Payments to acquire tangible fixed assets 17 Net cash used in investing activities 18 Financing activities 19 Loan received 20 Drawings 21 Net cash from financing activities 22 Net increase in cash and cash equivalents 23 Cash and cash equivalents at beginning of year 24 25 Cash and cash equivalents at end of year 26 Bank balances and cash 27 21750 -6000 -6000 25000 -20000 5000 20750 - 15750 5000 5000 28 29 Find the Operating Budget - DM (Direct Materials), DL (Direct Labour) and MOH (Manufacturing Overhead) 1