NC0025348_Report_20240510

Workbook Name: AT- HWA 2023, Worksheet Name: AT
Allocation Table
Headworks last approved: 05/07/15
Allocation Table updated: 02/26/24
Permits last modified: 04/16/24
POTw=> I City of New Bern
'ERMITStk> NC0025348 and W00017635
IUP
Count
2
3
4
Printed: 5/10/2024, 10:50 AM
Page 1 of 5
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, MAHI-s, Basis, and Uncontrollable load in this AT
worksheet are automatically entered from the HWA spreadsheet. This includes pollutant names in columns AT through BK.
INDUSTRY NAMES
(Please list elphabmicly)
Industry
Permit
number
Pipe
number
Type
of
Industry
Renewal Modification
Effective Effective
Date Date
Date
Permit
Expires
FLOW
Permit Limits
BOD
Permit Limits
TSS
Permit Limits
MGD al/day
Cone. Load
mg/1 lbs/day
Cone. Load
ingil lbs/day
B.S.H. Home Appliances - Ran a
1100
04a
466
09/28/23
12/31/27
0.0350
35,000
350.001
102.17
250.00
72.98
Chatsworth Products, Inc.
0600
01
433
01/01/23
12/31/27
0.0200
20,000
350.00
58.38
250.00
41.70
Coastal Regional Solid Waste M n.
0900
01
Landfill
01/01/23
12/31/27
0.1000
100,000
300.00
250.20
250.00
208.50
CCWE
1200
0002
4911
01/01/21
12/31/24
0.0900
90,000
150.00
112.59
150.00
112.59
Column Totals =>
0.2450
245,000
1 523
436
Basis=>
MAHL from HWA (Ibs/day) _>
Uncontrollable Loading (lbs/day) _>
Total Allowable for Industry (MAIL) (lbs/day) _>
Total Permitted to Industry (Ibs/day) _>
MAIL left (lbs/day) _>
Percent Allow. Ind. (MAIL) still available (%) _>
Percent MARL still available (%) _>
5 Percent MARL albs/dav) =>
H WA.AT
Revised:November 2005
NPDES Permitted Flow-
NPDES
Design
Design
6.5000
135531
10842
4.0020
7844
5274
2.4980
5709
5568
0.2450
523
436
2.2530
5186
5133
90.2 %
90.8 %
92.2 %
34.7 %
38.3 %
47.3
0.3250
678
542

Chapter 9, PAR Guidance
Pretreatment Performance Summary (PPS)
1. Pretreatment Town Name: City Of New Bern
2. "Primary" NPDES Number NCO025348 This Column
for office
or Non Discharge Permit # if applicable => WQ0017635 a e my
WENDS
3. PAR begin Date, please enter 01/01/yy or 07/01/yy 1/1/2023 7/l/2023 3. _> 1 1 23 PSSD
4. PAR end Date, please enter 06/30/yy or 12/31/yy 6/30/2023 12/31//2023 4. _> 12 31 23 PSED
5. Total number of SIUs, includes CIUs 5. _> 4 sRls
6. Number of CIUs 6. _> 2 CIUS
7. Enter the Higher Number, either (7a) or (7b) here => 0 NOIN
7a. Number of SIUs not sampled by POTW 7a. _> 0
7b. Number of SIUs not inspected by POTW 7b. _> 0
8. Number of SIUs with no IUP, or with an expired IUP 8. _> 0 NOCM
9, Total Number of SIUs in SNC due to either IU Reporting violations or
IUP Limit violations. To avoid double counting some SIUs
Enter ( 9a + 9b) - 9c here => 1 PSNC
Enter the Number of SIUs in SNC for:
9a. lU Reporting violations 9a. _> 0 MSNC
9b. IUP Limit violations 9b. _> 2 SNPS
9c. Both IU Reporting & Limit violations 9c. -> 1
10. Number of SIUs in SNC due to IU Reporting violations
that were not sampled or inspected by POTW 10. _> 0 SNIN
11. Number of SIUs in SNC due to violation of 11. _> 0 SSNC
Compliance Schedule due dates
12. Number NOVs, NNCs, AOs, or similar assesed to SIUs 12. _> 18 FENF
13. Number Civil or Criminal Penalties assessed to SIUs 13. _> 9 JUDI
14. Number of SIUs included in public notice 14. _> 1 SVPU
15. Number of SIUs from which penalties collected 15. _> 1 IUPN
16. Total Amount of Civil Penalties Collected 16.: $ 1928
17. Total Number of SIUs on a compliance schedule 17. => 0 SOCS
Foot Notes: AO Administrative Order NOV Notice of Violation
C1U Categorical Industrial User PAR Pretreatment Annual Report
CO Consent Order POTW Public Operated Treatment Works
IUP Industrial User Pretreatment Permit S1U Significant Industrial User
NNC Notice ofNon-Compliance SNC Significant Non-Comliance, formerly RNC
Chapter name: PAR Guidance File name: PAR_PPS.xls Revision date: August 1, 1994 Comprehensive Guide, Chapter 9, Section B, Page 5 Blank PPS Form, Copy and use in your PAR