- 20 Marks
Question
Abenwooha Ltd. produces two products: products Asana and Pito. The two products use two materials: A and B in their production. Employees engaged to produce both products work in two departments: Dept. X and Dept. Y. The company uses a marginal costing system.
You have just assumed the post of Management Accountant at Abenwooha Ltd. After your induction week, the Financial Controller gives you the data below:
Budgeted Data Product Asana Product Pito GH¢’000 GH¢’000
Sales for the year 15,000 20,000
Standard data per unit of product: Standard price Product Asana Product Pito Direct materials GH¢ Per Kg Kg Kg A 2 50 100 B 4 100 50
Wages to direct workers: Standard wage rate Product Asana Product Pito GH¢ Per hour hours required hours required Dept. X 20 5 4 Dept. Y 40 4 5 The company’s budgeted total variable production overheads and fixed production overheads are GH¢6,000,000 and GH¢3,000,000 respectively. Budgeted labour hours is 600,000 hours. The company earns a markup of 20% on marginal production cost.
Finished goods inventories are valued at standard marginal production cost per unit and are as follows:
Product Asana Product Pito GH¢’000 GH¢’000
Opening inventories 720 840 Closing inventories 432 798
You are required to: Use the data given above to prepare the following budgets:
(a) Production budget in units
(b) Direct materials cost budget
(c) Direct materials purchases budget
(d) Direct labour utilization budget
(e) Direct wages cost budget
(Total: 20 marks)
Answer
To prepare the budgets, first calculate the marginal production cost per unit to find sales units, as sales are in value, and inventories in value at marginal cost.
Marginal production cost = direct materials + direct labour + variable overheads.
Variable overhead rate = total variable overheads / budgeted labour hours = 6,000,000 / 600,000 = GH¢10 per hour.
For Asana per unit: Materials: A 50kg * 2 = 100; B 100kg * 4 = 400; total mat 500 Labour hours: Dept X 5 hrs, Y 4 hrs, total 9 hrs Labour cost: X 520 =100; Y 440 =160; total labour 260 Variable OH: 9 hrs *10 =90 Marginal cost Asana = 500 +260 +90 =850
For Pito: Materials: A 1002=200; B 504=200; total mat 400 Labour hours: X 4 hrs, Y 5 hrs, total 9 hrs Labour cost: X 420=80; Y 540=200; total 280 Variable OH: 9*10=90 Marginal cost Pito =400 +280 +90=770
Sales price = marginal cost + 20% markup. Asana price =850 *1.2 =1,020 Pito =770 *1.2 =924
Sales units = sales value / price Asana sales units =15,000,000 /1,020 ≈14,706 units (note: assuming GH¢ not ‘000, but data has GH¢’000, but inventories 720’000, but to match, perhaps all in ‘000.
The sales is GH¢’000 15,000, so 15,000,000 But units 15,000,000 /1,020 =14,706 units
Opening inventory Asana =720,000 /850 ≈847 units (720/0.85=847.06, approx 847
Closing Asana =432/850 ≈508 units
Pito opening 840/770 ≈1,091 units
Closing 798/770 ≈1,036 units
To be exact, let’s use code_execution for precise.
But since closed-ended math, explain.
Assuming the values are in GH¢, but labeled ‘000, but to have whole units, perhaps sales is GH¢15,000,000, inventories GH¢720,000.
Calculation:
First, marginal cost Asana 850 GH¢ per unit
Sales Asana 15,000,000 / (850*1.2) =15,000,000 /1,020 ≈14,705.88, say 14,706 units
Opening inventory 720,000 /850 =847.058, say 847 units
Closing 432,000 /850 =508.235, say 508 units
For Pito 20,000,000 /924 ≈21,645.02, say 21,645 units
Opening 840,000 /770 =1,090.91, say 1,091
Closing 798,000 /770 =1,036.36, say 1,036
To be precise, perhaps the ‘000 is for thousands, but numbers are designed for exact.
Let’s check if markup is on marginal cost, yes.
Perhaps sales is GH¢15,000 ‘000 =15,000,000
Yes, and units are fraction, but in budgets, we use exact.
But for answer, I’ll use rounded, but to be accurate, let’s calculate exact.
Notice the sales 15,000 ‘000, but perhaps it’s GH¢15,000,000.
But for production budget: production = sales + closing – opening
So, need units.
Let’s calculate the sales units exactly.
For Asana, price 1,020 GH¢
Sales value 15,000,000
Units =15,000,000 /1,020 =14,705.882
But opening 720,000 /850 =847.0588
Closing 432,000 /850 =508.2353
Perhaps the numbers are designed to be exact, perhaps I have unit error.
The data has GH¢’0000 for sales, but perhaps it’s GH¢’000 for all.
Look at the original, “GHe’0000” for sales, perhaps it’s GH¢000, but to make units whole, perhaps sales is 15,000 (GH¢000), so 15,000,000 GH¢.
But units 15,000,000 /1,020 =14,705.88, not whole.
Perhaps the markup is on cost, but to find, perhaps calculate back from inventories.
Perhaps the inventories are in GH¢’000, and sales in GH¢’000.
But to have whole units, perhaps assume large numbers.
For the budget, we can use the numbers as is, with fractional units, but in practice, round.
But for exam, probably they are exact.
Let’s calculate the marginal cost again.
Direct materials A 2 GH¢ per kg, Asana 50 kg =100 GH¢
B 4 per kg, 100 kg =400 GH¢
Labour X 20 per hr, 5 hrs =100
Y 40 per hr, 4 hrs =160
Variable OH 10 per hr, 9 hrs =90
Total 100+400+100+160+90 =850 yes.
Perhaps the sales is 15,000 ‘000 =15,000 thousand GH¢ =15,000,000 GH¢
Units =15,000,000 /1,020 =14,705.88
Perhaps round to 14,706 units
Opening 720,000 /850 =847.06 ≈847
Closing 432,000 /850 =508.24 ≈508
Production =14,706 +508 -847 =14,367 units
Similarly for Pito.
To be precise, perhaps use exact fractions, but in answer, I’ll use rounded.
For (b) direct materials cost budget, that is for production.
For (c) purchases = usage + closing – opening, but no inventory for materials given, so perhaps assume no stock of materials, or the budget is for production cost, but purchases budget is for materials, so assume zero opening/closing for materials, as not given.
The question has no materials inventory info, so purchases = usage.
Yes, common in such questions.
For labour, utilization is hours.
Let’s prepare.
First, calculate units.
To make exact, perhaps the sales is in GH¢, but that is small, no.
The handbook is old, perhaps the numbers are to be used as is, with ‘000.
To get whole numbers, notice the inventories are valued at marginal cost, so units can be calculated exactly as 720 /0.85 =847.058, but perhaps it’s intended to be GH¢ , but let’s use exact.
Let’s calculate the number of units.
For Asana sales units = (sales value) / price = 15,000 /1,020 =14.70588 thousand units? No, if sales is 15,000 ‘000, it’s 15,000 thousand GH¢.
The label is GHe’0000, perhaps typo for GH¢’000.
Assume the numbers are in thousands, but to have, perhaps multiply all by 1,000 to make whole.
Perhaps the problem expects to calculate the marginal cost in GH¢, and sales in GH¢’000, but units in thousands.
But to resolve, perhaps the sales is 15,000,000 GH¢, units 14,706 for Asana, but use exact.
For the answer, I’ll calculate as follows:
First, marginal cost Asana 850 GH¢
Price 1,020 GH¢
Sales value 15,000,000 GH¢
Sales units =15,000,000 /1,020 =14,705.88 units
Opening units =720,000 /850 =847.06 units
Closing units =432,000 /850 =508.24 units
Production units = sales + closing – opening =14,705.88 +508.24 -847.06 =14,367 units
Similarly for Pito price 924 GH¢
Sales units =20,000,000 /924 =21,645.02 units
Opening =840,000 /770 =1,090.91 units
Closing =798,000 /770 =1,036.36 units
Production =21,645.02 +1,036.36 -1,090.91 =21,590.47 units
This is not nice, perhaps the ‘0000 is typo, and it’s GH¢’000 for sales, but inventories GH¢’000, but same.
Perhaps the markup is 20% on cost, but to find units, perhaps the inventories are in GH¢’000, sales in GH¢’000.
So sales Asana 15,000 (‘000) =15,000,000 GH¢
Yes, same.
Perhaps the problem is to calculate without rounding, but in exam, they expect rounded.
Perhaps the variable OH is included in marginal cost for markup.
Yes, marginal cost includes variable OH.
Perhaps to make whole, let’s assume the numbers are such, and use rounded numbers for budget.
For (a) Production budget in units
Asana: sales 14,706 units + closing 508 – opening 847 =14,367 units
Pito: 21,645 +1,036 -1,091 =21,590 units
(b) Direct materials cost budget (for production)
For A: Asana 14,367 *50 kg *2 GH¢ =14,367 *100 =1,436,700
Pito 21,590 *100 kg *2 =21,590 *200 =4,318,000
Total A cost 5,754,700
For B: Asana 14,367 *100 *4 =14,367 *400 =5,746,800
Pito 21,590 *50 *4 =21,590 *200 =4,318,000
Total B cost 10,064,800
Total direct materials cost 5,754,700 +10,064,800 =15,819,500 GH¢
(c) Direct materials purchases budget
Since no opening/closing stock for materials given, purchases = usage, so same as cost budget, 15,819,500 GH¢
But the budget is for quantity or cost? The question says direct materials purchases budget, probably cost or quantity.
Typically cost.
(d) Direct labour utilization budget (hours)
Asana production 14,367 units
Dept X: 14,367 *5 =71,835 hrs
Dept Y: 14,367 *4 =57,468 hrs
Pito 21,590 units
Dept X: 21,590 *4 =86,360 hrs
Dept Y: 21,590 *5 =107,950 hrs
Total X 71,835 +86,360 =158,195 hrs
Total Y 57,468 +107,950 =165,418 hrs
Total labour hours 323,613 hrs
(e) Direct wages cost budget
Dept X total hrs 158,195 *20 =3,163,900 GH¢
Dept Y 165,418 *40 =6,616,720 GH¢
Total wages 9,780,620 GH¢
Explanation: First, calculated marginal cost per unit as above, then price = marginal cost *1.2
Then units = sales value / price (sales value =15,000 *1,000 =15,000,000 GH¢ for Asana, similar for Pito)
Opening and closing units = inventory value / marginal cost per unit
Production = sales units + closing units – opening units
For materials cost, production units * per unit kg * price per kg
For purchases, as no stock info, = cost
For labour utilization, production units * hours per unit
For wages, hours * rate
Note: Rounded to whole units for practicality, as fractional units not typical, but in exact, use decimal.
In Ghanaian budgeting, this supports operational planning, aligning with BoG’s sustainable banking principles for efficient resource use.
- Topic: Management Control
- Series: OCT 2022
- Uploader: Samuel Duah