Spreadsheet: 829523d1684286927-how-to-figure-weighted-average-how-to-figure-weighted-average
Sheet: josephteh

 | A GROUP |  | B GROUP |  | C GROUP |  | D GROUP |  |  |  |  |  |  | Tier | # Machines | Burdern Factor | Total Burdern | Burden % | Burden % per Machine
 |  |  |  |  |  |  |  |  |  |  | Total Burden: | 5400000 |  | 1 | 22 | 0.56
 |  |  |  |  |  |  |  |  |  |  | Billable Hours: | 4160 |  | 2 | 9 | 0.88
 |  |  |  |  |  |  |  |  |  |  | Burden / Hour: |  |  | 3 | 8 | 1.12
 |  |  |  |  |  |  |  |  |  |  | Machine Count | 44 |  | 4 | 5 | 1.44
Work |  |  |  |  |  |  |  |  |  |  |  |  |  | Burden | Labor
Center | Setup | Cycle | Setup | Cycle | Setup | Cycle | Setup | Cycle | [NAME] | Burden % | Burden Rate | Burden Factor |  | Rate/Hr | Rate/Hr
101 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 |  |  |  |  | 24.42 | 20.34 |  | How to figure weighted average
102 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 |  |  |  |  | 24.42 | 20.34 |  | How to figure weighted average (excelforum.com)
103 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 |  |  |  |  | 24.42 | 20.34
104 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 24.42 | 20.34
105 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 104 | 2 |  |  |  |  | 24.42 | 21
106 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 |  |  |  |  | 24.42 | 20.34
107 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 |  |  |  |  | 24.42 | 20.34
108 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 24.42 | 20.34
109 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 24.42 | 20.34
110 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 24.42 | 20.34
111 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 2 |  |  |  |  | 24.42 | 20.34
112 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 |  |  |  |  | 24.42 | 20.34
113 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 1 |  |  |  |  | 24.42 | 20.34
190 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 24.42 | 20.34
191 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 24.42 | 20.34
192 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 24.42 | 20.34
193 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 24.42 | 20.34
201 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
202 | 160 | 79.5 | 200 | 93.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
203 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
204 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
205 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
206 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
207 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
208 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
209 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
210 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 28.9 | 24.07
211 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 |  |  |  |  | 28.9 | 24.07
212 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 |  |  |  |  | 28.9 | 24.07
213 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 28.9 | 24.07
214 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 |  |  |  |  | 28.9 | 24.07
215 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 |  |  |  |  | 28.9 | 24.07
216 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 |  |  |  |  | 27.85 | 23.19
217 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 |  |  |  |  | 27.85 | 23.19
218 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 |  |  |  |  | 27.85 | 23.19
219 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 |  |  |  |  | 27.85 | 23.19
220 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
221 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 |  |  |  |  | 27.85 | 23.19
299 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 |  |  |  |  | 23.63 | 19.68
301 | 160 | 111.5 | 200 | 117 | 250 | 123 | 300 | 129 | 4 |  |  |  |  | 34.42 | 28.66
302 | 160 | 111.5 | 200 | 117 | 250 | 123 | 300 | 129 | 4 |  |  |  |  | 34.42 | 28.66
303 | 160 | 111.5 | 200 | 117 | 250 | 123 | 300 | 129 | 4 |  |  |  |  | 34.42 | 28.66
304 | 160 | 111.5 | 200 | 117 | 250 | 123 | 300 | 129 | 4 |  |  |  |  | 34.42 | 28.66
305 | 160 | 111.51 | 200 | 117 | 250 | 123 | 300 | 129 | 4 |  |  |  |  | 34.42 | 28.66
400 | 0 | 31.5 | 0 | 33 | 0 | 35 | 0 | 37 |  |  |  |  |  | 10.47 | 19.5
401 | 0 | 31.5 | 0 | 33 | 0 | 35 | 0 | 37 |  |  |  |  |  | 10.47 | 19.5
402 | 0 | 31.5 | 0 | 33 | 0 | 35 | 0 | 37 |  |  |  |  |  | 10.47 | 19.5
403 | 0 | 31.5 | 0 | 33 | 0 | 53 | 0 | 37 |  |  |  |  |  | 10.47 | 19.5
404 | 0 | 31.5 | 0 | 33 | 0 | 53 | 0 | 37 |  |  |  |  |  | 10.47 | 19.5
405 | 0 | 31.5 | 0 | 33 | 0 | 35 | 0 | 37 |  |  |  |  |  | 10.47 | 19.5
410 | 0 | 31.5 | 0 | 33 | 0 | 35 | 0 | 37 |  |  |  |  |  | 10.47 | 19.5
411 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
412 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
413 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
414 | 0 | 0 | 0 | 0 | 0 | 70 | 75 | 75 |  |  |  |  |  | 0 | 0
415 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
416 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
417 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
418 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
419 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0