Complete the folowing requirements.
Outien ? INGINE Statement of Financial Position A at April 1. 2015 Assets Von Land und Building Plant and mental com Less Aumalate Depreciation 5 $ 45.000 187.00 75.00 112.000 Curr Rassmates Finished Recephes Cast: 7,650 21,600 19.500 4.100 $5,050 212.050 Equity and liabilities Cura Stare capital Accumulated profit 150.000 55.250 205.250 Curi Pavables 6.500 212.050 Inished Products The sales tecto bas estimated the following Demand to company's noducts aks 4.500 units 532 400 units Castory of finished products at March 31, 2016 Opening in to finished ducts at April 2015 thithing insentory Aint capacity required for each unit product 4.000 units 944 1.2 units 200Units $28 $20 3 minutes 15 minutes Inte: MA 15 kn 5 Leiterunt hours Subjects Sectie Fuschl als are values un FIFO at hill production cost Raw materials Material A 600 1.106 $1.50 Material B 1.000 6.000 $1.00 Closing inventory requirement in kilos at March 31, 2016 Opening inventory at April 1, 2015 Budgeted cost of raw material per kilo Actual costs per kilo of opening inventory are as budgeted costs for the coming year Direct labour The standard wage rate for direct labour is $1.60 per hour I'roduction overhead Production overhead is absorbed on the basis of machining hours, with separate absorption rates for each department. The following overheads are anticipated in the production cost center budgets. Machining Department Assembling Department Supervisors salaries 10.000 9.150 Power 4,400 2.000 Maintenance and running costs 2.100 2.000 Consumables 3,400 5(X) Cieneral expenses 19.670 5,000 Total 39.500 15.650 Depreciation is taken at percent straight line on plant and equipment. A machine costing the company S. Dle to be installed on October 1, 2015 in the machining department, which already has machinery installed to the value of $100.000 (at cost). Land worth $180,000 is to be acquired in December 2015 Selling and Administrative expenses Sales commission and salaries 14.300 Travelling and distribution 3.500 Oflice salaries 10.100 General adinistration senses 2.500 30,400 There is no sporing or closing work in progress and inflation should be ignored Quarter 2 100.000 Quarter 3 100.000 Quarte: 4 40.000 Budgeted cash flows are as follows Quarter 1 Receipts from customers 70.000 Payments Materials 7,000 Wages 33.000 Other costs and expenses 10.000 9.000 20.000 100.000 10.000 11.000 205.000 3,000 15.000 5.000 Required: 2. Sales budget b. Production budget (in quantities) c. Plant utilization budget 4. Direct material usage budget c. Direct labour budget f Factory overhead budget L. Computation of the factory cost per unit for each product h. Direct materials purchases budget 1. Budgeted cost of goods sold j. Cash budget k. Budgeted income statement 1. Budgeted balanced sheet Ott No. 2 P'LAGTED ENGINEERING Statement of Financial Position As at April 1, 2015 Assets Son-current assets Land und Building Plant and Equipment at cost Less Accutulated Depreciation s S 45,000 187,000 75,000 112,000 Current Raw materials Finished goods Receivables Cash 7.650 23,600 19,500 4,300 55,050 212,050 Equity and liabilities Capital and se Shure capital Accumulated profit 150,000 55,250 205,250 Curre dahil Payables 6.800 2.12.050 Finished Products The sales director las estimated the following Niks 4,500 units $32 400 units 900 units $20 Ares 4.000 units $44 1,200 units 200 Units $28 Demand for company's products Selling price per unit Closing inventory of finished products at March 31, 2016 Opening inventory of finished products at April 12035 Unit cost of this opening inventory Amount of plant capacity required for each unit of product Machining Assembling Raw material content per unit of each product Mistral Malena B Labour hours required per unit 15 minutes 12 minutes 24 minutes 18 minutes 1.5 kes 2.0 kgs 6 hours 0.5 kgs 4.0 kgs 9 hours Subjective Section best goods are valued IFO full production et Raw materials MA Closing inventory requirement in kilos at March 31, 2016 Opening inventory at April 1, 2015 Budgeted cost of raw material per kilo 1.100 5130 1.000 6.900 $1.00 Actual costs per kilo of opening inventory are as budgeted costs for the coming your Direct labour The standard wage rate for direct labour is $1.60 per hour Production overhead Production overhead is absorbed on the basis of machining hours, with separate absorption rates for cach department. The following overheads are anticipated in the production cost center hudgets Machining Department Assemblin Dort Supervisor salaries 10,000 9,150 Power 4,400 2.000 Maintenance and running costs 2,100 2.000 Consumables 3,400 500 General expenses 19,600 5.000 Total 39,500 18.650 Depreciation is taken at 5 percent straight line on plant and equipment machine costing the company 520,000 is dat he walled on October 2015 in the machining department, which already has machinery installed to the value of $100.000 cat cos). Land worth it be acquired in December 2015 Selling and Administrative expenses Sales commission and salaries Travelling and distribution Officeries General administrationen TO 14.300 3.500 10,100 2.500 30,400 Mervis no opening of in work in progress and inflation should be ignored Subjecth Section Quarter 2 100,000 Quarter 100.000 Quarter 4 40.000 Budgeted cash 110ws are as follows Quarter 1 Receipts from customers 70,000 Payments Materials 7,000 Wages 33.000 Other costs and expenses 10.000 9,000 20,000 100,000 10,000 11.000 205.000 3,000 15,000 3.000 Required: a Sales budget b. Production budget (in quantities) C. Plant utilization budget di Direct material usage budget c. Direct labour budget 1. Factory overhead budget Computation of the factory cost per unit for each product h. Direct materials purchases budget i Budgeted cost of goods sold jCash budget k. Budgeted income statement | Budgeted balance sheet Outien ? INGINE Statement of Financial Position A at April 1. 2015 Assets Von Land und Building Plant and mental com Less Aumalate Depreciation 5 $ 45.000 187.00 75.00 112.000 Curr Rassmates Finished Recephes Cast: 7,650 21,600 19.500 4.100 $5,050 212.050 Equity and liabilities Cura Stare capital Accumulated profit 150.000 55.250 205.250 Curi Pavables 6.500 212.050 Inished Products The sales tecto bas estimated the following Demand to company's noducts aks 4.500 units 532 400 units Castory of finished products at March 31, 2016 Opening in to finished ducts at April 2015 thithing insentory Aint capacity required for each unit product 4.000 units 944 1.2 units 200Units $28 $20 3 minutes 15 minutes Inte: MA 15 kn 5 Leiterunt hours Subjects Sectie Fuschl als are values un FIFO at hill production cost Raw materials Material A 600 1.106 $1.50 Material B 1.000 6.000 $1.00 Closing inventory requirement in kilos at March 31, 2016 Opening inventory at April 1, 2015 Budgeted cost of raw material per kilo Actual costs per kilo of opening inventory are as budgeted costs for the coming year Direct labour The standard wage rate for direct labour is $1.60 per hour I'roduction overhead Production overhead is absorbed on the basis of machining hours, with separate absorption rates for each department. The following overheads are anticipated in the production cost center budgets. Machining Department Assembling Department Supervisors salaries 10.000 9.150 Power 4,400 2.000 Maintenance and running costs 2.100 2.000 Consumables 3,400 5(X) Cieneral expenses 19.670 5,000 Total 39.500 15.650 Depreciation is taken at percent straight line on plant and equipment. A machine costing the company S. Dle to be installed on October 1, 2015 in the machining department, which already has machinery installed to the value of $100.000 (at cost). Land worth $180,000 is to be acquired in December 2015 Selling and Administrative expenses Sales commission and salaries 14.300 Travelling and distribution 3.500 Oflice salaries 10.100 General adinistration senses 2.500 30,400 There is no sporing or closing work in progress and inflation should be ignored Quarter 2 100.000 Quarter 3 100.000 Quarte: 4 40.000 Budgeted cash flows are as follows Quarter 1 Receipts from customers 70.000 Payments Materials 7,000 Wages 33.000 Other costs and expenses 10.000 9.000 20.000 100.000 10.000 11.000 205.000 3,000 15.000 5.000 Required: 2. Sales budget b. Production budget (in quantities) c. Plant utilization budget 4. Direct material usage budget c. Direct labour budget f Factory overhead budget L. Computation of the factory cost per unit for each product h. Direct materials purchases budget 1. Budgeted cost of goods sold j. Cash budget k. Budgeted income statement 1. Budgeted balanced sheet Ott No. 2 P'LAGTED ENGINEERING Statement of Financial Position As at April 1, 2015 Assets Son-current assets Land und Building Plant and Equipment at cost Less Accutulated Depreciation s S 45,000 187,000 75,000 112,000 Current Raw materials Finished goods Receivables Cash 7.650 23,600 19,500 4,300 55,050 212,050 Equity and liabilities Capital and se Shure capital Accumulated profit 150,000 55,250 205,250 Curre dahil Payables 6.800 2.12.050 Finished Products The sales director las estimated the following Niks 4,500 units $32 400 units 900 units $20 Ares 4.000 units $44 1,200 units 200 Units $28 Demand for company's products Selling price per unit Closing inventory of finished products at March 31, 2016 Opening inventory of finished products at April 12035 Unit cost of this opening inventory Amount of plant capacity required for each unit of product Machining Assembling Raw material content per unit of each product Mistral Malena B Labour hours required per unit 15 minutes 12 minutes 24 minutes 18 minutes 1.5 kes 2.0 kgs 6 hours 0.5 kgs 4.0 kgs 9 hours Subjective Section best goods are valued IFO full production et Raw materials MA Closing inventory requirement in kilos at March 31, 2016 Opening inventory at April 1, 2015 Budgeted cost of raw material per kilo 1.100 5130 1.000 6.900 $1.00 Actual costs per kilo of opening inventory are as budgeted costs for the coming your Direct labour The standard wage rate for direct labour is $1.60 per hour Production overhead Production overhead is absorbed on the basis of machining hours, with separate absorption rates for cach department. The following overheads are anticipated in the production cost center hudgets Machining Department Assemblin Dort Supervisor salaries 10,000 9,150 Power 4,400 2.000 Maintenance and running costs 2,100 2.000 Consumables 3,400 500 General expenses 19,600 5.000 Total 39,500 18.650 Depreciation is taken at 5 percent straight line on plant and equipment machine costing the company 520,000 is dat he walled on October 2015 in the machining department, which already has machinery installed to the value of $100.000 cat cos). Land worth it be acquired in December 2015 Selling and Administrative expenses Sales commission and salaries Travelling and distribution Officeries General administrationen TO 14.300 3.500 10,100 2.500 30,400 Mervis no opening of in work in progress and inflation should be ignored Subjecth Section Quarter 2 100,000 Quarter 100.000 Quarter 4 40.000 Budgeted cash 110ws are as follows Quarter 1 Receipts from customers 70,000 Payments Materials 7,000 Wages 33.000 Other costs and expenses 10.000 9,000 20,000 100,000 10,000 11.000 205.000 3,000 15,000 3.000 Required: a Sales budget b. Production budget (in quantities) C. Plant utilization budget di Direct material usage budget c. Direct labour budget 1. Factory overhead budget Computation of the factory cost per unit for each product h. Direct materials purchases budget i Budgeted cost of goods sold jCash budget k. Budgeted income statement | Budgeted balance sheet