COPA V vs. S

Embed Size (px)

Citation preview

  • 7/31/2019 COPA V vs. S

    1/10

    Copyright 2007 Accenture All Rights Reserved. Accenture, its logo, and High Performance Delivered are trademarks of Accenture.

    Copyright 2007 Accenture All rights reserved. Accenture, its logo, and High Performance Delivered are trademarks of Accenture.

    CO-PA

    Accounting and reporting with standard price vs. MAP

  • 7/31/2019 COPA V vs. S

    2/10

    CO-PAChallenge in current scenario

    Currently HOBI have two different legal entities one is HOBI and another is RA

    All the manufacturing activities taking place in HOBI only

    All the Domestic sales taking place in RA only, and there is no direct domestic sale

    from HOBI

    HOBI is transferring the Finished goods to RA with some margin on it, also SCTand VAT charged on the transfer price.

    For RA the cost of product is transfer price from HOBI to RA plus the SCT charged

    on transfer price.

    With this scenario, in COPA reports system is showing the inflated figures forRevenue as well as Cost.

  • 7/31/2019 COPA V vs. S

    3/10

    CO-PAChallenge in current scenarioExample

    HOBI RACost of product 80 TL per Piece Cost of product 110 TL per PieceHOBI to RA Selling Price 100 TL per Piece RA Selling Price 150 TL per PieceSCT Applicable 10 TL Per PieceVAT Payable 10 TL Per Piece VAT Payable 10 TL per Piece

    Total 120 TL Per Piece Total 160 TL per piece

    COPA Document & Reporting for profitability (Sales price minus cost and SCT orVAT)a)Cost 80 TL a) Cost 110 Tb) Revenue 100 TL b) Revenue 150 TLc) Profit (b-a) 20 TL c) Profit (b-a) 40 TL

    Group Profitabilitya)Cost 190 TL (Inflated Cost)b) Revenue 250 TL (Inflated Revenue)c) Profit (b-a) 60 TL

  • 7/31/2019 COPA V vs. S

    4/10

    CO-PAAccounting with price control V

    vs. S (RA Finished goods price)

    Example: Cost in HOBI 800

    Margin in HOBI 200

    Sale Price 1000

    SCT 200

    VAT 200

    Total Invoice Value 1400

    At the time of goods issue from HOBI to RA :

    In HOBI:

    COS a/c Dr. 800

    To Inventory a/c Cr. 800

    In RA:

    Inventory a/c Dr. 1200

    To GR/IR a/c Cr. 1200

    Example: Cost in HOBI 800

    Margin in HOBI 200

    Sale Price 1000SCT 200

    VAT 200

    Total Invoice Value 1400

    At the time of goods issue from HOBI to RA :

    In HOBI:

    COS a/c Dr. 800

    To Inventory a/c Cr. 800

    In RA:

    Inventory a/c Dr. 800

    Price Diff a/c Dr. 400

    To GR/IR a/c Cr. 1200

    Moving Average Price Standard Price

  • 7/31/2019 COPA V vs. S

    5/10

    CO-PAAccounting with price control V

    vs. S (RA Finished goods price)

    At the time of Invoice ;

    In HOBI

    Customer a/c (RA) Dr. 1400

    Sales a/c Cr. 1000

    To SCT Payable a/c Cr. 200

    To VAT Payable a/c Cr. 200

    In RA

    GR/IR a/c Dr. 1200

    Input VAT Dr. 200

    To Vendor a/c(HOBI) Cr. 1400

    At the time of Invoice ;

    In HOBI

    Customer a/c (RA) Dr. 1400Sales a/c Cr. 1000

    To SCT Payable a/c Cr. 200

    To VAT Payable a/c Cr. 200

    In RA

    GR/IR a/c Dr. 1200

    Input VAT Dr. 200

    To Vendor a/c(HOBI) Cr. 1400

    Moving Average Price Standard Price

  • 7/31/2019 COPA V vs. S

    6/10

    CO-PAAccounting with price control V

    vs. S (RA Finished goods price)

    At the time of standard cost estimate run ;

    In HOBI:

    Revaluation a/c Dr./Cr.

    To Inventory a/c Dr./Cr.

    In RA:

    In RA no need of standard cost estimate run, so noaccounting entry will happen

    At the time of standard cost estimate run ;

    In HOBI:

    Revaluation a/c Dr./Cr.To Inventory a/c Dr./Cr.

    In RA:

    Revaluation a/c Dr./Cr.

    To Inventory a/c Dr./Cr.

    Moving Average Price Standard Price

  • 7/31/2019 COPA V vs. S

    7/10

    CO-PA

    With Price Control V With Moving average price, additive cost calculation and updation will not be required in RA

    With Moving average price, profitability analysis will be available at the group level and alsoat the company code level.

    With Moving average price, Cost analysis will be available at HOBI company code only,itemization of cost will not be available in RA .

    With Moving average price, to get a consolidated report of profit analysis and cost analysis,excel work will be required.

    With Moving average price, Price difference hit will not come at the time of moving the goods

    from HOBI to RA

    With Moving average price, Revaluation hit will not come in RA at the time of standard costestimate run

  • 7/31/2019 COPA V vs. S

    8/10

    CO-PA

    With Price Control S With Standard price, additive cost calculation and updation will be required in RA everymonth for all the materials. (Additive cost will be equal to margin at HOBI and SCT charged byHOBI from RA)

    Additive cost calculation will be done out of system manually

    With standard cost, Price difference a/c hit will come with every transaction at the timetransfer of goods from HOBI to RA ( If transfer value not equal to the standard price in RA)

    With Standard price, revaluation a/c hit will come every month in RA also at the time ofstandard cost estimate run.

    With Standard cost, Profitability analysis and cost analysis reports will be available from thesystem without manual work in excel.

  • 7/31/2019 COPA V vs. S

    9/10

    CO-PA

    Proposed Solution Finished goods should be managed at moving average price in RA

    It would be preferred if HOBI margin could be fixed in terms of percentage.

    HOBI margin will be captured in one of the condition in SD at the time of transferring the

    finished goods from HOBI to RA

    COPA Consolidation report will have the total sale (excluding inter-company) total COGS(excluding inter-company)

  • 7/31/2019 COPA V vs. S

    10/10

    CO-PA

    Proposed Solution (Example)HOBI RACost of product 80 TL per Piece Cost of product 110 TL per PieceHOBI to RA Selling Price 100 TL per Piece RA Selling Price 150 TL per PieceSCT Applicable 10 TL Per PieceVAT payable 10 TL Per Piece VAT Payable 10 TL per Piece

    Total 110 TL Per Piece Total 160 TL per piece

    COPA Document & Reporting for profitability (Sales price minus cost and SCT or VAT)No COPA Document created here Customization is done at this levelb) SCT 10 TL a) Cost of HOBI 80 TL

    b) SCT applicable in HOBI 10 TL

    c) Revenue 110 TL c) Revenue in RA 150 TLd) Profit (c-(a+b)) 20 TL d) Profit (c-(a+b)) 60 TL

    Group Profitability a) Cost 80 TLb) SCT 10 TLc) Revenue 150 TLd) Profit (c-(a+b)) 60 TL