Transcript 正淩專案 Team up meeting

Ganda ERP System
Cost Calculation Validation
Process
• Digiwin Group
• Nick Lu
• 11-Dec-2014
CFC ERP Cost Validation Process
Raw Material
Open Balance
(axct001)
Production Cost
S/P MISC Issue
Cost Calculate
(axcp500)
Reason Code
(axci010)
Raw Material
Good
Receiving
RM Issue Rpt
(axcr771)
Direct Labor
Cost Article
(axct310)
Stock-in &
Stock-return
Cost Calculate
(axcp500)
Cost Voucher
(axcp191)
Overhead
Purchasing AP
Inbound Exp
Allocation
Cost Calculate
(axcp500)
Raw Material
Issue / Return
Production
Stock-in
Prd Summary
(axcr773)
Pur Stk-in Rpt
(axcr700)
Sales Delivery
Inventory Rpt
(axcr430)
COGS Rpt
(axcr760)
PD Srock-in Rpt
(axcr772)
General
Ledger
Cost Allocate
(axct312)
CFC ERP Production Flow
(for Clink direct-ship)
Packing
csrt303
Cement
Mill
csrt304
csrt305
Packing
Merge
(Manual)
WS-RM-1
WS-KL-1
WS-CM-1
WS-PK-1
WS-PK
(P2110)
1502-000001
(P2210)
1503-000001
(P2310)
1504-000001
(P3110)
1505-000002
(P3010)
1506-000002
Quarry
Explosive
csrt301ab
Quarry
Crush
csrt301ab
Raw Mill
Klin
csrt302
WS-Q-LST
WS-Q-LST
(P1000)
1500-000001
(P1000)
1500-000002
Product
Line 1
WS-Q-CLAY
(P1000)
1501-000001
WS-Q-LST
WS-Q-LST
(P1000)
1500-000001
(P1000)
1500-000002
Product
Line 2
WS-Q-CLAY
(P1000)
1501-000001
< Work Center >
< Cost Center >
< Stock-in Item Code >
WS-RM-2
(P2120)
1502-000002
WS-KL-2
(P2220)
1503-000002
Clinker
For
Ship-out
Clink-Dispatch
For sales
1503-000000
WS-CM-2
WS-PK-2
WS-PK
(P2320)
1504-000002
(P3120)
1505-000003
(P3010)
1506-000002
Production Cost Collection
WS-Q-LST
WS-Q-LST
WS-RM-1
WS-KL-1
WS-CM-1
WS-PK-1
WS-PK
(P1000)
1500-000001
(P1000)
1500-000002
(P2110)
1502-000001
(P2210)
1503-000001
(P2310)
1504-000001
(P3110)
1505-000002
(P3010)
1506-000002
Product
Line 1
WS-Q-CLAY
(P1000)
1501-000001
G/L Labor & Overhead Account
622111 - DL:Salary
627230 - OH:Supplies
627250 - OH:Maint Exp
Indirect
Acc Dept
P3110
G/L Labor & Overhead Account
…..
622111 - DL:Salary
Mult-Dept
Alloctaion
6xxxxxx - OH : Dir. Exp
Cost Center
P3110
Direct
Acc Dept
P3110
627230 - OH:Supplies
627250 - OH:Maint Exp
622111 - DL:Salary
627230 - OH:Supplies
627250 - OH:Maint Exp
Indirect
Acc Dept
P3110
…..
6xxxxxx - OH : Dir. Exp
…..
Packing
Work Center
WS-PK-1
Packer
PM-01
Packer
PM-02
Packer
Packer
PM-03
PM-04
6xxxxxx - OH : Dir. Exp
Packer
PM-06
Packer
PM-06
Cost Calculation Setting Procedure
axci001
(Multi-Dept
Allocation for Labor)
axci002
(Multi-Dept
Allocation for OH)
Cost Center
Level
Cost Article
Level
Dept. Account
Level
axci030
Cost Center
(ex. P3110)
Direct
Labor 1
Dept
CoA
(Cost Article
Setting)
OH
Exp 1
Dept
CoA
OH
Exp 2
axci040
axci050
(Cost Center Data
Collection)
(Cost article
allocate coefficient )
Dept
CoA
Axci060
(Cost Article by
Product)
Monthly End Cost Calculation
Procedure
(Both VND/USD DB)
(Both VND/USD DB)
(Only in VND DB)
(Both VND/USD DB)
(Both VND/USD DB)
axcp702
(Production Volume
Summary)
All Transactions
have been Input
axcp312
(G/L balance
Allocation)
aimp620
axcr360
(Monthly Inventory
Calculation)
(Cross-Checking
Before costing)
axcp500
axcr370
(Monthly Cost
Calculation)
(Cross-Checking
After costing)
Cost Report
Review &
Checking
Cost Related Report
•
•
•
•
•
•
•
•
axcr999 : Cost Summary Report
axcr700 : Purchase Stored-in Monthly Rpt.
axcr430 : Inventory Cost Periodic Report
axcr760 : Sales Cost Monthly Report
axcr770 : MISC Transaction Monthly Rpt.
axcr771 : Production Material Issuing Monthly Rpt.
axcr772 : Production Stock-in Monthly Rpt.
axcr773 : Production Summary Report