Dear Jean,
Our conversation yesterday refers.
In view of the maintenance of EPPO rate in the GSAP system starting from 01.09.2016, I would like to propose that this same quotation be incorporated into the following items:
OA 4600130873_item 30
OA 4600131018_items 120 & 130.
I have compiled data from June to Aug 2016 for these items. You may refer to the respective tabs for the formula being maintained every week and the changed element is highlighted in yellow. Item 130 for OA 4600131018 is not detailed in my file since it is exactly the same as item 120.
The high level compilation of the data shows that at least 75% of the update for these 3 materials is a result of change in EPPO rate every Monday.
Part of the formula taken from OA 4600130873_item 30 maintained effective from 01.09.2016:
The value in red is calculated by:
[(EPPO Rate – Discount)*100]*3.2%
[(35.51 – 3.50)*100]*3.2%
= 102.432 THB 100/L30
Proposed formula to incorporate EPPO Quotation:
The incorporation of the EPPO quotation allows the system to pick the EPPO rate maintained to do the calculation.
Foreseeable benefits:
1. Saving potentially 20 mins each week for CPT team.
2. Saving email storage space – the file is at least 1MB each week.
3. Reduce manual intervention.
4. Eliminate the need to raise request and seek approval every Monday unless there is any update to the calculation factor or surcharge besides the one affected by EPPO.
5. There is no risk of conversion from different currency because EPPO rate is maintained at THB/L30 in the system.
I will proceed to book our time to go through this with you and Areeya.
Feel free to raise any concern you have with regards to this proposal.