3 - Cost
3 - Cost
QUESTIONS
Material Cost
1.   Reliable India Pvt Ltd is a startup company engaged in manufacturing of Agro Tech product
     from a raw material, which is purchased at `190 per kg. The company incurs a handling
     cost of `1,470 plus, freight of `770 per order. The incremental carrying cost of inventory
     of raw material is `3 per kg per month. In addition, the cost of working capital finance on
     the investment in inventory of raw material is `20 per kg per annum. The annual production
     of the product is 1,50,000 units and 3 units are obtained from one kg. of raw material.
     Assume 360 days in a year.
     Required:
     (i)   Calculate the economic order quantity of raw materials.
     (ii) Determine, how frequently company should order for procurement be placed.
     (iii) If the company proposes to rationalize placement of orders on quarterly basis,
           determine the percentage of discount in the price of raw materials should be
           negotiated?
Employee Cost
2.   Following information are available from the cost records of BMR Limited, CALCULATE
     Labour turnover rate and Labour flux rate:
     No. of Employees as on 01.04.2021 = 9,400
     No. of Employees as on 31.03.2022 = 10,600
     During the year, 160 Employees left while 640 Employees were discharged and 1,500
     Employees were recruited during the year; of these, 400 Employees were recruited
     because of exits and the rest were recruited in accordance with expansion plans.
Overhead
3.   SANDY Ltd. is a manufacturing company having three production departments, ‘A’, ‘B’ and
     ‘C’ and two service departments ‘X’ and ‘Y’. The following is the budget for December
     2022:
                             Total (`)      A (` )     B (` )        C (` )    X (` )    Y (` )
      Direct material                    1,60,000 3,20,000      6,40,000 3,20,000 1,60,000
      Direct wages                       8,00,000 3,20,000 12,80,000 1,60,000 3,20,000
      Factory rent           6,40,000
      Power                  4,00,000
      Depreciation           1,60,000
2                           INTERMEDIATE EXAMINATION: MAY, 2023
     COMPUTE the cost and profit per piece of each batch order and overall position of the
     order for 1,200 pieces.
       Month              Batch Output     Material cost     Direct wages      Direct labour
                            (Pieces)           (`)                (`)             (Hours)
       January                 210            6,500              1,200              240
       February                200            6,400              1,400              280
       March                   220            6,800              1,500              280
       April                   180            6,300              1,400              270
       May                     200            7,000              1,500              300
       June                    220            7,200              1,600              320
     The other details are:
               Month                 Chargeable expenses                  Direct labour
                                               (`)                            Hours
       January                           1,20,000                           4,800
       February                          1,05,600                           4,400
       March                             1,20,000                           5,000
       April                             1,05,800                           4,600
       May                               1,30,000                           5,000
       June                              1,20,000                           4,800
Contract Costing
8.   XYZ LLP, contractors and civil engineers, are building a new wing to a school. The quoted
     fixed price for the contract is `30,00,000. Work commenced on 1 st January 20X2 and is
     expected to be completed on schedule by 30 June 20X3.
     Data relating to the contract at the year ended 31 st March 20X3 is as follows.
                                                                                            (`)
      Plant sent to site at commencement of contract                                   2,40,000
      Hire of plant and equipment                                                       77,000
      Materials sent to site                                                           6,62,000
      Materials returned from site                                                      47,000
      Direct wages paid                                                                9,60,000
      Wage related costs                                                               1,32,000
      Direct expenses incurred                                                          34,000
6                               INTERMEDIATE EXAMINATION: MAY, 2023
       Degree of completion:
                 Milk                                                                100%
                 Labour and overheads                                                 80%
       Closing work-in process: 27,000 litres
       Degree of completion:
                 Milk                                                                100%
                 Labour and overheads                                                 80%
                 Milk transferred for Packing: 1,18,500 litres
       You are required to PREPARE using average method:
       (i)   Statement of equivalent production,
       (ii) Statement of cost,
       (iii) Statement of distribution cost, and
       (iv) Process-I Account.
Joint Product by Product
10. Key Pee Limited produces and sells the following products:
       Products         Units          Selling price at split-off     Selling price after
                                               point (`)            further processing (`)
             A          500000                     42.5                     62.5
             B          75000                      32.5                     42.5
             C          62500                       20                       30
             D          50000                      25                          -
             E          187500                     35                        50
    Cost of raw material ` 89,75,000 and other manufacturing ex-penses cost `13,67,500 in
    the manufacturing process which are absorbed on the products on the basis of their ‘Net
    realisable value’. The further processing costs of A, B, C and E are `31,25,000;
    ` 3,75,000; `1,25,000 and `3,75,000 respectively. Fixed costs are `11,82,500.
    You are required to PREPARE the following in respect of the coming year:
    (a) Statement showing income forecast of the company assuming that none of its
        products are to be further processed.
    (b) Statement showing income forecast of the company assuming that products A, B, C
        and E are to be processed further.
8                         INTERMEDIATE EXAMINATION: MAY, 2023
Service Costing
11. PREPARE cost statement of Panipat Thermal Power Station showing the cost of electricity
    generated per kwh, from the following data.
       Total units generated                                   16,50,000 kWh
                                                                           (`)
       Operating labour                                             21,75,000
       Repairs & maintenance                                          7,25,000
       Lubricants, spares and stores                                  5,80,000
       Plant supervision                                             4,35,000
       Administration overheads                                     29,00,000
       Insurance Charges                                            15,00,000
       Fuel Charges                                                  8,00,000
     7 kWh. of electricity generated per kg. of coal consumed @ `4.75 per kg. Depreciation
     charges @ 5% on capital cost of `3,10,00,000.
Standard Costing
12. XYZ Manufacturing Ltd. had prepared the following estimation for the month of Janua ry:
                                              Quantity         Rate (`)           (`)
      Raw Material-DF                         1,600 kg.          50              80,000
      Raw Material-CE                         1,200 kg.          35              42,000
      Skilled labour                        2,000 hours          40              80,000
      Semiskilled labour                    1,600 hours          25              40,000
     Standard loss in the process was expected to be 10% of total input materials and an idle
     labour time of 5% of expected labour hours was also estimated.
     At the end of the month the following information has been collected from the cost
     accounting department:
     The company has produced 2,960 kg. finished product by using the followings:
                                       Quantity     Rate (`)                               (`)
       Raw Material-DF                 1,800 kg.          40                            72,000
       Raw Material-CE                 1,300 kg.          30                            39,000
       Skilled labour               2,400 hours           35                            84,000
       Semiskilled labour           1,720 hours           20                            34,400
                    PAPER – 3: COST AND MANAGEMENT ACCOUNTING                               9
     Material-X and Material-Y cost `8 and `10 per kg and labours are paid `30 per hour.
     Overtime premium is 75% and is payable, if a worker works for more than 45 hours a week.
     There are 400 direct workers.
     The target efficiency ratio for the productive hours worked by the direct workers in actually
     manufacturing the products is 85%. In addition the non-productive down-time is budgeted
     at 15% of the productive hours worked.
     There are four 6-days weeks in the budgeted period and it is anticipated that sales and
     production will occur evenly throughout the whole period.
     It is anticipated that stock at the beginning of the period will be:
      Product-A                                               550 units
      Product-B                                               350 units
      Material-X                                             1,200 kgs.
      Material-Y                                               600 kgs.
     The anticipated closing stocks for budget period are as below:
      Product-A                                   5 days sales
      Product-B                                   5 days sales
      Material-X                                  10 days consumption
      Material-Y                                  5 days consumption
     Required:
     CALCULATE the Material Purchase Budget and the Wages Budget for the direct workers,
     showing the quantities and values, for the next month.
                       PAPER – 3: COST AND MANAGEMENT ACCOUNTING                                            11
Miscellaneous
15. (a) SUGGEST the unit of cost for following industries:
           (a) Transport
           (b) Power
           (c) Hotel
           (d) Hospital
           (e)   Steel
           (f)   Coal mining
           (g) Professional Services
           (h) Gas
           (i)   Engineering
           (j)   Oil
     (b) DISCUSS the difference between Job costing and Batch costing.
     (c) EXPLAIN what are the essential pre-requisite for Integrated Accounting system?
     (d) DISCUSS the difference between cost control and cost reduction.
ANSWERS
                                                          360days
           Frequency of placing orders (in days) =                  = 14.4 Days
                                                         25orders
     (iii) Percentage of discount in the price of raw materials to be negotiated:
             Particulars                            On Quarterly Basis            On E.O.Q Basis
             1.    Annual Usage (in Kg.)                50,000 kg.                  50,000 kg.
             2.    Size of the order                    12,500 kg.                   2,000 kg.
             3.    No. of orders (1 ÷ 2)                    4                          25
             4.    Cost of placing orders                ` 8,960                     ` 56,000
                   or Ordering cost
                   (No. of orders × Cost            (4 order × ` 2,240)      (25 orders × ` 2,240)
                   per order)
             5.    Inventory     carrying               `3,50,000                    `56,000
                   cost
                   (Average inventory ×           (12,500 kg. × ½ × ` 56)    (2,000 kg. × ½ × ` 56)
                   Carrying cost per unit)
             6.    Total Cost (4 + 5)                   ` 3,58,960                  ` 1,12,000
           When order is placed on quarterly basis the ordering cost and carrying cost increased
           by `2,46,960 (`3,58,960 - `1,12,000). So, discount required = ` 2,46,960
           Total annual purchase = 50,000 kg. × `190 = `95,00,000 So, Percentage of discount
                                     ` 2,46,960
           to be negotiated = =                   ×100 = 2.60%
                                  ` 95,00,000
2.   Employee turnover rate:
     It comprises of computation of Employee turnover by using following methods:
                                      Number of employees seperated during the period
     (i)   Separate Method: =                                                              x 100
                                     Average number of employees during the period on roll
                      Number of employees left + Number of employees discharged
           OR,    =                                                             x 100
                         Average number of employees during the period on roll
                          (160 + 640)
                  =                      x100
                      (9,400 + 10,600) ÷
                       800
                  =          x 100     = 8%
                      10,000
                                         Number of employees replaced during the period
     (ii) Replacement Method =                                                               x 100
                                       Average number of employees during the period on roll
                     PAPER – 3: COST AND MANAGEMENT ACCOUNTING                                                    13
                                               400
                                          =          x 100     = 4%
                                              10,000
                                        Number of employees joining in a period (excluding replacement)
     (iii) New Recruitment =                                                                                  x 100
                                               Average number of employees during the period on roll
                                         1500 - 400
                                    =               x 100
                                          10,000
                                          1,100
                                   = 10,000 𝑥 100 = 11%
     Note: This question can also be solved by using cost driver rate
5.   Calculation of Cost of Production of Motilal Ltd for the period…..
      Particulars                                                                              (`)
      Raw materials purchased                                                        64,00,000
      Add: Opening stock                                                                 2,88,000
      Less: Closing stock                                                            (4,46,000)
      Material consumed                                                              62,42,000
      Wages paid                                                                     23,20,000
      Prime cost                                                                     85,62,000
      Repair and maintenance cost of plant & machinery                                   9,80,500
      Insurance premium paid for inventories                                              26,000
      Insurance premium paid for plant & machinery                                        96,000
      Quality control cost                                                                86,000
16                       INTERMEDIATE EXAMINATION: MAY, 2023
7.
           Particulars             Jan.     Feb.     March      April       May      June     Total
                                    (`)      (`)      (`)        (`)        (`)       (`)      (`)
           Batch output              210      200      220        180        200       220    1,230
           (in pieces)
           Sale value @ `80        16,80    16,00       17,60   14,40       16,00    17,60    98,40
                                            0           0       0           0        0        0        0
           Material cost           6,500    6,400       6,800   6,300       7,000    7,200    40,20
                                                                                                       0
           Direct wages            1,200    1,400       1,500   1,400       1,500    1,600    8,600
           Chargeable              6,000    6,720       6,720   6,210       7,800    8,000    41,45
           expenses*                                                                                   0
           Total cost              13,70    14,52       15,02   13,91       16,30    16,80    90,25
                                            0           0       0           0        0        0        0
           Profit per batch        3,100    1,480       2,580     490       (300)      800    8,150
           Total cost per piece     65.2     72.6        68.3    77.3        81.5     76.4     73.4
           Profit per piece         14.8      7.4        11.7     2.7        (1.5)     3.6      6.6
     Overall position of the order for 1,200 pieces
     Sales value of 1,200 pieces @ ` 80 per piece               ` 96,000
     Total cost of 1,200 pieces @ ` 73.4 per piece              ` 88,080
     Profit                                                      ` 7,920
              Chargeable expenses
     *                                     Direct labour hours for batch
         Direct labour hour for the month
8.   School Contract Account
         Particulars                                (`) Particulars                             (`)
         To Plant                            2,40,000 By Material returned                   47,000
         To Hire of plant                      77,000 By Plant c/d                        1,65,000
         To Materials                        6,62,000 By Materials c/d                       50,000
         To Direct wages    9,60,000                     By WIP c/d:
            Add: Accrued      40,000        10,00,000       Value of work certified      24,00,000
         To Wages related costs              1,32,000       Cost of work not certified    1,80,000
         To Direct expenses                    34,000
         To Supervisory staff:
                 Direct        90,000
18                          INTERMEDIATE EXAMINATION: MAY, 2023
     (b) Statement showing income forecast of the company: assuming that products A, B, C
         and E are further processed (Refer to working note)
                                                          Products
                                   A (`)         B (` )        C (`)        D (`)          E (` )       Total (`)
     A. Sales revenue       3,12,50,000 31,87,500 18,75,000 12,50,000 93,75,000 4,69,37,500
     B. Apportioned           67,74,563      6,77,456       4,21,528     3,01,092 21,67,860 1,03,42,500
        Costs
     C. Further               31,25,000      3,75,000       1,25,000             -     3,75,000        40,00,000
        processing cost
                   PAPER – 3: COST AND MANAGEMENT ACCOUNTING                                            21
     Labour Variances:
        Labour        SH       SR SH × SR      RSH RSH × SR           AH     AH × SR       AR      AH × AR
                    (WN-3) (`)                (WN-4)
                                     (` )            (` )                       (` )       (` )       (` )
     Skilled           2232 40       89,280    2289        91,560   2,400       96,000      35       84,000
     Semiskilled       1785 25       44,625    1831        45,775     1720      43,000      20       34,400
                   4,017 hrs       1,33,905    4,120     1,37,335   4,120    1,39,000               1,18,400
                                               0.95 x 1600 hr             
    Semiskilled labour = 1785.397 or 1785 hrs                  x 2,960 kg 
                                               0.90 x 2,800 kg            
    WN- 4: Revised Standard Hours (RSH):
                                                2,000 hrs             
    Skilled labour = 2,288.889 or 2,289 hrs. =            x 4,120 hrs 
                                                3,600 kg              
                                                 1,600 hrs             
    Semiskilled labour = 1831.11 or 1831 hrs. =            x 4,120 hrs 
                                                 3,600 kg              
    (e) Labour Cost Variance (Skilled + Semiskilled) = {(SH × SR) – (AH × AR)}
                                                    {1,33,905 – 1,18,400} =15,505 (F)
    (f)   Labour Efficiency Variance (Skilled + Semiskilled) = {(SH × SR) – (AH × SR)}
                                                   {1,33,905 – 1,39,000} = 5,095 (A)
    (g) Labour Yield Variance (Skilled + Semiskilled) = {(SH × SR) – (RSH × SR)}
                                                = {1,33,905 – 1,37,335} = 3,430 (A)
                         Sales per unit - Variable Cost per unit
13. (a) P/V ratio:                                                 100
                                 Selling price per unit
                      1000 − 800
                  =               100
                        1000
                       200
                 =          100 = 20%
                      1000
                                    Annual fixed cost
          Annual BEP in units:
                                   Contribution per unit
              ` 23,00,000
          =               = 11,500 units
                 ` 200
                                   Annual fixed cost
          Annual BEP in value:
                                      P / V ratio
                            ` 23,00,000
                                        = `1,15,00,000
                               ` 20%
    (b) Revised P/V ratio and BEP :
          commission on sales per unit= 1% of 1,000= `10
24                          INTERMEDIATE EXAMINATION: MAY, 2023
                            1000 − ( 750 + 50 + 10 )
          So, P/V ratio :
                                      1000
              190
          =         100 = 19%
              1000
                                     Annual fixed cost
          BEP in terms of units:
                                    Contribution per unit
                                23,00,000
                            =             = 12,106 units
                                   190
                                      Annual fixed cost
          BEP in terms of value:
                                           P/V
                                23,00,000
                            =             = `1,21,05,263
                                  19%
     (c) Break-even point under fixed salary plan:
                        Contribution per unit 1000 − 750          250
          P/V ratio =                          =          100 =      ×100 =25%
                        Selling price per unit   1000            1000
(c) Essential pre-requisites for Integrated Accounts: The essential pre-requisites for
    integrated accounts include the following steps-
      1.    The management’s decision about the extent of integration of the two sets of
            books. Some concerns find it useful to integrate up to the stage of prime cost or
            factory cost while other prefers full integration of the entire accounting records.
      2.    A suitable coding system must be made available so as to serve the accounting
            purposes of financial and cost accounts.
      3.    An agreed routine, with regard to the treatment of provision for accruals, prepaid
            expenses, other adjustment necessary for preparation of interim accounts.
      4.    Perfect coordination should exist between the staff responsible for the financial
            and cost aspects of the accounts and an efficient processing of accounting
            documents should be ensured.
(d)
       S. No.            Cost Control                        Cost Reduction
          1   Cost control aims at maintaining Cost reduction is concerned with
              the costs in accordance with the reducing costs. It challenges all
              established standards.              standards and endeavours to
                                                  improvise them continuously
          2   Cost control seeks to attain lowest Cost reduction recognises no
              possible cost under existing condition as permanent, since a
              conditions.                         change will result in lower cost.
          3   In case of cost control, emphasis In case of cost reduction, it is on
              is on past and present              present and future.
          4   Cost control is a preventive Cost reduction is a corrective
              function                            function. It operates even when an
                                                  efficient cost control system exists.
          5   Cost control ends when targets Cost reduction has no visible end and
              are achieved.                       is a continuous process.