Diminutive Limited is a manufacturing company situated at the Jubilee field that produces chemicals for oil production. The company is preparing its budget for the coming year. It expects to be able to sell 10,000 tonnes of its only product, the “Sparkle Oil,” in January 2016. Sales are then expected to rise to 11,000 tonnes in February and 14,000 tonnes in March and then remain stable for the rest of the year.

Diminutive Limited aims to carry a finished goods inventory at the end of each month equal to 10% of the following month’s sales. Each “Sparkle Oil” takes 2 hours of labour to make. Diminutive Limited’s 132 production workers are employed on contracts that require them to work a minimum of 160 hours per month and are each paid GH¢1,280 per month. Production workers are highly skilled and require a minimum of one year’s training. In the short term, it is not possible to recruit any more production workers. Any labour hours required in excess of 160 hours per worker are made up by overtime that is paid at the basic rate plus an overtime premium of 48% of the basic rate.

Required:

i) Prepare the production budget on a monthly basis for the first quarter of 2016. (3 marks)

ii) Prepare the labour budget for the first quarter of 2016 showing both hours and labour cost (assume that all production workers work at least 160 hours per month). (6 marks)

i) Production Budget for the First Quarter of 2016:

Months January February March
Budgeted sales (units) 10,000 11,000 14,000
Add: Closing stock (10% of next month’s sales) 1,100 1,400 1,400
Less: Opening stock (1,000) (1,100) (1,400)
Production requirement 10,100 units 11,300 units 14,000 units

(3 marks)

ii) Labour Budget for the First Quarter of 2016:

Months January February March
Labour Hours:
Production Requirement (units) 10,100 11,300 14,000
Labour Hours (2 hours per unit) 20,200 22,600 28,000
Standard Hours Available (132 workers × 160 hours) 21,120 21,120 21,120
Overtime Required (Hours) 0 1,480 6,880
Labour Cost (GH¢):
Basic Rate Payment (GH¢1,280 × 132 workers) 168,960 168,960 168,960
Overtime Payment:
January (no overtime) 0
February (1,480/160 × GH¢1,280 × 1.48) 0 17,523 0
March (6,880/160 × GH¢1,280 × 1.48) 0 0 81,459
Total Labour Cost (GH¢) 168,960 186,483 250,419

(6 marks)