Decisions on Cost Accumulation and Allocation from the Management

Decisions on Cost Accumulation and Allocation from the Management

Kindly circulate the below decisions from the Management End.

1. Costing Approach - Concurred by Sonata and KPMG that the approach is Okay. The control account to be used for Costing purposes have been included in the Chart of Accounts -COA.

2. Costing UAT - Costing UAT to be done initially based on the expenses booked by cost center in GL in the absence of entries coming from Payroll and Fixed Assets . Once these modules are up, Costing to be tested again from complete flow perspective. Testing shall not be stuck for the accuracy of data.

3. Direct Labour resources to be bifurcated by Operations and separate Cost Component Class to be created for each Labour Resource. - Costing Team to confirm the same with Head of Manufacturing.

4. The feasibility of including Labor Overtime as a separate resource. To be confirmed by Costing  and Manufacturing.

5. LCM Charges to be defaulted based on the item Category - to be included in Solution design by KPMG. For this a personalization/customization will be required.

6. Indirect Cost Allocation - Allocation sheet to be circulated by KPMG. To be confirmed by Sonata.

7. Product wise Contribution Margin - Not required in the present scope.

8. Manufacturing Budget - Manufacturing budget will loaded as a whole and not Cost Center wise at present, at the year end Cost Center wise budget will be prepared based on Actuals.


9. Day 1 Reports - Supplier Ledger report and other additional formats required will be included as Day 1 Reports. Finance to provide the updated list and formats.

10. Cost Centers in Costing: Apart from the previous cost centers.

-Three Packaging Cost Centers are added: Primary Packing (Sterile), Primary Packing (Non sterile), Secondary Packing to segregate Sterile and Non Sterile Packing Cost.

-Product and Process Engineering cost center is added under manufacturing -PPIC is added under manufacturing

- Product Development is created as a separate cost center to accumulate the product cost

11. Payroll Costing Approach: High level Payroll costing approach is finalized.

Direct Labor cost will be segregated by Cost Centers Manufacturing Administrative and Supervision Cost will include the cost of Production Officers Non-Manufacturing Admin and Sup cost will go to the respective departments (Such as Finance & Accounts, IT etc.)

12. PF, Loan and WPPF/WF.

The solution approach for the above was discussed and finalized.



PF: Separate books will be maintained at GL level. Employee wise PF schedule will be maintained in Payroll.

WPPF/WWF: Separate financial statements will be generated for these.

Loans: Loan disbursement in AP-Accounts payable followed by Loan Deduction in Payroll (Detailed documents for these areas to be shared for review)

OPM Financials-Costing Discussion for the ERP Implementation

OPM Financials-Costing Discussion for the ERP Implementation

The Summary of the costing meeting for ERP Implementation yesterday.


1.      Separate costing for batches run at night shift: As discussed, to separately account for the night shift allowances to the batches run in the night shift following actions would be required:

i)      Labour Resources on all batches will have to be segregated into day time labour and night time labour to segregate the labour hours for day shift and night shift.

ii)     The Night shift allowance and other night shift specific allowances will be captured in different GL Accounts directly from the Payroll module.

iii)    The Night shift allowance cost aggregated in Step (ii) will be allocated to the Batches based on the night time labour hours captured on the batch in Step (i) and will reflect as a higher Batch Cost.

The applicability of the above solution depends on the following

(i)     whether the labour hours for the day time and night time can be captured on every production batch separately
(ii)    If it is desirable to load the products manufactured in the night shift with the extra night shift allowance cost as opposed to apportioning the cost equally to all the products and batches with in a plant.

The same has to be discussed amongst the Sonata Manufacturing, Marketing and Finance departments and communicated to KPMG.

2.       Resource Cost per hour will be based on the average resource rate for the cost center which will include the expenses related to all the equipment in that cost center / cost pool
3.      Costing for Samples (Physician’s/Export): Since the production of samples is decided after the completion of base product manufacturing. There will be separate formula (FO, FLP) and batch for the base product and the commercial product/samples. Hence the Cost of Base Product will be as per the FO and routing and for the samples the Base Product will be used as an Ingredient in the FLP. So the Base Product, Commercial Product and the Samples will be costed separately.

4.      Excess packaging material consumed: The cost of excess material consumed in a batch will reflect in the Material usage variance Report (Standard Report) which will show standard vs actual quantity of the material used along with the variance percentage.
 
5.      Cost of New Product Development: Least Cost Formulator functionality to be explored by KPMG for the new Product development,  if the batches run for New Product Development are not being captured in the system, the cost of new products can be ascertained based on the formula and proposed routing ( the standard rates of the cost centers used in the routing will be captured in the system for commercial product costing)

6.      Change in formula used for Production: The Costing formula used for Standard Costing can be separated in the system from the Production formula to effectively track the variance.

7.      TDS on Cumulative Balances: Deduction of TDS on cumulative balances to be automated in the system.

Advanced Supply Chain Planning (ASCP) process

Advanced Supply Chain Planning (ASCP) process
This is FYI that KPMG has released the following To Be processes to Sonata today, which I am sharing with you:

  • Ø  Sonata OPM Manufacturing processes
  • Ø  Sonata Advanced Supply Chain Planning (ASCP) process

Please review the files if and only if it is concerned with you/ your department. The discussion regarding these files will be carried out by KPMG next week and I shall notify the schedule as soon as I receive it from KPMG. Hope these will be helpful. Thanks

Due to massive change in FO and FLP of Prednisone Tablet, cost has increased significantly. For example, in New formulation, coating is introduced along with inclusion of Alu Alu Foil instead of PVC Film and an equivalent Rs. 145400 per batch is increased due to such changes 

As you know we are following periodical accounting system where everything should be completed including data correction within a particular accounting period. I found your correction required from August, 2012. In this regard we can change data only when Finance department give us approval, because they already given accounting treatment according to your given data.You are requested to get approval from finance department for the above changes


We need your involve to resolve the matter that due to typing error a mistake was made for the Finished Goods stock report  of September 2012 which was introduced product code 925, quantity 3840. The right product code should be 935 of these quantity. Our It department update the request after approval from you.