Spreadsheet: 126345d1319644648-fluctuating-breakeven-analysis-manufacturing-absorption-values-forums-version
Sheet: Sheet2

 | 2011 | Bottler | Plant | Vol | Sales | [NAME] | Margin | Absorp | Vol | Sales | [NAME] | Margin | Absorp |  | 2012 | Bottler | Plant | Vol | Sales | [NAME] | Margin | Absorp
 |  | CCR |  | 4904535 | 32048622 | 30888072.65 | 1160549 |  |  |  |  |  |  |  |  | CCR
 |  |  | 258_MOBILE CS | 2401688 | 12525800 | 12049105.96 | 476694 |  |  |  |  |  |  |  |  |  | 258_MOBILE CS
 |  |  | 098_NASHVILLE CS | 1004058 | 6284025 | 6138575.12 | 145450 |  |  |  |  |  |  |  |  |  | 098_NASHVILLE CS
 |  |  | 219_ROANOKE CS | 804296 | 4108856 | 3971606.11 | 137249 |  |  |  |  |  |  |  |  |  | 219_ROANOKE CS
 |  |  | 054_SNYDER CS | 694493 | 9129941 | 8728785.46 | 401155 |  |  |  |  |  |  |  |  |  | 054_SNYDER CS
 |  | WESTERN KENTUCKY |  | 2848200 | 17246915 | 17025927.68 | 220987 |  |  |  |  |  |  |  |  | WESTERN KENTUCKY
 |  |  | 098_NASHVILLE CS | 2004797 | 11455955 | 11327410.79 | 128544 |  |  |  |  |  |  |  |  |  | 098_NASHVILLE CS
 |  | STARKVILLE | 258_MOBILE CS | 706022 | 5010560 | 4936745.39 | 73815 |  |  |  |  |  |  |  |  | STARKVILLE | 258_MOBILE CS
 |  |  | 054_SNYDER CS | 135981 | 772641 | 754240.6 | 18401 |  |  |  |  |  |  |  |  |  | 054_SNYDER CS
 |  |  | 219_ROANOKE CS | 1400 | 7759 | 7530.91 | 228 |  |  |  |  |  |  |  |  |  | 219_ROANOKE CS
 |  | MIDDLESBORO |  | 1426885 | 7379662 | 7290794.65 | 88867 |  |  |  |  |  |  |  |  | MIDDLESBORO
 |  |  | 219_ROANOKE CS | 1205393 | 6160175 | 6089635.33 | 70539 |  |  |  |  |  |  |  |  |  | 219_ROANOKE CS
 |  |  | 054_SNYDER CS | 221492 | 1219487 | 1201159.33 | 18328 |  |  |  |  |  |  |  |  |  | 054_SNYDER CS
 |  | UNITED |  | 895641 | 5972205 | 5736391.42 | 235813 |  |  |  |  |  |  |  |  | UNITED
 |  |  | 054_SNYDER CS | 761679 | 5140479 | 4932577.45 | 207902 |  |  |  |  |  |  |  |  |  | 054_SNYDER CS
 |  |  | 098_NASHVILLE CS | 115574 | 748188 | 722752.42 | 25436 |  |  |  |  |  |  |  |  |  | 098_NASHVILLE CS
 |  |  | 219_ROANOKE CS | 18388 | 83537 | 81061.55 | 2475 |  |  |  |  |  |  |  |  |  | 219_ROANOKE CS
 |  |  | 258_MOBILE CS | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 258_MOBILE CS
 |  | MERIDIAN | 258_MOBILE CS | 471130 | 3179597 | 3138277 |  |  |  |  |  |  |  |  |  | MERIDIAN | 258_MOBILE CS
 |  | WEAVER (Corinth) | 098_NASHVILLE CS | 736018 | 4923866 | 4829172.46 | 94693 |  |  |  |  |  |  |  |  | WEAVER (Corinth) | 098_NASHVILLE CS
 |  | Pulaski | 098_NASHVILLE CS | 99288 | 556000 | 548216 |  |  |  |  |  |  |  |  |  | Pulaski | 098_NASHVILLE CS
 |  | Union City | 098_NASHVILLE CS | 183187 | 1164526 | 1158631 |  |  |  |  |  |  |  |  |  | Union City | 098_NASHVILLE CS
 |  | [NAME] | 219_ROANOKE CS | 340748 | 1713976 | 1691505 |  |  |  |  |  |  |  |  |  | [NAME] | 219_ROANOKE CS
 |  | Northern Neck | 219_ROANOKE CS | 123497 | 620099 | 622419 |  |  |  |  |  |  |  |  |  | Northern Neck | 219_ROANOKE CS
 |  | TULLAHOMA | 098_NASHVILLE CS | 590933 | 4080829 | 4001467.39 |  |  |  |  |  |  |  |  |  | TULLAHOMA | 098_NASHVILLE CS
 |  | LBH | 098_NASHVILLE CS | 140250 | 743570 | 726815 |  |  |  |  |  |  |  |  |  | LBH | 098_NASHVILLE CS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sold prod & purch
 |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | 098_NASHVILLE CS |  |  |  |  |  |  |  |  |  |  |  |  |  | 098_NASHVILLE CS
 |  |  | 258_MOBILE CS |  |  |  |  |  |  |  |  |  |  |  |  |  | 258_MOBILE CS
 |  |  | 054_SNYDER CS |  |  |  |  |  |  |  |  |  |  |  |  |  | 054_SNYDER CS
 |  |  | 219_ROANOKE CS |  |  |  |  |  |  |  |  |  |  |  |  |  | 219_ROANOKE CS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sold just production
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absorption lost with recalclated rates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lost prod & purch |  |  |  | Absorption
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DIFFERENCE 2011 vs 2012 |  |  |  |  |  | Lost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Using July rates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 098_NASHVILLE CS |  |  |  | 098_NASHVILLE CS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 258_MOBILE CS |  |  |  | 258_MOBILE CS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 054_SNYDER CS |  |  |  | 054_SNYDER CS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 219_ROANOKE CS |  |  |  | 219_ROANOKE CS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lost just production
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL LOST MARGIN & ABSORPTION