| Raw Material Inventory | Date : | | | 31-Jul-20 | | JN1 | JN2 | JN3 | JN4 | JN5 | JN6 | JN7 | JN8 | JN9 | JN10 | JN11 | JN12 | JN13 | JN14 | JN15 | JN16 | JN17 | JN18 | JN19 | JN20 | JN21 | JN22 | JN23 | JN24 | Unresolved Check count (ok if green) | 0 | | | | | | | | | | | | |
No. | Description | Type | SIZE | Loc. | Qty. | Calc Count (Verify Only) | Count | 5241 | 5244 | 52827 | 53067 | 53152 | 53196 | 53199 | 53202 | 53212 | 53216 | 53238 | 53240 | 53245 | 53249 | 53269 | 53270 | 53275 | 53276 | 53286 | 53287 | 53288 | 53293 | 53296 | 53297 | Used At Saw/Job | Status | Weight (#) Each | Total Weight | Value Each* | Price Per Pound | Total | Invoice number | Invoice Date | Exchange Rate | Total | qty ordered | product usage |
-2 | 14" x 6" x 3/8" | ASTM A500 Gr B Tube | 20'(check 185-5/8" next) | 1B | 18 | 18 | 18 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 958.00 | 17,244.0 | $708.80 | $0.7399 | $12,758.40 | 829THI-1(27184)817THI-8(27003)817THI-7(26981)817THI-5(26816) | multi | 31.48966538 | ฿401,757.75 | 1 | E28502 |
-1 | 14" x 6" x 1/4" (multi) | ASTM A500 (Q345) Tube | 17'-22' | 1B, 2B, 14D,15D,16D | 113.7 | 112 | 112 | | | 0.7 | | | | | | | | | | | | | | | | | | | | | 1 | 1.7 | OK | 811.48 | 90,886.2 | $242.43 | $0.2988 | $27,152.43 | #REF! | multi | 31.40662448 | ฿852,766.04 | 15 | E175,E176,E240,E259,E262,E28502 |
0 | 12" x 8" x 3/8" | ASTM A500 Gr B Tube | 20' | 2D | 1.3 | 1.3 | 1.3 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 958.00 | 1245.4 | $1,576.75 | $1.6459 | $2,049.78 | 571 | 11-May-11 | 29.922 | ฿61,333.37 | | |
1 | 12" x 8" x 1/4" | ASTM A500 Gr B Tube | 20' | 2C | 2.5 | 2.5 | 2.5 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 652.60 | 1631.5 | $217.62 | $0.3335 | $544.06 | 778THI | 10-Apr-18 | 31.0702 | ฿16,903.90 | | AM-2718 |
2 | 12" x 6" x 3/8" (multi) | ASTM A500 Gr B Tube | 18' to 20' | 14A,14B | 40 | 40 | 40 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 788.19 | 31,527.7 | $341.17 | $0.4329 | $13,646.89 | multi | multi | 31.25812643 | ฿426,576.36 | 32 | E175, E281,E20801 |
3 | 12" x 6" x 1/4" (6mm)(MAL) | ASTM A500 Gr B Tube | 20' | 12D,13C,D | 47 | 45 | 45 | | | | | | | | | | | | | | | | | | 2 | | | | | | | 2 | OK | 584.60 | 26,307.0 | $223.53 | $0.3824 | $10,058.91 | multi | multi | 30.56196495 | ฿307,420.02 | 22 | 956A7644,102716,E082,E240,E248,E259,E262,E272,E277,AM-2228,AM-2811 |
4 | 12" x 4" x 1/2" | ASTM A500 Gr B Tube | 20' | 3D | 2.5 | 2.5 | 2.5 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 977.00 | 2,442.5 | $723.00 | $0.7400 | $1,807.50 | 817THI-4(26816) | 31-Jan-19 | 31.0788 | ฿56,174.93 | | E28175 |
5 | 12" x 4" x 3/8" (multi) | ASTM A500 (Q345) Tube | 14' to 24.5' | 10C,11C | 52 | 52 | 52 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 742.49 | 38,609.6 | $308.54 | $0.4155 | $16,043.92 | multi | multi | 31.3558942 | ฿503,071.59 | 36 | AM-1802,??AM-2563??,AM-2811,??E237??,E248,E281,E285 |
6 | 12" x 4" x 1/4"(6mm Tianjin) | ASTM A500 (Q345) Tube | 16'-20' | 2A,10D,11D | 77 | 71 | 71 | | | | | | | | | | | | | | | | 3 | | | 3 | | | | | | 6 | OK | 464.76 | 32,998.0 | $203.62 | $0.4381 | $14,457.06 | multi | multi | 31.99415938 | ฿462,541.57 | 62 | AM-1802,AM-2563,E18602,E237,E248 |
7 | 12" x 3" x 1/4" | ASTM A500 Gr B Tube | 80-5/8" | 2A, 4B | 17 | 17 | 17 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 162.04 | 2,754.7 | $207.00 | $1.2774 | $3,519.01 | multi | multi | 31.85039038 | ฿112,081.87 | 8 | E17502-7/-9 |
8 | 12" x 2" x 1/4" | ASTM A500 Gr B Tube | 20' | 5C | 0.6 | 0.6 | 0.6 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 448.40 | 269.0 | $299.29 | $0.6675 | $179.57 | multi | multi | 31.10105463 | ฿5,584.86 | 2 | E107,E281 |
9 | 10" x 10" x 3/8" | ASTM A500 Gr B Tube | 20' | 1C | 4.8 | 4.8 | 4.8 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 958.00 | 4,598.4 | $621.12 | $0.6483 | $2,981.37 | multi | multi | $30.50 | ฿90,929.70 | 5 | 956A7644 (80" per cradle/set) |
10 | 10" x 6" x 1/2" | ASTM A500 Gr B Tube | 18' | 2C | 1 | 1 | 1 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 879.30 | 879.3 | $306.95 | $0.3491 | $306.95 | 700THI | 19-Sep-16 | 34.7028 | ฿10,652.02 | | |
11 | 10" x 6" x 1/4" | ASTM A500 Gr B Tube | 20'(check 141") | 2C | 1 | 1 | 1 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 516.40 | 516.4 | $246.64 | $0.4776 | $246.64 | 854THI(28190) | 10-Oct-19 | 30.1362 | ฿7,432.79 | | 9C6001(9426M22), E13301 |
12 | 10" x 4" x 1/2" | ASTM A500 Gr B Tube | 124-5/8" | 3C | 8 | 8 | 8 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 436.71 | 3,493.7 | $254.13 | $0.5819 | $2,033.05 | 733THI | 23-Jun-17 | 33.8158 | ฿68,749.14 | | E203 |
13 | 10" x 4" x 1/4"(6mm Tianjin) | ASTM A500 (Q345) Tube | 16'-20' | 7C,7D | 55 | 50 | 50 | | | | | | | | | | | | | | | | 1 | | | 2 | | 2 | | | | 5 | OK | 403.56 | 20,178.0 | $160.52 | $0.3978 | $8,025.89 | multi | multi | 32.23248104 | ฿258,694.31 | 68 | AM-1928,AM-2701,E166,E169,E175,E18602,E248 |
14 | 10" x 4" x 3/16" | ASTM A500 Gr B Tube | 20' | 3C | 6 | 6 | 6 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 341.60 | 2,049.6 | $253.40 | $0.7418 | $1,520.40 | 813THI(26623) | 27-Dec-18 | 32.4077 | ฿49,272.67 | | E241 |
15 | 10" x 3" x 1/4" | ASTM A500 Gr B Tube | 20' | | 0.5 | 0 | 0 | | | | | | | | | | | | | | | | | | | | | | | | 0.5 | 0.5 | OK | 414.40 | 0.0 | $445.80 | $1.0758 | $0.00 | 780THI-3 | 4-May-18 | 31.4696 | ฿0.00 | | 9C6001(9426M23) |
16 | 10" x 2" x 3/16" | ASTM A500 Gr B Tube | 20' | | 0 | 0 | 0 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 290.60 | 0.0 | $252.00 | $0.8672 | $0.00 | 796THI-3(26020) | 29-Aug-18 | 32.5065 | ฿0.00 | | AM-1802-300 |
17 | 9" x 5" x 1/2" | ASTM A500 Gr B Tube | 20' | 4C | 25 | 25 | 25 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 841.00 | 21,025.0 | $574.69 | $0.6833 | $14,367.25 | 705-1 THI | 14-Dec-16 | 35.402 | ฿508,629.38 | | 956A7644P154/P155 |
18 | 8" x 8" x 3/8" | ASTM A500 Gr B Tube | 20' | 2B | 2 | 2 | 2 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 753.80 | 1,507.6 | $489.20 | $0.6490 | $978.40 | 817THI-6(26920) | 21-Feb-19 | 30.9701 | ฿30,301.15 | 6 | E28502 |
19 | 8" x 8" x 1/4" | ASTM A500 Gr B Tube | 23' | 2D | 1 | 1 | 1 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 593.00 | 593.0 | $0.00 | $0.3500 | $0.00 | 700THI | 19-Sep-16 | 34.7028 | ฿0.00 | | Found 1 in August count |
20 | 8" x 6" x 1/2" | ASTM A500 Gr B Tube | 20' | 4C | 3 | 3 | 3 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 841.00 | 2,523.0 | $538.20 | $0.6400 | $1,614.60 | 586 | 23-Apr-12 | 30.7959 | ฿49,723.06 | | E20803 |
21 | 8" x 6" x 3/8" | ASTM A500 (Q345) Tube | 18' to 20' | 3B | 7.3 | 7.3 | 7.3 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 641.83 | 4,685.3 | $270.89 | $0.4221 | $1,977.48 | multi | multi | 31.48569301 | ฿62,262.33 | 6 | AM-2811, S/B 18.5' per order |
22 | 8" x 6" x 5/16" | ASTM A500 Gr B Tube | 16' to 19' | 2B, 3B | 10 | 10 | 10 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 482.83 | 4,828.3 | $237.18 | $0.4912 | $2,371.84 | 860THI(28590) | 23-Dec-19 | 31.41597276 | ฿74,513.69 | 8 | E107,E202 |
23 | 8" x 6" x 1/4" | ASTM A500 Gr B Tube | 20' | 3B | 25 | 25 | 25 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 448.40 | 11,210.0 | $239.53 | $0.5342 | $5,988.24 | 778THI | 10-Apr-18 | 31.10603517 | ฿186,270.26 | | AM-1928,AM-2228,AM-2718 |
24 | 8" x 4" x 1/2" | ASTM A500 Gr B Tube | 20' | 4B | 13.5 | 13.5 | 13.5 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 704.80 | 9,514.8 | $422.19 | $0.5990 | $5,699.63 | 829THI-1(27184)817THI-8(27003)817THI-7(26981)817THI-4(26816) | multi | 31.39787106 | ฿178,956.27 | 1 | E184,E21509,E28514 |
25 | 8" x 4" x 3/8" | ASTM A500 Gr B Tube | 20' | 4B | 18 | 18 | 18 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 549.60 | 9,892.8 | $356.60 | $0.6488 | $6,418.80 | 829THI-1(27184) | multi | 31.59545909 | ฿202,804.93 | 2 | E281,E28514 |
26 | 8" x 4" x 1/4" (6mm)(MAL) | ASTM A500 Gr B Tube | 6.1m(20') | 14C,15C | 146 | 144 | 144 | | | | | | | | | | | | | | | | | | 2 | | | | | | | 2 | OK | 380.40 | 54,777.6 | $143.94 | $0.3784 | $20,726.77 | PO 1912-080 | multi transfers | 32.32231396 | ฿669,937.17 | 123 | 986A7644,AM-2563,E107,E240,E259,E260,E262,E272,E277,E285 |
27 | 8" x 4" x 3/16" | ASTM A500 Gr B Tube | 20' | 4D | 3 | 3 | 3 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 290.60 | 871.8 | $187.53 | $0.6453 | $562.60 | 805THI-2(26414)618A pg 1 | multi | 32.41941792 | ฿18,239.16 | | E241 |
28 | 8" x 3" x 1/2" | ASTM A500 Gr B Tube | 14' | | 0 | 0 | 0 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 445.76 | 0.0 | $534.80 | $1.1997 | $0.00 | 810THI-1(26604) | 20-Dec-18 | 32.5871 | ฿0.00 | | AM-2067M-401/-402 |
29 | 8" x 3" x 1/4" (TianJin) | Q345B-ASTM A500 Gr B/C Tube | 5.98m(19.6') | 8B, 13B | 52 | 47 | 47 | | | | | | | | | | | | | | | | 2.5 | | | | | 2.5 | | | | 5 | OK | 346.40 | 16,280.8 | $116.77 | $0.3371 | $5,488.18 | Bank transfer | 11-Oct-19 | 30.31104116 | ฿166,352.45 | 30 | AM-2228,AM-2472,AM-2563,E169,E186,E237 |
30 | 8" x 3" x 3/16" | ASTM A500 Gr B Tube | 20' | 4D | 7 | 7 | 7 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 265.00 | 1,855.0 | $192.00 | $0.7245 | $1,344.00 | 581A | 30-Jan-12 | 30.9059 | ฿41,537.53 | | |
31 | 8" x 2" x 1/4" | ASTM A500 Gr B Tube | 18' to 20' | 5C | 1.5 | 1.5 | 1.5 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 312.40 | 468.6 | $177.71 | $0.5689 | $266.56 | multi | multi | 30.82883769 | ฿8,217.85 | | E184,E215 |
32 | 8" x 2" x 3/16" | ASTM A500 Gr B Tube | 20' | | 0 | 0 | 0 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 239.40 | 0.0 | $155.80 | $0.6508 | $0.00 | 817THI-8(27003) | 14-Mar-19 | 31.4869 | ฿0.00 | 5 | AM-2718 (8x2x1/4 ok) |
33 | 7" x 5" x 3/8" | ASTM A500 Gr B Tube | 12' | 2A | 1 | 1 | 1 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 329.76 | 329.8 | $165.00 | $0.5004 | $165.00 | 861THI(28716) | 16-Jan-20 | 30.1091 | ฿4,968.00 | | |
34 | 7" x 5" x 1/4" | ASTM A500 Gr B Tube | 20' | 2C | 4.7 | 4.7 | 4.7 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 380.40 | 1,787.9 | $210.89 | $0.5544 | $991.21 | 708THI612A pg 1 | multi | 33.28952763 | ฿32,996.75 | | |
35 | 7" x 4" x 3/8" (China) | ASTM A500 (Q345) Tube | 18' to 20' | 11A | 65 | 65 | 65 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 473.67 | 30,788.6 | $203.42 | $0.4295 | $13,222.24 | multi | multi | 30.70481903 | ฿405,986.56 | 54 | 956A7644,E175 |
36 | 7" x 4" x 1/4" (Tianjin) | ASTM A500 (Q345) Tube | 18' to 20' | 9C | 43 | 35 | 35 | | | | | | | | | | | | | 1.5 | | | | | | | | | | | 6.5 | 8 | OK | 346.40 | 12,124.0 | $129.36 | $0.3734 | $4,527.60 | multi | multi | 30.50883454 | ฿138,131.80 | 75 | 9426M23, E108, E175 |
37 | 7" x 3" x 1/4" | ASTM A500 Gr B Tube | 22' | 5B | 4.3 | 4.3 | 4.3 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 343.64 | 1,477.7 | $256.78 | $0.7472 | $1,104.17 | 861THI(28716) | 16-Jan-20 | 30.09069658 | ฿33,225.25 | 2 | 956A7644P02 (84" long per base) |
38 | 6" x 6" x 1/2" | ASTM A500 Gr B Tube | 20' (check 148") | 2A | 0.8 | 0.8 | 0.8 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 704.80 | 563.8 | $0.00 | $0.0000 | $0.00 | N/A | N/A | 34.95 | ฿0.00 | | found in 2019 pre-audit count |
39 | 6" x 6" x 3/8" | ASTM A500 (Q345) Tube | 18' to 20' | 7B | 80 | 80 | 80 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 548.20 | 43,856.0 | $210.31 | $0.3836 | $16,824.59 | multi | multi | 30.40086457 | ฿511,482.16 | 100 | 956A1618,956A7644,102716,E13201,E281,E285 |
40 | 6" x 6" x 1/4" | ASTM A500 Gr B Tube | 20' | 9B | 0 | 0 | 0 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 380.40 | 0.0 | $204.20 | $0.5368 | $0.00 | 772THI | 16-Mar-18 | 31.0549 | ฿0.00 | | AM-2700,AM-2774-701,E082,E132,E166,E18401,E18424,E215,9C6001 |
41 | 6" x 4" x 1/2" (Tianjin) | ASTM A500 (Q345) Tube | 6.0m(19.7') | 11B | 94.5 | 94.5 | 94.5 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 560.07 | 52,926.7 | $215.98 | $0.3856 | $20,410.23 | multi | multi | 30.94947633 | ฿631,685.92 | 46 | E108,E079,E082,E175,E176,E28514 |
42 | 6" x 4" x 3/8" (Tianjin) | ASTM A500 (Q345) Tube | 18' to 20' | 5C,6C,6D | 95 | 90 | 90 | | | | | | | | | | | 5 | | | | | | | | | | | | | | 5 | OK | 425.03 | 38,252.7 | $178.82 | $0.4207 | $16,094.01 | PO 2002-131 (partial 2) | multi | 32.42987826 | ฿521,926.69 | 126 | 956A7644,102716,E082,E20801,E240,E248,E259,E262,E272,E277,AM-2228,AM-2811 |
43 | 6" x 4" x 1/4" | ASTM A500 Gr B Tube | 18' to 20' | 13A,13B | 113.5 | 96 | 96 | | | | | | | | | | | 6 | | 1 | 6 | | | | 1 | | | | | | 3.5 | 17.5 | OK | 296.78 | 28,490.9 | $118.36 | $0.3988 | $11,362.23 | multi | multi | 31.57680456 | ฿358,782.96 | 162 | AM-1928,AM-237108,E082,E108,E132,E175,E176,E203,E240,E241,E259,E262,E272 |
44 | 6" x 4" x 3/16" | ASTM A500 Gr B Tube | 20' | 2A | 12 | 11.5 | 11.5 | | 0.5 | | | | | | | | | | | | | | | | | | | | | | | 0.5 | OK | 239.40 | 2,753.1 | $144.61 | $0.6040 | $1,662.97 | multi | multi | 32.04319235 | ฿53,286.85 | | E241, E27604 |
45 | 6" x 3" x 3/8" (Jiade) | ASTM A500 (Q345) Tube | 18' to 20' | 5B | 14 | 14 | 14 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 376.58 | 5,272.1 | $177.33 | $0.4709 | $2,482.56 | PO 2003-007 | multi | 32.13386172 | ฿79,774.14 | 16 | 102716,E203,E20801,E237,E281 |
46 | 6" x 3" x 1/4"(Tianjin) | ASTM A500 (Q345) Tube | 18' to 20' | 8B,8C | 144 | 138 | 138 | | | | | | | | | | | | | | | | 3 | | 3 | | | | | | | 6 | OK | 264.29 | 36,472.0 | $104.79 | $0.3965 | $14,460.44 | PO 20-01-059 | multi | 32.29908402 | ฿467,059.09 | 56 | 956A7644,AM-1802,AM-1928,AM-2811,AM-2701,E108,E166,E18607,E17502 |
47 | 6" x 3" x 3/16" | ASTM A500 Gr B Tube | 20' | 5B | 41 | 41 | 41 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 214.00 | 8,774.0 | $103.65 | $0.4843 | $4,249.56 | multi | multi | 35.08308453 | ฿149,087.64 | | E24830 |
48 | 6" x 2" x 3/8" (Tianjin) | ASTM A500 (Q345) Tube | 18' to 20' | 16A | 19 | 19 | 19 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 328.13 | 6,234.5 | $147.73 | $0.4502 | $2,806.85 | PO 2002-131 (partial 1) | multi | 32.48616415 | ฿91,183.93 | 36 | AM-2811 |
49 | 6" x 2" x 1/4" (Tianjin) | ASTM A500 (Q345) Tube | 18' to 20' | 8C | 47 | 42 | 42 | | | | | | | | 4.5 | | | | | | | | | 0.5 | | | | | | | | 5 | OK | 231.99 | 9,743.6 | $95.11 | $0.4100 | $3,994.61 | PO 2002-131 (partial 1) | multi | 32.48616415 | ฿129,769.64 | 58 | AM-1802 ok,AM-2228,AM-2718 ok,C052,C069,E132,E20801,L03405 |
50 | 6" x 2" x 3/16" | ASTM A500 Gr B Tube | 20' | 5D | 3 | 3 | 3 | | | | | | | | | | | | | | | | | | | | | | | | | 0 | OK | 188.40 | 565.2 | $94.00 | $0.4989 | $282.00 | 861THI(28716) | 16-Jan-20 | 30.1091 | ฿8,490.77 | | AM-1802,AM-2718 (6x2x/14 ok) |