Copy of WS Audit Data 1-1-22 thru 12-31-22.xlsm

	A	B	C	D	E	F	G	H	I	J	K	L
1	Aggregated Inbound Audit Report
2	Location	Winston Salem MRF - 1st
3	Customer	City of Winston Salem – WM Del FEL, CITY OF WINSTON-SALEM SS-Floor Sort
4	Sample Confidence	93%
5	Audit Period	1/1/2022 - 12/31/2022
6	# of Audits	44
7	Audit Time (hrs)	89.05
8	Avg Audit Time (hrs)	2.02
9	Total Weight (lbs)	12467.2
10	Avg Weight (lbs)	283.3
11	Status	Complete
12
13	Material	Material Sub	Shape	Color	Product Bale	Material Subtotal (lbs)	Min (lbs)	Max (lbs)	Avg (lbs)	Sum (lbs)	% of Total
14	Plastic	MRF Film Plastic			Film		0.0	0.0	0.0	0.0	0.0%
15	Glass	Three Mix Glass > 3/8			GP-3Mix		8.0	165.7	34.9	1535.9	12.3%
16	Plastic	2 HDPE		Colored	HDPE-C		0.2	8.9	4.5	199.9	1.6%
17	Plastic	2 HDPE		Natural	HDPE-N		1.3	8.0	4.0	176.0	1.4%
18	Fiber	Mixed Paper 54			MixPpr54		29.6	191.6	85.4	3757.6	30.1%
19	Plastic	Plastic 3-7			MxPlstc3-7		0.0	4.7	0.7	30.9	0.2%
20	Fiber	OCC			OCC		10.4	105.0	58.7	2580.9	20.7%
21	Fiber	ONP8-SRPN			ONP8-SRPN		0.0	0.0	0.0	0.0	0.0%
22	Plastic	1 PET			PET		6.3	27.4	15.8	695.3	5.6%
23	Residue	Plastic Bagged Material			Res		0.0	15.9	3.1	137.6	1.1%
24	Residue	Residue			Res		10.9	263.1	66.1	2909.4	23.3%
25	Res				Total	3047.0					0.0%	24.44%
26	Metal	Scrap Metal			ScrpMtl		0.0	0.0	0.0	0.0	0.0%
27	Metal	Steel-Tin			Steel-Tin		0.5	8.4	4.2	183.0	1.5%
28	Metal	Aluminum			UBC		1.3	10.3	5.9	260.7	2.1%
29											0.0%
30											0.0%
31											0.0%
32											0.0%
33											0.0%
34											0.0%
35											0.0%
36											0.0%
37											0.0%
38											0.0%
39	NOTE: Values calculated by hand will differ due to rounding.								Total Sample Weighed	12467.2	100.0%
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100