UGB106 Management Accounting: Costing, Budgeting, and Analysis

Verified

Added on Β 2023/06/18

|19
|4364
|139
Report
AI Summary
This document presents a comprehensive analysis of management accounting principles through the lens of several practical questions. It begins with Plaistead Plc, examining contribution per unit, break-even sales revenue, margin of safety, and profit estimation under varying conditions, including pricing strategy adjustments. The analysis extends to calculating the units needed to achieve a specific profit target and evaluating the impact of new pricing strategies. The report then transitions to Crawford Plc, focusing on cost allocation across different departments using various methods such as employee numbers, direct materials, and floor space. It calculates overhead recovery rates and determines the full job cost for a special product. Finally, the document briefly discusses the advantages and disadvantages of absorption costing. The assignment also includes estimations of budgets and variances.
Document Page
Introduction to
management accounting
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Contents
Contents................................................................................................................................................2
Part 1.....................................................................................................................................................3
Question 2: Plaistead Plc..................................................................................................................3
Part 2.....................................................................................................................................................8
Question 3: Crawford Plc.................................................................................................................8
Part 3.....................................................................................................................................................3
Question 4:........................................................................................................................................3
REFERENCES.....................................................................................................................................9
Document Page
Part 1
Question 2: Plaistead Plc.
Answer to (a)
Estimating Contribution per Unit
Note: Contribution per unit = (selling price per unit) – (variable costs per unit)
Particulars Β£
Selling Price 13
Materials (5.25)
Labour (2.95)
Variable Overheads (1.85)
Β£2.95
Answer to (b)
Estimating Break Even Sales Revenue at the Break-even Point and Margin of Safety:
Break Even point is reached when: total contribution = total fixed costs.
The break-even point (units) is estimated as:
Fixed Cost/ (𝑠𝑒𝑙𝑙𝑖𝑛𝑔 π‘π‘Ÿπ‘–π‘π‘’ π‘π‘’π‘Ÿ 𝑒𝑛𝑖𝑑)–(π‘£π‘Žπ‘Ÿπ‘–π‘Žπ‘π‘™π‘’ π‘π‘œπ‘ π‘‘π‘  π‘π‘’π‘Ÿ 𝑒𝑛𝑖𝑑)
Note: (selling price per unit) – (variable costs per unit) = Contribution per unit
According to the information in the question, total fixed costs are estimated as:
Production Fixed Costs = Β£59,000
Selling Fixed Costs. = Β£47,600
Β£106,600
Document Page
Applying the formula, the number of electric kettles at break-even (the break-even point
(sales): =Β£106,600
Β£2.95
= 36,136 electric kettles.
Therefore, Revenue at Break-even = 36,136 electric kettles x Β£13
= Β£469,768
Margin of Safety (Volumes/Units) = (Planned sales in unit) - (Breakeven sales in unit)
= (53, 000 electric kettles) – (36, 136 electric kettles)
= 16, 864 electric kettles
Margin of Safety (Revenue) = (Planned sales revenue) - (Breakeven revenue)
= Β£689,000 –£469,768
= Β£219, 232
OR
Margin of safety (revenue) = (Margin of safety (volume/unit)) x (Selling price)
= 16,864 electric kettles x Β£13
= Β£219, 232
Answer to (c)
Estimating profit at 53,000 electric kettles at selling price of Β£13per electric kettle:
Sales (from question) = 53,000 electric kettles
Break even number of electric kettles (from calculation). = 36,136 electric kettles
Therefore, sales are above break-even point by 16,864 electric kettles (53, 000 – 36,136)
Contribution per electric kettles = Β£2.95
Additional contribution = 16, 864 x Β£2.95 = Β£49, 749
Answer to (d)
Estimating units of electric kettles to produce and sell for a profit of Β£90,000
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Creating and attempting to sell 36,136 electric kettles would then contribute in neither a
deficit nor revenue, as per the computations above. This really is the juncture at which
the investment pays off hence is called break-even point (Abou Taleb and Al Farooque,
2021).
ο‚· In many other phrases, no profit, no loss (zero profits) would've been decided to
make when 36,136 electric kettles were manufactured and marketed.
ο‚· Evey supplemental electric kettle bought and marketed will indeed contribute
Β£2.95 (see answer (a) above).
ο‚· To create Β£90,000 revenue, the multitude of different electric kettles to generate (in
addition to 36,136 electric kettles) is:
Β£90,000
Β£2.95
= 30,508 electric kettles.
As a consequence, the maximum count of electric kettles that might have needed to be
manufactured and marketed in sequence to make a revenue of Β£90,000 would have been:
= (36,136 electric kettles) + (30,508 electric kettles = 66,644 electric kettles
Answer to (e)
Recalculation of selling price at which 53,000 electric kettles would be sold for a profit of Β£90,000.
Total contribution = (fixed costs) + (profit)
Therefore: Profit = (Total Contribution) – (Fixed Costs)
Thereafter: Derive β€˜contribution per unit’ of 53, 000 electric kettles.
Note that: Contribution per unit = (selling price per unit) – (variable costs per unit)
Therefore: Selling Price per unit = (Contribution per unit) + (variable costs per unit) Total
Contribution is estimated as: Β£106,600 (Fixed costs) + Β£90,000 (Profit desired) = Β£196, 600
Document Page
If 53,000 electric kettles are sold, contribution needed per electric kettles is estimated as:
Β£196, 600
53, 000 (electric kettles)
= Β£3.71
Therefore, the estimated selling price = (Contribution per unit) + (variable costs per unit):
Contribution per unit Β£3.71
Materials Β£5.25
Labour Β£2.95
Variable Overheads Β£1.85
New Selling Price Β£13.76
Answer to (f)
Adoption of new pricing strategy:
Proposed Strategy’s Selling Price = Β£13 x 1.09 (estimating 9% increase in
selling price)
= Β£14.17
Proposed Strategy’s Contribution (per kettle) = Β£2.95 + Β£1.17 (This is the proposed
Strategy’s selling price less old selling price)
= Β£4.12
Proposed Strategy’s Sales (in Units/Volume) = 53, 000 x 1.17 (estimating 17% increase in
Sales volume)
=62, 010 electric kettles
Document Page
Proposed Strategy’s Total Contribution = Β£4.12 x 62, 010 electric kettles
= Β£255,481
Proposed Strategy’s Fixed Costs = Β£106,600 + Β£45,000
= Β£151, 600
Proposed Strategy’s Profit = New Total Contribution – New Fixed Costs
= Β£255, 481 - Β£151,600
= Β£103, 881
The suggested technique generates a revenue of Β£103, 881, which is larger than the initial
allocated financial gain of Β£49,749 As a result (as stated in response (c) above), the new
proposal is a vital way that should be approved by Plaistead Plc (Adams and Larrinaga, 2019).
Answer to (g)
The break-even assessment is based on a number of assumptions, including the aforementioned:
ο‚· All costs (manufacturing, shipments, and setup) are broken down into fixed and changeable
components.
ο‚· Since the framework of expenditure is continuous, if valuation records are kept on a chart,
there will be a tendency.
ο‚· The total quantity of operating expenses would then stay unchanged at each current output,
while indirect expenses would then vary in comparison to production.
ο‚· The manufacturer's selling prices will stay continuous at each and every sale volume,
implying that it does not change in response to variants in end goods (Alsharari and
Abougamos, 2017).
ο‚· The cost of implementation, employees, housing, advertising, and other bought equipment
would all stay unchanged.
ο‚· People’s views and computer systems' science abilities and efficacy will indeed remain
unchanged.
ο‚· Earnings and expenditure were also computed using a fully electric measurement, like the
fair prices of inventory or the total demand.
ο‚· Only the level of productivity or marketing is viewed as a crucial percentage of the price
(Altukhov, Predeus and Predeus, 2019).
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Part 2
Question 3: Crawford Plc
Answer to (a)
Allocating cost based on:
ο‚· Number of employees 12:10:3.
ο‚· Direct materials 17:8.
ο‚· Floor space 3:4:1.
ο‚· Floor space 3:4:1.
ο‚· Machinery used in each department 50:40:3.
ο‚· Number of employees 12:10:3.
ο‚· Kilowatt hours 1.5:1.3:2.
STEP 1: Allocating costs to departments using a suitable method (ratio) for each
department:
Total (Β£) Assembly (Β£) Joinery (Β£) Canteen
(Β£)
Indirect labour–12:10:3 28 000 13,440 11,200 3,360
Indirect material – 17:8 22 000 14 960 7 040 -----
Heating & lighting – 3:4:1 13 000 4 875 6 500 1 625
Rent & rates – 3:4:1 14 000 5 250 7 000 1 750
Depreciation – 50:40:3 19 000 10 215 8 172 613
Supervision – 12:10:3 15 000 7 200 6 000 1 800
Power – 1.5:1.3:2 9 000 2 813 2 438 3 750
120 000 58 753 48 350 12 898
STEP 2: Allocating service department costs to production departments:
Total (Β£) Assembly (Β£) Joinery (Β£) Canteen
(Β£)
Balance from Step 1 above 120 000 58 753 48 350 12 898
Allocate Canteen to Assembly &
Joinery
7 035 5 863 [12 898]
120 000 65 788 54 213 ------
STEP 3: Calculating the overhead recovery rates for Assembly and Joinery Department:
The expenditure installed capacity is determined by the number of "labour hours." In both
cases, the department's overhead costs are calculated by dividing the number of real labour
hours for each suburb. The following is the surplus recovery proportion:
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦ π·π‘’π‘π‘Žπ‘Ÿπ‘‘π‘šπ‘’π‘›π‘‘ = π‘‡π‘œπ‘‘π‘Žπ‘™ π‘‚π‘£π‘’π‘Ÿβ„Žπ‘’π‘Žπ‘‘ πΆπ‘œπ‘ π‘‘ π‘œπ‘“ π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦
π·π‘’π‘π‘Žπ‘Ÿπ‘‘π‘šπ‘’π‘›π‘‘ Diπ‘Ÿπ‘’π‘π‘‘ πΏπ‘Žπ‘π‘œπ‘’π‘Ÿ π»π‘œπ‘’π‘Ÿπ‘  π‘œπ‘“π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦ π·π‘’π‘π‘Žπ‘Ÿπ‘‘π‘šπ‘’π‘›t
Document Page
= 65,788 = Β£31.33 per labour hour
2 100 hours
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦ π·π‘’π‘π‘Žπ‘Ÿπ‘‘π‘šπ‘’π‘›π‘‘ = π‘‡π‘œπ‘‘π‘Žπ‘™ π‘‚π‘£π‘’π‘Ÿβ„Žπ‘’π‘Žπ‘‘ πΆπ‘œπ‘ π‘‘ π‘œπ‘“ π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦ π·π‘’π‘π‘Žπ‘Ÿπ‘‘π‘šπ‘’π‘›π‘‘
π·π‘–π‘Ÿπ‘’π‘π‘‘ πΏπ‘Žπ‘π‘œπ‘’π‘Ÿ π»π‘œπ‘’π‘Ÿπ‘  π‘œπ‘“ π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦ π·π‘’π‘π‘Žπ‘Ÿπ‘‘π‘šπ‘’π‘›t
= Β£54,202 =38.72 per labour hour
1 400 hours
Answer to (b)
Special Product Soft Stool: Calculation of full job cost and product cost for 10 units of Soft Stool.
Β£ Β£
Direct costs 85
Production overhead:
Assembly department (4 labour hours x Β£31.33) 125.32
Joinery department (6 labour hours x Β£38.72) 232.32
Total production overheads 357.64
Total production cost for one unit Β£442.64
Total production for 10 units (Β£442.64 x 10) Β£4,426.4
Working of Overhead Costs Allocations
Allocation of cost of indirect labour is 12:10:3 (= 25), on the basis of number of employees
(28 000)
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦= 12 x Β£28,000=Β£13,440
25
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦= 10 x Β£28,000=Β£11,200
25
πΆπ‘Žπ‘›π‘‘π‘’π‘’π‘›= 3 x Β£28,000=Β£3,360
25
Note: Canteen would not be reimbursed for indirect material costs because they are not
manufacturing and do not use the Β£22,000 in raw - materials.
Allocation of cost of indirect materials is 17:8(= 25), in proportion to direct materials
Document Page
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦= 17x Β£22,000=Β£1
πŸ’,960
25
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦= 8 xΒ£22,000=Β£7,4
𝟎
25
Allocation of cost of heating and lighting is 3:4:1(= 8), in proportion to floor space (13 000)
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦=3 x Β£13,000=Β£4,875
8
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦= 4 x Β£13,000=Β£6,500
8πΆπ‘Žπ‘›π‘‘π‘’π‘’π‘›= 1 x Β£13,000=Β£1,25
8
Allocation of cost of rent and rates is 3:4:1(= 8), in proportion to floor space (14 000)
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦=3 x Β£14,000=Β£5,250
8
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦. =4x Β£14,000=Β£7,000
8
πΆπ‘Žπ‘›π‘‘π‘’π‘’π‘›=1 xΒ£14,000=Β£1,750
8
Allocation of depreciation cost is 50:40:3(= 93), according to the value of machinery used in each
department (19 000)
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦=50 x Β£19,000=Β£10,215
93
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦=40 x Β£19,000=Β£8,172
93
πΆπ‘Žπ‘›π‘‘π‘’π‘’π‘›=3 xΒ£19,000=Β£613
93
Allocation of cost of supervision is 12:10:3(= 25), on the basis of number of employees
(15,000)
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦=12 𝑋£15,000=Β£7,200
25
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦=10 𝑋£15,000=Β£6,000
25
πΆπ‘Žπ‘›π‘‘π‘’π‘’π‘›=3 𝑋£15,000=Β£1,800
25
Allocation of cost of power is 1.5:1.3:2(= 4.8), on the basis of kilowatt hours (9,000)
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦=1.5 xΒ£9,000=Β£2,813
4.8
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦=1.3 xΒ£9,000=Β£2,438
4.8
πΆπ‘Žπ‘›π‘‘π‘’π‘’π‘›= 2 xΒ£9,000=Β£3,750
4.8
Document Page
Absorption of canteen cost is 12:10(=22), on the basis of kilowatt hours
π΄π‘ π‘ π‘’π‘šπ‘π‘™π‘¦=12 xΒ£12,898=Β£7,035
22
π½π‘œπ‘–π‘›π‘’π‘Ÿπ‘¦=10 𝑋 Β£12,898 =Β£5,863
22
Answer to (c)
Functioning at a continual absorptive stage is far more effective and definitely less
expensive (plant-wide rate). Nevertheless, if manufacturing methods vary markedly across
segments (labour-intensive vs that of machine-intensive), using a set sum quantity is
probable to exaggerate operational cost. It might have been risen if the outcomes were
dissimilar (Altukhov, Predeus and Predeus, 2019).
Advantages of Absorption Costing:
ο‚· GAAP Compliance– It has the advantage of adhering to Generally Accepted
Accounting Principles (GAAP), which is required for submitting with the Tax
Authorities (IRS).
ο‚· Accounting for All Production Costs– Extendable selling prices hardly considers
direct costs, whereas this takes into account all production costs. Absorptive costing
is used to address for corrected operating costs such as staff, property rental prices,
and energy costs. This provides employees with a far more complete picture about
how much a business consumes on each item, allowing someone to implement
orders to increase the economic growth and revenues options (Aouni, McGillis and
Abdulkarim, 2017).
ο‚· Tracking Profits- Absorption cost, as compared to extendable costing, offers a
much more precise financial position, particularly if all goods are not supplied
during that given cycle. If a firm spends manufacturing in the assumption of a
consistent sales growth, this is becoming a major problem.
Disadvantages of Absorption Costing:
chevron_up_icon
1 out of 19
circle_padding
hide_on_mobile
zoom_out_icon
[object Object]