Chairman Line 25 square feet 0 5 hours O 10.32 Budget schedules for a manufacturer. Delite Furniture is an elite gesk manufacturer. It makes two WASANAETA, MUSS products Executive desks - 3 x 5 oak desks Chairman desks - 8x4 red oak desks The budgeted direct-cost inputs for each product in 2012 are Executive Line 16 square feet Oak top 0 Red oak top 4 0 Oak legs Red oak legs 3 hours Direct manufacturing labor Unit data pertaining to the direct materials for March 2012 are Actual-beginning Direct Materials Inventory (3/1/2012) Executive Line Chairman Line 320 0 Oak top square feet) 0 150 Red oak top Isquare feet) 100 0 Oak legs 40 Red oak legs Target Ending Direct Materials Inventory (3/31/2012) Executive Line Chairman Line 192 0 Oak top square feet) 0 200 Red oak top Isquare feet) 80 0 Oak legs Red oak legs Unit cost data for direct-cost inputs pertaining to February 2012 and March 2012 are February (actual) March 2005 (budgeted Oak top (per square feet) Rs 18 Rs 20 Red oak top (per square feet) 23 25 Oak legs (per leg) 11 12 Red oak legs (per leg! 17 18 Manufacturing labor cost per hour 30 30 Manufacturing overhead (both variable and fixed) is allocated to each desk on the basis of budgeted direct manufacturing labor-hours per desk. The budgeted variable manufacturing overhead rate for March 2012 is Rs 35 per direct manufacturing labor-hour. The budgeted foed manufacturing overhead for March 2012 is Rs 42,500. Both variable and fixed manufacturing overhead cost are allocated to each unit of finished goods Data relating to finished goods inventory for March 2012 are Executive Line Chairman Line Beginning inventory in units 20 5 Beginning inventory in rupees (cost) Rs 10,480 Target ending inventory in units Rs 4,850 30 15 Budgeted sales for March 2012 are 740 units of the executive line and 390 units of the chairman line The budgeted selling prices per unit in March 2012 are Rs 1,020 for the executive line desk and Rs 1.500 fer the chairman line desk. Assume the following in your answer. Work-in-process inventories are negligible and ignored. Direct materials inventory and finished goods inventory are Costed using the first-in-first-out (FFO) metal Unit costs of direct materials purchased and finished goods are constant in March 2006. 1. Prepare the following budgets for March 2012 a. Revenues budget 2 subparts b. Production budget in units c. Direct materials usage budget and direct materials purchases budget d. Direct manufacturing labor budget e Manufacturing overhead budget t. Ending inventory budger rsubposts