Reference no: EM132553166

Dimuthu Limited is preparing its annual budgets for the year 31 st December 2013. It manufactures and sells one product, which has a selling price of Rs 150. The marketing director believes that the price can be increased to Rs. 160 with effect from 1 July 2013.

At this price the sales volume for each quarter of 2013 will be as follows:

Sales volume

Quarter 1 40,000

Quarter 2 50,000

Quarter 3 30,000

Quarter 4 45,000

Sales for each quarter of 2014 are expected to be 40,000 units. Each unit of the finished product which is manufactured requires four units of component R and three units of component T. together with a body shell S. These items are purchased from an outside supplier.

Currently prices are:

Component R Rs. 8 each

Component T Rs. 5 each

Shell S Rs. 30 each

The components are expected to increase in price by 10 per cent with effect from from I April 2013; no change is expected in the price of the shell.

Assembly of the shell and components into the finished product requires 6 labor hours: labor is currently paid at Rs. 10 per hour. A 4 per cent increase in wage costs is anticipated to take effect from 1 October 2013. Variable overhead costs are expected to be Rs. 10 per unit for the whole of 2013: fixed production overhead costs are expected to be Rs. 240,000 for the year; and are absorbed on a per unit basis. Stocks on 31 st December 2012 are expected to be as follows:

Finished units 9000 units

Component R 3000 units

Component T 5500 units

Shell S 500 units

Closing stocks at the end of each quarter are to be as follows:

Finished units 10% of next quarter's sale

Component R 20% of next quarter's production requirements

Component T 15% of next quarter's production requirements

Shell S 10% of next quarter's production requirements.

Question (a) Required to prepare the following budgets of Dimuthu Limited for the year ending 31 December 2013 showing, values for each quarter and the year in total:

(i) Sales budget (in RS and units)

(ii) Production budget (in units)

(iii) Material usage budget (in units)

(ix) Production cost budget (in RS)

Question (b) Sales are often considered to be the principal budget factor of an organization. Explain the meaning of the principal budget factor and assuming that it is sales, explain how sales may be forecast making appropriate reference to the use of statistical techniques and the use of microcomputers.