Loading...
HomeMy WebLinkAbout2.63 Correspondence 2Heckman Motors, Inc. 10/25/12 Profit & Loss -PA DT Rentals/Bus/Charter/City Parking/Sales July through September 2012 Jul 12 Aug 12 Sep 12 `;t At. Ordinary Income/Expense Income 61100• Mileage -Car 216 90 243 61150 • Mileage -Truck 23 0 75 61200 • Time/Daily Rental -Car 17,303 20,555 17,906 5 61250 • Truck Daily Rental 244 900 160 1 61300 • Loss Damage Waiver (LDW) 1,379 1,793 1,563 4,736 61400 • Discounts 0 0 -27 -27 61550 • Cash Over/Short -0 6 7 13 61701 • Intercity Car Rental <Revenue> 1,238 2,796 2,158 6,192 61702 • Intercity Car Rental <Expense> -1,663 -3,345 -731 -5,739 62103 • P.A.E. <Revenue> 18 0 12 30 62104 • P.A.E. <Expense> -5 0 -3 -8 62107 • Extra Driver Fee 10 10 20 40 62109 • Underage Driver Fee 10 20 60 90 62115 • GPS Rental 6 21 9 36 62200 • Other Income 62201 • Retail Car Sales -Gross 0 7,950 0 7,950 62202 • Wholesale Car Sales -Gross 27,350 0 0 27,350 62204 • Other Rental Income 20 0 20 40 62220• Interest 0 0 1 1 Total 62200 • Other Income 27,370 7,950 21 35,341 62250 • Bus Lines Revenue BusLines Express Freight 375 190 75 640 Greyhound Sales Commission 481 208 292 982 OBL Bus Revenue 55,562 58,745 48,724 163,030 Total 62250 • Bus Lines Revenue 56,417 59,143 49,091 164,652 62260 • Charter Revenue 2,041 5,024 1,590 8,655 62275 • Grant Money Income Grant $-Old Program Calculation 23,371 18,270 33,522 75,162 Grant $-Over/Under Old Program 17,536 23,628 6,949 48,112 62275 • Grant Money Income - Other 0 0 0 0 Total 62275 • Grant Money Income 40,907 41,898 40,470 123,275 62701 • S.L.I. <Revenue> 684 349 463 1,496 62702 • S.L.I. <Expense> -294 -150 -232 -676 63550 • 105 Front St. PA Lease Revenue 600 600 600 1,800 64000 • Daily Parking Revenue 2,322 3,159 1,989 7,470 64200 • Long Term Storage Revenue 757 683 395 1,835 Total Income 149,584 141,502 115,841 406,926 Cost of Goods Sold 70050 • Cost of Sales-Whlse Cars Gross 29,210 0 0 29,210 70790 • Cost of Sales -Retail 0 7,368 0 7,368 Total COGS 29,210 7,368 0 36,578 Gross Profit 120,374 134,134 115,841 370,349 Expense Advertising & Promotion Expense 73000 • Television Expense 2,940 3,029 69 6,039 73100 • Yellow Pages Expense 878 876 788 2,543 73200 • Newspaper Expense 1,942 1,152 3,522 6,616 73300 • Radio Expense 1,411 1,546 1,277 4,234 73400 • Billboard Expense 978 1,200 1,200 3,378 73500 • Rack Cards (Printing/Distrib.) 1,012 0 0 1,012 73900 • Advertising and Promotion 153 108 663 924 Total Advertising & Promotion Expense 9,315 7,911 7,520 24,746 Direct Vehicle Expense 70100 • Depreciation Expense -Vehicle 6,963 6,541 7,452 20,956 70110 • Interest Expense -Vehicles 0 0 0 0 70115 • Fleet Lease Expense 1,465 1,465 1,465 4,396 70200 • Insurance Exp. -Vehicles 3,118 3,025 3,214 9,357 Page 1 Heckman Motors, Inc. 10/25/12 Profit & Loss -PA DT Rentals/Bus/Charter/City Parking/Sales July through September 2012 Jul 12 Aug 12 Sep 12 TOTAL 70210 • Parts Expense 2 145 71 218 70220 • Tires Expense 0 0 963 963 70300 • Outside Maintenace & Repairs 1,476 3,528 2,774 7,778 70310 • Vehicle Damage Repair 4,541 0 520 5,062 70350 • Subrogation 0 -522 -3,668 -4,190 70370 • Windshield Replacement/Repair 0 445 353 798 70500 • Monthly Car Fees 1,181 1,203 1,385 3,768 70700 • Licenses -Vehicles 343 105 155 602 70750 • Other Direct Vehicle Expenses 0 0 0 0 Total Direct Vehicle Expense 19,089 15,935 14,685 49,709 General & Admn. Expense 77000 • Amortization -Franchise 132 130 133 395 77110 • Bank Charges 6 7 6 20 77120 • Equip/FurnExpense-Less than$250 60 45 18 123 77130 • Interest Expense -Non Auto 0 0 0 0 77200 • Office Supplies 457 169 746 1,371 77210 • Postage and Freight 80 118 0 199 77230 • Telephone Expense 1,375 949 862 3,185 77260 • Depreciation Expense 176 177 176 530 77340 • Professional Fees -Consultants 0 0 0 0 77400 • Meals & Entertainment 150 20 33 203 77405 • Travel & Meetings 0 3 1 4 77410 • Dues and Subscriptions 1,121 73 49 1,243 77420 • General Insurance Expense 0 0 463 463 77425 • Customer Goodwill 0 122 0 122 77430 • Other General Expenses OBL Hotel (ALL HOTELS) -245 -104 -169 -518 Snacks/Water for Passengers 728 808 684 2,219 Total 77430 • Other General Expenses 482 704 514 1,701 77450 • Donations Expense 4 52 0 56 77510 • Uniform Expense 0 60 451 512 77820 • Computer Equipment -Maintenance 65 231 65 361 77900 • Taxes & Licenses -Business 77901 • Business Licenses 0 0 0 0 77902 • Business Taxes 2,057 2,251 1,894 6,202 Total 77900 • Taxes & Licenses -Business 2,057 2,251 1,894 6,202 Total General & Admn. Expense 6,165 5,111 5,411 16,687 Occupancy Expense 75110 • Rent 4,827 4,827 4,827 14,480 75200 • Utilities 450 559 463 1,471 75300 • Insurance-Buildings/Bus Stops 496 0 -1 496 75400 • Maintenance & Repair -Facilities 498 31 1,848 2,377 75600 • Sign Expense 455 0 0 455 75800 • Other Occupancy Expense 9 0 0 9 Total Occupancy Expense 6,734 5,416 7,137 19,287 Operating Expense 72100 • Garage & Washing Supplies 76 181 27 284 72110 • Oil Expense 41 46 33 119 72510 • Drop-off Collection -3,001 -2,946 -2,156 -8,103 72600 • Vehicle Transfer 0 78 0 78 72700 • Other Operating Expense Tacoma Narrow Bridge Tolls 5 8 8 21 Total 72700 • Other Operating Expense 5 8 8 21 72750 • Port Fees 215 212 225 653 72800 • Gasoline Expense 7,568 9,782 8,133 25,484 72850 • Gasoline Refueling Charge -533 -682 -409 -1,624 77415 • Ferry Fees 10,157 10,034 9,274 29,465 Total Operating Expense 14,529 16,711 15,135 46,375 Personnel Expense Page 2 Heckman Motors, Inc. 10/25/12 Profit & Loss -PA DT Rentals/Bus/Charter/City Parking/Sales July through September 2012 Jul 12 Aug 12 Sep 12 TOTAL 76200 • Corporate Officers Wages 4,205 4,226 4,208 12,638 76300 • Accounting Wages 2,813 2,884 2,555 8,253 76620 • Counter Agents Wages 8,231 8,266 8,490 24,987 76650 • Parking Attendents Wages 91 98 41 229 76730 • Service Wages 5,080 4,847 5,126 15,053 76750 • Cleaning Wages 0 0 0 0 76810 • Incentive Pay 129 219 183 531 76850 • Bus Line Driver 14,284 14,441 16,880 45,606 76875 • Vehicle Transfer Driver 633 1,025 825 2,483 76900 • Payroll Tax Expense Employment Security 436 446 471 1,353 FICA 2,389 2,439 2,554 7,382 FUTA 28 25 36 89 Labor & Industries 1,504 1,604 1,528 4,636 Medicare 559 570 597 1,726 76900 • Payroll Tax Expense - Other -332 -374 -310 -1,016 Total 76900 • Payroll Tax Expense 4,583 4,712 4,876 14,171 76910 • Other Personnel Expenses Drug -Alcohol Tests/DOT Physical 115 120 75 310 76910 • Other Personnel Expenses - Other 24 100 2 126 Total 76910 • Other Personnel Expenses 139 220 77 436 76920 • Medical Insurance 8,259 8,269 8,260 24,788 Total Personnel Expense 48,447 49,206 51,521 149,175 Selling Expense 74100 • Travel Agency Commissions 115 411 221 747 74300 • Credit Card Commissions 1,411 1,770 1,284 4,465 74350 • Credit Card Expense 60 60 60 180 74426 • BusLines Greyhound Discounts 304 250 223 777 74500 • Reservation Expense 1,155 1,203 976 3,334 74600 • Other Selling Expenses 6 9 147 162 Total Selling Expense 3,051 3,702 2,910 9,663 Total Expense 107,330 103,994 104,318 315,642 Net Ordinary Income 13,044 30,140 11,523 54,706 Net Income 13,044 30,140 11,523 54,706 Page 3