Loading...
HomeMy WebLinkAbout2.63 Correspondence 10 2.63 Heckman Motors C. 04/24/15 Profit & Loss- A l DT Rentals/Bus/Charter/Cit l- r ing/Sales January through March 2015 Jan 15 Feb 15 Mar 15 TOTAL Ordinary Income/Expense Income 61150 • Mileage-Truck 73 13 35 121 61200•Time/Daily Rental-Car 7,788 4,757 7,432 19,978 61250 •Truck Daily Rental 32 132 154 318 61300 Loss Damage Waiver(LDW) 529 621 872 2,021 61400 Discounts -46 -51 -63 -159 61450•Adjustments -254 0 0 -254 61550 Cash Over/Short -0 -1 10 9 61701 Intercity Car Rental<Revenue> 1,038 564 1,196 2,798 61702 Intercity Car Rental<Expense> -1,013 -429 -1,061 -2,503 62103• P.A.E.<Revenue> 18 18 30 65 62104• P.A.E.<Expense> -5 -5 -8 -17 62109 Underage Driver Fee 0 0 54 54 62200 Other Income 62201 • Retail Car Sales-Gross 0 14,800 0 14,800 62202•Wholesale Car Sales-Gross 47,590 90,955 43,975 182,520 62204•Other Rental Income 0 0 115 115 62209 • Reimbursement of an Expense 0 0 230 230 62220• Interest 0 0 0 0 Total 62200•Other Income 47,590 105,755 44,320 197,665 62250 • Bus Lines Revenue BusLines Express Freight 300 325 209 834 Greyhound Sales Commission 143 141 163 447 OBL Bus Revenue 43,170 33,722 49,354 126,246 Total 62250 • Bus Lines Revenue 43,613 34,188 49,726 127,527 62275• Grant Money Income Grant$-Old Program Calculation 40,828 38,266 40,264 119,358 Grant$-Over/Under Old Program 3,213 284 3,226 6,722 62275•Grant Money Income-Other 0 0 0 0 Total 62275•Grant Money Income 44,041 38,550 43,490 126,080 62701 •S.L.I.<Revenue> 184 324 237 745 62702 S.L.I.<Expense> -92 -162 -119 -373 63525 Celestial Espresso Lease Revenu 100 100 100 300 63550• 105 Front St.PA Lease Revenue 600 600 600 1,800 64000 • Daily Parking Revenue 135 493 646 1,274 64200 • Long Term Storage Revenue 665 845 805 2,315 Total Income 144,996 186,313 148,456 479,766 Cost of Goods Sold 70050•Cost of Sales-Whlse Cars Gross 45,695 86,178 37,014 168,887 70790 •Cost of Sales-Retail 0 12,917 0 12,917 Total COGS 45,695 99,095 37,014 181,804 Gross Profit 99,301 87,218 111,442 297,962 Expense Advertising&Promotion Expense 73000 •Television Expense 2,326 3,704 2,210 8,239 73100 •Yellow Pages Expense 1,006 981 981 2,968 73200 Newspaper Expense 0 1,248 1,825 3,074 73300 Radio Expense 1,344 1,344 1,478 4,166 73400 • Billboard Expense 1,200 1,200 2,400 4,800 73600 Website 89 35 35 159 73700 KONP Home Show 450 0 0 450 73900 Advertising and Promotion 75 75 825 975 Advertising&Promotion Expense-Other -63 -63 -63 -188 Total Advertising&Promotion Expense 6,427 8,524 9,692 24,643 Direct Vehicle Expense 70100 Depreciation Expense-Vehicle 9,189 7,047 6,969 23,206 70110 Interest Expense-Vehicles 0 0 0 0 70200 • Insurance Exp.-Vehicles 2,679 2,500 2,491 7,670 Pagel Heckman Motors, Inc. 04/24/15 Profit & Loss-PA DT Rentals/Bus/Charter/City Parking/Sales January through March 2015 Jan 15 Feb 15 Mar 15 TOTAL 70210 • Parts Expense 58 0 260 318 70220 •Tires Expense 492 0 383 876 70230•Towing Expense 0 0 509 509 70300•Outside Maintenace&Repairs 4,584 3,157 9,246 16,986 70350 Subrogation -1,324 -20 0 -1,344 70370 Windshield Replacement/Repair 0 0 0 0 70500 Monthly Car Fees 609 410 645 1,665 70700 Licenses-Vehicles 56 196 426 679 70750•Other Direct Vehicle Expenses 0 0 0 0 Direct Vehicle Expense-Other -254 -631 -412 -1,297 Total Direct Vehicle Expense 16,089 12,660 20,519 49,268 General&Admn.Expense 77110 • Bank Charges 6 81 40 127 77120 • Equip/Furs Exp-Less than$500 0 0 69 69 77200 •Office Supplies 944 341 253 1,537 77210• Postage and Freight 137 30 41 209 77220•Supplies 0 0 2 2 77230 •Telephone Expense 790 878 1,049 2,717 77260 Depreciation Expense 24 24 24 72 77300 Professional Fees-Accounting 0 0 1,838 1,838 77310 • Professional Fees-Legal 150 0 0 150 77400 Meals&Entertainment 17 761 32 810 77405 Travel&Meetings 0 1,683 0 1,683 77410• Dues and Subscriptions 748 80 838 1,666 77420•General Insurance Expense 0 0 0 0 77425 •Customer Goodwill 0 0 40 40 77430 • Other General Expenses Bluebird Wizard Accounting 100 100 100 300 BRAC Wizard Monthly Fees 206 171 184 562 OBL Hotel(ALL HOTELS) -165 -35 -108 -307 Snacks/Water/Blankets for Buses 690 644 766 2,100 Vehicle Owner Info from DOL 9 4 2 15 Total 77430 •Other General Expenses 840 885 945 2,669 77510• Uniform Expense 30 0 116 145 77820 •Computer Equipment-Maintenance 76 70 71 216 77900 •Taxes&Licenses-Business 77901 • Business Licenses 236 0 150 386 77902 • Business Taxes 1,804 1,522 2,083 5,409 Total 77900 •Taxes&Licenses-Business 2,040 1,522 2,233 5,795 General&Admn. Expense-Other -246 -89 -234 -569 Total General&Admn. Expense 5,555 6,264 7,356 19,175 Occupancy Expense 75100•Airport Concession Fee 0 0 0 0 75110 • Rent 5,402 5,284 5,350 16,036 75200 Utilities 783 684 647 2,114 75400 Maintenance&Repair-Facilities 0 0 2 2 75800• Other Occupancy Expense 13 0 0 13 Occupancy Expense-Other -254 -231 -159 -644 Total Occupancy Expense 5,943 5,736 5,840 17,519 Operating Expense 72100 Garage&Washing Supplies 183 55 115 352 72110 Oil/Transmission Fluid Expense 112 77 105 294 72600•Vehicle Transfer 0 690 1,337 2,027 72700 •Other Operating Expense Bridge Tolls Bridge Toll Recovery Charges -171 5 -5 -171 Bridge Tolls-Other 436 50 79 564 Total Bridge Tolls 265 55 74 393 Taxicab Expense 0 0 262 262 Page 2 Heckman Motors, Inc. 04/24/15 Profit & Loss-PA DT Rentals/Bus/Charter/City Parking/Sales January through March 2015 Jan 15 Feb 15 Mar 15 TOTAL Total 72700 •Other Operating Expense 265 55 335 655 72750 • Port Fees 146 130 144 420 72800•Gasoline Expense 4,938 4,346 5,248 14,533 72850 •Gasoline Refueling Charge -30 -90 -113 -233 77415• Ferry Fees 8,391 7,351 8,536 24,278 Operating Expense-Other -41 -50 -210 -301 Total Operating Expense 13,964 12,563 15,497 42,024 Personnel Expense 76200•Corporate Officers Wages 6,333 5,817 5,914 18,064 76300 Accounting Wages 5,596 4,465 4,580 14,640 76620 Counter Agents Wages 8,655 7,632 8,665 24,951 76650 Parking Attendents Wages 45 50 122 217 76730 Service Wages 4,525 4,453 4,667 13,645 76810 Incentive Pay 110 78 292 480 76850 Bus Line Driver 15,807 13,082 13,940 42,829 76875 Vehicle Transfer Driver 58 20 0 78 76900 Payroll Tax Expense Employment Security 149 131 141 422 FICA 2,624 2,360 2,508 7,492 FUTA 254 191 151 596 Labor&Industries 1,190 1,104 1,218 3,512 Medicare 614 552 587 1,752 76900• Payroll Tax Expense-Other -114 -232 -211 -557 Total 76900 • Payroll Tax Expense 4,717 4,106 4,394 13,217 76910 •Other Personnel Expenses Drug-Alcohol Tests/DOT Physical 0 370 262 632 76910 •Other Personnel Expenses-Other 8 320 3 331 Total 76910 •Other Personnel Expenses 8 690 265 963 76920 • Medical Insurance ACA Reinsurance Fees(IRS) 29 29 29 88 76920 • Medical Insurance-Other 8,760 8,491 8,564 25,815 Total 76920 • Medical Insurance 8,790 8,520 8,594 25,903 Personnel Expense-Other -1,426 -1,273 -907 -3,606 Total Personnel Expense 53,218 47,641 50,525 151,383 Selling Expense 74100•Travel Agency Commissions 8 8 0 16 74300 •Credit Card Commissions 854 256 1,242 2,352 74426 • BusLines Greyhound Discounts 225 195 212 631 74500 . Reservation Expense 868 665 1,135 2,668 74600•Other Selling Expenses AVIS/BRAC Rategain 0 0 6 6 Dealerslink(MIS) 470 470 470 1,410 NBTA 9 3 154 166 Total 74600 • Other Selling Expenses 479 473 630 1,582 Selling Expense-Other 0 0 -3 -3 Total Selling Expense 2,434 1,597 3,215 7,245 Total Expense 103,630 94,985 112,643 311,258 Net Ordinary Income -4,329 -7,767 -1,201 -13,297 Net Income -4,329 -7,767 -1,201 -13,297 Page 3 w o _ 5:43 PM Heckman Enter Inc. 04/22/15 Profit & Loss-AVIS Downtown Accrual Basis January through March 2015 Jan 15 Feb 15 Mar 15 TOTAL Income 61100 • Mileage-Car 35.20 40.20 82.40 157.80 61200 •Time/Daily Rental-Car 2,029.45 860.63 1,822.90 4,712.98 61300 Loss Damage Waiver(LDW) 22.99 0.00 265.90 288.89 61400 Discount -56.45 0.00 -55.29 -111.74 61701 • Intercity Car Rental(Revenue) 985.87 1,238.54 271.66 2,496.07 61702 • Intercity Car Rental(Expense) -637.21 -173.76 -612.04 -1,423.01 62103 P.A.E.(Revenue) 0.00 0.00 41.65 41.65 62104 P.A.E.(Expense) 0.00 0.00 -10.83 -10.83 62701 •S.L.I.(Revenue) 0.00 0.00 111.60 111.60 62702 •S.L.I.(Expense) 0.00 0.00 -55.80 -55.80 Total Income 2,379.85 1,965.61 1,862.15 6,207.61 Expense Advertising and Promotion 73100•Yellow Pages Expense 62.73 62.73 62.73 188.19 73900 • Misc.Advertising and Promotion 0.00 0.00 0.00 0.00 Total Advertising and Promotion 62.73 62.73 62.73 188.19 Direct Vehicle Expense 70110• Interest Expense-Vehicles 0.00 0.00 0.00 0.00 70200 Insurance Exp.-Vehicles 180.27 156.16 93.60 430.03 70210 Parts Expense 0.00 0.00 10.04 10.04 70220 Tires Expense 0.00 0.00 61.36 61.36 70300 Outside Maintenance&Repairs 60.85 422.03 175.11 657.99 70310 •Vehicle Damage Repair 0.00 0.00 0.00 0.00 70500 Monthly Car Fees 147.89 66.16 158.69 372.74 70700 Licenses-Vehicles 13.10 52.99 71.39 137.48 70750•Other Direct Vehicle Expenses 0.00 0.00 0.00 0.00 Total Direct Vehicle Expense 402.11 697.34 570.19 1,669.64 General&Admin Expense 77000•Amortization-Franchise 53.43 47.53 53.37 154.33 77110 • Bank Charges 0.01 0.01 0.23 0.25 77120 • Equip/Furn Exp-Less than$500 0.00 0.00 0.00 0.00 77200 Office Supplies 14.08 13.20 31.97 59.25 77210 Postage and Delivery 5.71 0.75 16.72 23.18 77230•Telephone Expense 23.12 19.66 17.63 60.41 77300 Professional Fees-Accounting 0.00 0.00 528.09 528.09 77310 Professional Fees-Legal 0.00 0.00 0.00 0.00 77405•Travel&Meetings 0.00 0.00 0.00 0.00 77410• Dues and Subscriptions 20.14 20.43 38.94 79.51 77420 •General Insurance Expense 0.00 0.00 0.00 0.00 77425•Customer Goodwill 0.00 0.00 0.00 0.00 77430 • Other General Expenses Bluebird Wizard Accounting 50.00 50.00 50.00 150.00 Total 77430 • Other General Expenses 50.00 50.00 50.00 150.00 77820 • Computer Equipment Maintenance 3.16 2.73 1.90 7.79 77900•Taxes&Licenses-Business 77901 Business Licenses and Permits 0.00 0.00 0.00 0.00 77902 Business Taxes 0.00 0.00 -0.06 -0.06 Total 77900 •Taxes&Licenses-Business 0.00 0.00 -0.06 -0.06 Total General&Admin Expense 169.65 154.31 738.79 1,062.75 Occupancy Expense 75110 • Rent 222.60 205.60 142.43 570.63 r 75200• Utilities 31.87 25.41 16.49 73.77 75400 • Maintenance&Repair-Facilities 0.00 0.00 0.00 0.00 Total Occupancy Expense 254.47 231.01 158.92 644.40 Operating Expense 72100•Garage&Washing Supplies 6.41 2.21 2.78 11.40 72600 •Vehicle Transfer Expense 0.00 0.00 177.14 177.14 72700 •Other Operating Expense Pagel t' 5:43 PM Heckman Enterprises, Inc. 04/22/15 Profit & Loss-AVIS Downtown Accrual Basis January through March 2015 Jan 15 Feb 15 Mar 15 TOTAL Bridge Tolls Bridge Tolls 69.50 0.00 0.00 69.50 Bridge Toll Recovery Charges -49.50 16.50 0.00 -33.00 Total Bridge Tolls 20.00 16.50 0.00 36.50 Total 72700 •Other Operating Expense 20.00 16.50 0.00 36.50 72800 • Gasoline Expense 34.61 38.05 78.48 151.14 72850 • Gasoline Refueling Charge -268.79 -110.59 -105.48 -484.86 Total Operating Expense -207.77 -53.83 152.92 -108.68 Personnel Expense 76200•Corporate Officers Wages 264.25 228.55 159.12 651.92 76300•Accounting Wages 233.50 175.43 123.21 532.14 76620•Counter Agent Wages 371.40 347.78 255.05 974.23 76730•Service Wages 191.83 180.11 127.98 499.92 76810 • Incentive Pay 0.00 0.00 6.39 6.39 76900 Payroll Tax Expense 114.38 100.05 72.34 286.77 76910 Other Personnel Expenses 0.34 0.00 0.09 0.43 76920• Medical Insurance 250.01 240.96 163.23 654.20 Total Personnel Expense 1,425.71 1,272.88 907.41 3,606.00 Selling Expenses 74100 •Travel Agency Commissions 17.80 37.59 47.13 102.52 74300 • Credit Card Commissions 77.10 44.77 68.70 190.57 74600•Other Selling Expense AVIS"AID"Charges 33.32 14.33 0.00 47.65 AVIS Equifax Credit Reporting 0.00 0.00 1.98 1.98 Total 74600•Other Selling Expense 33.32 14.33 1.98 49.63 Total Selling Expenses 128.22 96.69 117.81 342.72 Total Expense 2,235.12 2,461.13 2,708.77 7,405.02 Net Income 144.73 -495.52 -846.62 -1,197.41 I Page 2 i i