Loading...
HomeMy WebLinkAboutNC0020761_Pretreatment_Annual_Report_20240227February 27, 2024 Subject: Pretreatment Annual Report (January — December 2023) Pretreatment Staff, The purpose of this letter is to report to you the conditions of our pretreatment program for the January - December 2023 monitoring period. SIU's (Significant Industrial User's) 'rhe town currently has two SIU Gardner Glass Products (Permit # 0001) and Johnston Casuals (Permit # 0002). Gardner Glass Products tested a total of 53 times with no violations and Johnston Casuals was tested 2 times with no violations. Neither SIU is in SNC for this reporting period. There have been no changes in either SIU treatment process. Johnston Casuals permit went into effect on October 1, 2020 and will expire September 30, 2025. Gardner Glass Products permit went into effect on October 1, 2022 and will expire on September 30, 2027. If you should have any questions about this PAR please feel free to contact me at (336) 838-5001. Wastewater2(�northwi l kesboronc. gov Justin S 1 retreatment Coordinator Town ofNorth Wilkesboro PRETREATMENT ANNUAL REPORT POTW Name: Gardner Glass Products (SIU's Permit # 0001) POWT Name: Johnston Casuals (SIU's Permit # 0002) Report Date: February 27 2024 Period Covered by This Report: from January through December 2023 Name of Wastewater Treatment Plant NPDES Permit # Thurman Street Wastewater Treatment Plant NCO020761 Person to contact concerning information contained in this report: Name: Justin Shell Title: Pretreatment Coordinator Mailing Address: P.O. Box 218 North Wilkesboro, NC 28659 Telephone #: (336) 838-5001 Email Address: wastewater2@northwilkesboronc.gov Pretreatment Program Info Database printed on: 12/22/2023 for Program Name North Wilkesboro WWTP Name Town of North Wilkesboro Program Approval Date 07/01/1985 Pretreatment Status Modified Region WSRO County Wilkes NPDE N S umber N00020761 Last PAR Rec 02115/2022 PAR Due Date03/01/2023 mercury NPDES Effective Date 07/01/2021 1631 NPDES Expire Date 06/3012026 Current Fiscal 06/1�2 required Year PCI Done as�26 POTW is Primary WWTP TRUE Last Audit on Audit Year Next Design Flow mgd 2.0000 % Design mgd is SIU permitted 4.23 Permitted SIU flow (mgd) [Pt SIU) •0845 WWTP SIU's Program SIUs WWTP CIU's Program CiUs HWA LTMP 1WS SUO ERP date Inactive Date Next Due 12/27/2026 07/01/2021 Date Received by DWR 10/01/2021 01/16/2015 09/14/2022 04/11/2012 02/12/2020 Date Approved /0 .07. Zoll 04/06/2015 0 9 - 10 •�Q3 04/30/2012 02/14/2020 Adopt Date Required Date Adopted 03/06/2012 Info in this Box from Pt Contacts PT Pro Formal Name g.Prime Phonel Mr. Wilson 1 leep-m- Ot M%n+an Mr. Scotty Perry Mr. Justin Shell 1Prirr j(336) 667-7129 336)838-5001 336) 838-5001 . ^ 14-0 I I - !!j0,Sj; wa atment Related NOVs from DWQ ext Fax I k336) 838-1779 Town Manager 401 k336) 838-1779 ORC Coordinator Date Date Attended Attended Wksp IUP Wksp Date Attended PAR Wksp IHWA II tt - PO Box 218 1 1 1 /24/2008 PO Box 218 1 /24/2008 PO Box 218 6oronc . so v h- S tiara no ,S ov DWR Central Office Contact Pretreatment Staff DWR Regional Contact 04 e'er Ron / oon l; No SNC Chapter 9, PAR Guidance Pretreatment Performance Summary (PPS) 1. Pretreatment Town Name: Town of North Wilkesboro 2. "Primary" N PD ES Number N C00 20761 or Non -Discharge Permit # if applicable=> 3. PAR Begin Date, pl ease enter 01 /01 /yyyy 3. => 1 /1 /2023 4. PAR End Date, please enter 12/31 /yyyy 4. => 12/31 /2023 5. Total number of SI Us, i ncl udes Cl Us 5. => 2 6. Number of Cl Us 6. => 2 7. Number of SlUswith no lUP, or with an expired lUP 7.=> 0 8. Number of SI Us not inspected by POTW 8. => 0 9. Number of SI Us not sampled by POTW 9. => 0 10. Number of SI Us in SNC dueto I UP Limit violations 10. => 0 11. N umber of SI U s i n SN C due to Reporti ng A of ati ons 11. => 0 12. Number of SI Us in SNC dueto violation of a Compliance Schedule, CO, AO or similar 12. => 0 13. Number of Cl Us in SNC 13. => 0 14. Number of SI Us included in Public Notice 14. => 0 15 Total number of SI Us on a compliance schedule, CO, AO or si mi I ar 15. => 0 16. Number of NOVs, NNCsor similar assesed to SIUs 16. => 0 17. Number of Civil Penalties assessed to SI Us 17. => 0 18. Number of Criminal Penalties assessed to SI Us 18. => 0 19. Total Amount of Civil Penalties Collected 19. => $ 0 20. Number of IUsfromwhich penal ti es col I ected 20. => 0 VoteS: AO Administrative Order IUP Industrial User Pretreatment Permit POTW CIU Categorical Industrial User NNC Noticeof Non -Compliance SIU Publicly Owned Treatment Works Significant Industrial User CO Consent Order NOV Noticeof Violation SNC Significant Non -Compliance IU Industrial User PAR Pretreatment Annual Report revised 1/2018: PAR PPS 2018 Pretreatment Annual Report (PAR) Significant Non -Compliance Report (SNCR) WWTP = Wastewater Treatment Plant, use separate form for each WWTP. SIU = Significant Industrial User SNC = Significant Non -Compliance PAR covers this calendar year => Control Authority=Program=Town Name => WWTP Name => N PD ES # _> A SNCR Form must be submitted with every PAR, please write"None" if you had No SIUs in SNC during calendar year 1 UP # Pipe # I ndustry Name Parameter or "Reporting" SNC ? ( Yes/ No) for each 6-month period. Jan. - June July - Dec. 1 Gardner Glass NA NO NO 2 Johnston Casuals NA NO NO Attach a copy of the Division's "SIUs in SNC H i stori cal Report" for your POTW's SIUs behind this page. Is the database correct? Notify the Division of any errors! Database indicates SNC history for previous years. EVERY SNC MUST be explained in the Narrative, How was, is, or will it be resolved? REPEAT SNCs are serious matters that MUST be explained in the Narrative. Form name. PAR,SNCR,2001 Date Revised: 1 /4/2001 2023 North W i I kesboro Thurman Street N CO020761 Form name: PAR,SNCR,2001 Date Revised: 1/4/2001 Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each industry/pipe Enter BDL values as < (value) Total # of samples => Maximum (mg/1) _> or M axi mum (1 b/d) _> or Average(mg/1) _> or Average Loading (I b/d) _> % viol ations,(chronic SNC is>= 66%) _> % TRC violations, (SNC is>= 33 %) _> Total # of samples => Maximum (mg/1) _> or M axi mum (1 b/d) _> or Average(mg/1) _> or Average Loading (I b/d) _> % violations, (chronic SNC is>= 66%) _> % TRC violations, (SNC is>= 33 %) _> Total # of samples => Maximum (mg/1) _> or Maximum (lb/d) _> or Average (mg/1) _> or Average Loading (I b/d) _> % violations, (chronic SNC is>= 66%) _> %TRC violations, (SNC is>= 33 %) _> Control Authority, Town Name => WWTP Name => N PD ES # _> 1st 6 months, dates => 2nd 6 months, dates => Town of North Wilkesboro Thurman Street N C0020761 6/14/2023 12/20/2023 I industry Name Gardner Glass Products IUP# 1 Pipe # • ram[. i"f'iL•Tiiii�7 � . • ram[. i"f'iL•Tiiii�7 . • ram[. i"f'iL•Tiiii�7 . • ram[. i"f'iL•Tiiii�7 • WI[.^l'if.7iM • WI[.^l'if.7iM • WI[.^l'if.7iM • f�lfi[.^l'if.7ifii�l � 1 11 1 11 • • • a Lftyk-TiTri C « • f�lfi[.'Y'if.7ifiikl � • f�lfi[.'Y'if.7ifiikl � • f�lfi[.'Y'if.7ifiikl � • f�lfi[."l'if.7ifii�l 1- BDL => Below Detection Limit mg/I => milligrams per liter POTW must enter at least one of these IUP=> Industrial User Permit Ib/d => pounds per day fourrows, Rease indicate how averages were calculated SNC => Significant Non -Compliance mgd => million gallons per day Avg period could be month, Qtr, or 6-month & if BDL , 1/2BDL, or zero values used. TRC => Technical Review Criteria WWTP=> wastewater treatment plant Chapter: PAR Guidance File name: PPlEbiii�islde�i'�uJa�teli$tc1iIB, pages 12, 13, 14 Blank IDSF Form, Copy and use in your PAR Number each set for each IUP pipe- Page of Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each industry/pipe Enter BDL values as < (value) Total # of samples => Maximum (mg/1) => or Maximum (I b/d) => or Average(mg/1) => or Average Loading (I b/d) => % violations, (chronic SNC is>= 66%) => %TRC violations, (SNC is>= 33 %) => Total # of samples => Maximum (mg/1) => or Maximum (lb/d) => or Average(mg/1) => or Average Loading (I b/d) => % violations, (chronic SNC is>= 66%) => % TRC violations, (SNC is>= 33 %) => Total # of samples => Maximum (mg/1) => or Maximum (lb/d) => or Average(mg/1) => or Average Loading (I b/d) => % violations, (chronic SNC is>= 66%) => % TRC violations, (SNC is>= 33 %) => Industry Name Johnston Casuals IUP# 2 Pi pe # • I�Y.TifiiT[1Tii • • • • • f�lfi[� � • f�lfi[� • f�lfi[� � • • . • 111.. •• 111.. •• 111 111 111 111 11 11 lCyanicle 1PH WMrtr� WMrtr� WMrtr� WMrt M BDL => Below Detection Limit mg/I => milligrams per liter POTW must enter at least one of these IUP=> Industrial User Permit Ib/d => pounds per day four rows, R ease indicate how averages were calculated SNC => Significant Non -Compliance mgd => mi I I i on gal I ons per day Avg period could be month, Qtr, or 6-month & if BDL , 1/2BDL, or zero values used. TRC => Technical Review Criteria WWTP=> wastewater treatment Chapter: PAR Guidance File name: PPlEbiii�isldJ�ia�teli$tc1iIB, pages 12, 13, 14 Blank IDSF Form, Copy and use in your PAR Number each set for each IUP pipe- Page of Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each industry/pipe Total # of samples => Maximum (mg/1) => or Maximum (I b/d) => or Average(mg/1) => or Average Loading (I b/d) => % violations, (chronic SNC is>= 66%) => % TRC violations, (SNC is>= 33 %) => Total # of samples => Maximum => or Minimum => % violations, (chronic SNC is>= 66%) => % TRC violations, (SNC is>= 33 %) => Total # of samples => Maximum (mg/1) => or Maximum (lb/d) => or Average(mg/1) => or Average Loading (I b/d) => % violations, (chronic SNC is>= 66%) => % TRC violations, (SNC is >= 33 %) => Industry Name Gardner Glass Products IUP# 1 Pipe # • ram[. i"f'iL•Tiiiil;7 � . • ram[. i"f'iL•Tiiiil;7 . • ram[. i"f'iL•Tiiiil;7 . • ram[. i"f'iL•Tiiiil;7 • f�lf:[.^l'if.7ifii1;1 � . • f�lf:[.^l'if.7ifii1;1 � . • f�lf:[.^l'if.7ifii1;1 � . • f�lf:[.^l'if.7ifii1;1 • W[."l'if.7ifii1;1 • W[."l'if.7ifii1;1 • W[."l'if.7ifii1;1 • W[."l'if.7ifii1;1 BDL => Below Detection Limit mg/I => milligrams per liter POTW must enter at least one of these IUP=> Industrial User Permit Ib/d => pounds per day fourrows, Rease indicate how averages were calculated SNC => Significant Non -Compliance mgd => million gallons per day Avg period could be month, Qtr, or 6-month & if BDL , 1/2BDL, or zero values used. TRC => Technical Review Criteria WWTP=> wastewater treatment plant Chapter: PAR Guidance File name: PPlEbiii�islde�i'�uJa�teli$tc1iIB, pages 12, 13, 14 Blank IDSF Form, Copy and use in your PAR Number each set for each IUP pipe- Page of Pretreatment Annual Report (PAR) Industry Name Industrial Data Summary Form (IDSF) IUP # Use separate forms for each industry/pipe Pipe # Enter BDL values as < (value) Total # of samples => Maximum (mg/1) => or M axi mum (I b/d) => or Average (mg/1) => or Average Loadi ng (I b/d) => % violations, (chronic SNC is>= 66%) => % TRC violations, (SNC is>= 33 %) => Total # of samples => Maximum (mg/1) => or M axi mum (I b/d) => or Average (mg/1) => or Average Loadi ng (I b/d) => % violations, (chronic SNC is>= 66%) => % TRC violations, (SNC is>= 33 %) => Total # of samples => Maximum (mg/1) => or M axi mum (I b/d) => or Average (mg/1) => or Average Loadi ng (I b/d) => % violations, (chronic SNC is>= 66%) => % TRC violations, (SNC is>= 33 %) => WOEMM err:[_ IMEMM err:[_ IMEMM err:[_ IMEMM WOUMM • • WOUMMl%l•T:[.YiT.7iiii� • E�[.YiT.7iiii� . l%l•T:[.YiT.7iiii� . l%l•T:[.YiT.TiSii�WOUMMl%l•T:[.YiT.7iiii� BDL => Below Detection Limit mg/I => milligrams per liter POTW must enter at least one of these IUP=> Industrial User Permit Ib/d => pounds per day fourrows, Please indicate how averages were calculated SNC => Significant Non -Compliance mgd => million gallons per day Avg period could be month, Qtr, or 6-month & if BDL , 1/2BDL, or zero values used. TRC => Technical Review Criteria WWTP=> wastewater treatment plant Chapter: PAR Guidance File name: pages 12, 13,14 Blank IDSF Form, Copy and use in your PAR Number each set for each IUP pipe- Page of of 12 Workbook Name: Allocation Table 2024• Worksheet Name: HWA Page 19 Printed 2/27/2M � 024, 2:4PM A I B C D E I F G H I J K 1 2 3 HeadworksAnalysis Spreadsheet Spreadsheet Instructions: POTW Name: NWWTP 1) Applicable Values should be entered in the Heavy Bordered Blue cells. The rest of worksheet is Date: 10/2/2018 protected, password is "2". POTW NPDES # => NCO020761 2) Additional pollutants can be added in cells A34 to A42. Note all Pollutant names are linked from POTW Sludge Permit # => WQ0002040 here to other pages in HWA worksheet and also to AT worksheet (i.e., automatically entered into other pages in HWA worksheet and also AT worksheet from HWA worksheet). POTW NPDES Permitted Flow(MGD)= 2.0 -used in AT only 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter. POTW Average Row(MGD)= 1.048 <=used in HWA calwlaticns 4) HWA, AT and HASL worksheets are linked. MAHLs, Basis, and Uncontrollable load are Uncontrollable Flow(MGD)= 0.999 automatically entered into AT from this worksheet. 7Q10 Stream Row(MGD)= 126.6 5) If red tab notes are not visible, they can be turned on in the "Tools" menu under "options", in the Stream Classification = C "view" tab click the "comment indicator only" button. Class of Siudgegenerated (A, or B) B Sludge to Digestor Row(MGD)= Through calc.for different POTW use Design Sludge to DisposalFlow(MGD)= 0.022 flows Criteria %Solids to Disposal= 0.41 Desi n Values Average Flow Permitted Flow Loading Sludge SiteArea(acres)= 106.4 WWTF Influent BOD (mg/1) 5 773.2 405.2 x 9udgeSiteLife(yrs)= 50 WWTF InfluentTSS(mg/I) 5 1298.7 680.5 x Age of SludgeSite(yrs)= 5 WWTF Influent NH3 (mg/I) 40 238.7 125.1 WWTF Influent Total N(mg/I) Pass -Through Loading Calculations WWTF I nfl uent Total P(mg/I) 4 5 7 8 9 10 11 13 14 15 16 17 18 19 201 21 23 Pdlut8M NPDESLIMIT (mgtl) Plant Removal Rate(%) Removal rate Source NPDESLoading (lbs/day) Stream Standard (mgM Stream Standard Source Standard Loading (lbs/day) Design Criteria Loading(lbsrday) PasThru Loading (lbsfday) Minimum Pass-Thru Bass 24 BOD 30 96.12 site spacific 6,758 2,752 2,752 Design 25 TSS 30 97.69 site specific 11,351 2,502 2,502 Design 26 Ammonia 9 96.23 site specific 2,087 667 2,087 NPDES 27 Arsenic 45 literature 0.05 96.7804 96.7804 Stream Std 28 Cadmium 67 literature 0.002 6.4520 6.4520 Stream Std 29 Chromium 82 literature 0.05 295.7179 295.7179 Stream Std 30 Copper 94.34 sitespecific Action Level 31 Cyanide 69 literature 0.005 17.1707 17.1707 Stream Std 32 Lead 61 literature 0.025 68.2426 68.2426 Stream Std 33 Mercury 97.57 site spedfic 0.000012 0.52572 0.52572 Stream Std 34 Molybdenum 33 literature 35 Nickel 42 literature 0.088 161.5231 161.5231 Stream Std 36 Selenium 50 literature 0.005 10.6458 10.6458 Stream Std 37 Silver 75 literature Action Level 38 Zinc 91.86 literature Action Level 39 Total Nitrogen 40 Total Phos. 41 c 42 d 43 e 44 f 45 g 4AIr 47 11 Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 Workbook Name: Allocation Table 2024• Worksheet Name: HWA Page � Printed 2/27/2024, 2:49 49 PM A B C D E F G H I J K 49 NH3 (mg/1)� AverageInfluenterobic Digester Average Anaerobic Digester NH3 (mg/I) Inhibition Loading Calculations only enter when have ANAEROBIC digester 50 51 52 Pollutant Primary Removal Rate N Primary Removal Rate Source A.S./Ni[,/I.F-. Inhibition Concentration (mgM A.S./Nit,/I.f•. Inhibition Concentration Source 1, Inhibition Loading (lbsfday) Ulgestor Inhibition Concentration (mgA) DigWor Inhibition Cona Source Digestor Inhibition Loading (lbs/day) —mmimum Inhibition Loading (lbs/day) minimum Inhibition Loading Source 53 BOD 54 TSS 55 Ammonia 480 IT it- EPA 4195.3536 4195.35 AS✓Nit/TF i 56 Arsenic 0.1 Lit -AS -EPA 0.8740 0.8740 AS✓Nit/TF i 57 Cadmium 1 Lit -AS -EPA 8.7403 8.7403 AS✓Nit/TF i 58 Chromium 0.394 Ltt- T- 3.4437 3.4437AS✓Nit/TFi 59 Copper 0.48 Lit-Nit-NC2006 4.1954 4.1954 AS✓Nit/TF i 60 Cyanide 0.1 Lit -AS -EPA 0.8740 0.8740 AS✓Nit/TF i 61 Lead 0.5 Lit -AS -EPA 4.3702 4.3702 AS✓Nit/TF i 62 Mercury 0.1 Lit -AS -EPA 0.8740 0.8740 AS✓Nit/TF i 63 Molybdenum 64 Nickel 0.25 Lit -AS -EPA 2.1851 2.1851 AS✓Nit/TF i 65 Selenium 66 Silver 0.25 Lit -AS -EPA 2.1851 2.1851 AS✓Nit/TFi 67 Zinc 1 Lit-Nit-NC2006 8.7403 8.7403 AS✓Nit/TF i 68 Total Nitrogen 69 Total Phos. 70 c 71 d 72 e 73 f 74 g 75 h 76 I Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 Workbook Name: Allocation Table 2024• Worksheet Name: HWA Page 3 of 12 � Printed 2/27/2024, 2:49 PM A B C D E F G H I J K 77 78 Sludge Loading Calculations 79 Pollutant Sludge Ceiling Concentration Limit (mgrkg) SludgeCeling Load (lbs/day) u ge eimg Load - HASLCaIc.- (Ibs/day) Cumulative Sludge Rate Limit (Ibs/(acrelife)) Cumulative Sludge Loading (lbs/day) ClassA Limits Monthly Average Rate Limit(mgtkg) Class imits Monthly Avg. Loading (Ibs/day) ass emits Mon. Avg. Load. - HASLCaIc.- (Ibs/day) immum Sludge Loading (Ibs/day) Minimum Sludge Loading Sorce 80 BOD 81 TSS 82 Ammonia 83 Arsenic 75 0.1254 36 0.4661 41 1 0.1254 Sludge Cei Ii 84 Cadmium 85 0.0954 34 0.2957 39 0.0954 SI udge Cei I i 85 Chromium 86 Copper 4300 3.4288 1338 8.2635 1500 3.4288 SI udge Cei I i 87 Cyanide 88 Lead 840 1.0359 267 2.5503 300 1.0359 SI udge Cei I i 89 M ercury 57 0.0439 15 0.0896 17 0.0439 SI udge Cei I i 90 Molybdenum 751 0.1710 0.1710 Sludge Cei li 91 Nickel 420 0.7523 374 5.1883 420 0.7523 SI udge Cei I i 92 Selenium 100 0.1505 89 1.0371 100 0.1505 SI udge Cei I i 93 Silver 94 Zinc 7500 6.1420 2498 15.8442 2800 6.1420 SI udge Cei I i 95 Total Nitrogen 96 Total Phos. 97 c 98 d 99 e 100 f 101 g 102 h 103 1 104 Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 Workbook Name: Allocation Table 2024• Worksheet Name: HWA Printed 2/27/2024, 2:49PPM Page4 � M A I B I C I D E F G H I J K 105 M aximum Allowable Headworks Loading Calculations 106 MinimumPass Through Loading (lbs/day) PawThrough Source Minimum Inhibition Loading (Ibsiday) Minimum Inhibition Loading Source Minimum Sludge Loading (lbsfday) Minimum Sludge Loading Sorce Allowable Headworks Loading (lbsfday) Maximum Allowable Headworks Loading Source 107 BOD 2752.2 Design 2752.2 Desi n 108 TSS 2502.0 Des n 2502.0 Design 109 Ammonia 2086.5 NPDES 4195.3536 AS/Nit/TF inhibiti 2086.5 NPDES 110 Arsenic 96.7804 StreamStd 0.8740 AStNit/TF inhibiti 0.1254 Slud eCeling 0.1254 SudgeCeiling 111 Cadmium 6.45201 StreamStd 8.7403 AStNit/TF inhibiti 0.0954 Slud eCeling 0.0954 SludgeCeiling 112 Chromium 295.7179 Stream Std 3.4437 AStNit/TF inhibiti 3.4437 AS'Nit/TF inhibition 113 Copper 4.1954 AStNit/TF inhibiti 3.4288 SudgeCeiling 3.4288 9ud eCeiIin 114 Cyanide 17.1707 Stream Std 0.8740 A&Nit/TF inhibiti 0.8740 AS'Nit/TF inhibition 115 Lead 68.2426 StreamStd 4.3702 A&Nit/TFinhibiti 1.0359 SudgeCeiling 1.0359 SudgeCeiling 116 Mercury 0.52572 StreamStd 0.8740 A&Nit/TFinhibiti 0.0439 SudgeCeiling 0.04395 SudgeCeiling 117 Molybdenum 0.1710 Slud eCelin 0.1710 SudaeCeilinci 118 Nickel 161.5231 StreamStd 2.1851 AS/Nit/TFinhibiti 0.7523 SudgeCeiling 0.7523 SudgeCeiling 119 Selenium 10.64581 StreamStd 0.1505 SudoeCeilina 0.1505 SudgeCeiling 120 Silver 2.1851 ASINWTFinhibiti 2.1851 AS'Nit/TFinhibition 121 Zinc 8.7403 ASINit/TFinhibiti 6.1420 Slud eCeling 6.1420 9ud eCeli ng 122 Total Nitrocien 123 Total Phos. 124 c 125 d 126 e 127f 128 129 h 130 I 131 Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 Workbook Name: Allocation Table 2024• Worksheet Name: HWA Page 5 of 12 � Printed 2/27/2024, 2:49 PM A B C D E F G H I J K 132 133 MaximumAllowable Industrial Loadin Calculations Design vs. Pass Thru Warning 134 Pollutant Allowable HeadworksLoading (lbs(day) MAHL Bass Check to Use HASL Calcs (x) Uncontrollable Concentration (m911) Uncontrollable Source Uncontrollable Load (lbslday) Ivi Allowable Industrial Load (lbs(day) 135 BOD 2752.2000 Design 117 mass balance 974.8042 1777.3958 136 TSS 2502.0000 Design 134.4 mass balance 1119.7751 1382.2249 137 Ammonia 260.1120 NPDES 12.3 mass balance 102.4794 157.6326 138 Arsenic 0.0753 Sl udge Cei I i ng 5 mass balance 0.0433 0.0320 139 Cadmium 0.0954 Sludge Ceiling mass balance 0.0083 0.0871 140 Chromium 3.4437 AS/Nit/TFinhibiti . 5 mass balance 0.0433 3.4004 141 Copper 3.4288 SI udge Cei I i ng 0.0545 mass balance 0.4541 2.9747 142 Cyanide 0.8740 AS/Nit/TFinhibiti 0.00 5 mass balance 0.0208 0.8532 143 Lead 1.0359 Sl udge Cei I i ng 0.0049 mass balance 0.0408 0.9951 144 Mercury 0.04395 Sl udge Cei I i ng 0.0003 mass balance 0.00250 0.04145 145 Molybdenum 0.1027 AS/Nit/TFinhibition 0.0026 mass balance 0.0217 0.0810 146 Nickel 0.7523 Sl udge Cei I i ng 0.005 mass balance 0.0417 0.7106 147 Selenium 0.1433 Sl udge Cei I i ng 0.0052 mass balance 0.0433 0.1000 148 Silver 1.7097 AS/Nit/TFinhibiti 0.0025 mass balance 0.0208 1.6889 149 Zinc 6.1420 SludgeCeiIing 0. 19 mass Mlance 1.5830 4.5590 150 Total Nitrogen 3.75 mass balance 31.2437 151 Total Phos. 152 c 153 d 154 e 155 f 156 g 157 h 158 1 Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 POTW= NPDES#= IUP Count 1 2 3 4 5 6 7 8 9 10 Workbook Name: Allocation Table 2024, Worksheet Name: AT Printed: 2/27/2024, 2:49 PM Page 6 of 12 Allocation Table Headworks last approved: 10/07/21 Allocation Table updated: 02/27/23 Permits last modified: 10/01/22 NW WTP NC0020761 Spreadsheet Instructions: 1) Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is protected, password is 2 2) Formulas are discussed in the Comprehensive Guidance, Chapter 6, Section C. 3) HWA and AT worksheets in this workbook are linked. Pollutant Names, MAHLs, Basis, and Uncontrollable load in this AT worksheet are automatically entered from the HWA spreadsheet. This includes pollutant names in columns AT through BK. Type Renewal Modification Date Pipe of Effective Effective Permit number I ndustry Date Date Expires Industry INDUSTRY NAMES Permit (plEacelist alphabaidy) number FLOW Permit Limits B D Permit Limits TSS Permit Limits MGDgal/day Conc. Load m I Ibstd Conc. Load m I bstday Gardner Glass Products 0001 1 433 10/01/22 09/30/27 0.0750 75,000 150 93.83 150 93.83 Johnston Casuals 0002 1 433 10/01/20 09/30/25 0.0095 9,500 Col umn Total s => 1 0.08451 84,5001 94 94 Basis=> MAHL from HWA (lbstday) _> Uncontrollable Loading (lbstday) _> Total Allowablefor Industry (MAIL) (lbstday) _> Total Permitted to Industry (Ibstday) _> MAIL left (lbstday) _> Percent Allow. Ind. (MAIL) still available(%) _> Percent MAHL still available(%) _> 5 Percent MAHL (I bstdav) _> HWA.AT Revised: November 2005 NPDES Permitted Flow=> NPDES 1.0010 1777 1382 0.0845 94 94 0.9165 1684 1288 91.6% 94.7% 93.2% 45.8% 61.2% 51.5% 0.10001 1381 125 POTW= NPDES#= IUP Count 1 2 3 4 5 6 7 8 9 10 Workbook Name: Allocation Table 2024, Worksheet Name: AT Allnnntinn TahlP I Printed: 2/27/2024, 2:49 PM Page 7 of 12 Headworks last approved: Allocation Table updated: Permits last modified: 10/07/21 Pipe number 02/27/23 10/01/22 NWWTP NC0020761 Industry INDUSTRY NAMES Permit (plEacelist alphabaidy) number Ammonia Permit Limits Arsenic Permit Limits Cadmium Permit Limits Chromium Permit Limits Copper Permit Limits Cyanide Permit Limits Conc. Load m I Ibs/d Conc. Load m I Ibs/d Conc. Load m I Ibs/d Conc. Load m I Ibs/d Conc. Load m I Ibs/d Conc. Load m I bstday Gardner Glass Products 0001 1 0.050 0.03 0.06 0.04 1.5 0.938 0.10 0.063 Johnston Casuals 0002 1 0.07 0.006 0.02 0.002 0.40 0.032 0.10 0.008 Col umn Total s => 01 1 0.0000 0.0368 0.03911 1 0.9699 0.0705 Sludge Sludge AS/Nit/TF Sludge AS/Nit/TF Basis=> NPDES Ceiling Ceiling inhibition Ceiling inhibition M A H L from H WA (I bs/day) _> 260.11 0.0753 0.0954 3.4437 3.4288 0.8740 Uncontrollable Loading (lbs/day) _> 102.48 0.0433 0.0083 0.0433 0.4541 0.0208 Total A I I owabl e f or Industry (MAIL) (I bs/day) _> 157.63 0.0320 0.0871 3.4004 2.9747 0.8532 Total Permitted to Industry (Ibs/day) _> 0.00 0.0000 0.0368 0.0391 0.9699 0.0705 M A I L I eft (I bs/day) _> 157.63 0.0320 0.0503 3.3612 2.0048 0.7827 Percent Allow. Ind. (MAIL) still available(%) _> 100.0 % 100.0% 7.7 % 91.7 Percent MAHL still avaiIabla(%) _> 42.5 M67A 58.5% 89.6 5 Percent MAHL (Ibs/dav) => 0 37 HWA.AT Revised: November 2005 POTW= NPDES#= IUP Count 1 2 3 4 5 6 7 8 9 10 Workbook Name: Allocation Table 2024, Worksheet Name: AT Allnnntinn TahlP I Printed: 2/27/2024, 2:49 PM Page 8 of 12 Headworks last approved: Allocation Table updated: Permits last modified: 10/07/21 Pipe number 02/27/23 10/01/22 NWWTP NCO020761 Industry INDUSTRY NAMES Permit (pl- ist dphabdidy) number Lead Permit Limits Mercury Permit Limits Molybdenum Permit Limits Nickel Permit Limits Selenium Permit Limits -9I Permit Conc. Load m I I bs/d Conc. Load m I I bs/d Conc. Load m I I bs/d Conc. Load m I I bs/d Conc. Load m I I bs/d Conc. m Gardner Glass Products 0001 1 0.05 0.031 0.4 0.250 0.07 Johnston Casuals 0002 1 0.15 0.012 0.10 0.008 0.15 Col umn Total s => 0.0432 0.000000 0.0000 0.2581 1 0.0000 Sludge Sludge AS/Nit/TF Sludge Sludge Basis=> Ceiling Ceiling inhibition Ceiling Ceiling M A H L from H WA (I bs/day) => 1.0359 0.043947 0.1027 0.7523 0.1433 Uncontrollable Loading (lbs/day) => 0.0408 0.002499 0.0217 0.0417 0.0433 Total A I I owabl e f or Industry (MAIL) (I bs/day) => 0.9951 0.041448 0.0810 0.7106 0.1000 Total Permitted to Industry (Ibs/day) => 0.0432 0.000000 0.0000 0.2581 0.0000 M A I L I eft (I bs/day) => 0.9519 0.041448 0.0810 0.4525 0.1000 Percent Allow. Ind. (MAIL) still available(%) _> 95.7 % 100.0 % 100.0 % 100.0 Percent MAHL still avaiIabla(%) _> 91.9% 94.3% 78.9% k603.77 69.8 5 Percent MAHL (Ibs/dav) => 00518 0.002197 0.0051 1 0.0072 HWA.AT Revised: November 2005 Workbook Name: Allocation Table 2024, Worksheet Name: AT Allocation Table Headworks last approved: 10/07/21 Allocation Table updated: 02/27/23 Permits last modified: 10/01/22 POTW=> NPDEs#=> IUP Count 1 2 3 4 5 6 7 8 9 10 ivvvvv i r NC0020761 Ver Industry Limits INDUSTRY NAMES Permit Pipe Load (ply fist alphabaidy) number number I bs/day Gardner Glass Products 0001 1 0.044 Johnston Casuals 0002 1 0.012 Col umn Total s => 0.0557 AS/Nit/TF Basis=> inhibition MAHL from HWA (lbs/day) _> 1.7097 Uncontrollable Loading (lbs/day) _> 0.0208 Total Allowablefor Industry (MAIL) (lbs/day) _> 1.6889 Total Permitted to Industry (Ibs/day) _> 0.0557 MAIL left (Ibs/day) _> 1.6332 Percent Allow. Ind. (MAIL) still available(%) _> 96.7 Percent MAHL still available(%) _> 95.5 5 Percent MAHL (I bs/dav) _> 0.0855 HWA.AT Revised: November 2005 Printed: 2/27/2024, 2:49 PM Page 9 of 12 POTW= NPDES#= IUP Count 1 2 3 4 5 6 7 8 9 10 Workbook Name: Allocation Table 2024, Worksheet Name: AT Printed: 2/27/2024, 2:49 PM Page 10 of 12 Allnnntinn TahlP Headworks last approved: Allocation Table updated: Permits last modified: 10/07/21 Pipe number 02/27/23 10/01/22 NWWTP NC0020761 Industry INDUSTRY NAMES Permit (plEacelist alphabaidy) number Zinc Permit Limits Total Nitrogen Permit Limits Total Phos. Permit Limits c Permit Limits d Permit Limits e Permit Limits Conc. Load m I Ibstd Conc. Load m I Ibstd Conc. Load m I Ibstd Conc. Load m I Ibstd Conc. Load m I Ibstd Conc. Load m I bstday Gardner Glass Products 0001 1 0.3 0.188 Johnston Casuals 0002 1 0.50 0.040 1 Column Total s => 1 0.22731 1 0.00 0.00 0.0000 0.0000 0.0000 Sludge Basis=> Ceiling MAHL from HWA (lbstday) _> 6.1420 Uncontrollable Loading (lbstday) _> 1.5830 31.2437 Total Allowablefor Industry (MAIL) (lbstday) _> 4.5590 Total Permitted to Industry (Ibstday) _> 0.2273 0.00 0.00 MAIL left (Ibstday) _> 4.3317 Percent Allow. Ind. (MAIL) sti I I avai I abl a (%) _> 95.0 % Percent M A H L sti I I avai I abl e (%) _> 70.5 % 5 Percent M A H L (I bstdav) _> 0.3071 HWA.AT Revised: November 2005 t1�lIlIlI1] POTW= NPDES#= IUP Count 1 2 3 4 5 6 7 8 9 10 Workbook Name : Allocation Table 2024, Worksheet Name: AT Printed: 2/27/2024, 2:49 PM Page 11 of 12 Allocation Table Headworks last approved: Allocation Table updated: Permits last modified: 10/07/21 Pipe number 02/27/23 10/01/22 NWWTP NC0020761 Industry INDUSTRY NAMES Permit (phase l ist J phabdidy) number f Permit Limits g Permit Limits h Permit Limits I Permit Limits Conc. Load mg/I Ibsida Conc. Load mg/I Ibsida Conc. Load mg/I Ibsida Conc. Load mg/I Ibsida Gardner Glass Products 0001 1 Johnston Casuals 0002 1 Column Totals => 0.00001 1 0.00001 1 .00001 1 0.0000 Basis=> MAHL from HWA (lbs/day) _> Uncontrollable Loading (Ibs/day) _> Total Allowablefor Industry (MAIL) (lbsiday) _> Total Permitted to Industry (Ibs/day) _> 0.0000 0.0000 MAIL left (Ibs/day) _> Percent A I I ow. Ind. (MAIL) sti I I avai I abl a (%) _> ####### ####### Percent M A H L sti I I avai I abl e(%) _> ####### ####### 5 Percent MAHL (lbs/dav) _> HWA.AT Revised: November 2005 None IUIII #######1 1####### #######1 1####### Name: Allocation Table 2024; Worksheet Name: HASL Headworks Addendum for SludgeLoadings (HASL)worksheet POTW Name=> NWWTP Spreadsheet Instructions: POTW NPDES # _> NC0020761 POTW Sludge Permit # _> WQ0002040 1) Data entered only in Heavy Bordered cells. Rest of worksheet is protected, Date => 10/2/2018 password is "2'. POTW Average Flow => 1.05 mgd Avg. sludge flow to Disposal => 0.022 mgd 2) This spreadsheet changes based on the class of sludge generated inputted in Average % Solids to Disposal => 0.41 % cell C13 of the HWA spreadsheet. The title and the limits in column G of this Sludge Site Area permitted => 106.4 acres spreadsheet are updated automatically. CUMULATIVE SLUDGE POLLUTANT LOADING LIMITS Ibs/acre mium ickel 3) Formulas in Comprehensive Guidance HWA Chapter, Section K. Enter actual CUMULATIVE LOADING data from most recent Flag if Sludge Report for % of Greater the most heavily Cumulative than loaded field' Limit 80% IF Greater than 80% Flag POTW MUST SUBMIT LAND APP & METALS MANAGEMENT PLAN In a _sv = (Q_potw * C_inf * 8.34 Page 12 of 12 Printed 2/27/2024, 2:49 PM adj Q_potw = Average POTW flow (mgd) C_inf = Average influent concentration (mgd) %_adj = Per percentage of Sludge Limit as decimal (example: enter 117% as 1.17) 8.34 = Conversion Factor Flag if > Enter actual 80% of MAXIMUM SLUDGE % of Applicable Sludge Ceiling CONC. from most Applicable Ceiling Flag if > Concentrations recent Sludge Report Ceiling Conc. Cone. 100% of Limits or LTMP Data Limit Limit the Limit mg/dry kg m /d k % Flag Flag 75 85 If Greater than 80% of the concentration limit POTW MUST SUBMIT METALS MANAGEMENT PLAN n/a Calculate MAHL_sv based on % of Monthly Average Concentration Limits Enter Average to Protect Sludge POTW Influent Quality (insert these Cone. values into HWA) #VALUE! I #VALUE! #VALUE! #VALUE! I #VALUE! #VALUE! If over ceiling conc. POTW must reduce MAHL n/a ' The most heavily loaded field is determined for each polluntant indivisually, and is the field that contains the highest amount (Ibs/acre) of that polluntant.