| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Date | NBS_WheatFlour_NGN | US_HRW_USD_per_mt | CBN_USDNGN_avg | Tariff_rate | Freight_USD_per_mt | Extraction_rate | Landed_price_with_tariff | Landed_price_with_waiver | Pred_price__with_tariff | Pred_price_with_waiver | |||||||||||||||
2 | 2016-01-01 00:00:00 | 519 | 193.2717042 | 196.55 | 0.05 | 70 | 0.75 | 144.8889497 | 137.9894759 | 547.5660186 | 539.415994 | |||||||||||||||
3 | 2016-02-01 00:00:00 | 523 | 187.0252803 | 196.5 | 0.05 | 70 | 0.75 | 141.4153092 | 134.6812469 | 543.4627701 | 535.5081382 | |||||||||||||||
4 | 2016-03-01 00:00:00 | 531 | 191.067084 | 196.5 | 0.05 | 70 | 0.75 | 143.6391096 | 136.799152 | 546.0896412 | 538.0099202 | |||||||||||||||
5 | 2016-04-01 00:00:00 | 545 | 187.392717 | 196.5 | 0.05 | 70 | 0.75 | 141.6174729 | 134.8737837 | 543.7015766 | 535.735573 | |||||||||||||||
6 | 2016-05-01 00:00:00 | 549 | 171.9603756 | 196.5 | 0.05 | 70 | 0.75 | 133.1265987 | 126.7872368 | 533.6717052 | 526.1833145 | |||||||||||||||
7 | 2016-06-01 00:00:00 | 559 | 173.0626857 | 231.2613636 | 0.05 | 70 | 0.75 | 157.3908228 | 149.8960217 | 562.3338948 | 553.4806379 | |||||||||||||||
8 | 2016-07-01 00:00:00 | 581 | 151.7513571 | 294.0722222 | 0.05 | 70 | 0.75 | 182.5905602 | 173.8957716 | 592.1011622 | 581.8304164 | |||||||||||||||
9 | 2016-08-01 00:00:00 | 567 | 149.1793002 | 309.2304348 | 0.05 | 70 | 0.75 | 189.7753488 | 180.7384275 | 600.5882159 | 589.9133247 | |||||||||||||||
10 | 2016-09-01 00:00:00 | 569 | 150.649047 | 304.725 | 0.05 | 70 | 0.75 | 188.2643864 | 179.2994156 | 598.8033868 | 588.2134875 | |||||||||||||||
11 | 2016-10-01 00:00:00 | 596 | 151.7513571 | 304.7125 | 0.05 | 70 | 0.75 | 189.1971491 | 180.1877611 | 599.9052157 | 589.2628483 | |||||||||||||||
12 | 2016-11-01 00:00:00 | 604 | 150.649047 | 304.6818182 | 0.05 | 70 | 0.75 | 188.2377079 | 179.2740075 | 598.7718728 | 588.1834741 | |||||||||||||||
13 | 2016-12-01 00:00:00 | 613 | 141.8305662 | 304.7236842 | 0.05 | 70 | 0.75 | 180.7394136 | 172.1327748 | 589.9144895 | 579.747871 | |||||||||||||||
14 | 2017-01-01 00:00:00 | 627 | 153.2211039 | 304.702381 | 0.05 | 70 | 0.75 | 190.4448051 | 181.3760049 | 601.3790132 | 590.666465 | |||||||||||||||
15 | 2017-02-01 00:00:00 | 621 | 155.0582874 | 304.8125 | 0.05 | 70 | 0.75 | 192.0816218 | 182.9348779 | 603.312508 | 592.5078886 | |||||||||||||||
16 | 2017-03-01 00:00:00 | 623 | 154.323414 | 305.9021739 | 0.05 | 70 | 0.75 | 192.138856 | 182.9893867 | 603.380116 | 592.5722772 | |||||||||||||||
17 | 2017-04-01 00:00:00 | 627 | 166.0813884 | 305.5527778 | 0.05 | 70 | 0.75 | 201.9789072 | 192.360864 | 615.0037068 | 603.6423637 | |||||||||||||||
18 | 2017-05-01 00:00:00 | 646 | 180.4114197 | 305.0380952 | 0.05 | 70 | 0.75 | 213.878063 | 203.6933933 | 629.0596212 | 617.0289488 | |||||||||||||||
19 | 2017-06-01 00:00:00 | 632 | 189.5973372 | 305.2125 | 0.05 | 70 | 0.75 | 221.8505864 | 211.2862727 | 638.4771891 | 625.998061 | |||||||||||||||
20 | 2017-07-01 00:00:00 | 630 | 202.4576217 | 305.3619048 | 0.05 | 70 | 0.75 | 232.9548993 | 221.8618089 | 651.5941929 | 638.4904457 | |||||||||||||||
21 | 2017-08-01 00:00:00 | 647 | 171.2255022 | 305.1673913 | 0.05 | 70 | 0.75 | 206.1196402 | 196.3044193 | 619.8949604 | 608.3007005 | |||||||||||||||
22 | 2017-09-01 00:00:00 | 627 | 178.5742362 | 305.3868421 | 0.05 | 70 | 0.75 | 212.5516429 | 202.4301361 | 627.4927834 | 615.5367223 | |||||||||||||||
23 | 2017-10-01 00:00:00 | 641 | 175.6347426 | 305.1238095 | 0.05 | 70 | 0.75 | 209.8572236 | 199.8640224 | 624.3099923 | 612.5054927 | |||||||||||||||
24 | 2017-11-01 00:00:00 | 649 | 179.6765463 | 305.4045455 | 0.05 | 70 | 0.75 | 213.506586 | 203.3396057 | 628.6208129 | 616.6110361 | |||||||||||||||
25 | 2017-12-01 00:00:00 | 639 | 184.0857867 | 305.8138889 | 0.05 | 70 | 0.75 | 217.5682951 | 207.2079001 | 633.4187193 | 621.1804708 | |||||||||||||||
26 | 2018-01-01 00:00:00 | 655 | 192.1693941 | 305.2772727 | 0.05 | 70 | 0.75 | 224.0962013 | 213.4249537 | 641.1298287 | 628.5243845 | |||||||||||||||
27 | 2018-02-01 00:00:00 | 646 | 192.1693941 | 305.395 | 0.05 | 70 | 0.75 | 224.1826219 | 213.507259 | 641.2319132 | 628.6216078 | |||||||||||||||
28 | 2018-03-01 00:00:00 | 658 | 192.1693941 | 305.2404762 | 0.05 | 70 | 0.75 | 224.06919 | 213.3992285 | 641.0979214 | 628.4939966 | |||||||||||||||
29 | 2018-04-01 00:00:00 | 650 | 213.8481594 | 305.11 | 0.05 | 70 | 0.75 | 242.4937534 | 230.9464318 | 662.8619936 | 649.2216844 | |||||||||||||||
30 | 2018-05-01 00:00:00 | 660 | 213.8481594 | 305.3261905 | 0.05 | 70 | 0.75 | 242.6655761 | 231.1100725 | 663.0649598 | 649.4149855 | |||||||||||||||
31 | 2018-06-01 00:00:00 | 660 | 219.3597099 | 305.3710526 | 0.05 | 70 | 0.75 | 247.4138218 | 235.6322112 | 668.6738396 | 654.7567758 | |||||||||||||||
32 | 2018-07-01 00:00:00 | 658 | 218.2573998 | 305.3068182 | 0.05 | 70 | 0.75 | 246.4194587 | 234.6851988 | 667.4992452 | 653.6381145 | |||||||||||||||
33 | 2018-08-01 00:00:00 | 661 | 236.6292348 | 305.5571429 | 0.05 | 70 | 0.75 | 262.3397081 | 249.8473411 | 686.3050888 | 671.5484418 | |||||||||||||||
34 | 2018-09-01 00:00:00 | 652 | 212.3784126 | 305.7725 | 0.05 | 70 | 0.75 | 241.7619489 | 230.2494751 | 661.9975473 | 648.3984022 | |||||||||||||||
35 | 2018-10-01 00:00:00 | 657 | 213.4807227 | 305.9954545 | 0.05 | 70 | 0.75 | 242.8826753 | 231.3168336 | 663.3214089 | 649.6592227 | |||||||||||||||
36 | 2018-11-01 00:00:00 | 660 | 203.5599318 | 306.2119048 | 0.05 | 70 | 0.75 | 234.5484618 | 223.3794874 | 653.4765935 | 640.2832081 | |||||||||||||||
37 | 2018-12-01 00:00:00 | 663 | 211.2761025 | 306.4210526 | 0.05 | 70 | 0.75 | 241.3289743 | 229.8371184 | 661.4860948 | 647.9113046 | |||||||||||||||
38 | 2019-01-01 00:00:00 | 665 | 209.8063557 | 306.3454545 | 0.7 | 70 | 0.75 | 388.5855703 | 228.5797473 | 835.4334025 | 646.4260311 | |||||||||||||||
39 | 2019-02-01 00:00:00 | 665 | 218.9922732 | 306.27 | 0.7 | 70 | 0.75 | 401.2438079 | 236.0257694 | 850.3859846 | 655.2216676 | |||||||||||||||
40 | 2019-03-01 00:00:00 | 664 | 205.764552 | 306.4238095 | 0.7 | 70 | 0.75 | 383.0704047 | 225.3355321 | 828.918596 | 642.593792 | |||||||||||||||
41 | 2019-04-01 00:00:00 | 669 | 199.5181281 | 306.4625 | 0.7 | 70 | 0.75 | 374.440637 | 220.2591982 | 818.7246564 | 636.5973569 | |||||||||||||||
42 | 2019-05-01 00:00:00 | 668 | 199.5181281 | 306.45 | 0.7 | 70 | 0.75 | 374.4253643 | 220.2502143 | 818.7066155 | 636.5867446 | |||||||||||||||
43 | 2019-06-01 00:00:00 | 675 | 206.1319887 | 306.4470588 | 0.7 | 70 | 0.75 | 383.6099222 | 225.6528954 | 829.5559028 | 642.9686783 | |||||||||||||||
44 | 2019-07-01 00:00:00 | 668 | 196.2111978 | 306.4369565 | 0.7 | 70 | 0.75 | 369.8155032 | 217.5385313 | 813.2612029 | 633.3835607 | |||||||||||||||
45 | 2019-08-01 00:00:00 | 663 | 181.1462931 | 306.4325 | 0.7 | 70 | 0.75 | 348.882552 | 205.2250306 | 788.5340897 | 618.8382 | |||||||||||||||
46 | 2019-09-01 00:00:00 | 664 | 189.5973372 | 306.4175 | 0.7 | 70 | 0.75 | 360.6047574 | 212.1204455 | 802.380981 | 626.9834302 | |||||||||||||||
47 | 2019-10-01 00:00:00 | 675 | 199.5181281 | 306.4619048 | 0.7 | 70 | 0.75 | 374.4399097 | 220.2587704 | 818.7237973 | 636.5968515 | |||||||||||||||
48 | 2019-11-01 00:00:00 | 673 | 203.1924951 | 306.4475 | 0.7 | 70 | 0.75 | 379.5268457 | 223.2510857 | 824.7327561 | 640.1315332 | |||||||||||||||
49 | 2019-12-01 00:00:00 | 676 | 210.9086658 | 306.45 | 0.7 | 70 | 0.75 | 390.2495549 | 229.5585617 | 837.3989894 | 647.5822586 | |||||||||||||||
50 | 2020-01-01 00:00:00 | 673 | 224.5038237 | 306.4595238 | 0.7 | 70 | 0.75 | 409.1492071 | 240.6760042 | 859.7242618 | 660.7147718 | |||||||||||||||
51 | 2020-02-01 00:00:00 | 668 | 215.3179062 | 306.455 | 0.7 | 70 | 0.75 | 396.3815152 | 233.1655972 | 844.6423864 | 651.8430804 | |||||||||||||||
52 | 2020-03-01 00:00:00 | 674 | 209.0714823 | 327.0619048 | 0.7 | 70 | 0.75 | 413.7738826 | 243.3964015 | 865.1871739 | 663.9282496 | |||||||||||||||
53 | 2020-04-01 00:00:00 | 693 | 218.9922732 | 360.5 | 0.7 | 70 | 0.75 | 472.290439 | 277.8179053 | 934.3100365 | 704.5887569 | |||||||||||||||
54 | 2020-05-01 00:00:00 | 698 | 205.764552 | 360.5 | 0.7 | 70 | 0.75 | 450.6728152 | 265.101656 | 908.7741517 | 689.5676483 | |||||||||||||||
55 | 2020-06-01 00:00:00 | 707 | 198.415818 | 360.5 | 0.7 | 70 | 0.75 | 438.6630242 | 258.037073 | 894.5875491 | 681.2225879 | |||||||||||||||
56 | 2020-07-01 00:00:00 | 713 | 222.13 | 360.5 | 0.7 | 70 | 0.75 | 477.4183213 | 280.8343067 | 940.3673633 | 708.1518903 | |||||||||||||||
57 | 2020-08-01 00:00:00 | 718 | 223 | 376.7857143 | 0.7 | 70 | 0.75 | 500.4719048 | 294.3952381 | 967.5994797 | 724.1707824 | |||||||||||||||
58 | 2020-09-01 00:00:00 | 730 | 247.68 | 379.5 | 0.7 | 70 | 0.75 | 546.536672 | 321.49216 | 1022.013628 | 756.1791048 | |||||||||||||||
59 | 2020-10-01 00:00:00 | 741 | 272.36 | 379.5526316 | 0.7 | 70 | 0.75 | 589.0778299 | 346.5163705 | 1072.265502 | 785.7390306 | |||||||||||||||
60 | 2020-11-01 00:00:00 | 750 | 273 | 379.5 | 0.7 | 70 | 0.75 | 590.0972 | 347.116 | 1073.469636 | 786.4473448 | |||||||||||||||
61 | 2020-12-01 00:00:00 | 750 | 268.55 | 379.5 | 0.7 | 70 | 0.75 | 582.44142 | 342.6126 | 1064.426222 | 781.1276897 | |||||||||||||||
62 | 2021-01-01 00:00:00 | 758 | 289.3 | 379.5 | 0.05 | 70 | 0.75 | 381.79218 | 363.6116 | 827.4086892 | 805.9328231 | |||||||||||||||
63 | 2021-02-01 00:00:00 | 759 | 289.4 | 379.5 | 0.05 | 70 | 0.75 | 381.89844 | 363.7128 | 827.5342092 | 806.0523659 | |||||||||||||||
64 | 2021-03-01 00:00:00 | 766 | 273.13 | 379.5 | 0.05 | 70 | 0.75 | 364.609938 | 347.24756 | 807.1121129 | 786.6027504 | |||||||||||||||
65 | 2021-04-01 00:00:00 | 771 | 280.95 | 379.5 | 0.05 | 70 | 0.75 | 372.91947 | 355.1614 | 816.9277732 | 795.9509983 | |||||||||||||||
66 | 2021-05-01 00:00:00 | 786 | 297.25 | 397.1458333 | 0.05 | 70 | 0.75 | 408.3850604 | 388.9381528 | 858.8216111 | 835.8498916 | |||||||||||||||
67 | 2021-06-01 00:00:00 | 804 | 285.55 | 409.6647619 | 0.05 | 70 | 0.75 | 407.8376571 | 388.4168163 | 858.1749893 | 835.2340612 | |||||||||||||||
68 | 2021-07-01 00:00:00 | 831 | 294.27 | 409.6326316 | 0.05 | 70 | 0.75 | 417.8072604 | 397.9116765 | 869.9516139 | 846.4498942 | |||||||||||||||
69 | 2021-08-01 00:00:00 | 870 | 324.52 | 409.6531818 | 0.05 | 70 | 0.75 | 452.5258452 | 430.9769954 | 910.9630492 | 885.508404 | |||||||||||||||
70 | 2021-09-01 00:00:00 | 911.88 | 337.55 | 410.0168182 | 0.05 | 70 | 0.75 | 467.8865919 | 445.606278 | 929.1079785 | 902.7892891 | |||||||||||||||
71 | 2021-10-01 00:00:00 | 912.72 | 354.67 | 410.4126316 | 0.05 | 70 | 0.75 | 488.0118103 | 464.7731527 | 952.8809547 | 925.4302188 | |||||||||||||||
72 | 2021-11-01 00:00:00 | 950.6 | 379.45 | 410.8054545 | 0.05 | 70 | 0.75 | 516.9822323 | 492.3640308 | 987.102355 | 958.0220286 | |||||||||||||||
73 | 2021-12-01 00:00:00 | 967.46 | 376.81 | 411.1328571 | 0.05 | 70 | 0.75 | 514.3551613 | 489.8620584 | 983.9991193 | 955.066566 | |||||||||||||||
74 | 2022-01-01 00:00:00 | 974.87 | 374.24 | 414.535 | 0.05 | 70 | 0.75 | 515.6284795 | 491.0747424 | 985.5032303 | 956.4990527 | |||||||||||||||
75 | 2022-02-01 00:00:00 | 1021.66 | 390.5 | 416.149 | 0.05 | 70 | 0.75 | 536.5825206 | 511.030972 | 1010.255256 | 980.0724104 | |||||||||||||||
76 | 2022-03-01 00:00:00 | 1042.82 | 486.3 | 415.8273913 | 0.05 | 70 | 0.75 | 647.7093778 | 616.8660741 | 1141.524198 | 1105.090451 | |||||||||||||||
77 | 2022-04-01 00:00:00 | 1047.74 | 495.28 | 415.4015789 | 0.05 | 70 | 0.75 | 657.4909727 | 626.1818788 | 1153.078737 | 1116.094774 | |||||||||||||||
78 | 2022-05-01 00:00:00 | 1075.3 | 522.29 | 415.075165 | 0.05 | 70 | 0.75 | 688.3656345 | 655.5863186 | 1189.549527 | 1150.828859 | |||||||||||||||
79 | 2022-06-01 00:00:00 | 1092.92 | 459.59 | 415.0247619 | 0.05 | 70 | 0.75 | 615.4202982 | 586.1145698 | 1103.382624 | 1068.765142 | |||||||||||||||
80 | 2022-07-01 00:00:00 | 1065.91 | 382.5 | 415.1052632 | 0.05 | 70 | 0.75 | 525.9383684 | 500.8936842 | 997.6818184 | 968.097708 | |||||||||||||||
81 | 2022-08-01 00:00:00 | 1106.76 | 382.86 | 419.9727273 | 0.05 | 70 | 0.75 | 532.528778 | 507.1702647 | 1005.46676 | 975.511938 | |||||||||||||||
82 | 2022-09-01 00:00:00 | 1121.28 | 419.14 | 428.7495238 | 0.05 | 70 | 0.75 | 587.2119178 | 559.2494455 | 1070.061387 | 1037.030631 | |||||||||||||||
83 | 2022-10-01 00:00:00 | 1144.47 | 437.95 | 436.1155556 | 0.05 | 70 | 0.75 | 620.26971 | 590.7330572 | 1109.111006 | 1074.220744 | |||||||||||||||
84 | 2022-11-01 00:00:00 | 1189.74 | 422.68 | 441.8792727 | 0.05 | 70 | 0.75 | 609.5742242 | 580.5468802 | 1096.476931 | 1062.188291 | |||||||||||||||
85 | 2022-12-01 00:00:00 | 1203.88 | 386.33 | 445.9705 | 0.05 | 70 | 0.75 | 569.8272111 | 542.692582 | 1049.525649 | 1017.472785 | |||||||||||||||
86 | 2023-01-01 00:00:00 | 1236.31 | 380.36 | 454.9704762 | 0.7 | 70 | 0.75 | 928.8822832 | 546.4013431 | 1473.660559 | 1021.85377 | |||||||||||||||
87 | 2023-02-01 00:00:00 | 1247.42 | 394.75 | 460.426 | 0.7 | 70 | 0.75 | 970.0561919 | 570.6212893 | 1522.297365 | 1050.463656 | |||||||||||||||
88 | 2023-03-01 00:00:00 | 1275.23 | 369.86 | 460.4313636 | 0.7 | 70 | 0.75 | 918.1148729 | 540.0675723 | 1460.941522 | 1014.371984 | |||||||||||||||
89 | 2023-04-01 00:00:00 | 1295.17 | 378.18 | 460.4175 | 0.7 | 70 | 0.75 | 935.4529487 | 550.2664404 | 1481.422178 | 1026.419428 | |||||||||||||||
90 | 2023-05-01 00:00:00 | 1315.31 | 367.74 | 460.702381 | 0.7 | 70 | 0.75 | 914.2276331 | 537.7809606 | 1456.349708 | 1011.670917 | |||||||||||||||
91 | 2023-06-01 00:00:00 | 1380.45 | 345.5 | 607.7488889 | 0.7 | 70 | 0.75 | 1144.755807 | 673.3857689 | 1728.661824 | 1171.854514 | |||||||||||||||
92 | 2023-07-01 00:00:00 | 1419.14 | 345.5 | 769.8165238 | 0.7 | 70 | 0.75 | 1450.026404 | 852.9567084 | 2089.263657 | 1383.97324 | |||||||||||||||
93 | 2023-08-01 00:00:00 | 1487.88 | 315.82 | 761.6203478 | 0.7 | 70 | 0.75 | 1332.112577 | 783.5956336 | 1949.977586 | 1302.040257 | |||||||||||||||
94 | 2023-09-01 00:00:00 | 1515.88 | 314.68 | 761.3271579 | 0.7 | 70 | 0.75 | 1327.665234 | 780.9795496 | 1944.724148 | 1298.949999 | |||||||||||||||
95 | 2023-10-01 00:00:00 | 1727.28 | 298.1 | 796.438 | 0.7 | 70 | 0.75 | 1329.032019 | 781.7835408 | 1946.338668 | 1299.899716 | |||||||||||||||
96 | 2023-11-01 00:00:00 | 1884.62 | 283.55 | 832.6758095 | 0.7 | 70 | 0.75 | 1334.57948 | 785.0467532 | 1952.891623 | 1303.754396 | |||||||||||||||
97 | 2023-12-01 00:00:00 | 1976.59 | 291.12 | 898.8976316 | 0.7 | 70 | 0.75 | 1471.564938 | 865.6264339 | 2114.706116 | 1398.939392 | |||||||||||||||
98 | 2024-01-01 00:00:00 | 2042.98 | 283.91 | 941.2560227 | 0.7 | 70 | 0.75 | 1510.143633 | 888.319784 | 2160.277319 | 1425.745982 | |||||||||||||||
99 | 2024-02-01 00:00:00 | 2277.59 | 278.5 | 1504.820524 | 0.7 | 70 | 0.75 | 2377.415785 | 1398.479873 | 3184.74522 | 2028.374159 | |||||||||||||||
100 | 2024-03-01 00:00:00 | 2477.63 | 274.83 | 1510.8432 | 0.7 | 70 | 0.75 | 2361.794408 | 1389.290828 | 3166.292421 | 2017.519571 |