Prepare the following budgets for the month of April, May and June 2014: Sales budget in units and value , production budget in units,total direct material usage and direct material purchase budget in units and value, total direct labour cost budget in value ,total production overhead cost budget in value, total production cost budget in value .

thank you.

1) Lucky Sdn Bhd manufactures a product called Win. This product uses a special raw material so called HW" in its production. The selling price of Win is set at RM 30.00 per unit. The following information relates to the budgeted sales units of the Win for the year 2014: Month Sales Unit Month Sales Unit January 24,000 July 29,000 February 26,000 August 26,000 March 28,000 September 24,000 April 29,000 October 26,000 May 25,000 November 28,000 June 27,000 December 30,000 Additional information: i. The balances for opening and closing of sales and raw materials are as follows: Month Sales Raw materials January Opening Closing Opening Closing February 1,800 2,500 23,010 22,000 March 2,500 8,700 22,000 25,020 April 8,700 7,500 25,020 23,040 May 7,500 8,100 23,040 24,840 June 8,100 6,700 24,840 25,290 July 8,700 8,700 25,290 26,700 Augusi 8,700 9,100 26,700 28,120 September 9,100 8,500 28,120 29,130 October 8,500 8,700 29, 130 32,000 9,000 32,000 32,300 November 8,700 December 9,000 9,200 32,300 34,100 ii. The product requirements per unit are 3 kilograms of materials "HW" and 2 hours of direct labour. iii. Material "HW" can be purchased at RM 8.00 per kilogram and the direct labour hour rate is RM 15.00 per hour. iv. Overhead is absorbed at RM 1.50 per direct labour hour. Required