Loading...
HomeMy WebLinkAbout2.63 Correspondence 6 !i 2._1{Cj 3 HECKMAN MOTORS, INC. � 05/03/16 Profit & Loss-PA DT Budget Rentals/Bus/City Parking�Sales January through March 2016 Jan 16 Feb 16 Mar 16 TOTAL Ordinary Income/Expense Income 61100-Mileage-Car 0 0 36 36 61150 •Mileage-Truck 0 0 13 13 61200 •Time/Daily Rental-Car 5,668 5,157 9,344 20,169 61250 -Truck Daily Rental 32 125 222 379 61300 -Loss Damage Waiver(LDW) 783 290 1,189 2,261 61400 -Discounts -33 -27 -110 -170 61550 -Cash Over/Short 1 -0 -32 -31 61701 • Intercity Car Rental<Revenue> 4,449 2,126 1,735 8,309 61702• Intercity Car Rental<Expense> -1,278 -957 -2,083 -4,319 62100 - P.A.C.<Revenue> 0 9 18 27 62102 • P.A.C.<Expense> 0 -2 -5 -7 62103 -P.A.E.<Revenue> 24 0 0 24 62104• P.A.E.<Expense> -6 0 0 -6 62106 •Cleaning Fee 47 0 0 47 62107 -Extra Driver Fee 26 0 104 130 62109 -Underage Driver Fee 108 0 0 108 62200•Other Income 62201 • Retail Car Sales-Gross 11,000 0 11,999 22,999 62202•Wholesale Car Sales-Gross 0 0 34,415 34,415 62220• Interest 0 0 0 0 Total 62200•Other Income 11,000 0 46,414 57,414 62250• Bus Lines Revenue BusLines Express Freight 239 175 175 589 Greyhound Sales Commission 111 151 135 398 OBL Bus Revenue 41,890 39,215 52,848 133,953 Total 62250- Bus Lines Revenue 42,240 39,541 53,158 134,939 62275• DOT Contract/Grant Income Old Program Calculation 40,469 43,563 36,278 120,310 Over/Under Old Program 3,988 -1,517 8,284 10,756 62275• DOT Contract/Grant Income-Other 0 0 0 0 Total 62275• DOT Contract/Grant Income 44,457 42,046 44,562 131,066 62300 -Baby Seat Income 0 0 26 26 62701 •S.L.I.<Revenue> 153 31 285 469 62702•S.L.I.<Expense> -80 -16 -148 -244 67203• R.S.N.(Income) 0 13 0 13 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 69 81 2,074 2,225 64200 -Long Term Storage Revenue 640 640 640 1,920 Total Income 109,001 89,756 158,140 356,897 Cost of Goods Sold 70050 -Cost of Sales-Whlse Cars Gross 0 0 28,468 28,468 70790 •Cost of Sales-Retail 5,285 0 10,434 15,719 Total COGS 5,285 0 38,902 44,187 Gross Profit 103,716 89,756 119,238 312,710 Expense Advertising&Promotion Expense 73000 •Television Expense 2,636 2,555 4,063 9,253 73100 •Yellow Pages Expense 1,195 960 710 2,864 73200• Newspaper Expense 1,551 2,424 2,999 6,975 73300• Radio Expense 1,290 1,317 1,458 4,064 73400• Billboard Expense 2,400 1,200 1,200 4,800 73500• Rack Cards(Printing/Distrib.) 836 0 0 836 73600 •Website 35 35 35 105 73700 • KONP Home Show 0 500 15 515 Pagel HECKMAN MOTORS, INC. 05/03/16 Profit & Loss-PA DT Budget Rentals/Bus/City Parking/Sales January through March 2016 Jan 16 Feb 16 Mar 16 TOTAL 73900•Advertising and Promotion 75 75 825 975 Advertising&Promotion Expense-Other -83 -83 -83 -250 Total Advertising&Promotion Expense 9,934 8,982 11,221 30,137 Direct Vehicle Expense 70100 • Depreciation Expense-Vehicle 13,224 11,458 12,679 37,361 70110• Interest Expense-Vehicles 0 0 0 0 70200• Insurance Exp.-Vehicles 2,944 2,822 2,869 8,635 70210•Parts Expense 1,244 644 1,488 3,375 70220 •Tires Expense 331 1,218 418 1,967 70230•Towing Expense 0 1,722 0 1,722 70300•Outside Maintenace&Repairs 4,397 3,505 4,971 12,872 70310•Vehicle Damage Repair 242 0 0 242 70350•Subrogation 0 -887 -1,682 -2,569 70370 •Windshield Replacement/Repair 0 0 0 0 70500 • Monthly Car Fees 497 417 812 1,726 70700 • Licenses-Vehicles -113 251 220 359 70705-VLF Passthrough Charge -46 -44 -82 -172 70750 •Other Direct Vehicle Expenses 0 0 0 0 Direct Vehicle Expense-Other -1,261 -1,142 -1,095 -3,498 Total Direct Vehicle Expense 21,459 19,963 20,597 62,019 General&Admn. Expense 77100• Bad Debt Expense -1,666 1,821 0 155 77110• Bank Charges 54 81 25 160 77120- Equip/Furn Exp-Less than$1000 475 479 649 1,603 77130• Interest Expense-Non Auto 0 0 23 23 77200 •Office Supplies 405 231 447 1,083 77210 • Postage and Freight 0 125 13 139 77220•Supplies 0 8 20 27 77230•Telephone Expense 1,362 1,046 995 3,403 77240 •Cable Television 175 176 160 511 77260 • Depreciation Expense 24 40 31 95 77300• Professional Fees-Accounting 0 0 1,788 1,788 77310• Professional Fees-Legal 0 0 0 0 77400• Meals&Entertainment 0 29 212 241 77410 •Dues and Subscriptions 292 410 27 728 77420 -General Insurance Expense 0 0 0 0 77430•Other General Expenses Bluebird Wizard Accounting 100 100 100 300 BRAC Wizard Monthly Fees 213 177 203 593 Continuing Education Expense 0 95 0 95 OBL Hotel(ALL HOTELS) -177 -54 -69 -299 Record360 Monthly Subscription 48 48 48 143 Snacks/Water/Blankets for Buses Snacks/Water for Buses 463 540 599 1,602 Blankets and Laundry Expense 89 111 119 320 Total SnackstWater/Blankets for Buses 553 651 718 1,921 Vehicle Owner Info from DOL 7 2 0 9 Total 77430•Other General Expenses 743 1,018 1,000 2,762 77510 •Uniform Expense 0 565 31 596 77820•Computer Equipment-Maintenance 211 79 70 359 77830•Copy Machine Maintenance 0 0 88 88 77900•Taxes&Licenses-Business 77901 -Business Licenses 227 0 0 227 77902• Business Taxes 1,777 1,596 2,032 5,405 Total 77900 -Taxes&Licenses-Business 2,004 1,596 2,032 5,632 General&Admn. Expense-Other -331 490 -235 -1,057 Page 2 HECKMAN MOTORS, INC. 05/03/16 Profit & Loss-PA DT Budget Rentals/Bus/City Parking/Sales January through March 2016 Jan 16 Feb 16 Mar 16 TOTAL Total General&Admn.Expense 3,747 7,214 7,374 18,336 Occupancy Expense 75110 • Rent 5,423 5,324 5,411 16,158 75200• Utilities 926 835 857 2,618 75400- Maintenance&Repair-Facilities 181 989 493 1,664 76600•Sign Expense 405 325 71 801 75800-Other Occupancy Expense 17 0 0 17 Occupancy Expense-Other -796 -542 -421 -1,759 Total Occupancy Expense 6,157 6,931 6,411 19,498 Operating Expense 72100 •Garage&Washing Supplies 141 156 297 594 72110•Oil/Transmission Fluid Expense 95 0 21 116 72600•Vehicle Transfer 0 0 455 455 72700•Other Operating Expense Bridge Toils 0 0 17 17 Taxicab/Courier Expense 0 577 382 959 Vehicle Rental/Charter 0 0 1,753 1,753 Total 72700•Other Operating Expense 0 577 2,152 2,729 72750• Port Fees 216 199 216 632 72800•Gasoline Expense 4,186 3,569 3,829 11,583 72850•Gasoline Refueling Charge 16 -42 -101 -128 77415• Ferry Fees 8,491 7,755 8,369 24,615 Operating Expense-Other 33 -29 -69 -131 Total Operating Expense 13,112 12,185 15,169 40,467 Personnel Expense 76200•Corporate Officers Wages 6,543 6,567 5,814 18,923 76300•Accounting Wages 6,528 4,770 4,962 16,261 76620 •Counter Agents Wages 9,501 9,193 11,329 30,023 76650 •Parking Attendents Wages 72 17 161 250 76730•Service Wages 4,998 3,976 4,522 13,496 76810• Incentive Pay 376 432 383 1,191 76850• Bus Line Driver 14,787 13,566 15,251 43,604 76875•Vehicle Transfer Driver 0 0 0 0 76900 •Payroll Tax Expense Employment Security 48 42 50 140 FICA 2,694 2,434 2,819 7,947 FUTA 261 202 164 626 Labor&Industries 1,198 1,184 1,322 3,704 Medicare 630 569 659 1,859 76900 • Payroll Tax Expense-Other -60 -73 -287 -421 Total 76900• Payroll Tax Expense 4,770 4,358 4,728 13,856 76910 •Other Personnel Expenses Drug-Alcohol Tests/DOT Physical 222 0 75 297 76910 •Other Personnel Expenses-Other 0 0 376 376 Total 76910•Other Personnel Expenses 222 0 451 673 76920 •Medical Insurance 7,486 7,439 7,268 22,192 Personnel Expense-Other -3,379 -2,456 -2,293 -8,128 Total Personnel Expense 51,904 47,862 52,575 152,341 Selling Expense 74100 •Travel Agency Commissions 0 0 14 14 74300•Credit Card Commissions 814 670 1,397 2,882 74426• BusLines Greyhound Discounts 203 171 170 544 74500 • Reservation Expense 1,009 1,008 1,333 3,350 74600 •Other Selling Expenses AVIS/BRAC Rategain 39 39 39 118 Page 3 HECKMAN MOTORS, INC. 05/03/16 Profit & Loss-PA DT Budget Rentals/Bus/City Parking/Sales January through March 2016 Jan 16 Feb 16 Mar 16 TOTAL NBTA 9 151 6 166 Total 74600•Other Selling Expenses 48 191 45 284 Selling Expense-Other -20 20 -20 -59 Total Selling Expense 2,055 2,020 2,940 7,015 Total Expense 108,368 105,157 116,287 329,813 Net Ordinary Income -4,653 -15,401 2,951 -17,103 Net Income -4,653 -15,401 2,951 -17,103 Page 4 2.63 3:28 PM Heckman Enterprises, Inc. 3 _(6 05/03/16 Profit & Loss-AVIS Downtown Accrual Basis January through March 2016 Jan 16 Feb 16 Mar 16 TOTAL Income 61100•Mileage-Car 212.26 377.64 74.86 664.76 61200•Time/Daily Rental-Car 2,278.50 2,211.00 1,591.50 6,081.00 61300• Loss Damage Waiver(LDW) 0.00 57.98 231.92 289.90 61400• Discount -19.85 -22.70 -11.10 -53.65 61550•Cash Over/Short 0.00 0.00 136.05 136.05 61701 •Intercity Car Rental(Revenue) 4,558.03 2,125.40 3,178.71 9,862.14 61702• Intercity Car Rental(Expense) -1,072.42 -882.20 -288.82 -2,243.44 62104•P.A.E.(Expense) 0.00 0.00 0.00 0.00 62107• Extra Driver Fee 0.00 13.00 39.00 52.00 62111 •GA-Government Rate Surcharge 0.00 30.00 0.00 30.00 62701 •S.L.I.(Revenue) 0.00 0.00 97.65 97.65 62702 •S.L.I.(Expense) 0.00 0.00 -50.78 -50.78 Total Income 5,956.52 3,910.12 4,998.99 14,865.63 Expense Advertising and Promotion 73100 •Yellow Pages Expense 83.30 83.30 83.30 249.90 73900 •Misc.Advertising and Promotion 0.00 0.00 0.00 0.00 Total Advertising and Promotion 83.30 83.30 83.30 249.90 Direct Vehicle Expense 70705•VLF Passthrough Charge -15.40 -18.48 -16.72 -50.60 70110• Interest Expense-Vehicles 0.00 0.00 0.00 0.00 70200• Insurance Exp.-Vehicles 413.27 355.70 339.82 1,108.79 70210 •Parts Expense 425.81 101.90 386.05 913.76 70220•Tires Expense 124.89 445.52 139.42 709.83 70300•Outside Maintenance&Repairs 175.74 187.96 118.26 481.96 70310 •Vehicle Damage Repair 120.96 0.00 0.00 120.96 70500• Monthly Car Fees 182.53 197.73 164.78 545.04 70700 -Licenses-Vehicles 0.00 50.71 111.76 162.47 70750•Other Direct Vehicle Expenses 0.00 0.00 0.00 0.00 Total Direct Vehicle Expense 1,427.80 1,321.04 1,243.37 3,992.21 General&Admin Expense 77130• Interest Expense-Non Auto 0.00 0.00 1.45 1.45 77000 •Amortization-Franchise 54.85 55.58 53.31 163.74 77110• Bank Charges 0.00 0.00 0.00 0.00 77120• Equip/Furn Exp-Less than$1,000 44.15 39.97 41.03 125.15 77200 •Office Supplies 47.19 17.73 28.26 93.18 77210• Postage and Delivery 0.00 9.61 0.00 9.61 77230-Telephone Expense 76.42 53.58 39.40 169.40 77240-Cable Television Expense 16.14 13.47 10.13 39.74 77300 • Professional Fees-Accounting 0.00 0.00 523.17 523.17 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 21.19 37.02 19.35 77.56 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 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 23.75 23.75 23.75 71.25 Total 77430 •Other General Expenses 73.75 73.75 73.75 221.25 77510• Uniform Expense 0.00 275.77 31.41 307.18 77820 •Computer Equipment Maintenance 73.61 6.02 4.40 84.03 77830 •Copy Machine Maintenance 0.00 0.00 5.57 5.57 77900-Taxes&Licenses-Business 77901 • Business Licenses and Permits 0.00 0.00 130.00 130.00 Total 77900•Taxes&Licenses-Business 0.00 0.00 130.00 130.00 Total General&Admin Expense 407.30 582.50 961.23 1,951.03 Pagel 3:28 PM Heckman Enterprises, Inc. 05/03/16 Profit & Loss-AVIS Downtown Accrual Basis January through March 2016 Jan 16 Feb 16 Mar 16 TOTAL Occupancy Expense 75110- Rent 494.47 402.50 338.84 1,235.81 75200• Utilities 84.42 64.08 50.90 199.40 75400 •Maintenance&Repair-Facilities 16.69 75.82 31.18 123.69 75600 •Sign Expense 199.94 0.00 0.00 199.94 Total Occupancy Expense 795.52 542.40 420.92 1,758.84 Operating Expense 72100 •Garage&Washing Supplies 23.21 13.36 19.50 56.07 72510• Drop-Off Collection 0.00 0.00 -69.00 -69.00 72600•Vehicle Transfer Expense 0.00 0.00 36.59 36.59 72800•Gasoline Expense 77.02 98.80 82.12 257.94 72850 •Gasoline Refueling Charge -147.03 -119.41 -114.98 -381.42 Total Operating Expense -46.80 -7.25 -45.77 -99.82 Personnel Expense 76200•Corporate Officers Wages 603.23 503.27 367.61 1,474.11 76300•Accounting Wages 601.92 365.59 313.73 1,281.24 76620 •Counter Agent Wages 937.33 689.61 794.24 2,421.18 76730 •Service Wages 466.56 309.73 296.44 1,072.73 76810- Incentive Pay 32.56 26.65 22.80 82.01 76900• Payroll Tax Expense 271.77 197.27 185.98 655.02 76910•Other Personnel Expenses 0.00 0.00 0.00 0.00 76920 •Medical Insurance 465.97 363.73 312.43 1,142.13 Total Personnel Expense 3,379.34 2,455.85 2,293.23 8,128.42 Selling Expenses 74100•Travel Agency Commissions 119.93 41.45 112.41 273.79 74300•Credit Card Commissions 86.26 90.79 63.87 240.92 74500•Reservation Expense 78.25 0.00 112.25 190.50 74600 -Other Selling Expense AVIS/BRAC Rategain 19.67 19.67 19.67 59.01 AVIS"AID"Charges 37.12 30.58 3.94 71.64 AVIS Equifax Credit Reporting 0.00 0.00 0.00 0.00 AVIS Loyalty Earnings Fees 0.00 9.40 0.00 9.40 Total 74600 •Other Selling Expense 56.79 59.65 23.61 140.05 Total Selling Expenses 341.23 191.89 312.14 845.26 Total Expense 6,387.69 5,169.73 5,268.42 16,825.84 Net Income -431.17 -1,259.61 -269.43 -1,960.21 Page 2