Paper - 5: Advanced Management Accounting Questions Limiting Factor
Paper - 5: Advanced Management Accounting Questions Limiting Factor
Paper - 5: Advanced Management Accounting Questions Limiting Factor
QUESTIONS
Limiting Factor
1. List out the basis for deciding the priority of selecting the best product in the different
circumstances stated below:
(i) When maximum sales (in value) is a limiting factor.
(ii) When raw-material is a limiting factor.
(iii) When labour hour is a limiting factor.
(iv) When there is a heavy demand for the product.
Break-even Point (Batches)
2. DRB Ltd. is a leading Home Appliances manufacturer. The company uses just-in- time
manufacturing process, thereby having no inventory. Manufacturing is done in batch size
of 100 units which cannot be altered without significant cost implications. Although the
products are manufactured in batches of 100 units, they are sold as single units at the
market price. Due to fierce competition in the market, the company is forced to follow
market price of each product. The following table provides the financial results of its four
unique products:
D1 D2 D3 D4 Total
Sales (units) 2,00,000 2,60,000 1,60,000 3,00,000
(`) (`) (`) (`) (`)
Revenue 26,00,000 45,20,000 42,40,000 32,00,000 145,60,000
Less: Material Cost 6,00,000 18,20,000 18,80,000 10,00,000 53,00,000
Less: Labour Cost 8,00,000 20,80,000 12,80,000 12,00,000 53,60,000
Less: Overheads 8,00,000 7,80,000 3,20,000 12,00,000 31,00,000
Profit / (Loss) 4,00,000 (1,60,000) 7,60,000 (2,00,000) 8,00,000
Since, company is concerned about loss in manufacturing and selling of two products so,
it has approached you to clear picture on its products and costs. You have conducted a
detailed investigation whose findings are below:
The overhead absorption rate of `2 per machine hour has been used to allocate overheads
into the above product costs. Further analysis of the overhead cost shows that some of it
is caused by the number of machine hours used, some is caused by the number of batches
produced and some are product specific fixed overheads that would be avoided if th e
product were discontinued. Other general fixed overhead costs would be avoided only by
the closure of the factory. Numeric details are summarized below:
` `
Machine hour related……………………………………………………………… 6,20,000
Batch related……………………………………………………………………….. 4,60,000
Product specific fixed overhead:
D1…………………………………………………….10,00,000
D2……………………………………………………...1,00,000
D3………………………………………………..…… 2,00,000
D4………..…………………………………………….1,00,000…………. 14,00,000
General fixed overheads………………………………………………………. 6,20,000
31,00,000
The other information is as follows:-
D1 D2 D3 D4 Total
Machine Hours 4,00,000 3,90,000 1,60,000 6,00,000 15,50,000
Labour Hours 1,00,000 2,60,000 1,60,000 1,50,000 6,70,000
Required
(i) Prepare a profitability statement that is more useful for decision making than the profit
statement prepared by DRB Ltd.
(ii) Calculate the break-even volume in batches and also in approximate units for Product
‘D1’.
Flexible Budget
3. XEH Ltd. Had prepared fixed and flexible budget for the financial year 2017-18 as under:
Fixed Budget for full Flexible Budget for 75%
capacity level
(`) (`)
Sales 13,50,000 10,12,500
Direct Material 4,25,000 3,18,750
Direct Labour 1,85,000 1,38,750
Variable Overheads 2,15,000 1,61,250
Semi-Variable
3,65,000 3,23,750
Overheads
Profit 1,60,000 70,000
After the closing of the financial year 2017-18, total actual sales stood at `11,07,000 and
there was a favourable sales price variance of `17,000 (F).
Required
Prepare a flexible budget for the actual level of sales.
Pareto Analysis
4. The following information is given about the type of defects during a production period and
the frequencies of their occurrence in a spectacle manufacturing company:
Defect No. of items
End Frame not equidistant from the centre 10
Non-uniform grinding of lenses 60
Power mismatches 20
Scratches on the surface 110
Spots / Stains on lenses 5
Rough edges of lenses 70
Frame colours-shade differences 25
Required
Construct a frequency table so that a Pareto Chart can be constructed for the defect type.
Which areas should the company focus on?
Standard Costing
5. Sapporo Manufacturing Co. (SMC) is a leading consumer goods company. The budgeted
and actual data of SMC for the year 2017-18 are as follows:-
Particulars Budget Actual Variance
Sales / Production (units) 2,00,000 1,65,000 (35,000)
Sales (`) 21,00,000 16,92,900 (4,07,100)
Less: Variable Costs (`) 12,66,000 10,74,150 1,91,850
Less: Fixed Costs (`) 3,15,000 3,30,000 (15,000)
Profit 5,19,000 2,88,750 (2,30,250)
The budgeted data shown in the table is based on the assumption that total market size
would be 4,00,000 units but it turned out to be 3,75,000 units.
Required
Prepare a statement showing reconciliation of budget profit to actual profit through
marginal costing approach for the year 2017-18 in as much detail as possible.
Decision Making
6. A company manufactures three components, A, B and C. these components pas s through
machines P and Q. The machine hour capacity of Q is limited to 7,800 hours a month. The
company is interested in fulfilling the market demand to retain its market share. The
following information is given:
A B C
Division W can produce 1,00,000 units of product Z at full capacity. Demand for product Z
in the external market is for 70,000 units only at selling price of `2,500 per unit. To produce
product Z Division W incurs `1,600 as variable cost per unit and total fixed overhead of
`4,00,00,000. Division W has employed `12,00,00,000 as working capital, working capital
is financed by cash credit facility provided by its lender bank @ 11.50% p.a. Division W
has been given a profit target of `2,50,00,000 for the year.
Division B has found two other suppliers C Ltd and H Ltd. who are agreed to supply product
Z.
Division B has requested a quotation for 40,000 units of product Z from Division W.
Required
(i) Calculate the transfer price per unit of product Z that Division W should quote in order
to meet target profit for the year.
(ii) Calculate the two prices Division W would have to quote to Division B, if it became
AWB Ltd. policy to quote transfer prices based on opportunity costs.
Linear Programming
9. The manufacturing company has 100 kg of A, 180 kg of B and 120 kg of C ingredients
available per month. Company can use these materials to make three basic products
namely 5-10-5, 5-5-10 and 20-5-10, where the numbers in each case represent the
percentage of weight of A, B and C respectively in each of products. The cost of these raw
materials are as follows:
Ingredient Cost per Kg. (`)
A 64
B 16
C 40
Inert Ingredients 16
Selling price of these products are `32.60, `34.80, and `36.00 per Kg, respectively. There
is capacity restriction of the company product 5-10-5, so that company cannot produce
more than 30 Kg per month.
Required
Formulate this problem as an LP model to determine the productions (in Kg.) of each
product which will maximise its monthly profit.
Note: Formulate Only
Transportation Problem
10. Coupers Partners a leading CA firm has three managers. Each manager can work up to
176 hours during the next month, during which time three assignments must be completed.
Tax Accounting (TA) Assignment will take 143 hours, Tax Performance Advisory (TPA) will
take 154 hours, and Global Compliance & Reporting (GCR) will take 176 hours. The
amount per hour that can be billed for assigning each manager to each assignment is given
below:
Assignment
Manager TA TPA GCR
(`) (`) (`)
C1 1,800 2,250 2,850
C2 2,100 1,950 1,800
C3 2,400 2,100 2,250
Required
Formulate this as a transportation problem and find the optimal solution. Also find out the
maximum total billings during the next month.
Note: A manager may be involved in more than one assignment.
PERT and CPM
11. State the Validity of following statements along with the reasons:
(i) Two activities have common predecessor and successor activities. So, they can have
common initial and final nodes.
(ii) In respect of any activity whether real or dummy, the terminal node should bear a
number higher than the initial node number.
(iii) The difference between the latest event time and the earliest event time is termed as
free float.
(iv) For every critical activity in a network, the earliest start and the earliest finish time as
well as the latest finish time and the latest start time are the same.
(v) The optimal duration of a project is the minimum time in which it can be completed.
(vi) Resource leveling aims at smoothening of the resource usage rate without changing
the project duration.
Simulation
12. Finance Controller of Dunk Limited has drawn the following projections with probability
distribution:
Wages &
Raw Material Other Variable Sales
Overheads
` in 000 Probability ` in 000 Probability ` in 000 Probability
08 – 10 0.2 11 – 13 0.3 34 – 38 0.1
10 – 12 0.3 13 – 15 0.5 38 – 42 0.3
14. State whether the learning curve theory can be applied to the following indepen dent
situations briefly justifying your decision:
(i) A labour intensive sculpted product is carved from the metal provided to the staff. The
metal is sourced from different suppliers since it is scarce. The alloy composition of
the input metal is quite different among the suppliers.
(ii) Pieces of hand-made furniture are assembled by the company in a far off location.
The labourers do not know anything about the final product which utilizes their work.
As a matter of further precaution, rotation of labour is done frequently.
(iii) Skilled workers have been employed for a long time. The company has adequate
market for the craft pieces done by these experts.
(iv) A company funds that it always has an adverse usage of indirect material. It wants to
apply learning curve theory to improve the way standards have been set.
Target Costing
15. A toy company ‘T’ expects to successfully launch Toy Z based on a film character. T must
pay 15% royalty on the selling price to the film company. ‘T’ targets a selling price of ` 100
per toy and profit of 25% selling price.
The following are the cost data forecast:
`/toy
Component A 8.50
Component B 7.00
Labour: 0.4 hr. @ ` 60 per hr 24.00
Product specific overheads 13.50
In addition, each toy requires 0.6 kg of other materials, which are supplied at a cost of
` 16 per kg with a normal 4% substandard quality which is not usable in the manufacture.
Required
Determine if the above cost structure is within the target cost. If not, what should be the
extent of cost reduction?
Cost Classification
16. ANZB Financial Services Limited is an Indian banking and financial services company
headquartered in Chennai, Tamil Nadu. Apart from lending to individuals, the company
grants loans to micro, small and medium business enterprises. Listed below are several
costs incurred in the loan division of ANZB Financial Services Limited.
(i) Remuneration of the loan division manager.
(ii) Cost of Printer Paper, File Folders, View Binders, Ink, Toner & Ribbons used in the
loan division.
(iii) Cost of the division’s MacBook Pro purchased by the loan division manager last year.
(iv) Cost of advertising in business newspaper by the bank, which is allocated to the loan
division.
Cost Classification
Controllable by the loan division Direct cost of the loan Sunk Cost
manager division
Uncontrollable by the loan Indirect Cost of the loan Out of Pocket
division manager division Cost
Required
For each Cost, indicate which of the above mentioned Cost Classification best describe
the cost.
Note
More than one classification may apply to the same cost item.
1. Limiting Factor
Case Basis for Selecting Priority of Product
If maximum sales (in value) is a limiting Profit Volume Ratio
factor
If raw material is a limiting factor Contribution per unit of raw material
required to produce one unit of a product
If labour hour is a limiting factor Contribution per unit of labour hour
required to produce one unit of a product
If there is a heavy demand for the Profit Volume Ratio
product
2. (i) Statement of Profitability of DRB Ltd
Products (Amount in `)
D1 D2 D3 D4 Total
Sales 26,00,000 45,20,000 42,40,000 32,00,000 1,45,60,000
Direct Materials 6,00,000 18,20,000 18,80,000 10,00,000 53,00,000
Direct Wages 8,00,000 20,80,000 12,80,000 12,00,000 53,60,000
Overheads (W.N.2):
Machine Related 1,60,000 1,56,000 64,000 2,40,000 6,20,000
Batch Related 1,00,000 1,30,000 80,000 1,50,000 4,60,000
W.N.-2
Statement Showing - Overhead Costs Related to Product
Particulars D1 D2 D3 D4
Machining hrs. ` 1,60,000 ` 1,56,000 ` 64,000 ` 2,40,000
related overheads (4,00,000 hrs (3,90,000 hrs (1,60,000 hrs × (6,00,000 hrs ×
× `0.40) × `0.40) `0.40) `0.40)
Batch related `1,00,000 `1,30,000 `80,000 `1,50,000
overheads (2,000 batches (2,600 batches (1,600 batches (3,000 batches
× `50) × `50) × `50) × `50)
3. Working Notes
(1) Calculation of Actual Sales at Budgeted Prices
(`)
Actual Sales at Actual Price 11,07,000
Less: Sales Price Variance (F) 17,000
Actual Sales at Budgeted Prices 10,90,000
ActualSalesat BudgetedPrices
Activity Level = ×100
BudgetedSalesat FullCapacity
` 10,90,000
= ×100
`13,50,000
= 80.74…%
(2) Segregation of Fixed & Variable Cost Element from Semi-Variable Overheads
Overheadat Full Capacity -Overheadat 75% Capacity
Variable Overhead =
DifferenceinActivityLevel
` 3,65,000- ` 3,23,750
=
25
= `1,650
Fixed Overhead = Total SV Overheads at 100% Level – Variable
Overheads at 100% level
= `3,65,000 – (`1,650 × 100)
= `2,00,000
Flexible Budget at 80.74% Activity Level
(Amount in `)
Sales 10,90,000
Less:
Direct Material (`4,25,000 × 80.74..%) 3,43,148
Direct Labour (`1,85,000 × 80.74..%) 1,49,370
Variable Overheads (`2,15,000 × 80.74..%) 1,73,593
Semi-Variable Overheads
Variable Cost (`1,650 × 80.74..) [W.N.-2] 1,33,222
Fixed Cost [W.N.-2] 2,00,000
Profit 90,667
4. Statement Showing “Pareto Analysis of Defects”
Defect Type No. of Items % of Total Cumulative
Items Total
Scratches on the surface 110 36.67% 36.67%
Rough edges of lenses 70 23.33% 60.00%
Non-uniform grinding of lenses 60 20.00% 80.00%
Frame colours-shade 25 8.33% 88.33%
differences
Power mismatches 20 6.67% 95.00%
End frame not equidistant from 10 3.33% 98.33%
the centre
Spots/ Strain on lenses 5 1.67% 100.00%
300 100.00%
The company should focus on eliminating scratches on the surface, rough edges of lenses
and grinding of lenses related defects which constitute 80% portion, according to Pareto
Theory.
5. Statement of Reconciliation - Budgeted Vs Actual Profit
Particulars `
Budgeted Profit 5,19,000
Less: Sales Volume Contribution Planning Variance (Adverse) 52,125
Less: Sales Volume Contribution Operational Variance (Adverse) 93,825
Less: Sales Price Variance (Adverse) 39,600
Less: Variable Cost Variance (Adverse) 29,700
Less: Fixed Cost Variance (Adverse) 15,000
Actual Profit 2,88,750
Workings
Basic Workings
2,00,000units
Budgeted Market Share (in %) =
4,00,000units
= 50%
1,65,000units
Actual Market Share (in %) =
3,75,000units
= 44%
Budgeted Contribution = `21,00,000 – `12,66,000
= `8,34,000
`8,34,000
Average Budgeted Contribution (per unit) =
`2,00,000
= `4.17
`21,00,000
Budgeted Sales Price per unit =
`2,00,000
= `10.50
`16,92,900
Actual Sales Price per unit =
`1,65,000
= `10.26
`12,66,000
Standard Variable Cost per unit =
`2,00,000
= `6.33
`10,74,150
Actual Variable Cost per unit =
`1,65,000
= `6.51
Calculation of Variances
Sales Variances:
Volume Contribution Planning* = Budgeted Market Share % × (Actual Industry
Sales Quantity in units – Budgeted Industry Sales
Quantity in units) × (Average Budgeted
Contribution per unit)
= 50% × (3,75,000 units – 4,00,000 units) × `4.17
= 52,125 (A)
Fixed Overhead Volume Variance does not arise in a Marginal Costing system
However, at selling price ` 50 per unit, the company can sell 1,40,000 units only, which is
60,000 units less than the budgeted production units.
After analyzing the price-demand pattern in the market (which is price sensitive), to sell all
the budgeted units market price needs to be further lowered, which might be lower than
the total cost of production.
Statement Showing “Profit at Different Demand & Price Levels”
I II III IV Budgeted
Qty. (units) 1,68,000 1,52,000 1,40,000 1,28,000 1,08,000
` ` ` ` `
Sales 73,92,000 72,96,000 70,00,000 71,68,000 64,80,000
Less: Variable Cost 53,76,000 48,64,000 44,80,000 40,96,000 34,56,000
Total Contribution 20,16,000 24,32,000 25,20,000 30,72,000 30,24,000
Less: Fixed Cost 16,00,000 16,00,000 16,00,000 16,00,000 16,00,000
Profit (`) 4,16,000 8,32,000 9,20,000 14,72,000 14,24,000
Profit
5.96 12.87 15.13 25.84% 28.16%
(% on total cost)
Now, let us apply VAM method to the above matrix for finding the initial feasible
solution.
Manager Assignment Time Difference
TA TPA GCR Dummy Avail.
(`) (`) (`) (`) (Hours)
176
1,050 600 0 2,850 176/0 600 - -
C1
121 55
750 900 1,050 2,850 176/55/0 150, 150 1,950
C2
143 33
450 750 600 2,850 176/33/0 150, 300, 2,100
C3
Time 143/0 154/121/0 176/0 55/0
528
Required
300 150 600 0
Difference
300 150 -- 0
- 150 - 0
The initial solution is given below. It can be seen that it is a degenerate solution since the
number of allocation is 5. In order to apply optimality test, the total number of allocations
should be 6 (m + n -1). To make the initial solution a non-degenerate, we introduce a very
small quantity in the least cost independent cell which is cell of C3, GCR.
Manager Assignment
TA TPA GCR Dummy
(`) (`) (`) (`)
C1 176
1,050 600 0 2,850
C2 121 55
750 900 1,050 2,850
C3
450 143 750 33 600 e 2,850
Now we calculate ij = Cij – (ui + vj) for non basic cells which are given in the table below-
ij Matrix
Since, all allocations in ∆ij = Cij –(ui+vj)are non negative, the allocation is optimal. The
allocation of assignments to managers and their billing amount is given below:
Manager Assignment Billing Amount
C1 Global Compliance & Reporting (GCR) `5,01,600
(176 hrs. × `2,850)
C2 Tax Performance Advisory (TPA) `2,35,950
(121 hrs. × `1,950)
C3 Tax Accounting (TA) `3,43,200
(143 hrs. × `2,400)
C3 Tax Performance Advisory (TPA) `69,300
(33 hrs. × `2,100)
Total Billing `11,50,050
11. (i) Invalid
Reason: As per the rules of network construction, parallel activities between two
events, without intervening events, are prohibited. Dummy activities are needed when
two or more activities have same initial and terminal events. Dummy activities do not
consume time or resources.
(ii) Valid
Reason: As per the conventions adopted in drawing networks, the head event or
terminal node always has a number higher than that of initial node or tail event.
(iii) Invalid
Reason: The difference between the latest event time and the earliest event time is
termed as slack of an event. Free float is determined by subtracting head event slack
from the total float of an activity.
(iv) Invalid
Reason: For every critical activity in a network, the earliest start time and the latest
start time is same and also the earliest finish time and the latest finish time is same.
(v) Invalid
Reason: The optimum duration is the time period in which the total cost of the project
is minimum.
(vi) Valid
Reason: Resource leveling is a network technique used for reducing the requirement
of a particular resource due to its paucity or insufficiency within a constraint on the
project duration. The process of resource leveling utilize the large floats available on
non-critical activities of the project and cuts down the demand of the resource.
12. Allocation of Random Numbers
Raw Material Wages & Sales
Other Variable
Overheads
Mid Cum. Random Mid Cum. Random Mid Cum. Random
Point Prob. Nos. Point Prob. Nos. Point Prob. Nos.
9 0.2 0−1 12 0.3 0−2 36 0.1 0
11 0.5 2−4 14 0.8 3−7 40 0.4 1−3
13 0.8 5−7 16 1.0 8−9 44 0.8 4−7
15 1.0 8−9 48 1.0 8−9
Simulation Table
(` in 000)
Month Raw Wages & Sales Fixed Net Cash Cash
Material Other V.O Cost Flow Balancing
(Opening `40
thousand)
1 11 12 36 15 -2 38
2 11 14 44 15 +4 42
3 9 16 44 15 +4 46
4 9 12 36 15 0 46
5 11 16 40 15 -2 44
6 13 16 48 15 +4 48
13. (i) Variable cost per unit that will be effected by learning and experience curve is `2,200
(`4,400 – 50% of ` 4,400) .
Let, ‘r’ be the learning curve rate.
No. of Batch (x) Cumulative Average Cost per unit (y)
1 2,200
2 2,200 r
4 2,200 r2
If 2,200 r 2 = `1,920 (`4,120 – 50% of ` 4,400)
r2 = 0.8727
r = 0.934
Therefore, Learning Curve Effect = 93% (rounded off)
(ii) Calculation of Optimum Price
Price Demand Variable Variable Total Contribution Total
per unit (units) Cost Cost Variable per unit Contribution
per unit * per unit** Cost per
[W.N.] unit
(*) This represents variable cost part which is affected by the learning and experience curve
effect.
(**) This represents variable cost part which is not affected by the learning and experience
curve effect.
Working Note [W.N.]
Variable Cost per unit
Output in Average Cost of x – 0.1047 Cumulative Average
Batches (x) the First Unit (a) Cost per unit (y)
1 2,200 1.0000 2,200.00
2 2,200 0.9299 2,046.00
3 2,200 0.8913 1,960.86
4 2,200 0.8649 1,902.78
y = axb
Where,
y = Cumulative average unit costs
a = Average cost of the first unit
x = Cumulative number of batches
b = Log of learning ratio ÷ Log of 2
= log 0.93 ÷ log 2
= −0.0315 ÷ 0.3010
= −0.1047
14. (i) ‘Learning Curve Theory’ will not be applicable as alloy combination of the input metal
is quite different among the suppliers hence learning experience with one type of
metal may not be beneficial for the workers to deal with other metal with separate
alloy composition.
(ii) ‘Learning Curve Theory’ will not be applicable as in this situation rotation of labour is
done frequently, labours will not be able to get the benefit of learning and apply their
learning. Hence, learning curve theory can not be applied.
(iii) ‘Learning Curve Theory’ will not be applicable as in this situation as workers are
skilled and employed for a long time, they have already achieved maximum level of
expertise by taking advantage of learning. Hence, at this point of time learning curve
theory can not be applied.
(iv) ‘Learning Curve Theory’ will not be applicable as indirect materials are the materials
which are not used directly in the production (not directly proportionate with volume
of output) and usually used machines (e.g. lubricants, spares parts etc.) with less
human interactions. Adverse usage of indirect materials can be controlled through
proper monitoring and appropriate standard settings and not from applying learning
curve theory.
15. Statement Showing Target Cost “Z”
` / Toy
Target Selling Price 100.00
Less: Royalty @15% 15.00
Less: Profit @ 25% 25.00
Target Cost 60.00
Statement Showing Cost Structure “Z”
` / Toy
Component A 8.50
Component B 7.00