vlookup help

R

Roosterfosho

New Member
Joined
Mar 18, 2013
Messages
5
Hey guys quick question here, I'm familiar with vlookup and hlookup, but with this accounting course I'm currently in it's a huge table and that kind of overwhelms me.

The question is :1. Using the provided data and income statement template use the "vlookup" function in Excel to create a forecast to actual comparison for the current quarter to the preceding quarter and the current quarter compared to the prior year same quarter (Tip: number to the columns on the 'IS Data' tab for quick reference). Make sure the check figure at the bottom of the schedule is equal to zero.

Car Co.
Q1 Forecast to Actual Comparison
3/31/2010
<--------------- Current Quarter compared to Prior Quarter ----------------><--------------- Current Quarter compared to Prior Year Same Quarter ---------------->
Forecast Actual Forecast Actual
3/31/10As a % of12/31/09As a % of 3/31/10As a % of3/31/09As a % of
QTDNet SalesQTDNet SalesDifferenceQTDNet SalesQTDNet SalesDifference
clip_image001.png

<tbody>
</tbody>
Net Sales-Outsiders 1,286,766,4440.0%
Net Sales-Intercompany 0
Net Sales-Total 1,286,766,444
Materials @ Standard Plus Variances 667,816,823
Raw Material Sale of Scrap (5,029,671)
Freight-in Materials 9,449,780
Inventory Rev. - New Std (Non US Units) (1,853,389)
Supplies Utilities & Other Overhead 142,500,445
Direct & Indirect Employee Costs 193,827,651
Direct Charges Except Employees 38,277,767
Subtotal Spending Except Materials 374,605,863
Labor & Overhead @ Standard 214,444,958
Labor & Overhead Applied to Inventory 220,915,105
Total Cost of Sales 1,042,226,03681% -#DIV/0!#DIV/0! -#DIV/0! -#DIV/0!#DIV/0!
Gross Profit-Actual 244,540,40719% -#DIV/0!#DIV/0! -#DIV/0! -#DIV/0!#DIV/0!
Selling Expense- Employee Costs
Selling Expense- Other
Total Selling Expense -0% -#DIV/0!#DIV/0! -#DIV/0! -#DIV/0!#DIV/0!
Admin Expense-Employee Costs
Administrative Expense-Other
Total Administrative Expense -0% -#DIV/0! - -#DIV/0! -#DIV/0! -
Operations Expense
Total Selling Admin & Operating -0% -#DIV/0! - -#DIV/0! -#DIV/0! -
Other Income
Restructuring Expense
Operating Income before Allocations 244,540,40719% -#DIV/0! 244,540,407 -#DIV/0! -#DIV/0! -
Operations - I/C Management Fees
Operating Income after Allocations 244,540,40719% -#DIV/0! 244,540,407 -#DIV/0! -#DIV/0! -
Total Interest Expense
Loss/(Gain) on Sale of Business
Inventory Profits
Corporate Headquarter Expense
Intercompany Expense
Intercompany Royalty Elimination
Depreciation of Fixed Asset Write-ups
For Corporate Use Only
Allocated Tax Expense
Net Income Before Taxes 244,540,40719% -#DIV/0!#DIV/0! -#DIV/0! -#DIV/0!#DIV/0!
Federal Taxes
Earnings-Equity Affiliates
Extraordinary Gain/Loss
Net Inc Bef Min Int. 244,540,40719% -#DIV/0!#DIV/0! -#DIV/0! -#DIV/0!#DIV/0!
Minority Interest in Earnings -
Net Income 244,540,40719% -#DIV/0!#DIV/0! -#DIV/0! -#DIV/0!#DIV/0!
Net Income
Check 244,540,407 - - - -
QTD Column to pull 23


<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>




That is the table I need to plug the values into, but here is the actual sheet in which the values are located:

1234567891011121314151617181920212223
Quarter to Date Q1 2011 - ActualQuarter to Date Q4 2011 - ActualQuarter to Date Q1 2012 - Forecast
Reporting Unit Wheels & TiresPaintEngineInteriorsTransmissionAssemblyTotalWheels & TiresPaintEngineInteriorsTransmissionAssemblyTotalWheels & TiresPaintEngineInteriorsTransmissionAssemblyTotal1
clip_image001.png

<tbody>
</tbody>
 2
Gross Sales 52,901,667 93,817,042 368,913,145 110,629,787 142,818,486 56,701,797 825,781,924 62,955,277 157,495,677 502,275,294 134,137,742 259,636,213 91,853,001 1,208,353,203 71,092,610 171,839,521 530,102,345 135,980,401 283,231,627 104,443,045 1,296,689,5493
Sale Returns (75,987)(67,650)(2,305,571)(2,371,384)(1,373,437)(92,778)(6,286,806)(60,490)(138,957)(4,671,732)(3,138,225)(2,038,402)(30,536)(10,078,342) 40,848(34,211)(4,587,191)(3,461,339)(1,858,334)(22,878)(9,923,105)4
Net Sales-Outsiders 52,825,680 93,749,392 366,607,575 108,258,403 141,445,049 56,609,019 819,495,118 62,894,788 157,356,720 497,603,561 130,999,516 257,597,811 91,822,465 1,198,274,861 71,133,458 171,805,310 525,515,154 132,519,062 281,373,294 104,420,167 1,286,766,4445
Net Sales-Intercompany 740,705 2,436,482 1,382,568 0 1,020,113 153 153 528,821 3,889,032 1,459,607 384 3,902,952 5,226 384 226,475 4,973,885 1,217,882 0 3,981,181 1,952 06
Net Sales-Total 53,566,385 96,185,874 367,990,143 108,258,403 142,465,162 56,609,172 819,495,271 63,423,609 161,245,752 499,063,168 130,999,901 261,500,763 91,827,691 1,198,275,245 71,359,933 176,779,195 526,733,035 132,519,062 285,354,475 104,422,119 1,286,766,4447
Materials @ Standard Plus Variances 24,446,536 34,659,427 227,608,380 45,943,698 72,224,522 35,158,206 434,460,902 27,926,501 52,458,540 286,507,682 59,766,556 136,222,165 56,507,073 609,602,878 34,071,167 61,809,675 305,640,098 59,369,955 154,824,928 62,502,375 667,816,8238
Raw Material Sale of Scrap (54,771)(75,983)(404,681)(18,863)(1,164,287)(30,613)(1,749,198)(119,084)(219,840)(775,097)(183,099)(3,227,041)(61,786)(4,585,947)(88,363)(222,102)(677,848)(104,758)(3,818,829)(117,771)(5,029,671)9
Freight-in Materials 590,306 794,648 2,325,234 90,873 997,318 968,694 5,767,072 761,511 1,980,001 4,514,558 87,565 1,843,327 996,330 10,183,292 589,032 2,111,492 4,546,536 171,163 1,343,894 687,662 9,449,78010
Inventory Rev. - New Std (Non US Units) 13,071 281,618 876,897 0(464,430) 69,486 776,642(33,031)(485,804)(1,810,037) 0(512,697) 18,177(2,823,393)(1,141)(369,333)(1,659,380) 0 187,242(10,776)(1,853,389)11
Maintenance 538,703 1,259,817 3,109,378 1,297,988 5,186,431 476,163 11,868,480 546,184 2,471,318 3,976,826 1,735,462 5,940,456 548,125 15,218,371 832,503 2,240,628 4,658,277 1,520,190 6,616,888 560,047 16,428,53312
Perishable Tools 296,281 1,753,897 2,463,410 1,286,983 1,389,507 423,503 7,613,582 460,757 2,605,484 3,152,084 1,436,286 2,348,199 1,003,576 11,006,385 395,809 2,695,571 3,372,452 1,153,241 3,365,617 972,703 11,955,39113
Utilities 919,076 3,211,588 2,081,461 2,311,131 3,837,618 1,849,546 14,210,419 896,101 3,055,164 2,362,733 2,724,568 3,996,563 855,143 13,890,273 787,634 3,502,049 2,214,080 2,587,020 4,583,656 976,761 14,651,19914
Supplies Depreciation 1,280,987 8,614,104 11,390,479 6,885,015 9,255,259 2,882,729 40,308,572 1,316,578 10,368,676 12,104,514 8,287,427 9,961,086 2,203,642 44,241,925 1,183,060 9,223,104 9,870,603 6,945,590 9,834,045 2,164,291 39,220,69315
Rental -Operating Leases 277,757 372,490 1,713,363 300,950 936,530 193,523 3,794,613 276,711 497,458 1,868,047 338,233 980,534 243,053 4,204,037 299,765 325,162 1,322,703 283,150 919,592 167,567 3,317,94016
Insurance 130,836 263,871 614,058 144,420 494,937 209,201 1,857,324 189,691 299,552 418,712 245,061 594,675 158,134 1,905,824 134,171 275,595 446,276 179,087 592,816 136,505 1,764,45117
Workers Comp & Oth Self Insured Losses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 018
Patent Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 019
Legal 5,545 35,488 0 0 294,819 2,469 338,321 63,718 50,113 0 41,901 190,318 28,825 374,875 6,462 21,810 2,367 0 225,184 459 256,28220
Real Estate and Property Taxes 130,477 274,513 235,903 355,851 534,343 991,315 2,522,401 133,509 261,985 213,584 239,672 446,926 300,205 1,595,881 103,126 396,120 293,383 265,721 586,464 293,903 1,938,71621
Amortization of Capital Leases 0 0 2,663 0 0 0 2,663 0 0 34,922 0 0 0 34,922 0 0 0 0 0 0 022
Routine Engineering-Non Employee Costs 30,709 0 0 581,691 56,519 3,773,417 4,442,337 78,236 0 0 361,577(41,937) 2,440,706 2,838,582 35,127 0 0 1,216,440(74,640) 2,424,589 3,601,51623
Tools, Dies-Amortized and Charged, Net 807,492 892,302 4,640,607 374,686 1,600,292 1,608,901 9,924,280 989,636 771,968 5,008,279 382,610 1,269,978 1,082,552 9,505,024 1,023,225 693,795 4,714,983 338,540 1,394,870 1,013,320 9,178,73324
Gain/Loss on Customer Tooling (1,317) 18,338(1,761,095) 0(221,656) 0(1,965,731)(61,762)(151,326)(3,465,541) 0(617,605)(283,527)(4,579,761)(38,089)(14,826)(1,835,518) 0(66,971) 0(1,955,404)25
Outside Production 36,790 400,255 398,039 0 732,072 27,514 1,594,670 70,984 1,018,846 611,171 0 1,746,423 130,606 3,578,030 146,481 943,380 852,573 0 2,266,106 211,246 4,419,78626
Travel/Entertainment 71,206 169,995 355,310 207,213 262,647 107,018 1,173,388 124,290 558,877 908,798 320,998 601,606 138,686 2,653,255 112,543 442,023 925,026 252,579 577,192 129,240 2,438,60427
Other 4,626,917 4,321,800 7,593,574 814,964 4,796,151 2,545,601 24,699,006 2,815,127 6,404,772 6,867,805 973,365 10,234,468 2,045,842 29,341,380 4,086,878 5,985,867 7,826,426 816,509 8,915,612 2,476,375 30,107,66828
Supplies Utilities & Other Overhead 9,151,459 21,588,457 32,837,149 14,560,893 29,155,469 15,090,899 122,384,326 7,899,760 28,212,889 34,061,934 17,087,161 37,723,013 10,965,302 135,950,059 9,882,486 27,831,390 36,469,304 15,856,945 40,728,565 11,731,755 142,500,44529
IT Central Allocation Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75,149 338,820(258,489) 60,930 180,255 71,897 468,56330
IT - Outside Consulting Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71,453 346 305,840 16,115 25,434 39,635 458,82231
Depreciation Expense - IT Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 304,183 156,500 760,532 1,563 123,357 12,955 1,359,08932
IT - Voice Communications Expense 0 0 0 0 0 0 0 0 0 0 0 17,631 24,776 42,407 43,919 103,403 138,165 52,146 110,851 44,147 492,63133
IT - Data Communications Expense 0 0 0 0 0 0 0 0 0 0 0 14,606 0 14,606 137 54,719 88,839 32,088 134,678 12,602 323,06334
IT Telecom Expenses - Total 0 0 0 0 0 0 0 0 0 0 0 32,237 24,776 57,013 44,056 158,121 227,004 84,234 245,529 56,749 815,69435
IT Software and Hardware Maintence and Support Fees 0 0 0 0 0 0 0 0 0 0 0 8,536 0 8,536 60,992 87,062 636,291 83,594 228,567 1,398 1,097,90436
IT Hosting Services Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2,848 2,434 0 41,058 6,941 2,347 55,62837
IT Software Expense 0 0 0 0 0 0 0 0 0 0 0 18,265 0 18,265 9,650 167,513 4,321 0 43,902 5,572 230,95838
IT Lease Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 180 55,559 125,791 0 36,188 3,386 221,10439
IT Hardware Expense 0 0 0 0 0 0 0 0 0 0 0 838 0 838 5,506 86,416 80,392 10,827 63,187 886 247,21440
IT Office Expense 0 0 0 0 0 0 0 0 0 0 0 5,513 44,959 50,472 339 22,324 10,647 131 31,394 8,724 73,55841
IT Travel Expense 0 0 0 0 0 0 0 0 0 0 0 5,933 0 5,933 1,771 5,535 6,049 426 7,270 300 21,35242
Supplies - IT 0 0 0 0 0 0 0 0 0 0 0 71,323 69,735 141,058 773,791 1,101,112 1,805,674 298,878 992,132 204,752 5,176,33943
Direct Labor 3,106,165 6,128,285 15,845,936 8,835,273 11,311,732 2,900,969 48,128,360 3,009,272 9,853,748 19,595,436 10,913,348 17,478,303 2,047,270 62,897,377 3,241,002 10,228,359 19,010,740 10,016,457 19,834,846 1,639,616 63,971,02144
Supervision/Clerical 331,835 6,789,625 1,015,037 0 1,579,516 1,967,335 11,683,349 387,353 6,060,225 980,733 0 1,504,993 737,213 9,670,518 354,498 6,422,725 1,111,679 0 1,549,868 695,086 10,133,85645
Set up 59,590 26,113 0 0 0 63,327 149,030 40,151 34,696 0 0 0 70,561 145,408 48,449 35,551 0 0 0 111,749 195,74946
Maintenance 461,368 1,026,551 272,944 1,143,178 2,308,020 1,627,085 6,839,146 419,633 1,517,098 220,955 1,221,057 1,315,032 391,709 5,085,484 461,914 1,472,370 264,222 1,263,918 1,427,877 513,213 5,403,51647
Moving & Rearranging 240,125 324,128 759,576 293,002 12,527 0 1,629,358 217,170 524,887 631,914 344,835 12,919 4,640 1,736,366 213,456 569,416 699,939 348,386 17,816 8,992 1,858,00648
Reoperations-Rework 962 15,049 0 0 0 120,273 136,284 0 30,059 0 0 0 0 30,059 4,828 17,178 0 0 0 0 22,00649
Overtime Premium 74,442 571,545 221,096 0 466,463 299,941 1,633,487 81,940 1,487,114 679,653 0 1,513,205 211,930 3,973,842 78,991 1,494,093 853,265 0 1,428,736 322,710 4,177,79550
Shift Premium 99,183 148,401 1,164,422 0 455,805 9,180 1,876,991 130,812 268,017 1,672,127 0 724,330 25,407 2,820,693 98,784 244,942 1,518,707 0 751,415 27,068 2,640,91651
Inspection & Testing 181,930 395,351 217,360 413,484 641,544 48,946 1,898,614 188,097 704,400 186,271 499,448 729,308 66,788 2,374,312 187,382 724,147 198,046 453,419 996,944 112,996 2,672,93552
Routine Engineering 0 1,310 22,200 0 1,102,528 121,256 1,247,294 0 32,643 79,157 0 925,048 96,356 1,133,205 0 33,602 64,707 0 1,005,764 142,918 1,246,99153
Office Personnel 2,356,456 732,279 8,995,968 1,967,272 4,765,950 1,248,848 20,066,772 2,206,466 1,021,518 10,516,948 1,785,578 4,641,914 1,651,279 21,823,703 2,119,244 1,003,331 9,772,251 1,993,934 5,030,343 1,703,749 21,622,85354
IT Salaries and Wages 0 0 0 0 0 0 0 0 0 0 0 6,666 0 6,666 81,252 251,220 328,073 23,876 273,479 17,706 975,60755
Indirect Labor - Other 1,531,147 1,171,572 3,863,771 5,863,156 1,448,893 377,670 14,256,209 1,194,803 1,138,951 4,848,251 6,669,135 1,671,438 1,872,062 17,394,639 1,126,271 1,593,810 5,375,832 6,012,986 1,777,465 2,385,568 18,271,93256
Indirect Labor 5,337,038 11,201,922 16,532,374 9,680,091 12,781,247 5,883,862 61,416,534 4,866,425 12,819,608 19,816,009 10,520,053 13,044,855 5,127,944 66,194,894 4,775,071 13,862,386 20,186,722 10,096,519 14,259,710 6,041,754 69,222,16257
Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 058
Utilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 059
Perishable Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 060
Maint(Inc. Supplies) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 061
Fringe Benefits 2,423,766 6,689,042 14,871,104 5,800,654 9,800,591 3,311,263 42,896,420 2,232,347 6,047,874 13,852,932 6,750,823 9,689,816 1,863,755 40,437,548 2,009,620 6,690,841 16,935,353 5,701,367 10,746,673 1,665,790 43,749,64462
IT Fringe Benefits 0 0 0 0 0 0 0 0 0 0 0 991 0 991 17,622 60,777 119,344 9,269 138,787 1,947 347,74663
Employee Costs MIP expense 0 14,706 3,348 0 0(83,266)(65,212) 841,348 3,269,858 1,478,101 591,069 2,217,497 729,335 9,127,209 159,686 789,791 437,413(54,911) 225,335(87,467) 1,469,84864
IT Fringe Benefits 0 0 0 0 0 0 0 0 0 0 0 991 0 991 17,622 60,777 119,344 9,269 138,787 1,947 347,74665
Employee Costs EIP expense 0 13,347(35,703) 0 9,489(20,363)(33,229) 589,584 3,894,729 3,129,751 470,667 2,229,259 1,474,707 11,788,696 168,070 1,299,340 1,746,572(11,831) 283,696 332,872 3,818,72066
IT Employee Costs - Employee Incentive Plan (EIP) Expense 0 0 0 0 0 0 0 0 0 0 0 6,613 0 6,613 0(5,785) 21,970 0 1,669 1,588 19,44367
Pension Expense 114,532 668,908 942,118 245,171 1,018,441 569,216 3,558,385 121,401 1,567,412 537,199 341,623 1,615,015 808,432 4,991,081 128,752 704,713 693,185 403,737 1,348,887(17,713) 3,261,56168
IT Employee Cost Pension Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6,977 3,030 1,313 3,910 269 15,49969
Emp Cost - Post Ret. Benefits 69,850 204,217 21,989 490,431 1,271 450,750 1,238,508 62,371 203,696 21,989(539,910) 1,271 450,738 200,155 83,649 207,350 22,500 184,431 0 493,726 991,65670
IT Emp Cost - Post Ret. Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 071
Employee Cost Defined Contribution Plan 487,809 721,743 489,384 0 793,043 485,488 2,977,468 266,446 872,975 936,994 0 669,316 273,898 3,019,629 257,486 955,971 709,894 0 964,544 486,898 3,374,79272
IT Employee Cost Defined Comtribution Plan 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,056 9,680 4,216 0 3,415 0 18,36773
Employee Cost Workers Comp 75,384 215,512 49,339 0 282,430 93,107 715,771 93,018 218,209 70,060 0 247,501 31,892 660,679 88,681 283,593 45,490 0 313,832 21,338 752,93474
IT Employee Cost Workers' Comp 0 0 0 0 0 0 0 0 0 0 0 0 0 0 153 0 0 0 0 0 15375
Stock Option Comp Exp - Manuf Alloc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 076
IT - Stock Option Comp Exp - Manuf Alloc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 077
Government Employee Cost Reimbursement 0(22,940)(50,359)(357,298)(941,998)(8,754)(1,381,349) 0(35,933)(4,085)(311,068)(40,561)(965)(392,612) 0 0 0(218,296)(488) 0(218,784)78
IT - Government Employee Cost Reimbursement 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0(27,061) 0 0(27,061)79
Other 141,745 244,199 2,637(332,764) 206,999 35,909 298,724(2,568) 279,109 6,768 1,045,472 409,304 3,541 1,741,626 110,653 558,262 2,001 1,502,754 191,944 15,415 2,381,03080
IT Employee Cost - Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14,201 11,583 0 217 923 0 26,92481
Direct & Indirect Employee Costs 11,756,288 26,078,942 48,672,167 24,361,558 35,263,244 13,618,181 159,750,380 12,079,645 38,991,285 59,441,152 29,782,078 47,867,014 12,810,548 200,971,722 11,055,703 36,290,829 59,959,038 27,603,966 48,322,083 10,596,033 193,827,65182
Employee Costs and Supplies Total 20,907,746 47,667,399 81,509,315 38,922,451 64,418,714 28,709,081 282,134,706 19,979,404 67,204,174 93,503,086 46,869,239 85,590,027 23,775,850 336,921,781 20,938,188 64,122,219 96,428,342 43,460,911 89,050,648 22,327,789 336,328,09683
Indirect Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 084
Royalties Expense 0 59,476 9,212 260,568 0 3,220 332,475 0 62,500 58,367 13,895 9,272 410 144,444 0 62,500 15,000 190,555 35,224 543 303,82385
Amortization-Patents 0 0 0 353,856 0 0 353,856 0 0 0(133,799) 0 0(133,799) 0 0 0 291,797 0 0 291,79786
Packing and Shipping 30,252 314,392 867,280 228,098 332,829 76,597 1,849,449 57,192 691,794 979,162 510,020 999,472 616,870 3,854,511 55,456 899,619 1,131,489 459,383 1,164,831 428,041 4,138,81987
Sale of Scrap (100,593)(238,716)(341) 0 0(3,640)(343,291)(188,689)(752,816)(773) 0 0(13,705)(955,983)(240,025)(1,140,558) 0 0 0(8,414)(1,388,996)88
Rental Expense(Operating Leases) 0 0 3,245 856,358 11,905 17,525 889,032 0 0 6,416 937,809 46,276 17,855 1,008,355 0 0 5,610 80,219 39,489 18,642 143,96089
Warranty 514,504 154,252(253,659)(954,563) 398,707 291,469 150,709 2,151,968 2,139,253 9,520,277(1,306,060) 2,072,749(464,263) 14,113,925 1,049,511 1,174,353 6,272,182 769,923 407,586 218,842 9,892,39890
Slow Moving Inventory Allowance 80,581 100,286 665,629 125,711 144,775 396,609 1,513,591 352,402 4,971 920,276(784,709)(111,428) 256,855 638,367(24,784) 129,861 428,021(451,738)(107,170) 29,429 3,62091
Obsolete and Defective Inventory Allowance (26,310) 265,969 228,475(346,890)(2,469) 815,586 934,362(176,034)(103,230) 622,641 217,482 326,434(469,830) 417,461 45,796(188,333) 190,915(51,801) 86,241 163,973 246,79192
Inventory Shrinkage Allowance (2,620) 159,505 83,846 0 1,043,512 132,388 1,416,633 279,674 170,290 161,551(418,879) 444,459(254,906) 382,190 59,765 352,997 457,089 103,823 472,670 50,904 1,497,24793
Inventory Market Revaluation Allowance 0(127,204)(53,713)(275,665) 93,526 0(363,055)(20,403)(141,833)(499,475)(47,864) 176,395(600)(533,779)(1,992)(62,555)(3,776) 186,623(17,246) 0 101,05394
MRO Valuation Allowance 0(449,189) 135,672 0(996,085) 112,413(1,197,189)(41,737) 137,811 1,056,676 341,939 297,016(35,864) 1,755,842 0 138,957 202,758 68,868(866,477) 15,989(439,905)95
Inventory Adjustments 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 096
Product Start-up Costs 0 154,547 3,917 21,571 179,012 1,149,725 1,508,770 0 464,248 18,123 158,602 48,995 364,542 1,054,511 0 774,346 296,995 135,160 106,926 101,986 1,415,41297
Freight-out (Net) 296,673 725,361 431,830 848,268 233,582(3,752) 2,531,963 405,256 1,121,056 519,822 1,090,694 481,629 24,261 3,642,719 539,732 1,160,482 727,003 923,587 676,161 82,371 4,109,33798
Expedited/Special Freight 69,299 184,914 414,465 0 240,178 18,890 927,746 210,625 1,458,484 1,775,107 0 2,125,718 1,056,318 6,626,252 241,895 1,359,408 1,730,556 0 958,947 168,484 4,459,29199
Unplanned Outsourcing 0 1,421 0 0 10,600 0 12,021 0 62,211 0 0 39,111 0 101,322 0 48,166 0 0 42,476 0 90,641100
Duties 28,451(28,847) 188 3,527 38,774 17,520 59,612 62,228(59,598) 9,260 5,582 84,616 24,759 126,847 65,537(44,352) 21,700 3,112 122,121 28,787 196,903101
Other 45,571 479,819 24,827 1,424,075 194,101(360,111) 1,808,281 89,448 324,368 15,192 1,015,205 72,115 229,794 1,746,123 138,476 5,282,794 20,642 521,034 146,577(94,576) 6,014,947102
Supplier Chargebacks (110,791)(15,081)(9,849,000) 0(27,380) 70,151(9,932,101) 4,228(49,198)(9,768,808) 0(617,086)(541,709)(10,972,573)(6,684)(32,727) 0 0(369,251)(66,550)(475,212)103
Scrap 361,949 726,499 1,873,035 0 2,006,151 305,078 5,272,712 338,748 1,366,973 3,489,244 0 4,374,687 447,428 10,017,080 360,777 1,396,522 2,069,663 0 4,103,584 478,951 8,409,496104
Amortization of Def. Gov. Grant Income 0 0 0(15,078)(629,305)(61,873)(706,256) 0 0 0(60,844)(537,003)(1,841)(599,688) 0 0 0(18,418)(715,238) 0(733,656)105
Impairment Loss 73,018 0(8,778) 0 0 0 64,240 35,503 579,422(18,252) 0 83,999(4,664,366)(3,983,693) 0 0 0 0 0 0 0106
Direct Charges Dividends I/C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0107
Other 45,571 479,819 24,827 1,424,075 194,101(360,111) 1,808,281 89,448 324,368 15,192 1,015,205 72,115 229,794 1,746,123 138,476 5,282,794 20,642 521,034 146,577(94,576) 6,014,947108
Direct Charge Slow Moving Inv Allow 80,581 100,286 665,629 125,711 144,775 396,609 1,513,591 352,402 4,971 920,276(784,709)(111,428) 256,855 638,367(24,784) 129,861 428,021(451,738)(107,170) 29,429 3,620109
Dir Charge Obsolete and Defect Inv (26,310) 265,969 228,475(346,890)(2,469) 815,586 934,362(176,034)(103,230) 622,641 217,482 326,434(469,830) 417,461 45,796(188,333) 190,915(51,801) 86,241 163,973 246,791110
Inventory Shrinkage Allowance (2,620) 159,505 83,846 0 1,043,512 132,388 1,416,633 279,674 170,290 161,551(418,879) 444,459(254,906) 382,190 59,765 352,997 457,089 103,823 472,670 50,904 1,497,247111
Inv Market Revaluation Allow 0(127,204)(53,713)(275,665) 93,526 0(363,055)(20,403)(141,833)(499,475)(47,864) 176,395(600)(533,779)(1,992)(62,555)(3,776) 186,623(17,246) 0 101,053112
MRO Valuation Allowance 0(449,189) 135,672 0(996,085) 112,413(1,197,189)(41,737) 137,811 1,056,676 341,939 297,016(35,864) 1,755,842 0 138,957 202,758 68,868(866,477) 15,989(439,905)113
Direct Charges Except Employees 1,259,984 2,467,404(5,423,870) 2,529,836 3,272,412 2,977,793 7,083,559 3,560,411 7,476,706 8,864,808 1,539,073 10,417,425(3,407,991) 28,450,431 2,283,460 11,311,480 13,565,847 3,212,127 6,287,451 1,617,401 38,277,767114
Subtotal Spending Except Materials 22,167,730 50,134,803 76,085,445 41,452,287 67,691,126 31,686,874 289,218,265 23,539,815 74,680,880 102,367,894 48,408,311 96,007,453 20,367,859 365,372,212 23,221,649 75,433,699 109,994,189 46,673,038 95,338,099 23,945,190 374,605,863115
Labor & Overhead @ Standard 8,041,119 31,332,925 59,172,376 0 38,833,073 11,919,012 149,298,505 14,487,095 55,925,666 79,300,833 0 60,075,283 18,518,544 228,307,420 14,736,725 56,380,953 85,692,437 0 45,188,811 12,446,031 214,444,958116
Labor & Overhead Appld Inv. Risk 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0117
Labor & Overhead Applied to Inventory 7,233,473 28,729,881 55,893,758 0 33,385,252 12,034,954 137,277,318 14,762,386 57,821,736 79,145,871 0 61,813,229 19,059,763 232,602,985 14,802,173 57,226,629 89,620,564 0 46,595,006 12,670,733 220,915,105118
Total Cost of Sales 47,944,376 87,834,321 308,016,099 87,467,995 145,660,930 67,597,733 738,941,587 51,866,483 127,489,316 394,580,036 108,079,333 229,620,655 77,250,080 979,100,264 57,729,179 138,656,422 417,234,227 106,109,398 246,094,656 86,803,530 1,042,226,036119
Gross Profit-Actual 5,622,009 8,351,553 59,974,044 20,790,408(3,195,768)(10,988,561) 80,553,684 11,557,126 33,756,436 104,483,132 22,920,568 31,880,108 14,577,611 219,174,981 13,630,754 38,122,774 109,498,808 26,409,664 39,259,819 17,618,589 244,540,407120
Depreciation (Corp Use Only) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0121
Selling Salaries 525,019 1,028,376 2,584,690 3,331,070 772,614 525,976 8,767,746 582,973 1,040,757 2,836,344 3,833,917 758,516 331,527 9,384,033 585,974 1,124,150 2,770,425 3,657,239 910,128 423,777 9,471,694122
Selling Commissions 39,267 0 73,873 179,269 0 93,750 386,160 58,366 0 39,965 36,238 0(7,584) 126,984 40,486 0(0) 31,103 0 75,000 146,589123
Selling - Salaries/Commission 564,287 1,028,376 2,658,564 3,510,340 772,614 619,726 9,153,906 641,339 1,040,757 2,876,309 3,870,155 758,516 323,943 9,511,018 626,460 1,124,150 2,770,425 3,688,342 910,128 498,777 9,618,283124
Selling - Fringe Benefits 111,001 187,996 967,700 833,896 100,648 136,069 2,337,310 142,065 60,827 1,166,961 840,906 223,972 114,739 2,549,470 136,985 115,402 963,601 965,009 241,185 76,154 2,498,335125
Selling - MIP expense 0 0 0 0 0 0 0 141,065 252,958 561,361 413,363 808,848 250,630 2,428,227 22,950 273,325 223,203 0 101,554(6,679) 614,353126
Selling - EIP expense 0 9,470 13,142 0 0(5,114) 17,498 60,039 152,708 207,596 410,789 76,340 109,342 1,016,813 1,042 43,155 292,852(111,781) 28,976 24,195 278,439127
Selling - Pension Expense 15,931 38,780 33,987 29,540 83,823 0 202,062 17,902 52,884 45,839 82,168 95,728 0 294,522 24,685 40,511 27,577 61,251 101,231 0 255,255128
Selling - Post Ret. Benefits 0 294 0 47,965 0 0 48,259 0 100 0(280,398) 0 0(280,299) 0 181 0 0 0 0 181129
Selling - Workers' Comp. 0 0 0 0 1,235 0 1,235 1,554 0 0 0 4,131 0 5,685 1,454 0 0 0 281 0 1,734130
Selling - Defined Contribution Plan 25,086 29,846 66,922 0 17,709 27,260 166,823 19,844 29,692 72,330 0 13,978 16,873 152,717 26,050 37,829 60,705 0 18,300 18,055 160,940131
Marketing Salaries 30,239 14,414 72,977 0 0 0 117,630(22,382) 253 79,417 0 0 0 57,288 0 0 76,683 0 0 0 76,683132
Marketing - Fringe Benefits 3,648 8,437 11,831 0 0 0 23,915 158(2,614) 20,188 0 0 0 17,732 0 0 13,416 0 0 0 13,416133
Marketing - MIP expense 0 0 0 0 0 0 0 0 0 48,492 0 0 0 48,492 0 0 0 0 0 0 0134
Marketing - EIP expense (2,069) 0(14,232) 0 0 0(16,301) 12,344 0 27,465 0 0 0 39,809 0 0 0 0 0 0 0135
Selling Expense - Marketing 31,817 22,851 70,576 0 0 0 125,244(9,880)(2,361) 175,561 0 0 0 163,321 0 0 92,710 0 0 0 92,710136
Selling Expense- Employee Costs 748,122 1,317,612 3,810,891 4,421,740 976,030 777,941 12,052,337 1,013,929 1,587,564 5,105,957 5,336,983 1,981,513 815,527 15,841,473 839,625 1,671,951 4,433,478 4,602,822 1,401,794 610,502 13,560,173137
Selling Other 232,228 71,448 2,585,167 1,466,303 199,856 138,413 4,693,415 150,012 56,224 634,161 1,868,180 153,839 48,435 2,910,851 312,971(141,446) 2,710,050 1,481,104 198,029 147,756 4,708,463138
Selling Travel/Entertainment 123,567 81,502 292,555 273,916 75,467 41,042 888,049 171,613 277,922 554,517 418,862 219,468 110,339 1,752,721 164,113 179,163 485,881 315,848 118,547 89,538 1,353,091139
Selling Phone & Telegraph 17,197 15,520 67,285 40,468 9,637 11,403 161,509 24,603 26,948 91,409 51,102 18,735 7,382 220,179 15,243 7,131 58,533 16,459 3,116 2,139 102,621140
Selling Contributions 0 0 1,456 0 95,185 0 96,641 0 0(4,360) 0 110,229 0 105,869 0 31 1,523 0 2,500 0 4,054141
Selling Advertising & Public Relations 4,137 9,580 186,509 1,622,377 16,515 16,225 1,855,344(57) 2,604 278,481 1,628,872 5,976 43,867 1,959,743 16,976 1,157 171,283 1,337,108 23,867 0 1,550,392142
Selling Rental Exp.-Operating Leases 63,794 135,394 142,156 197,541 57,437 22,221 618,544 66,759 133,121 149,911 254,845 65,441 13,741 683,818 61,864 135,264 162,533 233,251 45,747 13,847 652,506143
Selling Amortization of Capital Leases 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0144
Selling Depreciation 3,184 12,338 63,684 69,886 6,327 15,185 170,604 3,453 11,981 57,316 71,426 7,128 0 151,304 3,232 11,838 34,794 74,812 1,276 0 125,952145
Selling - Sales of Prototypes 0 0(15,297) 0 0 0(15,297) 0 0(19,068) 0 0 0(19,068) 0 0 0 0 0 0 0146
Selling - Cost of Prototypes 0 0 6,290 0 0 1,094 7,384 483 0 17,977 0 0 165 18,625 0 0 0 0 0 0 0147
Marketing Travel/Entertainment 1,194 368 948 0 0 0 2,510(2,603) 881 6,024 0 0 0 4,301 0 0 3,838 0 0 0 3,838148
Market Research Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0149
Marketing Branding Expense (20,161)(1,552) 107,836 0 0 0 86,124 5,827 324 446,590 0 0 0 452,742 13,092 0 145,087 0 0 0 158,179150
Selling - Marketing Other 1,256 0 1,209 0 0 0 2,465 105 0(814) 0 0 0(709) 0 0 2,106 0 0 0 2,106151
Selling - Marketing Other (17,712)(1,184) 109,994 0 0 0 91,099 3,329 1,205 451,800 0 0 0 456,333 13,092 0 151,032 0 0 0 164,124152
Selling Expense- Other 426,396 324,598 3,439,800 3,670,492 460,425 245,583 8,567,293 420,195 510,004 2,212,144 4,293,287 580,816 223,929 8,240,375 602,240 210,129 3,905,650 3,458,582 407,677 255,464 8,839,743153
Total Selling Expense 1,174,518 1,642,210 7,250,691 8,092,232 1,436,455 1,023,525 20,619,630 1,434,123 2,097,568 7,318,101 9,630,269 2,562,329 1,039,456 24,081,848 1,441,865 1,882,080 8,339,128 8,061,404 1,809,472 865,967 22,399,916154
Administrative Salaries 479,558 682,386 3,551,132 1,778,017 2,426,177 1,439,249 10,356,520 525,500 473,011 3,863,075 2,068,693 1,550,993 1,224,984 9,706,256 326,601 532,141 2,996,564 963,739 1,645,223 733,264 7,197,532155
Administrative Fringe Benefits 109,854 79,664 1,004,212 336,989 646,769 451,706 2,629,193 275,492 48,599 1,177,971 491,955 441,332 224,294 2,659,644 405,151 71,516 1,601,166 156,260 390,866 215,699 2,840,660156
Admin - MIP expense 0 0(32,354) 0(65,870) 0(98,224) 1,752,407 3,417,840 2,636,982 1,653,453 3,392,730 1,975,592 14,829,004 334,113 783,424 420,477 0(191,890)(69,705) 1,276,419157
Admin - EIP expense 0 0(39,458) 0 0 4,150(35,308) 142,752 44,228 824,259 331,480 152,238 208,846 1,703,803 74,025 12,362 258,883(93,151)(26,284) 19,581 245,416158
Administrative Pension Expense 15,631 0 53,084 85,672 158,526 0 312,913 6,768 0(2,395)(100,866) 179,713 0 83,220 16,487 0 56,762 53,851 134,468 0 261,568159
Administrative Post Ret. Benefits 0(789) 6,979 127,818 4,125 0 138,133 0 0 6,979 18,060 4,125 0 29,164 0 0 7,500 120,520 4,125 0 132,145160
Administrative Workers' Comp 0 0 0 0 3,770 0 3,770 0 0 0 0 9,187 0 9,187 0 0 0 0 749 0 749161
Administrative Defined Cont. Plan 28,658 43,622 30,064 0 136,294 92,988 331,626 27,163 36,072 25,194 0 65,211 96,372 250,012 21,126 34,247 34,293 0 88,700 76,008 254,374162
Stock Option Comp Exp - Admin Alloc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0163
Admin - IT Stock Option Comp Expense Allocation 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0164
Administrative - IT Defined Cont. Plan Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,720 6,271 1,518 0 3,941 6,582 20,033165
Administrative - IT Worker's Comp Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0166
Administrative - IT Post Ret. Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0(1) 0 0(1)167
Administrative - IT Pension Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 583 31,297 36,995 0 68,874168
Admin - IT EIP Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4,275 57,856 0 8,126 857 71,115169
Admin - IT MIP expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33,223 0 5,760(1,055) 37,928170
Administrative - IT Fringe Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4,410 10,044 90,528 149,464 139,319 34,677 428,442171
Administrative - IT Salaries 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21,500 60,179 482,969 658,253 192,817 92,363 1,508,080172
Admin Expense - Total IT Employee Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27,630 80,769 666,740 839,013 386,959 133,424 2,134,535173
Admin Expense-Employee Costs 633,701 804,883 4,573,658 2,328,496 3,309,792 1,988,093 13,638,623 2,730,083 4,019,751 8,532,064 4,462,776 5,795,529 3,730,088 29,270,290 1,205,133 1,514,458 6,046,588 2,040,233 2,432,917 1,108,272 14,347,601174
Administrative Travel/Entertainment 45,723 2,004 395,971 153,684 287,493 90,917 975,792 72,221 77,323 939,087 79,239 283,874 234,285 1,686,028 81,934 166,676 789,091 90,457 288,878 312,690 1,729,725175
Administrative Phone & Telegraph 16,164 3,083 109,069 18,514 40,975 48,894 236,699 22,805 12,669 174,783 81,911 40,653 44,766 377,587 645 0 118,327 504 1,117 7,754 128,347176
Administrative Legal 0 13,816 1,797,263 1,138,908 147,059 148,733 3,245,779 0 38,148 1,864,963 2,064,953 375,209 113,796 4,457,069 6,364 25,116 965,114 851,554 104,158 208,977 2,161,282177
Administrative Professional Fees 28,526 36,010 26,199(39,522) 117,298 248,824 417,335 80,504 37,746 10,354(28,073) 97,484 188,515 386,530 11,091 57,819 11,753 0 84,707 131,120 296,490178
Administrative Contributions 0 0 37,663 26,359 5,212 0 69,234 1 0 76,138 17,656 18,222 0 112,017 0 0 26,640 23,889 19,170 0 69,699179
Administrative Bad Debt Expense 10,357 24,034(161,429) 324,547 435,879(31,659) 601,729 4,983(25,058) 268,327(328,578) 279,822 169,359 368,853(1,721)(65,324) 8,381 283,356 157,158(1,689) 380,162180
Admin Rental Expense-Operating Leases 25,831 18,421 192,977 58,664 79,697 59,428 435,017 31,628 12,825 252,109 59,154 92,476 13,268 461,459 6,421 15,822 199,473 41,948 53,923 8,285 325,871181
Admin Amortization of Capital Leases 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0182
Administrative Depreciation 51,919 8,309 337,673 556,233 140,648 23,959 1,118,741 49,442 10,468 409,810 616,318 124,301 38,840 1,249,179 3,580 10,300 264,487 91,146 29,116 3,842 402,471183
DT - Current Year Annual Financial Stmt Audit 19,108 13,323 3,216 0 140,522 0 176,168 15,158(4,692)(38,515) 0 3,431 0(24,619) 0 0 0 0 31,147 0 31,147184
DT - Prior Year Annual Fin Stmt Audit 0 52,570 7,142 0 30,410 0 90,122 0(1,526) 697 0 883 0 55 0 0 0 0 0 0 0185
DT - Audit Fee of Emp Benefits Plans 0 3,287 0 0 0 0 3,287 0 24 0 0 0 0 24 0 0 0 0 0 0 0186
DT - Tax Compliance 1,266 6,967 0 0 6,083 4,642 18,958 16 1,600 23 0 272 155 2,066 0 0 0 0 0 0 0187
DT - Tax Consulting 0 0 3,406 0 4,608 0 8,013 0 5,458 8,107 0 154 0 13,718 0 1,566 7,775 0 0 0 9,341188
DT - Statutory Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0189
DT - Other Services 0 1,331 5,478 5,138 19,444 5,142 36,533 0(12,788) 183 3,863 651 172(7,919) 0 2,849 0 0 0 0 2,849190
Admin Deloitte & Touche Exp. 20,373 77,478 19,242 5,138 201,066 9,785 333,082 15,174(11,926)(29,504) 3,863 5,390 327(16,675) 0 4,415 7,775 0 31,147 0 43,337191
PWC - Current Year Annual Financial Stmt Audit 0 0 0 0 0 0 0 3,799 117,521 406,744 94,822 80,685 2,785 706,355 19,009 42,947 53,847 24,980 22,099 3,931 166,813192
PWC - Prior Year Annual Fin Stmt Audit 0 0 0 0 0 0 0 0 0 31 0 0 0 31 0 44,478 17,511 50,947 32,116 0 145,052193
PWC - Audit Fee of Emp Benefits Plans 0 0 0 0 0 0 0 0(815) 0 0 0 0(815) 0 1,229 0 0 0 0 1,229194
PWC - Tax Compliance 0 0 0 0 0 0 0 1,339 9,726 28,151 0 5,106 0 44,322 1,371 22,272 66,451 8,686 8,270 5,678 112,727195
PWC - Tax Consulting 0 0 0 0 0 0 0 0 18,987 0 0 6,887 0 25,875 0(349) 0 0 6,943 0 6,594196
PWC - Statutory Fees 0 0 0 0 0 0 0 0 18,697 0 0 60,718 0 79,416 0 0 0 0 52,419 0 52,419197
PWC - Other Services 0 0 0 0 0 2,571 2,571 0 341 0 0 5,767 177 6,285 0 523 0 0 10,205 0 10,728198
Admin PWC Exp. 0 0 0 0 0 2,571 2,571 5,138 164,458 434,926 94,822 159,165 2,961 861,469 20,380 111,100 137,809 84,613 132,052 9,609 495,563199
Administrative Other 69,828(22,972) 1,428,290 551,316 892,249 462,117 3,380,827 207,327(1,773,267) 1,384,005(483,893) 778,215 508,520 620,908 107,769 15,904 1,513,583 410,652 204,612 283,921 2,536,442200
Administrative HQ Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0201
Administrative Total Other 69,828(22,972) 1,428,290 551,316 892,249 462,117 3,380,827 207,327(1,773,267) 1,384,005(483,893) 778,215 508,520 620,908 107,769 15,904 1,513,583 410,652 204,612 283,921 2,536,442202
Administrative Expense-Other 268,720 160,183 4,182,919 2,793,840 2,347,577 1,063,569 10,816,807 489,221(1,456,614) 5,784,996 2,177,373 2,254,811 1,314,639 10,564,425 501,747 362,781 5,015,916 2,768,883 1,734,290 1,420,587 11,804,203203
IT Administrative - Software and Hardware Maintenance Fee Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 129,102 149,570 17,051 0 295,723204
IT Administrative - Server Hosting and ASP Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 31,755 0 31,342 63,097205
IT Administrative - Software Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 27,571 0 163 0 27,755206
IT Admininstrative - Lease Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13,006 0 27,947 984 41,937207
IT Administrative Hardware Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8,019 126 31,231 1,584 1,498 1,563 44,022208
IT Administrative - Office Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0(29,229) 8,357 8,585 50 0(12,237)209
IT Administrative - Travel/Entertainment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 433 16,407 101,354 1,962 7,042 5,626 132,824210
IT Administrative Expense - Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0(141,847) 0 68,788 0 96,030 827 23,798211
Admin - IT Central Allocation Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 291,447 28,227 432,587 105,724 348,771 313,963 1,520,719212
Administrative - IT Professional Fees 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36,500 0 42,455 29,867 21,042 33,750 163,613213
Depreciation Expense - IT Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 45,660 0 86,679 434,280 80,139 33,949 680,707214
IT Administrative - Telecom Voice Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25,073 5,402 5,719 65,625 28,452 34,075 164,346215
IT Administrative - Data Communications Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26,631 61,814 65 0 88,510216
Administrative IT - Telecom Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25,073 5,402 32,350 127,439 28,518 34,075 252,856217
Total Administrative Expense 902,421 965,065 8,756,577 5,122,336 5,657,369 3,051,661 24,455,429 3,219,303 2,563,136 14,317,060 6,640,149 8,050,340 5,044,727 39,834,715 1,706,880 1,877,239 11,062,504 4,809,116 4,167,206 2,528,858 26,151,804218
Operations - R&D Employee Costs 1,843,133 3,884,020 8,173,385 4,026,714 4,964,568 2,074,160 24,965,979 1,515,861 3,555,353 10,172,206 4,509,237 4,236,467 1,729,023 25,718,147 1,526,542 3,782,123 10,158,963 4,454,838 4,317,573 2,040,094 26,280,133219
Operations - R&D Fringe Benefits 370,105 845,472 2,517,010 1,163,141 1,527,949 775,555 7,199,233 399,441 568,134 2,196,584 1,342,522 1,404,603 347,349 6,258,633 478,978 673,625 2,775,511 1,233,642 1,789,822 314,103 7,265,681220
Operations - R&D MIP expense 0 0 1 0(9,222) 0(9,220) 73,599 268,551 745,368 275,576 2,294,526 250,630 3,908,250(46,886) 99,246 318,786 0(291,413)(21,289) 58,444221
Operations - R&D EIP expense 0(868)(16,670) 0 0(2,732)(20,269) 0 594,782 1,828,410 310,799 623,862 401,096 3,758,948 0 212,854 583,994(92,340) 23,432 27,572 755,512222
Operations - R&D Pension 16,670 89,126 104,673 33,192 166,237 0 409,898 24,800 103,566 94,873 136,439 187,404 0 547,080 27,916 91,856 122,261 65,423 153,519 0 460,975223
Operations - R&D Post Retirement Benefits 0 2,475 0 52,508 0(31,693) 23,289 0 2,475 0(43,686) 0(31,693)(72,904) 0 2,582 0 16,621 0(14,416) 4,787224
Operations - R&D Workers' Comp. 54 17,185 2,807 0 13,441 5,226 38,713 8,270 11,630 0 0 32,592 3,997 56,489 7,805 15,080 0 0 16,974 3,335 43,193225
Operations - R&D Defined Contribution Plans 73,674 195,029 189,259 0 148,521 124,976 731,459 49,773 169,403 179,671 0 111,722 92,987 603,557 63,846 195,163 194,043 0 129,084 105,155 687,291226
Operations - R&D - IT EIP Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 295 696 0 92 0 1,084227
Operations - R&D - IT MIP Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0228
Operations - R&D - IT Defined Contr. Plan Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0229
Operations - R&D - IT Workers Comp 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0230
Operations - R&D - IT Post Retirement Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0231
Operations - R&D - IT Pension Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 535 1,964 44 0 2,543232
Operations - R&D - IT Fringe Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 351 581 0 21 0 953233
Operations - R&D - IT Salaries 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 713 1,553 0 122 0 2,388234
Operations - R&D IT Total IT Employee Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,379 3,413 1,964 279 0 7,036235
Operations - R&D Total Employee Costs 2,303,637 5,032,439 10,970,465 5,275,554 6,811,495 2,945,492 33,339,082 2,071,744 5,273,894 15,217,111 6,530,887 8,993,724 2,793,389 40,880,749 2,058,201 5,164,225 14,168,320 5,680,148 6,174,773 2,454,554 35,700,223236
Operations - R&D Depreciation 260,011 382,952 1,580,788 796,415 808,595 220,761 4,049,523 272,072 370,379 1,825,162 871,999 871,482 304,831 4,515,924 266,968 316,459 1,431,699 770,909 799,038 261,734 3,846,807237
Operations - R&D Travel/Entertainment 34,670 117,567 200,482 91,425 188,503 72,225 704,872 95,444 290,367 481,849 85,574 274,295 60,326 1,287,855 51,450 263,773 554,807 115,956 328,298 93,131 1,407,416238
Operations - R&D Rent - Oper. Leases 73,866 20,770 56,968 38,585 149,424 47,376 386,990 36,842 30,269 70,497 25,803 147,957 28,853 340,220 36,245 23,642 63,931 28,861 123,837 33,425 309,940239
Operations - R&D Patents 143,418 286,203 198,081 0 464,824 77,753 1,170,279 216,652 273,779 1,552,755 1,426,441 349,829 39,781 3,859,238 181,706 226,473 514,804 369,744 379,591 44,372 1,716,690240
Operations - Advanced Engineering (1,681,265) 0 0 0 5,484 0(1,675,781)(1,687,418) 0 0 0 4,977 0(1,682,441)(1,528,194) 0 0 0 4,866 0(1,523,328)241
Operations - R & D Other 284,326(684,722) 5,989,092 1,614,948 673,828(1,806,312) 6,071,160 716,278 3,022,468 6,663,978 3,411,023 698,928(1,312,453) 13,200,221(92,594) 1,176,599 6,961,112 2,047,529 542,809(1,365,278) 9,270,178242
Operations - R&D Sales of Prototypes (441,870)(4,368,923)(14,334,328)(686,562)(1,045,689)(428,343)(21,305,715)(850,360)(3,718,236)(9,056,962)(1,223,670)(3,361,848)(2,228,319)(20,439,395)(544,954)(2,385,245)(7,776,906)(1,801,977)(1,852,159)(1,224,967)(15,586,207)243
Operations - R&D Engineering Reimbursements 0(1,059,551)(963,163)(243,393)(1,837,065) 0(4,103,172)(282,832)(767,550)(3,034,679)(1,236,615)(4,660,706) 0(9,982,381) 0(196,658)(1,023,217)(308,840)(3,116,359)(124,184)(4,769,258)244
Operations - R&D Cost of Prototypes 467,474 3,092,140 6,951,505 0 1,112,043 413,828 12,036,990 1,085,868 2,269,278 5,504,917 0 2,334,310 534,661 11,729,034 686,137 1,024,636 5,218,229 0 1,380,258 951,915 9,261,176245
Operations - R&D Transfers 0(133,075) 0 0 0 0(133,075) 0(55,594)(9,645) 0(0) 0(65,239) 0(0)(0) 0(0) 0(0)246
Operations - R&D Other 284,326(684,722) 5,989,092 1,614,948 673,828(1,806,312) 6,071,160 716,278 3,022,468 6,663,978 3,411,023 698,928(1,312,453) 13,200,221(92,594) 1,176,599 6,961,112 2,047,529 542,809(1,365,278) 9,270,178247
Operations - R&D Total Other (1,396,939)(684,722) 5,989,092 1,614,948 679,312(1,806,312) 4,395,378(971,140) 3,022,468 6,663,978 3,411,023 703,905(1,312,453) 11,517,780(1,620,788) 1,176,599 6,961,112 2,047,529 547,675(1,365,278) 7,746,850248
Operations R&D - IT - Travel by IT employees working for R&D or on R&D projects 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 92 0 0 9 0 101249
Operations - R&D - IT Office Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,557 277 0 227 0 2,062250
Operations - R&D - IT Hardware Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20,564 89,735 3,183 5,074 6,697 125,253251
R&D IT Lease Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7,962 0 0 12,234 0 20,196252
Operations - R&D - IT Software Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35,314 24,386 44,965 0 12,053 2,120 118,838253
Operations - R&D - IT Hosting Service Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 600 28,032 20,356 600 49,588254
Operations - R&D - IT Software and Hardware Maintenance Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25,060 300,471 36,840 63,337 27,586 453,295255
Operations - R&D - IT Costs Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 69,342 134,213 916,259 145,936 231,278 88,605 1,585,633256
Operations - R&D - IT Central Allocation Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 873 35,655 22,498 59,252 45,214 163,492257
Operations - R&D - IT Outside Consulting Services Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4,400 38,327 822 0 43,549258
Operations - R&D - Depreciation Expense - IT Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 31,296 350,348 0 28,491 0 410,136259
Operations - R&D - IT Voice Communications Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13,423 17,268 6,688 5,535 25,104 6,388 74,405260
Operations - R&D - IT Data Communications Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20,605 0 168 11,519 4,319 0 36,611261
Operations R&D Telecom Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34,028 17,268 6,856 17,054 29,423 6,388 111,016262
Operations - R&D Total 1,444,267 2,685,801 10,649,890 6,886,972 7,331,443 1,542,779 30,541,152 1,674,289 6,989,054 19,214,983 9,891,443 5,652,949 221,067 43,643,785 1,184,309 5,748,118 21,029,039 7,048,266 4,996,229 1,213,308 41,219,268263
Operations - State Income Taxes 17,083 0 1,591,532 0 14,083(352,644) 1,270,054(17,083) 270,237 603,539 0 4,164(39,481) 821,376 51,249 520,467 625,969 0 799,378 319,894 2,316,958264
Operations - Royalty Income 0 0(7,617)(111,104) 0 0(118,722) 0 0(251,804)(189,541) 0 0(441,345) 0 0(20,941)(240,561) 0 0(261,502)265
Operations - Int Inc Employee Loans 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0266
Operations - Int Inc Bank Interest (135,392)(6,657)(131,972)(101,633)(51,151)(13,354)(440,158)(111,444)(18,915)(262,730)(11,977)(59,763)(15,472)(480,301)(102,238)(14,452)(143,639) 0(28,944)(20,724)(309,998)267
Operations - Int Accts/Notes Rec 0 0(22,520) 0 0 0(22,520) 0 0(16,879) 0 0 0(16,879) 0 0(4,089) 0 0 0(4,089)268
Operations - Interest from Affiliates: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0269
Operations - Int Inc Other 0 0(22,561)(74,694)(1,233) 0(98,488)(2,218) 0(45,581)(151,024)(2,787) 0(201,610) 0 0(22,137)(45,792)(1,382) 0(69,311)270
Operations - Interest Income Total (135,392)(6,657)(177,052)(176,327)(52,383)(13,354)(561,165)(113,662)(18,915)(325,190)(163,002)(62,550)(15,472)(698,790)(102,238)(14,452)(169,864)(45,792)(30,327)(20,724)(383,398)271
Operations - Dividends-Outsiders 0 0 0 0 0 0 0 0 0 0(17,003) 0 0(17,003) 0 0 0 0 0 0 0272
Operations - Land, Building, & Imp. 0 0 0 0 0 0 0 0 2,647 0(34,365) 0 0(31,718) 0 0 0 0 0 0 0273
Operations - Machinery & Equipment (10,915) 33,607 174,993(6,520) 30,475(18,583) 203,057(176,512) 10,049 9,960,920(89,620)(87,227) 4,561,937 14,179,546 3,035 138,203 828,774 0 16,531(71,117) 915,425274
Operations - Autos & Trucks 0 0 0 0 0 0 0 0 0 0 0(279)(809)(1,088) 0 0 0 0 0 0 0275
Operations - Office Equipment 0 2,855 0 0 0 0 2,855 0 7,738 0 0(51) 0 7,688 0 11,695 0 0(10,077) 0 1,619276
Operations - Capital Leases 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0277
Operations - Capital/Disposals Other 0 0 1,700(154,195) 19,716 0(132,779) 0 0(2,134)(234,495) 115,840 26,280(94,509) 45,309 0 1,109 32,279(23,762)(10,443) 44,492278
Operations - Capital Asset Disposals (10,915) 36,463 176,694(160,715) 50,191(18,583) 73,134(176,512) 20,434 9,958,786(358,480) 28,283 4,587,408 14,059,920 48,344 149,898 829,883 32,279(17,307)(81,561) 961,535279
Operations - Exchange/Gain or Loss 192,533 1,323,856(867,924) 42,248 112,958 156,667 960,338 126,702 62,541 2,217,110 145,364 133,914 486,974 3,172,605(41,409) 461,345(342,011)(57,296) 207,524 1,124,640 1,352,792280
Operations - Rent. Exp. - Oper. Leases 0 0 0 0 0 0 0 0(179,544) 0 0 0 0(179,544) 0(65,467) 0 857 0 0(64,611)281
Operations - Amort. of Capital Leases 0 0 0 0 0 0 0 0 167,883 0 0 0 0 167,883 0 62,397 0 0 0 0 62,397282
Operations - Depreciation 0 0 259,489(164,587) 0 0 94,903 0 0 60,932(198,607) 0 0(137,675) 0 0 59,451(88,007) 0 0(28,556)283
Operations - Post Retirement Benefits 110,964 114,431 219,116 0 270,303 388,999 1,103,813 110,964 114,515 219,116 0 232,341 389,023 1,065,960 106,403 134,915 234,470 0 164,672 353,778 994,238284
Operations - Workers' Comp. 0 0 0 0 89,794 0 89,794 0 0 0 0 89,794 114,773 204,567 0 0 0 0 22,812 136,806 159,618285
Operations - Prior Service Costs 0 0 0 0 0 42,000 42,000 0 0 0 0 0 70,000 70,000 0 781 0 0 0 0 781286
Operations - Govt Emp Cost Reimburse 0(3,791)(14,698)(72,451)(77,711)(111)(168,761) 0(131)(1,293)(264,956)(28,235)(55,777)(350,392) 0 0 0(138,503) 300(1,398)(139,601)287
Operations - Amort. of Goodwill 0 0 0 3,350 0 0 3,350 0 0 0(200) 0 0(200) 0 0 0 0 0 0 0288
Operations - Intangible amortization incl PPA 0 98,427 0 4,791,264 573,547 0 5,463,238 0 104,454 0 5,845,288 644,511 0 6,594,254 0 105,718 0 5,278,582 602,673 0 5,986,973289
Operations - Purchase Discounts (29,791) 0(479,045)(15,613)(511,605)(761)(1,036,813)(20,882) 0(908,350)(10,725)(988,981) 0(1,928,938)(39,673) 0(760,169)(12,225)(1,145,463) 0(1,957,529)290
Operations - I/C Exchange Gain/Loss (17,254)(1,740,365) 504,790 0 198,625 98,751(955,452) 6,762(436,142)(497,203) 238(119,873)(114,237)(1,160,456)(9,661)(135,076)(381,250) 0(248,396)(899,472)(1,673,855)291
Operations - Bank Fees 8,790 24,969 105,100 29,464 40,998 35,797 245,117 13,018 41,751 118,115 40,853 45,294 71,267 330,299 12,496 36,785 122,351 38,682 43,217 66,553 320,084292
Operations - Impairment Loss 0 0(331) 0 0 0(331) 0(27) 0 900,309 3,015 0 903,297 0 85,683 0 0 0 0 85,683293
Operations - Other (607,126)(163,797) 232,288(299,871)(665,327)(1,858,185)(3,362,018) 19,191(201,405)(330,432)(453,298) 1,408,008(1,924,312)(1,482,249)(431,817)(270,254)(171,542)(289,715) 1,154,315(779,354)(788,367)294
Operations Expense 973,160 2,369,338 12,192,233 10,752,631 7,374,917 21,355 33,683,633 1,622,787 6,934,706 30,078,310 15,167,685 7,042,634 3,791,233 64,637,354 778,004 6,820,857 21,055,384 11,526,567 6,549,627 1,432,470 48,162,909295
Other Income 128 0 0(1) 7,039 35,055 42,221 223 4,799 423 0 10,223(96,984)(81,316) 233 891 148,522(1,504,530) 92,362 0(1,262,522)296
Restructuring Expense (0) 0 0 0(0) 1 1 24,948(53,482) 58,169 44,809 48,795 1,434 124,673 0 0 0 0 0 0 0297
Total Selling Admin & Operating 3,050,099 4,976,614 28,199,501 23,967,199 14,468,740 4,096,541 78,758,693 6,276,214 11,595,411 51,713,471 31,438,103 17,655,303 9,875,416 128,553,917 3,926,749 10,580,176 40,457,017 24,397,087 12,526,305 4,827,295 96,714,629298
Operating Income before Allocations 2,572,039 3,374,939 31,774,543(3,176,791)(17,657,470)(15,050,048) 1,837,211 5,256,187 22,219,306 52,711,916(8,562,344) 14,186,232 4,603,777 90,415,075 9,704,238 27,543,489 69,190,313 508,047 26,825,876 12,791,294 146,563,256299
Operations - I/C Management Fees 281,706(17,866)(263,879)(45,228)(388,481)(0)(433,749) 389,988(17,626)(349,885)(151,736)(66,123)(3)(195,385) 490,446 8,943(307,021) 48,483(136,236) 35,754 140,368300
Operating Income after Allocations 2,290,333 3,392,805 32,038,422(3,131,563)(17,268,988)(15,050,048) 2,270,960 4,866,199 22,236,932 53,061,800(8,410,608) 14,252,356 4,603,781 90,610,460 9,213,793 27,534,546 69,497,334 459,564 26,962,112 12,755,541 146,422,889301
Loss/(Gain) on Sale of Business 0 0 0 0 0 0 0 512 0 0 0 0 0 512 0 0 0 0 0 0 0302
Inventory Profits 85,552(273,710)(521,723) 0(140,828)(36,262)(886,970)(60,812)(543,823) 161,678 0 14,092(401,124)(829,990) 23,236(111,787)(79,223) 0(805,229)(109,906)(1,082,910)303
Corporate Headquarter Expense 1,125,110 601,771 1,080,993 153,643 1,264,951 864,867 5,091,335(460,374) 672,107 193,163 297,266 384,452(380,711) 705,904 801,262 632,185 810,655 183,033 918,465 640,205 3,985,804304
Interest Expense-Outsiders 0 231,484 258,618 1,140 137,050 103,214 731,506 0 89,189 251,719(562) 75,352 71,627 487,324 0 112,448 155,739 29,289 72,843 146,100 516,419305
Intercompany Interest Expense 293,417 65,882 5,900,304 190,850 529,393 177,862 6,616,195 287,776 17,653 7,071,398 214,464 8,031,121 177,157 15,197,358 204,660 31,304 6,608,345 203,647 2,103,591 244,573 8,647,301306
Intercompany Interest Income 183,236 103,670 3,983,069 2,490,984 719,610 0 6,999,633 210,097 53,776 5,209,780 3,034,561 5,286,593 0 13,277,676 155,923 126,549 5,564,258 2,794,789 1,540,782 0 9,511,743307
Intercompany Interest Balancing 0 9 0(0) 0 0 60,585 0 0(0) 0 0 0 85,079 0 0(0) 115 0 0 78,377308
Guarantee Fees Income 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0309
Guarantee Fees Expense 0 69,197 89,993 0 24,701 0 183,891 0 47,321(52,420) 0 27,758 0 22,659 0 103,278 106,966 0 211,028 14,348 435,621310
Guarantee Fees Elimination 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0311
Intercompany Interest Balancing 0 9 0(0) 0 0 60,585 0 0(0) 0 0 0 85,079 0 0(0) 115 0 0 78,377312
Total Interest Expense 110,181 262,902 2,265,845(2,298,994)(28,466) 281,076 592,545 77,679 100,387 2,060,916(2,820,659) 2,847,637 248,784 2,514,744 48,738 120,481 1,306,792(2,561,738) 846,681 405,021 165,974313
Interest Income - Outsiders 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71,343 0 0 0 0314
Finance Charge 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0315
Intercompany Expense 81,198 1 185,571 0 27,368 12,773 306,910 346,864(346,383)(393,537)(8,859)(406,783) 9,930(798,768) 19,659 0 93,340 51,870 54,172(33,223) 185,818316
Intercompany Royalty Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0317
Intercompany Royalty Income 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0318
Intercompany Royalty Elimination (0) 0(0) 0 0 0(0)(0)(0)(1) 0 1(3)(2)(0) 0 0 0(0)(1)(0)319
I/C Interest - Mirrors 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0320
Excess Purchase Price Amort. Expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0321
Depreciation of Fixed Asset Write-ups 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0322
For Corporate Use Only 20,359 23,219 437,125 0(459,662)(11,127) 9,914(16,585)(601,305)(77,202) 2,258,836(2,072,270)(711,241)(1,219,767) 13,092 24,840 277,122 0(1,112,980) 1,547,865 749,939323
Purchase Cost Amortization 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0324
Allocated Tax Expense (368,500) 0 1,600,325 3,171,663(1,760,594) 0 2,642,893 219,923 0 8,267,808(294,661) 573,906 0 8,766,977 520,144 0 10,095,523 3,145,750 1,766,835 0 15,528,251325
Net Income Before Taxes 1,407,539 2,231,201 25,946,840(4,157,876)(16,453,413)(16,233,898)(7,259,607) 4,637,368 21,868,303 43,172,330(7,842,532) 12,939,504 5,035,897 79,810,870 7,834,134 26,645,252 56,906,020(359,350) 23,683,711 10,085,767 124,795,534326
Federal Taxes 858,272(1,711,178)(582,567)(3,410,610)(1,599,199) 791,981(5,653,301) 1,876,671 8,851,727 276,158 3,721,524 1,492,804 183,629 16,402,512 1,839,456 5,166,510 3,851,713(1,960,347) 2,868,135 2,059,802 13,825,269327
Earnings-Discontinued 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0328
Earnings-Equity Affiliates 0 0 0 20,868 0 0 20,868 0 0 0 156,504 0 0 156,504 0 0 0 114,807 0 0 114,807329
Extraordinary Gain/Loss 0 0 0 0 0 0 0 0 0 0(0) 0 0(0) 0 0 0 0 0 0 0330
Minority Interest in Earnings 0 0 0 267,960 0 0 267,960 0 0 0 268,044 0 0 268,044 0 0 0 0 0 0 0331
Net Income 549,267 3,942,379 26,529,407(994,358)(14,854,214)(17,025,879)(1,853,398) 2,760,697 13,016,576 42,896,173(11,675,596) 11,446,700 4,852,269 63,296,818 5,994,679 21,478,742 53,054,307 1,715,803 20,815,576 8,025,965 111,013,730332

<colgroup><col><col><col span="7"><col><col span="13"><col></colgroup><tbody>
</tbody>


I'm sorry for the poor formatting, I'm just so lost on what to do here.

Any help would be greatly appreciated.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You must log in or register to reply here.

Similar threads

S
  • Solved
Sum column based on unique values in another column
2
Replies
11
Views
432
samide2001
S
A
  • Solved
Conditional macro
Replies
8
Views
153
Fluff
Fluff
C
  • Question
Adding new code to existing macro to account for locked/unlocked cells
Replies
1
Views
286
DanteAmor
DanteAmor
P
  • Question
Dynamic approach to calculating charges against nominal codes (single value, multi value, range & combo)
Replies
0
Views
229
PureBluff
P
V
  • Question
vlookup or match index
Replies
0
Views
360
vmjan02
V

Forum statistics

Threads
1,214,875
Messages
6,122,039
Members
449,063
Latest member
ak94

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top