Loading...
HomeMy WebLinkAbout2.63 Correspondence 8 HECKMAN MOTORS, INC. 10/26116 Profit & Loss-PA DT Budget Rsntalls/Bus/City-Pa.rki /Sales ,duly thiruulgh September 2016 Jival 16 Aug 16 Sep 16 TOTAL Ordinary Income/Expense Income 61100• Mileage-Car 210 0 0 210, 61150 Mileage-Truck 7 1 107 115 61200 Time/Daily Rental-Car 23,060 25,42.9 16,985 66,374 61250 Truck Daily Rental 564 82 492 1,138 61300°Loss Damage Waiver(LDW) 1,750 1,826 1,305 4,681 61400 'Discounts -213 -377 -125 -7115 61450•Adjustments 0 -36 -50 -86 61550°Cash O)verl'Short 1 0 -8 -7 61701 Intercity Car(Rental<Revenue> 6„341 7,11011 6,364 19,806 61702 Intercity Car(Rental<Expense> -4,147 -5,649 -3,636 -13,432 621102 P.A.C.<Exlpense> 0 0 0 0 621103 P.A.E.<Revenue> 0 54 0 54 62104•P.A.E.<Expense> 0 -14 0 -14 62106°Cleaning Fee 0 10 0 10 62107 •Extra Driver Fee 273 26 130 429 62115 °GPS Rental 14 112 56 181 62200 •Other(Income 62202 Wholesale Car Sales-Gross 0 0 46,163 46,163 62204 Other Rental Income 250 0 0 250 62207'° Misc.Retail Income-FaxCopyMail 18 0 0 118 62220 Interest 0 0 01 0 Total 62200•,Other Income 268 0 46,163 46,431 62'250. Bus Lines.Revenue BusLines Express Freight 436 723 498 1,657 Greyhound Sales Commission 197 253 230 681 GBL Bus Revenue 66„036 69,390 60,252 195,678 OABL Cancellation Fees 0 20 01 20 Total 62250•Bus Lines Revenue 66„669 70,387 60,981 198,036 62275•DOT ContracVGrant Income Old Program Calculation 21,560 9,615 18„842 50,017 Olver/Ulndler Old Program 23,346 35,335 24,303 82,984 62275•DOT Contract(Gra,nt Income-Other 0 0 0 0 Total 62276- DOT Colntract/Grant Income 44,906 44,949 43,145 1133,001 627011 •S.L.I.<R'evenue> 363 391 460 1,214 62702•S.L.I.<Expense> -189 -203 -239 -631 67203• R.S.N.(Income) 0 39 6 45 6352'5-Celestlal Espresso Lease Revenu 100 100 100 300 63550• 105 Front St. PA Lease Revenue 600 600 600 1,800 64000°Daily Parking Revenue 4,887 4,753 4,101 13,742 64200°Long Term Storage Revenue 820 920 500 2,240 Total Income 147,186 150„500, 177,437 475,122 Cost of Goods Sold 70050•Cost of Sales-Whlse Cars Gross 0 0 39,422 39,422 Total COGS 0 01 39,422 39„422 Gross Profit 147,186 150,500 138,015 435„70'0 Expense Advertising&Promotion Expense 73000-Television Expense 2,653 2„766 2,909 8,328 73100•Mellow Pages Expense 786 994 969 2,650 73200,° Newspaper Expense 2,824 2,387 2,533 7„745 73300 .Radio Expense 1,182 1,370 1,242 3,794 73400. Billboard Expense 771 1,200 1,200 3,171 73500° Rack Cards(PrintinglDiistrib.) 1,104 0 0 1,1104 73600°Website 35 35 35 1105 73900.Advertising and Promotion 0 2145 0 215 Page 1 HECKMAN MOTORS, INC. 10126/16 Profit & Loss-PA DT Budget Rentals/Bus/City Parking/Sales July through September 2016 Jul 16 Aug 16 Sep 16 TOTAL Advertising&Promotion Expense-Other -58 -1-66 -58 282 Total Advertising&Promotion Expense 9,297 8,802 8,730 26,829 Direct Vehicie Expense 70100 - Depreciation Expense-Vehicle 17,420 17,774 17,172 52,366 70110 - Interest Expense-Vehicles 1,618 964 986, 3,568 70200- Insurance Exp.-Vehicles 3,262 3,279 3,261 9,801 702101,Parts Expense 106 98 616 821 70220-Tires Expense 0 425 173 598 70230-Towing Expense 1,187 0 0 1,187 70300.Outside Maintenace&Repairs 9,149 7,329 5,004 21,482 70310-Vehicle Damage Repair 0 971 243 1,214 70350-Subrogation 0 -884 -765 -1,648 70370-Windshield Replacement/Repair 37 60 0 97 70500-Monthly Car Fees 2,011 2,033 1,422 5,466 70700-Licenses-Vehicles 58 102 77 237 70705.VLF Pa,ssthrougih Charge -146 -159 -99 -404 70750-Other Direct Vehicle Expenses 0 0 0 0 Direct Vehicle Expense-Other -1,6,67 -3,261 -2,107 -7,035 Total Direct Vehicle Expense 33,035 28,731 25,982 87,748 General&Admn. Expense 77100-Bad Debt Expense 0 0 250 250 77110°Bank Charges 6 679 10 695 77120-EquiiIp/Furn Exp-Less than$1000 283 243 0 526 772001 Office Supplies 408 234 532 1,173 77210 Postage and Freight 124 15 23 162 77220 Supplies 1 8 22 30 77230 Telephone Expense 1,089 1,311 1,172 3,572 77240 Cable Television 90 164 172 425 77260 - Depreciation Expense 30 186 189 4015 77310 • Professional Fees-Legal 30 0 0 30 77400 - Meals,&Entertainment 0 46 17 63 77405 -Travel&Meetings 0 9 0 9 77410 .Dues and Subscriptions 307 1,855 384 2,546 7'7420 -General Insurance Expense 0 701 980 1,681 77425 °Customer Goodwi I 1 0 25 0 25 77430-Other General Expenses Bluebird Wizard Accounting 100 100 100 300 BRAC Wizard Monthly Fees 216 217 219 652 OBL Hotel(ALL HOTELS) -114 -19 -38 -171 Penaltles/Fines 600 0 0 600 Snacks/Water/Blankets for Buses Snacks/Water for Buses 955 855 837 2,646 Blankets,and Laundry Expense 88 125 149 363 Total Snacks/Water/Blankets for Buses 1,043 980 986 3,009 Vehicle Owner Info from IDOL 10 4 11 25 Total 77430-Other General Expenses 1,854 1,282 1,279 4,414 77510- Uniform Expense 344 264 0 607 77820-Computer Equipment-Maintenance 229 65 66 360 77830-Copy Machine Maintenance 0 0 0 0 77904-Taxes&Licenses-Business 77901 - Business Licenses 0 0 0 0 77902- Business Taxes 2,365 2,444 2,167 6,976 ............. ............ ........ ...... Total 77900-Taxes&Licenses-Business 2,365 2,444 2,167 6„9176 General&Admn. Expense-Other -747 -951 -605 -2,3014 Total General&Admn.Expense 6,412 8,577 6,658 21,646 Occupancy Expense Page 2 HECKMAN M�OTORS, INC. 1012611',6 Profit & Loss-PA DT Buidget Rentals/Bus/City Parking/Sales July through September 2016 Jul 16 Aug 116 Sep 16 TOTAL 75100 Airport Concession Fee 0 0 0 0 75110 Rent 5,244 5,259 5,235 15,789 75200 Utilities 597 751 750 2,098 76300-Insurance-Buildings/Bus Stops 617 0 0 617 76400-Maintenance&Repair-Facilities 3,338 0 0 3,338 75600,Sign Expense 0 0 0 0 75800.Other Occupancy Expense 10 0 0 10 Occupancy Expense-Other -2,2109 -1,486 -1,120 -4,816 Total Occupancy Expense 7,597 4,524 4,915 17,036 Operating Expense 72100-Garage&Washing Supplies 69 222 55 347 72110-Oil/Transmission Fluid Expense 122 8 55 185 72510. Drop-off Collection -50 0 0 -50 72600-Vehicle Transfer 0 0 1,265 1,265 72700- Other Operating Expense Parkingi Tickets Parking Ticket Expense 0 99 0 99 Parking Ticket Recovery Charges 0 -99 0 -99 .. ........ ..... Total Parking Tickets 0 0 0 0 Bridge Tolls Bridge Toll Expense 23 47 19 89 Bridge Toll Recovery Charges 0 -15 -17 -32 .......................... Total Bridge Tolls 23 32 2 57 Taxicab/Courier Expense 350 0 0 350 Total 72700- Other Operating Expense 373 32 2 407 72750 - Port Fees 216 213 202 632 72800 Gasoline Expense 5,,800 5,733 4,892 16,425 72850 Gasoline Refueling Charge -601 -884 -370 -1,855 77416 Ferry Fees 11,109 11,516 10,959 33,584 Operating Expense-Other -28 -72 -8 -108 ..........-- - Total Operatingi Expense 17,011 16,768 17,053 50,832 Personnel Expense 76200-Corporate Officers Wages 5,285 5,419 5,541 16,244 76300-Accounting Wages 6,191 6,191 5,579 17,962 76620-Counter Agents Wages 10,753 10,610 9,425 30,788 76650-Parking Aftendents Wages 123 100 92 314 76730-Service Wages 5,196 4,647 4,460 14,303 76800 Temporary Help, 0 631 786 1,417 768110 Incentive Pay 607 555 535 1,697 76860, Bus Line Driver 15,599 13,896 16,211 45,706 76876-Vehicle Transfer Driver, 2,586 1,362 150 4,098 76900° Payroll Tax Expense Employment Security 60 54 51 166 FICA 3,276 3,021 2,878 9,175 FUTA 72 36 27 135 Labor&Industries 1,586 1,528 1,287 4,402 Medicare 766 707 673 2,146 76900,- Payroll Tax Expense-Other -662 -589 -425 -1,675 Total 76900 , Payroll Tax Expense 5,097 4,758 4,492 14,348 76910 -Other Personnel Expenses Driver Training 68 136 136 340 Drug-Alcohol TestsIDOT Physical 175 265 290 730 Other Employee Training 0 0 66 66 76910 -Other Personnel Expenses-Other 383 276 455 1,114 Total 76910-Other Personnel Expenses 626 677 948 2,250 Page 3 HECKMAN MOTORS, INC. 10126116 Profit & Loss-PA DT Budget Rentals/Bus/City Parking/Sales July through September 2016 Juil 16 Aug 16 Sep 16 TOTAL 76920 - Medical Insurance 7„017 6,912 7,031 20,960 Personnel Expense-Other -10,179 -9,664 -6,511 -26,355 Total Personnel Expense, 48,901 46,093 48,738 143,732 Selling Expense 74100-Travel,Agency Commissions 11 29 9 49 74300-Credit Card Commissions 1,750 1,981 1,,373 5,104 74426 BusLines Greyhound Discounts 301 328 241 869 74500 Reservation,Expense 1,997 2044 1,616 5,657 74600 Other Sellingi Expenses BRAC Equifax Credlit Reporting 0 825 0 825 AVISIBRAC Rategain 39 39 39 118 NBTA 6 9 151 166 Total 74600 -Other Selling Expenses 45 873 191 1,109 Selling Expense-Other -20 -432 -20 -472 Total Selling Expense 4,,084 4,823 3,409 12,317 Total Expense 126,337 118,317 115,485 360,140 Net Ordinary Income 20,848 32,182 22,530 75,560 Net Income 20,848 32,182 22,530 76,560 Page 4 6:33 PIWi Heckman Enterprises, Inc . ..._._ to - 10126116, ..10126116 Profit & Loss-AVIS Downtown Accrual Basis ,July through September 2016 Jul 16 Aug 16 Sep 16 TOTAL Income 61100 Mlilleage-Car 197.61 1,074,59 276.20 1,548.40 62115 GPS Rental 41.85 69.75 0.00 111.60 61200 Tilme{Daily Rental-Car 27,435.70 31,258.11 19„398.63 78,092.44 61300 Lass Damage Waiver(LDWW) 463.84 753.74 434.85 1,652.43 611400• Discount -2,576.55 -2,576.71 -2,315,57 -7,872.83 61450 •Adjustments -134.43 -636.48 -98.26 -869.17 61550 •Cash Over/Short 0.00 01.00 0.00 0.00 617011 - Intercity Car Rental(Revenue) 10,557.85 10,480.71 5°706.32 26,744.88 61702• Intercity Car Rental(Expense) -3,994.46 -5,436.44 1,590.45 -11,021.35 62103• P.A.E.(Revenue) 0.00 71.40 0.00 71.40 62104 P.A.E.(Expense) 0.00 -18.56 0.00 -18.56 62107 ° Extra Driver Fee 364.00 39.00 52.00 455.00 62109 Underage Driver Fee 27.00 135.00 0,00 162.00 621111 •GA-Government Rate Surcharge 0.00 0.00 5.00 5.00 62300 Baby Seat Income 0.00 78.00 0.001 78.00 627011 S.L.I.(Revenue) 530.10 585.90 69.75 1,185.75 62702 S.L.I.(Expense) -275.65 -304.67 -36.27 -616,59 67203 R.S.N.(Revenue) 0.00 38.94 0.00 38.94 Total Income 32,636.86 35,212.28 21,898.20 89,747.34 Expense Advertising and Promotion 73100-Yellow Pages Expense 58.10 58.10 58.10 174.30 73900 Misc.Advertising and Promotion 0.00 107.50 0.00 1017.50 Total Advertising and Promotion 58.10 165.60 58.10 281.80 Direct Vehicle(Expense 70350 °Subrogation 0.00' -883.76 -352.00 -1,235,76 70705-VLF Passthrough Charge -337,04 -411.84 -310.20 -1,059.08 70110 °Interest Expense-Vehicles 859.46 535.48 501.30 1,896.24 70200 ° Insurance Exp.-Vehiicies 677.46 718.18 647.90 2,043.54 70210 • Parts Expense 4.30 0.00 296.74 301.04 70220 Tires Expense 0.00 197.50 87.93 285.43 70300 Outside Maintenance&Repairs 75.46 2,151.74 885.83 3,113.03 70310 •Vehicle Damage Repair 0.00 485.49 0.00 485.49 70370•Windshield Replacement/Repair19.43 0.00 0.00 19.43 70500.Monthly Car Fees 000 0.00 1,313.60 1,313.60 70700 Licenses-Vehicles 30.96 56.49 39.26 126.71 70750 Other Direct Vehicle Expenses 0.00 4,142.23 0.00 4,142.23 Total Direct Vehicle Expense 1,330.03 6,991.51 3,110.31 11,4311.90 General&Admin Expense 77000 Amortization-Franchise 52.82 52.76 53.76 159.34 77100 Bad Debt.Expense 0.00 0.00 0.00 0.00 77110 •Bank Charges 0.00 335.83 0.00 335.83 77120 Equip/Furn Exp-Less than$1',,000 68.83 33,51 0.00 102.34 77200 Office Supplies 95.54 60.46 114.79 270.79 7721'0 Postage and Delivery 26.63 10.47 0.00 37,10 77220•Supplies 0.00 0.00 11.18 11.18 77230•Telephone Expense 150.26 189.71 139.22 479.19 7°7240 Cabe Television Expense 21.76 41.11 32.36 95.23 77300 Professional Fees-Accounting 0.00 0.00 0.00 0.00 77310 Professional Fees-Legal 0.00 0.00 0.00 0.00 77400 deals and Entertainment 0.00 17.25 0.00 17.25 77405°Travel&Meetings 0.00 1.92 0.00 1.92.' 77410•Dues and Subscriptions 87.32 267.62 54.04 408.96 77420•General insurance Expense 0.00 43.49 244.97 288.46 77425 Customer Goodwill 0.00 0.00 0.00 0.00 77430,.Other General'Expenses AVIS Wizard'Monthly Fees 0.00 0.00 0.00 0.00 Bluebird Wizard Accounting 50,00 50.00 50.00 150.00 Record360 Monthly Subscription 0.00 0.00 0.00 0.00 Pagel 6:33 PM Heckman Enterprises, Inc. 10126116 Profit & Loss-AVIS Downtown Accrual Basis, July through September 2016 Jul!16 Aug 16 Sep 16 TOTAL . ...................... Total 77430 -Other General Expenses 50,00 50-00 50.00 150,00 77510 - Uniform Expense 24870 -21.22 0.00 227.48 77820 -Computer Equipment Maintenance 55.63 16.27 12.49 84.39 77830-Copy Machine Maintenance 0.00 0.00 0,00 0.00 77900,•Taxes&Licenises-Business 779011 Business Licenses and Permits 78.00 0,00 0.00 78.00 779012 Business Taxes 0.00 0.00 508.37 508.37 Total 77900•Taxes&L11censes-Business 78.00 0.00 508.37 586.37 Total General&Admin Expense 935.49 1,099.18 1,221.18 3,255.85 Occupancy Expense 75100 Airport Concession Fee 0,00 0.00 0.00 0.00 75110,-Rent 1,266.19 1,313,12 989.32 3,568.63 762010-Utilities 131.60 173.17 131.14 435.91 754010 -Maintenance&Repair-Facilitles 811,15 0.00 0.00 811.15 Total Occupancy Expense 2,208.94 1,486.29 1,120.46 4,815,69 Operating Expense 721010 -Garage&Washing Supplies 17.60 56.94 10.89 85.43 72510, Drop-Off Collection -249.00 -200.00 0.00 -449.00 72600 -Vehicle Transfer Expense 0.00 0.00 0.00 0.00 72700 -Other Operating Expense Bridge Tolls Bridge Tolls 01.00 0.00 7.00 7.00 Bridge Toll Recovery Charges 0.00 0.00 -17.00 -17.00 Total Bridge Tolls 0.00 0.00 -10.00 _10.00 Total 72700 -Other Operating Expense 0.00 0.00 -10.00 -10.00 72800 -Gasoline Expense 300.80 167.41 38.47 506.68 72850 -Gasoline Refueling Charge -44316 -417.47 -469.00 -1,329,63 Total Operating Expense -373.76 -393.12 -429.64 -1,196.52 Personnel Expense 76200 Corporate Officers Wages 1,284.25 1,361.22 1,044.41 3,689.88 76300 Accounting Wages 1,504.51 1,555.29 1,051.69 4,111.49 76620-Counter Agent Wages 2,556,29 2,59676 1,851.10 7,004,15 76730. Service Wages 1,319.64 1,217.51 87615 3,413.40 76800-Temporary Help 0.00 165.36 154.38 319.74 76810- Incentive Pay 92.10 95,32 71.84 259.26 76876-Vehicle Transfer Driver Wages 0.00 756.62 7617 832.79 76900 Payroll Tax Expense 961.20 813,44 509,42 2,284.06 76910 Other Personnel Expenses 19.616 26,42 12.52 58.60 76920 Medical Insurance 1,068.09 1,076.44 863.00 3,007.53 Total Personnel Expense 8,805.74 9,664.48 6,510.68 24,980.90 Selling Expenses 74100 Travel Agency Commissions 461,85 452.83 230.59 1,145,27 74300 Credlit Card Commissions 1,060-13 766.05 355,59 2,181,77 74500 Reservation Expense 396.92 382,55 198,60 978,07 74600 Other Selling Expense AVIS/BRAC Rategain 19.67 19.67 19,67 59.01 AVIS,"AID"Charges 101.95 122.26 51.40 275.61 AVIS Equifax Credit Reporting 0,00 412.50 0.00 412.50 AVIS Loyalty Earnings Fees 68.82 78.76 4.36 151.94 Total 74600-Other Selling Expense 190A4 63119 75.43 899.06 Total Selling Expenses 2,109.34 2,234.62 860.21 5,204.17 Total Expense 15,07188 21,248,56 12,451.35 48,773,79 Page 2 6:33 PM Heckman Enterprises, Inc. 10126116 Profit & Loss-AVIS Downtown Accrual Basis July through September 2,016 Jul 16 Aug 16 Sep 16 TOTAL Net Income, 17,562M 13,963.72 9,446.65 40,973.55 ...................... Page 3