A company‘s production for the year ending 30.3.2011 is given below:

Items

Production Departments

Office

Stores

Work shop

Total

 

P1

P2

P3

       

Direct Wages

Rs.20,000

25,000

30,000

 

 

 

75,000

Direct Materials

Rs.30,000

35,000

45,000

 

 

 

1,10,000

Indirect Materials

Rs.2,000

3,000

3,000

1,000

2,000

2,000

13,000

Indirect Wages

Rs.3,000

3,000

4,000

10,000

10,000

5,000

35,000

Area in Square Meters

200

250

300

150

100

250

1,250

Book value of Machinery

Rs.30,000

35,000

25,000

 

 

15,000

1,05,000

Total H.P. of Machinery

15

20

25

 

 

5

65

Machine Hours Worked

10,000

20,000

15,000

 

 

5,000

50,000

General Expenses:

(i) Rent

Rs.12,500

(ii) Insurance

Rs.1,050

(iii) Depreciation

15% of value of machinery

(iv) Power

Rs.3,800

(v) Light

Rs.1,250

You are required to prepare an overhead analysis sheet for the departments showing clearly the basis of apportionment when necessary.