Spreadsheet: 829497d1684259266-how-to-figure-weighted-average-burden-work-sheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Total Burden: | 5400000 |  | Tier 1 | 22 | 0.56
 |  |  |  |  |  |  |  |  |  |  | Billable Hours: | 4160 |  | [NAME] | 9 | 0.88
 |  |  |  |  |  |  |  |  |  |  | Burden / Hour: | 1298.076923076923 | 1073.863636363637 | Tier 3 | 8 | 1.12
 |  |  |  |  |  |  |  |  |  | 0.8272727272727277 | Machine Count | 44 |  | [NAME] | 5 | 1.44
Work | A GROUP |  | B GROUP |  | C GROUP |  | D GROUP |  |  |  |  |  |  | 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 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 24.42 | 20.34
102 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 24.42 | 20.34
103 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 24.42 | 20.34
104 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
105 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 104 | 2 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 24.42 | 21
106 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 24.42 | 20.34
107 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 24.42 | 20.34
108 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
109 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
110 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
111 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 2 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 24.42 | 20.34
112 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 | 0.02545454545454546 | 33.04195804195805 |  | 33.04195804195805 | 24.42 | 20.34
113 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
190 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
191 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
192 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
193 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 24.42 | 20.34
201 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
202 | 160 | 79.5 | 200 | 93.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
203 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
204 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
205 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
206 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
207 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
208 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
209 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
210 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 28.9 | 24.07
211 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 | 0.02545454545454546 | 33.04195804195805 |  | 33.04195804195805 | 28.9 | 24.07
212 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 28.9 | 24.07
213 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 28.9 | 24.07
214 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 | 0.02545454545454546 | 33.04195804195805 |  | 33.04195804195805 | 28.9 | 24.07
215 | 160 | 90.5 | 200 | 95 | 250 | 100 | 300 | 105 | 2 | 0.02 | 25.96153846153846 |  | 25.96153846153846 | 28.9 | 24.07
216 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 | 0.02545454545454546 | 33.04195804195805 |  | 33.04195804195805 | 27.85 | 23.19
217 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 | 0.02545454545454546 | 33.04195804195805 |  | 33.04195804195805 | 27.85 | 23.19
218 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 | 0.02545454545454546 | 33.04195804195805 |  | 33.04195804195805 | 27.85 | 23.19
219 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 | 0.02545454545454546 | 33.04195804195805 |  | 33.04195804195805 | 27.85 | 23.19
220 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
221 | 160 | 94.5 | 200 | 99 | 250 | 104 | 300 | 109 | 3 | 0.02545454545454546 | 33.04195804195805 |  | 33.04195804195805 | 27.85 | 23.19
299 | 160 | 79.5 | 200 | 83.5 | 250 | 87.5 | 300 | 92 | 1 | 0.01272727272727273 | 16.52097902097902 |  | 16.52097902097902 | 23.63 | 19.68
301 | 160 | 111.5 | 200 | 117 | 250 | 123 | 300 | 129 | 4 | 0.03272727272727272 | 42.48251748251748 |  | 42.48251748251748 | 34.42 | 28.66
302 | 160 | 111.5 | 200 | 117 | 250 | 123 | 300 | 129 | 4 | 0.03272727272727272 | 42.48251748251748 |  | 42.48251748251748 | 34.42 | 28.66
303 | 160 | 111.5 | 200 | 117 | 250 | 123 | 300 | 129 | 4 | 0.03272727272727272 | 42.48251748251748 |  | 42.48251748251748 | 34.42 | 28.66
304 | 160 | 111.5 | 200 | 117 | 250 | 123 | 300 | 129 | 4 | 0.03272727272727272 | 42.48251748251748 |  | 42.48251748251748 | 34.42 | 28.66
305 | 160 | 111.51 | 200 | 117 | 250 | 123 | 300 | 129 | 4 | 0.03272727272727272 | 42.48251748251748 |  | 42.48251748251748 | 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