Can someone help me to do question a-f please? The questions as following:
mm Company is a company that makes two types of dining tables: Plain and Maple. There are two types of direct materials: Pine and Mahogany woods. Direct manufacturing labour workers are hired on an hourly basis; no overtime is worked. In terms of manufacturing overhead costs, there are two manufacturing overhead cost pools and two cost drivers. The two manufacturing overhead cost pools are manufacturing operations overhead and machine setup overhead. The cost drivers for manufacturing overhead are: direct manufacturing labour-hours for manncturing operations overhead cost and setup labour- hours for machine setup overhead cost. Nonmanufacturing costs consist of product design, marketing, and distribution costs. The following data are available for the EDIE} budget: _ 310...... mam-(m2) Ir Mahogany $15 permeter square (m3) Direct Manufacturing labour rate 3213 per hour Quantity of Material for Each Product Products Plain Table* Maple Table* Expected Sales for 2015 ( in units*!* 52.000 18.OOD Selling Price 720 $ Target Ending Inventory It units 1 1.000 1. 000 Beginning Inventory In units 1.000 Beginning Inventory in dollars 420.000 $ 315.000 Direct materials inventory Pine Mahogany Beginning Inventory 80,000 m= Target Ending Inventory 20.000 17=\\ Data on Manufacturing Overhead Cost Manufacturing Operations Overhead cost ( capacity of 501, 000 direct manufacturing labour- hours) Variable manufacturing operation overhead costs ( PET direct manufacturing labour- hours) Supplies 5.00 Indirect manufacturing labour* 6.00 Power ( support department costs ) Maintenance ( support department costs) 7.00 Total variable manufacturing operation overhead cost 4. 00 22.010 Fixed manufacturing operation overhead cost Depreciation 1. 200.000 Supervision 100.090 Power ( support department costs ) 750.000 Maintenance ( support department costs) 425.000 Total fixed manufacturing operation overhead cost 2, 775, 000Machine Setup Overhead Costs ( capacity of 10, 0010 setup labour-hours) Variable machine setup overhead cost ( PET setup labour- hours ) Supplies 20 Indirect manufacturing labour Power ( support department ) 15 Total variable machine setup overhead cost 95 Fixed machine setup overhead cost Depreciation 515,000 Supervision 1. 10.0. 000 Power ( Support department cost ! 23.000 Total fired machine setup overhead cost 1. 635, 000 0. 2 hour of setup labour- hour is allocated to make one unit of Plain table and O. ] hour of* setup labour- hour is allocated for Maple table . Non- manufacturing Cost Product Design Cost ( fixed ; 1.000.000 Marketing Cost Fixed marketing cost 950.000 Variable marketing cost Equals `` of revenues Distribution Cost 5 Fixed distribution cost 1 . 50.0.000 Variable distribution cost is $ 2 per cubic feet of table sold and shipped Plain table 15 cubic feet per table sold and shipped Maple table 20 cubic feet per table sold and shipped Required :` Based on the above information provided by the various department managers . prepare the following* budgets :` Sales Revenue Budget ( Z' marks ) bo . Production Budget in unit ( 3 marks ) Direct Material sage Budget in quantity and dollars ( use FIFO For material allocation ) ( 6 points) Direct Material Purchases Budget in quantity and dollars ( 4 points) E . Direct Manufacturing Labour Cost budget ( 3 points ) Manufacturing Overhead Cost Budget ( 6 points ) E - Budgeted unit cost of ending finished goods inventory ( 4 points) Ending Inventory Budget ( 3 points) Cost of Goods Sold Budget ( 3 points) Non - manufacturing Cost Budget ( 3 points) Budgeted Income Statement . ( 3 points )
