Loading...
HomeMy WebLinkAbout2.63 Correspondence 3 Heckman Motors, Inc. 04/04/14 Profit & Loss-PA DT Rentals/Bus/Charter/City Parkin r 11 October through December 2013 °°_ Oct 13 Nov 13 Dec 13 TL � �� R�9(xL�°� PP I W. Ordinary Income/Expense Income 61100-Mileage-Car 0 32 0 32 61150•Mileage-Truck 195 0 0 195 61200•Time/Daily Rental-Car 11,167 4,986 6,889 23,042 61250-Truck Daily Rental 411 0 225 636 61300•Loss Damage Waiver(LDW) 897 575 644 2,115 61400•Discounts -495 -87 -91 -673 61550•Cash Over/Short -10 -92 0 -101 61701 -Intercity Car Rental<Revenue> 2,538 3,430 621 6,589 61702. Intercity Car Rental<Expense> -1,164 -1,112 -473 -2,750 62104• P.A.E.<Expense> 0 0 0 0 62107-Extra Driver Fee 13 26 39 78 62109• Underage Driver Fee 0 25 0 25 62200-Other Income 62201 -Retail Car Sales-Gross 40,050 11,950 -208,902 -156,902 62202-Wholesale Car Sales-Gross 257,625 22,100 -193,810 85,915 62203•Reimb.of Veh.Transfer Expense 115 0 0 115 62204•Other Rental Income 0 175 0 175 62220-Interest 0 0 25 25 62200-Other Income-Other 0 0 3 3 Total 62200-Other Income 297,790 34,225 -402,684 -70,669 62250, Bus Lines Revenue BusLines Express Freight 325 150 125 600 Greyhound Sales Commission 320 206 169 694 OBL Bus Revenue 51,239 46,868 47,587 145,694 Total 62250•Bus Lines Revenue 51,884 47,223 47,881 146,989 62260-Charter Revenue 1,893 0 0 1,893 62275•Grant Money Income Grant$-Old Program Calculation 28,726 33,659 45,245 107,630 Grant$-Over/Under Old Program 15,829 9,145 -1,129 23,845 62275•Grant Money Income-Other 0 0 0 0 Total 62275•Grant Money Income 44,556 42,804 44,116 131,476 62701 -S.L.I.<Revenue> 288 167 153 609 62702-S.L.I.<Expense> -144 -84 -77 -304 63550•105 Front St.PA Lease Revenue 600 600 600 1,800 64000•Daily Parking Revenue 1,494 678 1,360 3,532 64200•Long Term Storage Revenue 505 645 705 1,855 Total income 412,418 134,040 -300,092 246,366 Cost of Goods Sold 5000•Cost of Goods Sold 0 0 -250 -250 70050•Cost of Sales-Whlse Cars Gross 231,932 19,500 -156,606 94,826 70790•Cost of Sales-Retail 37,405 11,263 -185,509 -136,841 Total COGS 269,337 30,763 -342,364 -42,264 Gross Profit 143,081 103,277 42,273 288,631 Expense Advertising&Promotion Expense 73000•Television Expense 2,201 1,949 5,457 9,608 73100•Yellow Pages Expense 842 842 937 2,622 73200•Newspaper Expense 2,868 2,144 3,117 8,129 73300•Radio Expense 1,788 3,640 3,782 9,210 73400-Billboard Expense 1,200 1,200 1,200 3,600 73600•Website 232 179 408 819 73900-Advertising and Promotion 393 0 284 677 Total Advertising&Promotion Expense 91524 9,954 15,186 34,664 Direct Vehicle Expense 70100-Depreciation Expense-Vehicle 8,487 5,755 9,524 23,766 70110.Interest Expense-Vehicles 765 247 0 1,012 70200-Insurance Exp.-Vehicles 3,456 2,257 2,828 8,542 Pagel Heckman Motors, Inc. 04/04/ 4 Profit & Loss-PA DT Rentals/Bus/Charter/City Parking/Sales October through December 2O13 Oct 13 Nov 13 Dee 13 TOTAL 70210 Parts Expense 183 286 142 561 70220 Tires Expense O 292 U 292 70300 VuteiduMainhvnace&Ropeins 3.329 3,007 1.586 7.922 7V31V'Vehicle Damage Repair 1.291 O 2.698 3.989 7Vx5V'Subrogation O -8.317 O -0.317 70370 VVindohio|dRop|annment/Rmpair V O 0 O 70600 Monthly Car Fees 792 288 523 1.604 7V7VV'Licenses-Vehicles -oO 120 203 277 7V750-Other Direct Vehicle Expenses O 0 U 0 Total Direct Vehicle Expense 10.207 5.837 17.505 41.649 General&xdmn.Expense 7rVVn'Amortization-Franchise 121 118 121 360 771VV'Bad Debt Expanse O 49 O 49 7711U'Bank Charges 88 128 -40 171 77120' Eqvip/FurnExp'Lnas than$500 76 73 35 184 77130-interest Expense-Non Auto 0 O 8 O 7720O-Office Supplies 387 809 558 1.755 7721O' Postage and Freight 169 15 22 206 77u30'Telephone Expense 1.088 939 884 3.012 77280-Depreciation Expense 146 144 5.974 4.285 77310- Professional Fees-Legal O U 180 180 rro4V'Professional Fees-Consultants O 0 U U 774VO'Meals&Entertainment 132 32 *3 207 77405 Travel&Meetings 720 O O 720 77410 Dues and Subscriptions 409 23 728 1.157 774%V-General Insurance Expense 823 U U 823 7742s'Customer Goodwill O 3.082 9 3.070 77430-Other General Expenses oRACVViza,d Monthly Fees 215 136 180 532 OBL Hotel(ALL HOTELS) '2*5 '189 '92 -527 Gnacho8mamr/B|anketo for Buses 733 678 031 2.043 7r43V'Other General Expenses'Other 208 O O 200 Total r743O-Other General Expenses 909 626 718 2.254 r7450-Donations Expense O V 'OS -09 7751O- Uniform Expense O O O O 77820-CompvmrEquipment'Mainmnanue 71 09 68 200 7783V'Copy Machine Maintenance U O 284 284 7roVV'Taxes&Licenses-Business 77901 'Business Licenses U 0 25 25 77802' Business Taxes 2.634 1.363 2.021 6.618 Total 77gVV-Taxes&Licenses-Business 2.634 1.963 2.046 0.643 Total General mxxmn.Expense 7.789 e.051 8.657 25.478 Occupancy Expense 7s11V- Rent 5.002 5.000 5.072 15.134 7530V' Utilities 758 775 808 2.336 753VO- |neumnoo'Bvi|dingm/BuoStops 0 U U 0 754O0' Maintenance&Repair-Facilities 90 SO 292 472 758UO'Sign Expense O 13 U 13 7580V'Other Occupancy Expense 10 V O 1O Total Occupancy Expense 5.320 5.877 5.188 17.864 Operating Expense 7210O'Garage&Washing Supplies 148 128 100 376 72110-Oil/Transmission Fluid Expense 39 2 49 88 72VnV-Vehicle Transfer 460 115 1.468 2.043 72rVV'Other Operating Expense Tacoma Narrow Bridge Tolls 30 19 11 00 Total 727VV'Other Operating Expense 30 19 11 60 72750' Port Fees 224 208 220 650 728oV'Gasoline Expense 7.037 8.544 7.123 21.304 r20aO'Gasoline Refueling Charge -203 -131 '57 '*50 Page Heckman Motors, Inc. uwow ^ Profit & Loss-PA DT Rentals/Bus/Charter/City Parking/Sales October through December 2O13 Oct 13 Nov 13 Dec 13 TOTAL 77415- Ferry Fees 8.500 7.883 8.566 24.764 Total Operating Expense 10.580 14.778 17.479 48.037 Personnel Expense 7820V-Corporate Officers Wages 5.952 5.704 5.648 17.385 763VO-Accounting Wages 5.053 4.401 5,000 14.455 76VoV-Counter Agents Wages 10.912 10.051 10.269 31.212 7OV5V'Parking Aunndw^tsWages 123 V O 123 r673V'Service Wages 5.210 8.468 5.344 17.027 7V81V' Incentive Pay 1.136 2.413 3.295 6.844 78850 Bus Line Driver 15.358 14.100 14.515 43.973 7VV7s-Vehicle Transfer Driver 845 128 178 1.151 TV9VO-Payroll Tax Expense Employment Security 421 412 401 1.234 RCA 2.831 2.872 2.862 8.784 FUnu 32 18 4 50 Labor&Industries 1.472 1.2*7 1.261 3.981 Medicare 686 672 093 2.050 769V0'Payroll Tax Expense'Other '271 '285 '329 '89* Total T8900- Payroll Tax Expense 5.271 4.822 4.981 15.184 7VV1V'Other Personnel Expenses Dental Work for Dan Campbell O '2.058 n '2.058 Drug-Alcohol Tests/DOT Physical 75 115 75 265 7Gg1O-Other Personnel Expenses-Other 14 O 2.683 2.703 Total 7V91V'Other Personnel Expenses 83 '1.937 2.758 810 7892U' Medical Insurance 8.811 8.812 8.819 20.542 Total Personnel Expense 58.865 55.103 60.818 174.787 Selling Expense 741UO-Travel Agency Commissions 52 35 74 151 743VV'Credit Card Commissions 1.071 247 1.588 2.887 r4350'Credit Card Expense 00 60 D 120 74428- eusLinue Greyhound Discounts 157 150 158 471 745O0-Reservation Expense 1.737 582 1.047 3.316 748OO-Other Selling Expenses Carfax 92 64 O 157 Dna|ers|inx<M|S> 590 590 590 1.770 myTA 0 144 144 233 Total 748nV'Other Selling Expenses 688 738 734 2,220 Total Selling Expense 3.768 1.817 3.581 9.184 Total Expense 120.031 101.518 130.394 352.542 Net Ordinary Income 22.450 1.760 '88.121 '63.811 Other|nonme/Expunse Other Income 80100'Gain/Loss on Sale ofAssets 0 0 64.841 84.341 Total Other Income V O 04.3*1 54.3*1 Other Expense Income Tax Expense 0V0VO-Federal Income Tax Expense O O 012 012 Total Income Tax Expense 0 O 612 012 Total Other Expense V V 012 012 Net Other Income n n 63.730 63.730 Net Income 22.450 1.760 '24.391 481 Page ' � Heckman Motors, Inc. //--l - ---~-__— ` T- owow4 Balance Sheet Aamf December 31' 2013 Dec 31.13 ASSETS Current Assets Checking/Savings 10200-Cash inDrawers Cash neQiotur'PurtAngn|pso75 275.00 Driver Bank'Adams,Wayne 40.00 Driver Bank'Lee,Jessica 40.00 Driver Bank'Nelson,Willie 40�00 Driver Bank'Pouionn'Cap 40.00 Driver Bank'Sebastian,John 40.00 DrivarBank-Thaning.Chadon 40.00 Driver Bank-Wallace,Anthony 40�00 Total 1VuOD-Cash inDrawers 555.00 1O3VV' Fidelity Brokerage Account 1.200.33 10400'First Federal Checking 160.818.88 1&*2s' First Federal Money Market 815.62 10*J0' First Federal Cap.Replace m.M 833.88 Total Checking/Savings 104.224.71 Accounts Receivable 112OV'Credit Card Receivables 1.758.00 113VV'Accounts Receivable 108.470.44 Total Accounts Receivable 110.22852 Other Current Assets 14990- UndmpoeitodFunds 316.83 171DV'Gasoline Inventory Motor Oil Inventory-PA 015.32 Port Angeles Gas 2.387.20 7ma| 1r1UV'Gasoline Inventory 3.002,58 1810V' Prepaid Insurance-OoLvane 6.393.00 18200-Auto Insurance Deposit 2.500.00 18250- portofPASnouhtyDepoait Budget Rent A Car(Rite Bms.) 500.00 Total 18250-Port ofpASecurity Deposit 500.00 18520' Prepaid PA Yellow Pages 4.520.88 18540' Prepaid OBL Yellow Pages 3.378.65 1V7VV'Prepaid Federal Tax 3.238.80 u411V- Heckman,Jack Receivable 1.774.05 Total Other Current Assets 25.016�04 Total Current Assets 300.069.27 Fixed Assets 2O%nV'Leasehold Improvements 10*Front St.,PA 4.770.67 :apne Lot Paving 18.837.17 PA DT Bathroom Floor 05-08 849.66 2O30O'Leasehold Improvements'Other 20,211.23 ----'---- Total 203OV-Leasehold Improvements 44.108.75 e0350-PADT Surveillance System 2.508.46 2O38n'Signs "l 11 E. Front 8t.^Sign 2.08228 ^Bvdget^Lit Garage Sign 1.542.32 "Heckman Motors, Inc."Sign 1.772.98 4oapns Lot Signs(NO^BUDGEr') 1.065.05 Total 2V3V0-Signs 7.062.61 20400' Furniture and Fixtures 1PAoT Customer Service Chair 28519 3 PA OT Customer Service Chairs 980.01 Jack's Desk 1.083.98 Page Heckman Motors, Inc. ownwu Balance Sheet Asof December 31' 2Oi3 Dec 31. /3 Jack's Office Chair 320.87 oV4VV-Furniture and Fixtures'Other 4.788.65 Total%04U0'Furniture and Fixtures 7.465.31 20450-Parking Lot Assets 3 Halogen Floodlights 1.517.60 J New PADTParking Lot Lights 2.525.72 s Pay Boxes/Signs(_/ng) 10.76&66 Laser Sight for RugorGP-1V1 266.91 Security wugorPistol 37225 Snow Removal Tractor 2.081.44 Trimmer/Pruner for Lot Maint. 74128 Total%0460-Parking Lot Assets 10.87387 %0*0V'Office Equipment Accessories for Digital Camera 330.46 CononCn|orLamnrPrinuar/Suanner 2.343.61 Digital SLR Camera for Car8a|os 586.05 Jack's Cell Phone(Rep|acemont) 858.74 uV*0o'Office Equipment'Other 10.422.67 ------- Total oVS00-Office Equipment 14.047.58 200O0'Garage Equipment/Fixtures Carpet Cleaner Extractor 887.36 Garage Lighting-2006 1.809.30 Go,eQnLightinS'2O08 2.157.10 Gorag*LighUng'2VV9 315.96 Generator 650,33 Lighted Paint Meter 323.39 Miter Saw 867.13 Ozone Machine 512.54 Parking Lot Vacuum 1.191.32 Pressure Washer 401.07 Vacuum Cleaner for Buses 46377 Windshield Repair Tool 669.41 Total 2n6VV'Garage Equipment/Fixtures 10.410.00 207VO-Computer Software New Fi|omakor Pro for OBLComp. 2.020.20 VoL Computer Software Grant$Ruuoivmd/OBLSoftware '3.59854 oBL Computer Software'Other 8.857.93 Total O8L Computer Software 3.05839 QB Enterprise Solutions 2009 2.e26.80 Windows nP for Jack's Computer 216.79 2V7UV'Computer Software'Dther 2.655.33 Total 20700'Computer Software 11.077.51 3V8VV'Computer Hardware Battery Backup'SemnrComputor 254.74 Computer'East Cumt SnmDevk 1.073.11 Computnr-Jauk'e 19^LCD Monitor'Jack's 270.99 Cumpuou,Jonx'e(March oV1u) 1.12460 mnmoryUpgmdo-Jauk'eDosk 26558 Tota|Compuier-JaoKa 1.061.17 Computer'Jack's Apple Laptop 1.175.96 Computer'Jack's Mini Laptop 377.23 Computer'North Desk 1.017.88 Computer'Pam's Accounting 1.292.16 Computer'Sales(0an'o) 99727 Computer'South Customer Gem 1.687.16 Monitor-Sales Dept. Desk 263.48 neL Computer Hardware Page Heckman Motors, Inc. nwoww Balance Sheet Asof December 31' 2013 Dec»1'13 Grant$Rauoi,odK]BLHardware -2.770.58 OBL Computer Hardware'Other 4.405.30 Total nBL Computer Hardware 1.034.78 OeL Computer/Middle Desk 700.57 OBL Marketing/Training Computer 570.20 pADTSomar+uCounmrComputero 0.042.21 20800-Computer Hardware'Other 4.178.21 Total 2VVVV'Computer Hardware 25.479.13 20855-Acoumu|madDopmoiatinn -127.921.51 31000- Fleet-OBLBuyeqs Bike Racks'2 Existing Busses Grant$Received/Bike Racks -1.068.47 Bike Racks'u Existing Busses'Other 2.210.70 Total Bike Racks'2 Existing Busses 1.1*1.25 VVi'Fi Equip.for Buses 1.938.15 Total%1V0O-F|om+O8LBusses 3.079.88 21090-Aooum. Depreciation-Buses '3.078.00 2110V'Fleet-Rental Vehicles Veh#JC103 Winch#2 973.46 u11VV'Fleet-Rental Vehicles'Other 528.304.89 --------- Total 2110V-Fleet-Rental Vehicles 529.27&35 u118u'Acoum.Depreciation-Rental '112.053.83 212VV'Vehicle Equipment OohbriUatur-Bue#a 1.17579 Defibrillator'Bus#V 1.17579 Defibrillator'Bus#7 1.175.79 Total 21%0O-Vehicle Equipment 3.527.37 z14UO'Fleet-Vehicle(Non Depreciable) 1O8'2V0U Porsche noxste, 12.050.35 119'oV0o Pontiac Sun8m 3.895,91 29'2OO6 Yamaha Motorcycle 2.040.00 »*-uD08 Yamaha Motorcycle 2.550.29 so-Gn|fCart 282.27 84-19D1 GmC Fire Truck 8.79823 Total 214VO-Fleet-Vehicle(Non Depreciable) 23.023.05 Total Fixed Assets 402.148.02 Other Assets z710O-Franchise-Budget 7.000.00 27200 AucumAmvrtFranchise-Budget -5.000.00 28200 TmnmponaUonpermit-0BL 20.000.00 uV3O0-AroumAmortization-Permit '19.551�00 o84V0-Budget R4 -20.00 29989-A/R from HEtoHM 2.198.47 Total Other Assets 4.627.47 TOTAL ASSETS 766.844.76 ==== LIABILITIES&EQU|TY Liabilities Current Liabilities Accounts Payable 30001 -»IPmnMhnm HE 2.198.47 3V1U0-Accounts Payames 22.428.11 Total Accounts Payable 24.624.58 Credit Cards 30105-Credit Card Poyab|ns American Express 434.39 Page ` Heckman Motors, Inc. 04/04/14 Balance Sheet Asmf December 31' 2O13 Dec 31.13 Bank of America'Drivers 4.742�60 Bank of America'Jack 22.149.88 Bank nf America'Jim 100.42 Total 30105-CmditCardPayab|ns 27.496.29 Total Credit Cards 27.488.29 Other Current Liabilities 30155 10sE. Front/Security Deposit 1.200.00 30300 Sales Tax Payable 7.752.77 JO3Vg'Payroll Tax Liabilities 304O0- Federal Withholding Payable 2.762.00 3041O- FICA Tax Payable 2.857.26 3U*1s'Medicare Tax Payable 668.1* xVV0V' FUTA Tax Payable 49.60 30700-SUTA Tax Payable 1.336.71 JnnVn-Labor&Industries Payable 5.107.38 Total 30%99- Payroll Tax Liabilities 12.081.09 Total Other Current Liabilities 21.033.80 Total Current Liabilities 73,754.73 Total Liabilities 73.75473 Equity 3VDVO' Retained Earnings-HM 087.648.11 39801 ' RetainodEarningo'HE -2.188.47 *V1Oo'Common Stock-Heckman Motors 33.300.00 6O30U-Treasury Stock '14.000.00 5V4nV- Dividends Diviuendo-JaoxHnohman '22.832.00 Di,idandu-J|mHncxman -32.568.00 Total s04VV'Dividends '55.200.00 Net Income *3.542.39 Total Equity 093.090.03 TOTAL LIABILITIES&EQUITY 786,844J8 =—~—= Page