knowledge bank -applied learning Balanced Scorecard & Strategic Operating Income Analysis


1.       ABC Ltd produces a high end partitions and follows a product differentiating strategy. Data for the years 2016 and 2017 is as follows:           

 

 

2016

2017

1

Units produced and sold

40,000

42,000

2

Selling Price

Rs 1000

Rs1100

3

Direct material (square feet)

120000

123000

4

Direct material cost per square foot

Rs100

Rs110

5

Manufacturing capacity

50000 units

50000 units

6

Conversion costs

Rs 1 crores

Rs 1 crores10 Lc

7

Conversion cost per unit of capacity

Rs 200

Rs220

8

Selling and Customer service capacity

30 customers

29 customers

9

Actual number of customers

23

25

10

Selling and customer costs

Rs 7200000

Rs 7250000

11

Cost per customer of selling and customer service capacity

Rs 240000

Rs 250000

 

                Conversion costs are related to manufacturing capacity. Selling and customers costs have a direct bearing with the number of customers the selling and customer function is designed to support.

                1.            What elements should appear in a balanced score card.

                2.            Compute growth, price recovery and productivity components explain changes in           income in the two years.

                3.            Assuming market size growth of 3% in 2017 compute how much change in operating      income happens from industry market size factor, cost leadership and product    differentiation.

                4.            How successful has ABC been in implementing its strategy.




1.       HTCL makes a special purpose textile machine ASCS.The machines are designed to be both distinct and superior from its competitors. Following data pertains to years 2016 and 2017,

               

Units of ASCS bought and sold

200

210

Selling price

40000

42000

Direct material (Kgs)

300000

310000

Direct material cost per kg

Rs 8

Rs 8.5

Capacity to manufacture

250

250

Total conversion costs

Rs 20,00,000

Rs 20,25,000

Conversion cost per unit of capacity

Rs 8000

Rs8100

Selling and customer service capacity

100 customers

95 customers

Total selling and customer costs

10,00,000

9,40,000

Selling and customer service cost per unit of capaacity

10000

9900

Design staff

12

12

Design cost

12,00,000

12,12,000

Design cost per staff member

100000

101000

 

                The company wants to reduce the direct material usage in the year 2017.Conversion costs depend upon the manufacturing capacity defined in terms of ASCS units that can be produced. It is independent to the number of units actually produced.Selling and customer costs are dependent on the number of customers which HTCL can support. They are independent to the number of customers actually served. HTCL has 75 and 80 customers respectively in the years 2016 and 2017.The number of design staff is at the management discretion . Both the number of design staff and its cost has no direct relationship with the quantity of ASCS produced or the number of customers to whom it is sold. The year 2017 saw the market of the ASCS and similar machines grow by 3%.This growth was beneficial for HTCL also; however, all growth beyond 3% was due to HTCLs strategic planning and actions.

1.       What type of strategy has HTCL adopted?

2.       What elements should be included in HTCLs Balanced Scorecard?

3.       Compute the operating income of two years and identify the difference in the same.

4.       Calculate the Growth, Price recovery and Productivity components.

5.       Calculate the change in operating income due to industry market size, product differentiation strategy and cost leadership.




1.       Aptech Pvt Ltd is an information systems consulting firm specializing in implementing accounting software in companies. Aptech works in a competitive environment and to remain relevant needs to sell high quality at low cost. The clients are billed as per the volume and complexity of the accounting software developed for them. Software Labor hour costs are variable in nature .Aptech chooses the number of units of work to be performed each year. The software implementation support costs are dependent upon this choice, hence, Software support costs are independent of the actual work performed. The number of software development employees is also discretionary and decided in the beginning of the year.These costs are also independent of the actual units of work performed. Following data is available,

 

 

2016

2017

1.

Work performed in units

60

70

2.

Sale price per unit

Rs 500000

Rs 480000

3.

Software implementation labor

30000 hours

32000 hours

4.

Labor hour rate

Rs 600

Rs 6300

5.

Support capacity in units of work for software implementation.

90

90

6.

Software implementation support cost

Rs 3600000

Rs 3690000

7

Software implementation support cost per unit of work

Rs 40000

Rs 41000

8

Number of employees in software development

3

3

9

Software development cost

Rs 3750000

Rs 3900000

10

Software development cost per employee

Rs 1250000

Rs 1300000

 

1.       Is Aptech strategy one of product differentiation or cost leadership?

2.       What elements would you include in Aptech,s Balanced Scorecard?

3.       Do an operating income analysis.

4.       Calculate the growth, price recovery and productivity components.

5.       How much change of operating income has happened because of industry market size factor, product differentiation and cost leadership. Assume that the market software market has grown by 5%and that Aptech has experienced a 1% decline in selling price.




1.       An analysis of ABC Ltds operating income changes between 2016 and 2017 shows the following:

                Operating income for 2015                          Rs 17,00,000

                Add growth component                                                         70,000

                Deduct price recovery component                    (60,000)

                Add productivity component                              1,40,000                      

Operating income for 2016                          Rs 18,50,000

The industry size of Boxes did not grow in 2016, input price did not change and ABC Ltd reduced the price of card board boxes.

1.            Was ABC Ltd gain in operating income in 2016consistent with the strategy you identified earlier.

2.            Explain the productivity component. Does it represent saving only in the variable cost, or only in fixed cost or both.


Click To Answer


1.       ABC Ltd produces a high end partitions and follows a product differentiating strategy. Data for the years 2016 and 2017 is as follows:           

 

 

2016

2017

1

Units produced and sold

40,000

42,000

2

Selling Price

Rs 1000

Rs1100

3

Direct material (square feet)

120000

123000

4

Direct material cost per square foot

Rs100

Rs110

5

Manufacturing capacity

50000 units

50000 units

6

Conversion costs

Rs 1 crores

Rs 1 crores10 Lc

7

Conversion cost per unit of capacity

Rs 200

Rs220

8

Selling and Customer service capacity

30 customers

29 customers

9

Actual number of customers

23

25

10

Selling and customer costs

Rs 7200000

Rs 7250000

11

Cost per customer of selling and customer service capacity

Rs 240000

Rs 250000

 

                Conversion costs are related to manufacturing capacity. Selling and customers costs have a direct bearing with the number of customers the selling and customer function is designed to support.

                1.            What elements should appear in a balanced score card.

                2.            Compute growth, price recovery and productivity components explain changes in           income in the two years.

                3.            Assuming market size growth of 3% in 2017 compute how much change in operating      income happens from industry market size factor, cost leadership and product    differentiation.

                4.            How successful has ABC been in implementing its strategy.


Click To Answer