- 9 Marks
Question
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)
Answer
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)
- Topic: Budgetary control, Cash Budgets and Master Budgets
- Series: MAY 2018
- Uploader: Dotse