19 May 2009

1. Azbil Vietnam Specification Requirement 19 May 2009 NTT DATA Vietnam Co. Ltd.,

2. 1. Input File image Please refer to other document

3. 2. Output File Image Please refer to other document

4. 3. Master Data File Image Please refer to other document

5. 4. Check result file Image Please refer to other document

6. 5. Screen Image 1 (Initial screen) (1/3)

7. 5. Screen Image 1 (Description) (2/3) <Remarks> 1.All items are mandatory. 2.Underline value is default value.

8. 5. Screen Image 1 (Description) (3/3) <Remarks> 1.All items are mandatory. 2.Underline value is default value.

9. 6. Screen Image 2 (If there is no data in Price List) (1/3)

10. 6. Screen Image 2 （Description）(2/3)

11. 6. Screen Image 2 （Description） (3/3) <Details> 1. When user click create button in initial screen, If the “model” in “input file_ equipment sheet” is not in “Master data _ Price List”, tool should display this screen. 2. If there are several models which in not in price list, tool should display this screen for each model (one by one) 3. If any mandatory item are not inputted, tool should pop-up the error message and stop proceeding. 4. When clicking “OK” button, tool should update the inputted information to price list and “update date”

12. 7. Calculation Formula 1 – Equipment Unit Price <Output.xls - “Content” sheet – 1. Equipment – Unit Price> Unit Price = Roundup ( BASE / ( 1 – “Equipment Profit”), 2) 1. BASE It’s gotten from Master data.xls– “Price List” sheet -If the category of target equipment is “others” ： BASE = “Cost” -If the category of target equipment is “BA”, “IA”, “CP” ： BASE = “CTP(UNIT)” 2. Equipment Profit It’s gotten from Master data.xls- “profit rate” sheet as follows.

13. 7. Calculation Formula 2 – Panel Total <Output.xls - “Content” sheet – 2. Control Panel Fee – Panel Total> ①　Calculate Panel Total of each panel. Panel Total of each panel= Roundup((Sum(“Quantity”*“Price”) + “PICK & Delivery Fee”) /(1 – “Panel Profit”), -1) 1.Quantity It’s gotten from Input Data.xls– “Panel” Sheet – Qty 2. Price It’s gotten from Master Data.xls - “Panel Price List” sheet – Price Only “Others-1 ~ 5”, Price should be gotten from Input Data.xls– “Panel” Sheet 3. PICK & Delivery Fee It’s gotten from Input Data.xls– “Panel” Sheet – PICK & Delivery Fee 4. Panel Profit It’s gotten from Master data.xls- “profit rate” sheet –(Japanese/Vietnamese)Control Panel ②　Calculate total of “Panel Total of each panel”. Panel Total = Σ(each panel)

14. 7. Calculation Formula 3 – Tax and Freight Charge (1/9) <Output.xls - “Content” sheet – 4. Tax and Freight Charge– Amount> ①　Tax calculation Tax = Sum(import Tax (UNIT)) 1. Import Tax Unit ImportTax Unit of each Equipment is gotten from Master data.xls– “Price List” sheet. Calculate total of “import Tax Unit” for all equipment. The equipment whose category is “Others” doesn’t have import tax information. it’s OK to ignore that. ②　Freight Charge Case 1. in the case that “Transportation” – SHIP” was selected in initial screen. 1. Calculate total volume(RT) of all Equipment 　　→　Volume of each Equipment is gotten from Master data.xls– “Price List” sheet– Volume. The equipment whose category is “Others” doesn’t have volume information. it’s OK to ignore that.

15. 7. Calculation Formula 3 – Tax and Freight Charge (2/9) 2. Calculate FOB Charge If RT is less than 13 m3 , FOB Charge is calculated as follows, FOB Charge= Customs fee(Price * Qty) + shipping fee-LCL(Price * Qty) +Documentary arrangement fee(Price * Qty) + THC(Price * Qty) + CFS CHARGE(Price * RT) Price, Qty are gotten from Master data.xls- “Ocean Freight Master” sheet When the destination is Hai Phong in initial screen , please use the price for “Hai Phong”. When the destination is HCMC in initial screen , please use the price for “HCMC”. If RT is equal or greater than 13 m3 , FOB Charge is calculated as follows, FOB Charge= Customs fee(Price * Qty) + shipping fee-FCL(Price * RT) +Documentary arrangement fee(Price * Qty) + THC(Price * Qty) + Lashing fee(Price * Qty) +Container drayage (Price * Qty) + DOC FEE (Price * Qty) Price, Qty are gotten from Master data.xls- “Ocean Freight Master” sheet When the destination is Hai Phong in initial screen , please use the price for “Hai Phong”. When the destination is HCMC in initial screen , please use the price for “HCMC”.

16. 7. Calculation Formula 3 – Tax and Freight Charge (3/9) 3. Calculate Ocean Freight If RT is less than 13 m3 , FOB Charge is calculated as follows, Ocean Freight = Round(“Exchange JPY/US$”*(FREIGHT(LCL)(Price * RT)+FAF(Price * Qty) +YAS(Price * Qty),0) Exchange JPY/US$ is gotten from Master data.xls- “Constants” sheet Price, Qty are gotten from Master data.xls- “Ocean Freight Master” sheet When the destination is Hai Phong in initial screen , please use the price for “Hai Phong”. When the destination is HCMC in initial screen , please use the price for “HCMC”. If RT is equal or greater less than 13 m3 , FOB Charge is calculated as follows, Ocean Freight = Round(“Exchange JPY/US$”*(FREIGHT(FCL)(Price * Qty)+FAF(Price * Qty) +YAS(Price * Qty),0) Exchange JPY/US$ is gotten from Master data.xls- “Constants” sheet Price, Qty are gotten from Master data.xls- “Ocean Freight Master” sheet When the destination is Hai Phong in initial screen , please use the price for “Hai Phong”. When the destination is HCMC in initial screen , please use the price for “HCMC”.

17. 7. Calculation Formula 3 – Tax and Freight Charge (4/9) 4.Calculate total fee Total fee= Roundup(((FOB fee+Sea transport fee)*consumption tax)/ “Exchange JPY/US$” /(1 – “Equipment Profit”), 0) Equipmentprofit is got from Master data.xls- “profit rate” sheet. If Japanese Company is selected in initial screen, “Equipment Profit” is “Japanese-all product” If Others is selected in initial screen, “Equipment Profit” is “Vietnamese –BSC product”

18. 7. Calculation Formula 3 – Tax and Freight Charge (5/9) Case 2. in the case ”Transportation” – Air was selected in initial screen Calculate shipping charge both Courier and Air transport, and select transport type having higher shipping charge. (1)Courier calculation 1.Chargeable weight calculation Chargeable weight= CEILING(If (Volume weight > Gross weight, Volume weight, Gross weight),0.5) *　Gross weight: total weight of all Equipment 　　　→　Weight of each Equipment is gotten from Master data.xls– “Price List” sheet– Kg. The equipment whose category is “Others” doesn’t have weight information. it’s OK to ignore that. 　　　*　Volume weight = RT *1003/ Volume weight coefficient 　　　→　Volumeweight coefficient is gotten from Master data.xls- “Constants” sheet

19. 7. Calculation Formula 3 – Tax and Freight Charge (6/9) 2.Courier fee calculation Courier fee= Manufactured Origin certificate + consular visa service fee + Urgent operation charge + FOB Charge + shipping charge+ insurance fee * Manufactured Origin certificate + consular visa service fee+ Urgent operation charge are gotten from Masterdata.xls– “Constant” sheet 　　　　* FOB Charge It’s gotten from FOB Charge = Masterdata.xls– “Air Freight master” sheet – Documentary arrangement fee/other company. 　　　　* Shipping charge Get Price corresponding with Chargeable weight from Masterdata.xls – “Courier Price List” sheet. 　　　　* Insurance fee(in the case ”Insurance” – Yes was selected in initial screen) Insurance fee= (Equipment total *Exchange JPY/US$ + FOB Charge + Shipping charge ) * insurance premier The equipment whose category is “Others” doesn’t have weight information. it’s OK to ignore that. Insurance premier is gotten from Master data.xls- “Constants” sheet Equipment total is gotten from Output file - Contents

20. 7. Calculation Formula 3 – Tax and Freight Charge (7/9) (2) Air calculation Air fee= Manufactured Origin certificate + consular visa service fee + Urgent operation charge + FOB Charge + shipping charge+ insurance fee * Manufactured Origin certificate + consular visa service fee+ Urgent operation charge are gotten from Masterdata.xls– “Constant” sheet 　　　　* Insurance fee(in the case ”Insurance” – Yes was selected in initial screen) Insurance fee= (Equipment total * Exchange JPY/US$ + FOB Charge + Shipping charge ) * insurance premier The equipment whose category is “Others” doesn’t have weight information. it’s OK to ignore that. Insurance premier is gotten from Master data.xls- “Constants” sheet Equipment total is gotten from Output file - Contents 　　　　* FOB Charge FOB Charge = Documentary arrangement fee (YAS) + customs fee(YAS) + terminal charge Documentary arrangement fee (YAS) and customs fee (YAS) are got from Masterdata.xls– “Air Freight master” sheet

21. 7. Calculation Formula 3 – Tax and Freight Charge (8/9) Terminal charge= IF(Chargeable weight >29, Chargeable weight*CONST, Min) Const is gotten from Masterdata.xls– “Air Freight master” sheet terminal charge/Const Min is gotten from Masterdata.xls– “Air Freight master” sheet terminal charge/Min 　　　　* Shipping fee Use Fee table corresponding with Chargeable weight to calculate basic shipping charge (This basic shipping fee is changeable based on destination place ) Fee table is got from Masterdata.xls– “Air Freight master” sheet basic shipping charge = chargeable weight *fee / kg If basic shipping charge is smaller than M/M 　　　　　→　shipping fee= M/M If basic shipping charge is bigger than M/M 　　　　　→　shipping Charge= basic shipping charge ＋Add fuel expense* Chargeable weight Add fuel expense is value inputted in initial screen.

22. 7. Calculation Formula 3 – Tax and Freight Charge (9/9) (3) Shipping total charge calculation First, compare shipping charge of Courier and Air, then choice one having higher shipping charge. Shipping total charge= Roundup(((Courier or Air)*consumption tax/ “Exchange JPY/US$”) /(1 – “Equipment Profit”), 0) If Japanese Company is selected in initial screen, “Equipment Profit” is “Japanese-all product” If Others is selected in initial screen, “Equipment Profit” is “Vietnamese –BSC product” ③　The end, add TAX, shipping total charge and Forwarder cost (in initial screen) together, you will get Tax and Freight Charge.

23. 7. Calculation Formula 4 – T& C Total <Output.xls - “Content” sheet – 6. Test & Commissioning – Amount> First, Total(cost) should be calculated. Total(Cost) = Total of “each amount” * each amount = “UNIT” * “Day” “UNIT” price is gotten from Masterdata.xls– “T&C master” sheet Only “UNIT” price for AirFare, it’s got from input file. Second, “documentation fee” and “Expenses” should be decided by Total(Cost) these cost should be the corresponding “value” from Masterdata.xls– “T&C master” sheet -Total(Cost) list Third, Total(Selling) should be calculated. Total(selling) = Total of “each selling price” + ROUNDUP((“documentation fee” /(1-“T&C Profit”)),-1) + ROUNDUP((“Expenses” /(1-“T&C Profit”)),-1) Basically, Selling price is as same as “each amount” Incase of SV Fee(Ratio =1), Selling price “ROUNDUP((UNIT*DAY/(1-“T&C Profit”)),-1)

24. 8. Other conditions <file conditions> 1. Tool itself and Master data should be stored in same folder. 2. Everyone can run the tool, but Master data should be protected by password and the person who know the password can be opened and edited. 3. Output file and check result file should be created in same folder as tool and Master data. if there is same file in advance, tool should update the file.