Question is below, kindly help as deadline approached

Problem 17 A company is engaged in the manufacture of specialized sub-assemblies required for certain electronic components. The company estimates that in the forthcoming, December 2005, the sales will take a pattern of 3:4:2 respectively of sub-assemblies ACB, MCB and DP The following is the schedule of components required for manufacture: Components requirements Sub-assemblies Selling price Base board ICOS IC12 IC26 ACB 520 MCB 500 DP 350 4 Purchase Price Rs.60 Rs.20 Rs. 12 Rs.8 The direct labour time and variable overheads required for each of sub-assemblies are: Particulars Labour hours per sub-assembly Grade A Grade B Variable overheads per sub-assembly ACB 8 16 36 MCB 6 12 24 DP 4 24 Direct wages per hour Rs.5 Rs.4 7 Page Marginal Costing - Short Term Decision Making The labour works & hours a day for 25 days a month. The opening stocks of sub-assemblies and components for December 2005 are as under: Sub-assemblies Components ACB ROO Base board 1600 MCB 1200 ICOS 1200 DP 2800 IC12 6000 IC26 4000 Fixed overheads amount to Rs. 757200 for the month and a monthly profit target of Rs.12 Lacs has been set. The company is poised for a reduction of closing inventories for Dec.2005 of sub-assemblies and components by 10% in quantity as compared to the opening stock. Prepare the following budgets for Dec. 2005. Sales budget in quantity and value . . . Production budget in quantity Component usage budget in quantity Component purchase budget in quantity and value Manpower budget showing the number of workers and the amount of wages payable