Ch 14: BUSINESS FORECASTING MODELS (TIME SERIES AND REGRESSION ANALYSIS) — Previous Year Exam Questions (PYQ)
Final
📚 Strategic Cost Management
📖 Ch.14 — BUSINESS FORECASTING MODELS (TIME SERIES AND REGRESSION ANALYSIS)
⭐ V1: Previous Year Question (PYQ)
⚡ Free Mode (Answers Locked)
⏱ Duration: 54 Mins
🎯 Total Marks: 30
Passed at: 12 Marks
Max Attempts: 10
⚖️ Statutory Applicability: AY 2026-27 & Current Institute Curriculum
Answer ALL questions. Working notes / statutory sections must form part of the answers.
📑 Exam Questions
6 Questions • Total 30 Marks1(a): Time Series Analysis
5 Marks
(i) False
Explanation: In marketing, a loss leader is a type of strategy, where a product is sold at
a loss (below cost) to promote sale of other profitable products. It is a kind of Sales
Promotion.
(ii) True
Explanation: Break-Even Analysis is based on Cost-Volume-Profit (CVP) Analysis of a
firm.
(iii) False
Explanation: It is time series analysis that refers to problems in which observations
are collected at regular time intervals and there are correlations among
successive observations.
(iv) False
Explanation: Increase in contribution will lead to increase in profit so long on
operating fixed costs remain constant.
(v) True
Explanation: Because change is never static.
(b)
Column I
Column II
(A) Strategic Plan
(B) Value Drivers
(C) Conglomerate Merger
(D) Strategic Intent
(E) Mission
(iii) A unified, comprehensive and integrated plan.
(i) Entrance value and do not include waste reduction.
(iv) When a firm in an industry combines with another in
an unrelated industry.
(ii) It refers to the purposes an organisation strives for.
(v) It is the essence or purpose for which a firm stands.
SUGGESTED_ANSWER TO QUESTION_SYL2012_JUNE2017_PAPER-15
Academics Department, The Institute of Cost Accountants of India (Statutory Body under an Act of Parliament) Page 3
(c) (i) Competitive Advantage (CA): When a firm enjoys advantage in the matter of
cost, Product uniqueness or profit compared to its competitors in the market, it is
said to be having a Competitive Advantage.
(ii) Core Competency (CC): CC represents unique skill or technology that creates
distinct customer value. The unique capabilities are personified in the collective
knowledge of employees to produce better results.
(iii) Transfer Price (TP): TP is the price of one segment (sub-unit, department, division
etc.,) of an organization charges for a Product or service supplied to another
segment of the same organization. TPs are used when individual entities of a larger
multi-entity firm are treated and measured as separately run entities.
(iv) Life Cycle Costing (LCC): LCC is the accumulation of costs for activities that occurs
over the entire life cycle of a product from the very inception to the
abandonment by the manufacturer and consumer.
(v) Net Present Value (NPV): NPV is the difference between the present value of
aggregate of net cash flows from a product or project and the present value of its
capital outlay. It is one of the scientific methods of project evaluation.
(d) (i) (B)
(ii) (D)
(iii) (B) [Cost of Goods Sold = Material Cost + Conversion Cost
= (8,000 units × ₹ 45) + ₹ 4,80,000 = ₹ 8,40,000]
(iv) (A)
(v) (C) [BEP =
FC
C/ S Ratio or, C/S Ratio = FC
BEP =
40,000
60,000
₹
or 66.7%
Section – B
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
1(b): Time Series Analysis
5 Marks
Analysis of Variances:
1.
Direct Material Cost Variances:
Direct Material Price Variance = 16,500 (₹20 - ₹
396000
16500 )
= ₹3,30,000 – ₹ 3,96,000 = ₹ 66,000 (A)
Direct Material Usage Variance = ₹ 20 (8,000 X 2 – 16,500) = ₹ 10,000 (A)
2.
Direct Wages Variances:
Wages Rate Variance = (₹2 - ₹
) 1,70,000
= ₹3,40,000 – ₹ 3,46,800 = ₹ 6,800 (A)
Wages Efficiency Variance = ₹ 2 (8,000 X 20 – 1,66,000)
= ₹ 2 (1,60,000 – 1,66,000) = ₹ 12,000 (A)
Idle time Variance = 4,000 X ₹ 2 = ₹ 8,000 (A)
3.
Variable Overhead Cost Variance
Variable Overhead Cost Variance = ₹ 8 x 8,000 – ₹ 60,000 = ₹ 4,000 (F)
Alternatively
VOH Expenditure Variance = ₹ (
-
) X 1,70,000
= ₹ 68,000 – ₹ 60,000 = ₹ 8,000 (F)
VOH Efficiency Variance = ₹ 0.4(1,60,000 – 1,70,000)
= ₹ 4,000 (A)
4.
Fixed Overhead Cost Variance
FO Expenditure Variance = ₹ 2,00,000 – ₹ 1,84,000 = ₹ 16,000 (F)
FO Volume Variance = ₹ 20 X 8,000 – ₹ 2,00,000 = ₹ 40,000 (A)
5.
Sales Margin Variances
Here actual sales margin per unit and standard sales margin per unit remains same i.e. actual price –
standard cost = ₹ 140- ₹ 108 = ₹ 3
Sales Margin Price Variance = (₹ 32 - ₹ 32) X 8,000 = NIL
Sales Margin Volume Variance = (8,000-10,000) X ₹ 32 = ₹ 64,000 (A)
(ii) Calculation of Standard Profit
Per Unit
(₹)
Selling Price
Less: Variable Cost
Contribution
Standard Sales Quantity
8000
Total Contribution
4,16,000
Less: Standard Fixed Overhead @ ₹20 per unit
1,60,000
Standard Profit
2,56,000
7 of 13
Reconciliation between Standard Profit& Actual Profit
Standard Profit
₹ 2,56,000
Cost Variances
Adverse (₹)
Favourable (₹)
Direct Material
Price Variance
66,000
Usage Variance
10,000
Wages
Rate Variance
6,800
Idle Time Variance
8,000
Efficiency Variance
12,000
Variable Overhead
Cost Variance
4,000
Fixed Overhead
Expenditure Variance
16,000
Volume Variance
40,000
1,42,800
20,000
1,22,800 (A)
Actual Profit
1,33,200
Alternative Solution
(i) Analysis of Variances:
For Material Cost Variances :
D
M1 – Actual Cost of Material used
3,96,000
M2 – Standard Cost of Material used
3,30,000
M3 – No mix variance
Nil
M4 – Standard material cost Output
3,20,000
Material Price Variance. (M1 – M2)
66,000 (A)
Material Usage Variance. (M2– M4)
10,000 (A)
For Direct Wages Variances :
L1– Actual payment made to workers for actual hours worked
346800
L2– Payment involved, if workers had been paid at standard rate
340000
L3– No gang variance
L4– Standard labour cost of labour hours utilised. (This step will have value when
there is a difference between hours available and hours utilised.)
3,32,000
L5– Standard labour cost of output achieved
3,20,000
Wage Rate Variance (L1 – L2)
6,800 (A)
Wage idle Time Variance(L2 – L4)
8,000 (A)
Wage Yield Variance(L4 – L5)
12,000 (A)
For Variable Overhead Variances :
VO1 – Actual variable overhead (given)
60,000
VO2 – No expenditure variance
Nil
VO3– Standard variable overhead for production
64,000
Variable Overhead Variance (VO1 – VO3)
4,000 (F)
For Fixed Overhead Variances :
FO1 – Actual fixed overhead incurred (given)
1,84,000
FO2 – Budgeted fixed overhead for the period
2,00,000
FO3 –There is no calendar or idle time variance
FO4 – Fixed overhead for actual hours worked at standard rate
1,66,000
FO5 – Standard fixed overhead for production
1,60,000
8 of 13
Fixed overhead expenditure variance(FO1 – FO2)
16,000 (F)
Fixed overhead idle time variance(FO2 – FO4)
34,000 (A)
Fixed overhead efficiency variance(FO4 – FO5)
6,000 (A)
For Sales Margin Variances :
Standard sales margin = ₹ 32 (given). Actual sales margin also remains the same i.e., actual price –
standard cost.
SM1– Actual sales margin on actual sales.
2,56,000
SM2– Standard sales margin on actual sales
2,56,000
SM3– No Mix Variances
Nil
SM4– Standard sales margin on standard sales mix or budgeted sales margin as per
budget or standard.
3,20,000
Sales Margin Price Variance (SM1 – SM2)
Nil
Sales Margin Volume Variance (SM2 – SM4)
64,000 (A)
ii) Calculation of Standard Profit
Amount
(₹)
Budgeted Profit
3,20,000
Less: Sales Margin Volume Variance (Adverse)
64,000
Standard Profit
2,56,000
Reconciliation between Standard Profit& Actual Profit
Standard Profit
₹2,56,000
Cost Variances
Adverse (₹)
Favourable (₹)
Direct Material
Price Variance
66,000
Usage Variance
10,000
Wages
Rate Variance
6,800
Idle Time Variance
8,000
Yield Variance
12,000
Variable Overhead
Cost Variance
4,000
Fixed Overhead
Expenditure Variance
16,000
Idle Time Variance
34,000
Efficiency Variance
6,000
1,42,800
20,000
1,22,800 (A)
Actual Profit
1,33,200
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
2(a): Input-Output Models
5 Marks
6,000
1,200
(2,640)
(1,440)
Best output level is 3,000 units where profit is maximum at ₹ 1,350/-
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
2(b): Time Series Analysis
5 Marks
Statement Showing Allocation of Seats in the Aircraft:
Existing Situation for Destination A to B:
Seating Capacity of the Aircraft
passengers
Average Number of Passengers per flight
passengers
Proposed Situation for Destination D to B
Seat Booked by ZOMB Ltd.
50 Seats
For Destination A to B
Seats Available
{260 (Capacity) – 50 (booked by ZOMB Ltd. for Destination D to B)}
210 Seats
Requirement of Regular Passengers
{240 (original no. of passengers) – 25 (no. of passengers drop out due to wastage of time
)}
215 Seats
Possible Allocation of Seats to Regular Passengers
210 Seats
For Destination A to D
Seats Available
{260 (capacity) – 210 (seats allocated to regular passengers of destination A to B)}
50 Seats
Requirement of Agents
(tickets can be sold by Airway’s Travel Agents)
60 Seats
Possible Allocation to Agents of Airways Ltd.
50 Sets
(i)
Analysis of Profit Per flight
₹
₹
Revenue per passenger (Gross Fare)
5,000
Less: Total variable Cost per passenger
10 % Commission on Fare
Food
Contribution per passenger
4,200
Contribution per flight (Contribution for 240
Passengers)
10,08,000
Less: Fixed Costs per Flight
Fuel Cost
90,000
Annual Lease Cost
2,00,000
Group Service, Baggage Handling / Checking in
40,000
Flight Crew Salaries
48,000
3,78,000
Profit per Flight
6,30,000
(ii)
Break-even number of Passengers for each flight from A to B
Break-even number of Passengers =
Total Fixed cost per flight
Contribution per Passenger
Break-even number of Passengers @
4200
378000 = 90 Passengers
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
3(a): Exponential Smoothing
5 Marks
Given:
Initial Forecast for April = 200 units
Smoothing Constant (α) = 0.10
We have,
Et = Et−1 + α(Yt −Et−1)
where:
-
Et= New Forecast
-
Et−1= Previous Forecast
-
Yt= Actual Sales
Month
Actual
Sales
Old Forecast
Et-1
Corrections
New Forecast
Et
Forecast
Error
Given
Only for April
α (Yt – Et-1)
Et-1 + α (Yt – Et-1 )
Et - Yt
April
200.00
1.00
201.00
9.00
May
201.00
1.30
202.30
11.70
June
202.30
1.47
203.77
13.23
July
203.77
2.42
206.19
21.81
August
206.19
2.88
209.07
25.93
September
209.07
1.59
210.66
14.34
October
210.67
1.03
211.69
9.31
(Forecast Demands are in ‘000 units)
--------------------------------------------------
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
3(b): Importance of Business Forecasting in different areas of an organisation
5 Marks
With reference to the statutory framework governing 'Importance of Business Forecasting in different areas of an organisation' under Strategic Cost Management (CMA Final), critically examine the substantive legal provisions, scope, and applicability thresholds. Specifically elucidate: (i) the governing statutory sections/rules/standards; (ii) eligibility conditions, numerical limits, and compliance parameters; and (iii) consequences of non-compliance or procedural default.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Advertisement