EXCEL

profilezon5008
abc_trial_balance_2011.xlsx
Home>Business & Finance homework help>Accounting homework help>EXCEL

Table 1

Account Description FY11 Ending Balance FY11 Ending Balance
111150 OPERATIONS CASH (171,359.12) (171,359.12)
111151 OPERATIONS CASH- LANE A/C 270.11 270.11
111400 PETTY CASH 1,300.00 1,300.00
133050 LEAF DEPT CLAIMS 1,840.00 1,840.00
133070 MISC RECEIVABLES (NON-TRADE) 731,294.73 731,294.73
135200 INTERCOMPANY ACME MISC 358,562.94 358,562.94
135210 I/C L & M RECEIVABLE 2,614,036.78 2,614,036.78
135600 I/C ABC XYZ BRANDS (2,614,496.13) (2,614,496.13)
135900 I/C ACME INVENTORY 248,019.06 248,019.06
136500 INTER-DIV CASH - OPERATIONS/RT (648,148,564.72) (648,148,564.72)
137200 INTER-DIV INVENTORY REC-ABC RT 616,067,605.04 616,067,605.04
137300 INTER-DIV INVENTORY REC-XYZ 750,897.80 750,897.80
141100 LEAF INVENTORY 63,655,336.05 63,655,336.05
141101 LEAF INVENTORY-SNR 1,637,111.25 1,637,111.25
141700 MATERIAL OH 118,279.94 118,279.94
142100 RM INVENTORY 3,957,436.37 3,957,436.37
142200 RM IN TRANSIT - ERROR:#VALUE!
142400 RM VAR ALLOC (55,225.60) (55,225.60)
143100 WIP INVENTORY 197,378.76 197,378.76
143150 WIP INVENTORY IN PROCESS - ERROR:#VALUE!
143320 WIP OUTSIDE PROCESSORS 380,751.36 380,751.36
143350 WIP OUTSIDE PROCESSORS-CRES 110,309.47 110,309.47
143500 WIP PLAN OVER/UNDER ABSORB - ERROR:#VALUE!
144100 FG MFG STOCK NO TAX 22,419,447.48 22,419,447.48
144400 FG VAR ALLOC-MFG STOCK (672,535.41) (672,535.41)
144500 FG PLAN OVER/UNDER ABSORB - ERROR:#VALUE!
145100 TOOLS/OPER SUP INVENTORY 147,145.41 147,145.41
146100 PARTS INVENTORY 6,355,957.84 6,355,957.84
147100 LEAF LIFO RES (18,977,000.00) (18,977,000.00)
147200 RM LIFO RES (730,000.00) (730,000.00)
147300 WIP LIFO RES (51,000.00) (51,000.00)
147400 FG LIFO RES - MFG STOCK (5,464,000.00) (5,464,000.00)
148200 FG OBSOLETE RES - MFG STOCK (453,102.36) (453,102.36)
148400 RM OBSOLETE RES (70,000.00) (70,000.00)
148600 TOOLS/OPER SUP OBSOLETE RES (1,295,449.39) (1,295,449.39)
151110 PPD INSURANCE CURRENT 322,952.22 322,952.22
151120 PPD OTHER EXP CURRENT 87,294.92 87,294.92
152300 OTHER DEPOSITS CURRENT 4,430.00 4,430.00
171110 LAND 1,273,606.39 1,273,606.39
171120 LAND IMPROVE 144,710.48 144,710.48
171210 BUILDINGS 14,410,267.49 14,410,267.49
171220 BLDGS LEASE IMPROVE 147,169.03 147,169.03
171310 MACH/EQUIP 92,171,479.02 92,171,479.02
171312 MACH/EQUIP SURPLUS 52,998.81 52,998.81
171320 MACH/EQUIP LEASE IMPROVE - ERROR:#VALUE!
171330 MACH/EQUIP CAPITAL LEASE 10,820.00 10,820.00
171410 FURN/FIX 10,782,603.94 10,782,603.94
171510 AUTOS 710,907.55 710,907.55
171710 CONSTRUCTION IN PROCESS 3,036,641.16 3,036,641.16
172110 A/D LAND IMPROVE (77,055.69) (77,055.69)
172210 A/D BUILDINGS (8,344,954.23) (8,344,954.23)
172220 A/D BLDGS LEASE IMPROVE (36,765.93) (36,765.93)
172310 A/D MACH/EQUIP (53,585,657.48) (53,585,657.48)
172312 A/D MACH/EQUIP SURPLUS (52,998.81) (52,998.81)
172320 A/D MACH/EQUIP LEASE - ERROR:#VALUE!
172330 A/D MACH/EQUIP CAPITAL LEASE (2,404.48) (2,404.48)
172410 A/D FURN/FIX (5,937,430.48) (5,937,430.48)
172510 A/D AUTOS (704,412.21) (704,412.21)
191120 PPD OTHER EXP LT 76,710.56 76,710.56
192800 LOAN RECEIVABLE - DOMINION PAC 75,000.16 75,000.16
213105 MISC. EQUIPMENT LEASE CURRENT (5,693.90) (5,693.90)
221100 A/P TRADE (7,928,164.87) (7,928,164.87)
221200 A/P NO BILLS (35,486.93) (35,486.93)
221400 A/P UNMATCHED PO - ERROR:#VALUE!
223102 HRLY 401K (13,976.51) (13,976.51)
223103 HRLY 401K LOANS (6,631.94) (6,631.94)
223104 HRLY DEPEND LIFE - ERROR:#VALUE!
223106 HRLY GARNISHMENTS - ERROR:#VALUE!
223107 HRLY CONTRIBUTIONS (3,646.70) (3,646.70)
223109 HRLY UNION DUES - ERROR:#VALUE!
223110 HOURLY UNIFORMS (287.03) (287.03)
223202 SALY 401K (17,440.71) (17,440.71)
223203 SALY 401K LOANS (2,246.16) (2,246.16)
223204 SALY DEPEND LIFE - ERROR:#VALUE!
223206 SALY GARNISHMENTS - ERROR:#VALUE!
223207 SALY CONTRIBUTIONS (6,930.00) (6,930.00)
223208 SALY OPTIONAL ADD - ERROR:#VALUE!
223209 SALY LT DISABILITY - ERROR:#VALUE!
223210 SALY VOL GROUP LIFE (889.91) (889.91)
223212 SALARY UNIFORMS (13.90) (13.90)
224200 UNCLAIMED CHECKS (5,345.22) (5,345.22)
228070 MISC PAYABLES (NON-TRADE) (84,793.00) (84,793.00)
234100 EXCISE TAX PAYABLE (17,942,181.96) (17,942,181.96)
235100 SALES/USE TAX PAYABLE (6,262.32) (6,262.32)
236100 RE/PP TAX PAYABLE - ERROR:#VALUE!
237110 HRLY FED TAX W/H - ERROR:#VALUE!
237120 SALY FED TAX W/H - ERROR:#VALUE!
237210 HRLY STATE TAX W/H - ERROR:#VALUE!
237220 SALY STATE TAX W/H - ERROR:#VALUE!
237310 HRLY FICA TAX W/H - ERROR:#VALUE!
237320 SALY FICA TAX W/H - ERROR:#VALUE!
237420 OTHER SALARY PAYROLL ITEMS W/H - ERROR:#VALUE!
238110 HRLY UNEMPLOY TAX PAYABLE - ERROR:#VALUE!
238120 SALY UNEMPLOY TAX PAYABLE - ERROR:#VALUE!
238210 HRLY LGI FICA TAX PAYABLE - ERROR:#VALUE!
238220 SALY LGI FICA TAX PAYABLE - ERROR:#VALUE!
251011 HRLY ACCR PAYROLL (12,000.00) (12,000.00)
251012 SALY ACCR PAYROLL - ERROR:#VALUE!
251021 ACCR VACATION PAYABLE - ERROR:#VALUE!
251031 ACCR HOLIDAY PAYABLE - ERROR:#VALUE!
252210 HRLY PROFIT SHARING (10,281.16) (10,281.16)
252220 SALY PROFIT SHARING (7,000.00) (7,000.00)
254100 ACCR LEGAL FEES (400,000.00) (400,000.00)
256101 HRLY GROUP LIFE - ERROR:#VALUE!
256102 HRLY HOSPITAL - ERROR:#VALUE!
256103 HRLY WORKERS' COMP - ERROR:#VALUE!
256104 HRLY OTHER BENEFITS - ERROR:#VALUE!
256106 HRLY HEALTH CARE SPENDING (6,574.98) (6,574.98)
256201 SALY GROUP LIFE - ERROR:#VALUE!
256202 SALY HOSPITAL - ERROR:#VALUE!
256203 SALY WORKERS' COMP - ERROR:#VALUE!
256205 HEALTH CARE SPENDING (15,143.33) (15,143.33)
256206 DEPEND CARE SPENDING - ERROR:#VALUE!
256410 ACCR SEVERANCE PAY - ERROR:#VALUE!
258657 ACCRUED PROFESSIONAL FEES (60,000.00) (60,000.00)
273105 MISC. EQUIPMENT LEASE - LT (12,070.40) (12,070.40)
286300 DEFERRED INTEREST INCOME (24,457.71) (24,457.71)
311000 COMMON STOCK - ERROR:#VALUE!
321000 PREF STOCK - ERROR:#VALUE!
331000 PIC - ERROR:#VALUE!
331500 DEFERRED COMP EXPENSE APIC 383,865.76 383,865.76
333500 OPERATIONS EQUITY (726,659,123.72) (726,659,123.72)
341000 APPR R/E (1,108,809.00) (1,108,809.00)
342000 UNAPPROPRIATED RETAINED EARNIN 645,667,689.73 645,667,689.73
344000 INTERCO GAIN on FIXED ASSET SA (724,704.40) (724,704.40)
344100 ACCUMULATED OTHER COMPREHENSIV 280,992.42 280,992.42
411100 INTER-DIV SALES - ABC TO XYZ (54,896,150.80) (54,896,150.80)
411200 INTER-DIV SALES-ABC TO ABC (618,224,262.64) (618,224,262.64)
411700 INTER-DIV SALES ABC to ABC SNU - ERROR:#VALUE!
442000 XYZ MARKUP (1,046,233.21) (1,046,233.21)
511000 COST OF SALES TO CUSTOMERS - ERROR:#VALUE!
511100 INTER-DIV COST OF SALES-ABC TO 10,154,570.23 10,154,570.23
511200 INTER-DIV COS- ABC RTP 114,042,943.17 114,042,943.17
511700 INTER-DIV COS ABC to ABC SNUS - ERROR:#VALUE!
521100 INTER-DIV EXCISE TAX-ABC TO VE 44,741,356.80 44,741,356.80
521200 INTER-DIV EXCISE TAX-ABC RT 504,177,523.68 504,177,523.68
531000 LIFO EXPENSE 3,942,000.00 3,942,000.00
541100 RM USAGE VAR (715,713.03) (715,713.03)
541200 RM STANDARD CHANGE VAR 198,948.34 198,948.34
541300 O/S PROCESSOR GAIN/LOSS 346,602.16 346,602.16
541400 RM PURCHASE PRICE VARIANCE (591,028.95) (591,028.95)
541500 LEAF USAGE VARIANCE (341,340.47) (341,340.47)
541600 LEAF TRANSFER COST DIFF. 289,174.58 289,174.58
542100 LABOR PERFORM VAR (721,359.86) (721,359.86)
542300 DIRECT LABOR RATE VAR - ERROR:#VALUE!
542400 INDIRECT LABOR RATE VAR - ERROR:#VALUE!
543100 ACT O/H COSTS INCURRED 30,594,621.72 30,594,621.72
543200 O/H BUD AUTHORIZATION (33,651,500.00) (33,651,500.00)
543300 O/H ABSORBED IN PRODUCT (31,941,224.61) (31,941,224.61)
543400 O/H BUD AUTHORIZATION 33,651,500.00 33,651,500.00
543700 SPENDING VAR. SNUS - ERROR:#VALUE!
546100 OBSOLETE INV DISPOSAL 635,939.26 635,939.26
546700 OBSOLETE DISPOSAL SNUS - ERROR:#VALUE!
547200 RM STD COST REV (190,542.98) (190,542.98)
547300 WIP STD COST REV (16,421.98) (16,421.98)
547400 FG STD COST REV (863,252.98) (863,252.98)
571000 CONTROL ACCT OPERATORS (8,795,884.46) (8,795,884.46)
572030 UNIT OPERATOR 5,180,516.74 5,180,516.74
572040 PACKER MECHANIC OPER - ERROR:#VALUE!
572050 MAKER MECHANIC OPER - ERROR:#VALUE!
572060 KDF 2 FILTER MACH OPER 86,309.55 86,309.55
572070 OVER TIME DIRECT LABOR 291,696.53 291,696.53
572080 KDF 2 MECHANIC OPER 3,237,361.64 3,237,361.64
611010 SALARIES 6,336,206.61 6,336,206.61
611020 FRINGES 1,649,309.29 1,649,309.29
611030 OVERTIME SALAIRES 36,627.40 36,627.40
611041 2ND SHIFT PREM SALARIES 20,808.82 20,808.82
611042 3RD SHIFT PREM SALARIES 26,184.51 26,184.51
611051 INCENT COMP - ERROR:#VALUE!
611060 LT DISABILITY 40,939.67 40,939.67
611080 OTHER SALY PAYROLL (4,743.65) (4,743.65)
613100 HOURLY WAGES 5,351,203.86 5,351,203.86
613115 TRAINING WAGES - ERROR:#VALUE!
613116 CLASSROOM TRAINING WAGES 7,200.00 7,200.00
613118 SPECIAL LABOR WAGES 236,750.00 236,750.00
613210 OVERTIME WAGES 973,572.80 973,572.80
613310 2ND SHIFT PREM WAGES 21,809.18 21,809.18
613320 3RD SHIFT PREM WAGES 30,803.56 30,803.56
613400 HOURLY FRINGE BENEFITS 3,173,941.23 3,173,941.23
621210 EXPER CIGARETTES 80.51 80.51
621220 EXPER TOBACCO 3,371.67 3,371.67
621230 EXPER DIRECT MATERIAL 27.27 27.27
621240 CHEMICAL SUPPLIES 12,992.27 12,992.27
621260 OTHER RESEARCH SUPPLIES 13,492.06 13,492.06
621310 TOOLS 157.22 157.22
621321 CYLINDER BASE 100 100.00
621322 CYLINDER DESIGN CHGS - FDA - ERROR:#VALUE!
621325 99MM CYLINDER REPAIR - ERROR:#VALUE!
621326 CYLINDER & PKG DESIGN-WARNING 244,951.56 244,951.56
622020 GASOLINE 91,217.36 91,217.36
622080 SAMPLES NON PROMO 388.45 388.45
624010 PRINTED FORMS/STATIONERY 184.09 184.09
624020 OFFICE SUPPLIES 24,841.23 24,841.23
624030 COMPUTER SUPPLIES 21,290.05 21,290.05
624040 SOFTWARE 93,575.12 93,575.12
624060 PHOTO SUPPLIES - ERROR:#VALUE!
624080 TRAINING SUPPLIES 347.77 347.77
624090 MISC OPER SUPPLIES 218,817.19 218,817.19
624110 MISC OPER TOOLS 458.08 458.08
624120 INVENTORY ADJUSTMENTS-MMS 273,249.63 273,249.63
625200 PROTECTIVE CLOTHING 11,484.90 11,484.90
625300 SAFETY SHOES 25,089.89 25,089.89
625400 SAFETY GLASSES 1,500.00 1,500.00
626100 BLDG/GROUNDS MAINTENANCE 54,719.37 54,719.37
626200 MACH/EQUIP MAINTENANCE 2,309,305.92 2,309,305.92
626300 AUTO MAINTENANCE 618.54 618.54
626400 MECHANICAL REPAIRS - ERROR:#VALUE!
626500 ACCIDENT REPAIRS - ERROR:#VALUE!
626600 EXPENSE PORTION OF CAPITAL JOB 321,996.52 321,996.52
627100 ELECTRICITY 1,035,162.45 1,035,162.45
627200 WATER 57,595.13 57,595.13
627300 FUEL OIL 17,762.15 17,762.15
627400 NATURAL GAS 331,057.12 331,057.12
627610 TELEPHONE/TELEX SERVICE 162,570.64 162,570.64
631100 RE LEASING/RENTAL 380,496.60 380,496.60
631200 PP LEASING/RENTAL 221,791.37 221,791.37
633200 PROPERTY INS 4,652.00 4,652.00
633300 BROKER FEE PROPERTY INS 374,683.92 374,683.92
634100 PP TAXES 478,148.74 478,148.74
634200 RE TAXES 150,475.69 150,475.69
634300 USE TAXES 88,770.71 88,770.71
634500 LICENSE/PERMITS/FEES 25,681.76 25,681.76
635110 DEPR LAND IMPROVE 6,494.88 6,494.88
635210 DEPR BUILDINGS 618,087.93 618,087.93
635310 DEPR MACH/EQUIP 6,278,673.02 6,278,673.02
635320 DEPR MACH/EQUIP LEASE IMPROVE 3,895.63 3,895.63
635410 DEPR FURN/FIX 1,555,227.92 1,555,227.92
635510 DEPR AUTOS 5,556.82 5,556.82
635800 AMORTIZATION GAIN/LOSS FX EXCH 63,341.76 63,341.76
651101 EMPLOYEE RELATIONS 30,118.44 30,118.44
651102 SERVICE AWARDS 17,190.00 17,190.00
651104 TUITION AID 1,949.51 1,949.51
651105 EMPLOYEE CIGS 200,670.28 200,670.28
651106 CAFETERIA SERVICE 172,348.32 172,348.32
651110 UNION BUSINESS 5,088.31 5,088.31
651210 RECRUITMENT 20,673.37 20,673.37
651310 PHYSICAL EXAMS - ERROR:#VALUE!
651320 MEDICAL SERVICES 51,432.01 51,432.01
651410 MEMBERSHIPS/SUBSCRIPTIONS 31,674.36 31,674.36
651510 TRAINING ADMIN 56,565.25 56,565.25
651520 CONFERENCES 635 635.00
651530 TRAVEL/BUSINESS 50,422.12 50,422.12
651540 MEALS/ENTERTAINMENT 10,676.93 10,676.93
652110 PUBLIC RELATIONS - ERROR:#VALUE!
652120 COMMUNITY RELATIONS 2,316.71 2,316.71
652210 CHARITABLE CONTRIBUTIONS 25,985.00 25,985.00
653010 PROFESSIONAL FEES 210,167.88 210,167.88
653031 LEGAL FEES 7,995,116.10 7,995,116.10
653035 LAWSUIT SETTLEMENTS 504,183.00 504,183.00
654010 GENERAL PURCH MAINT SERV 2,111,614.14 2,111,614.14
654060 ENGINEERING SERVICES - ERROR:#VALUE!
654070 SECURITY SERVICES 271,539.32 271,539.32
654080 SUPPL MANPOWER 214,558.89 214,558.89
654100 AUTO PURCH MAINT SERV 54,754.94 54,754.94
654110 CONSTRUCTION PURCH MAINT SERV 82,439.64 82,439.64
654120 ROOFING PURCH MAINT SERV 20,829.08 20,829.08
654130 PAINTING PURCH MAINT SERV 1,858.08 1,858.08
654140 SHEET METAL PURCH MAINT SERV - ERROR:#VALUE!
654150 HAZ MAT PURCH MAINT SERV 1,485.94 1,485.94
654160 FORKLIFT MAINTENANCE SERVICE 61,580.88 61,580.88
657130 POSTAGE FRT DEMURRAGE 35,111.25 35,111.25
657150 MISC FREIGHT 27,680.42 27,680.42
657210 SUPPLIES - DAMAGED PRODUCT 11,656.27 11,656.27
657220 DEFECTIVE PRODUCT RETURNS 22,593.18 22,593.18
657230 LOSS RETURN DAMAGE THEFT 70,016.12 70,016.12
659300 DUTY DRAWBACK (26,087.38) (26,087.38)
659530 MISC CREDITS (217,873.85) (217,873.85)
662000 MFG EXP CONTROL O/H (30,594,621.72) (30,594,621.72)
672600 SERVICE CREDIT INTRA DIV ALLOC (1,358,192.42) (1,358,192.42)
812710 OTHER INT EXP (41,613.54) (41,613.54)
831111 GAIN/LOSS MACH/EQUIP SALE (43,493.82) (43,493.82)
831300 GAIN/LOSS FOREIGN CURRENCY 12,898.92 12,898.92
834100 OTHER NON OPER INC/EXP - ERROR:#VALUE!
834200 PURCHASE DISCOUNTS TAKEN (15,643.78) (15,643.78)