Loading...
HomeMy WebLinkAbout2.63 Correspondence 7 2.63 -� HECKMAN MOTORS, INC. 07/27/16 Profit & Loss-PA DT Budget Rentals/Bus/City Par ing/Sales April through June 2016 Apr 16 May 16 Jun 16 TOTAL Ordinary Income/Expense Income 61100 • Mileage-Car 0 42 0 42 61150• Mileage-Truck 0 50 46 95 61200 •Time/Daily Rental-Car 16,490 14,045 20,616 51,151 61250•Truck Daily Rental 225 207 332 764 61300• Loss Damage Waiver(LDW) 3,247 2,174 1,855 7,276 61400 • Discounts -147 -132 -143 -422 61450•Adjustments -31 -56 -6,501 -6,588 61550•Cash Over/Short 17 0 76 93 61701 Intercity Car Rental<Revenue> 2,771 2,209 5,694 10,674 61702 Intercity Car Rental<Expense> -6,882 -2,718 -519 -10,119 62100• P.A.C.<Revenue> 9 9 0 18 62102 • P.A.C.<Expense> -2 -2 0 -5 62103• P.A.E.<Revenue> 18 30 36 83 62104• P.A.E.<Expense> -5 -8 -9 -22 62107 • Extra Driver Fee 143 494 247 884 62109 • Underage Driver Fee 189 0 243 432 62111 •GA-Government Rate Surcharge 0 0 20 20 62115•GPS Rental 84 56 0 140 62200 •Other Income 62201 • Retail Car Sales-Gross 12,675 24,594 0 37,269 62202•Wholesale Car Sales-Gross 23,255 34,993 21,875 80,123 62207 • Misc. Retail Income-FaxCopyMail 22 0 0 22 62209• Reimbursement of an Expense 0 0 2,905 2,905 62220 • Interest 0 0 0 0 62235• Miscellaneous Income 0 50 0 50 Total 62200 •Other Income 35,952 59,637 24,780 120,369 62250 • Bus Lines Revenue BusLines Express Freight 425 245 458 1,127 Greyhound Sales Commission 160 236 279 675 OBL Bus Revenue 47,494 56,670 68,051 172,214 Total 62250 •Bus Lines Revenue 48,079 57,151 68,787 174,017 62275• DOT Contract/Grant Income Old Program Calculation 28,987 38,787 17,613 85,387 Over/Under Old Program 14,286 6,395 25,338 46,019 62275 • DOT Contract/Grant Income-Other 0 0 0 0 Total 62275 • DOT Contract/Grant Income 43,273 45,182 42,952 131,407 62300 Baby Seat Income 26 0 0 26 62701 S.L.I.<Revenue> 1,038 319 474 1,832 62702 •S.L.I.<Expense> -540 -166 -247 -952 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 2,966 3,284 3,101 9,351 64200• Long Term Storage Revenue 710 635 610 1,955 Total Income 148,330 183,140 163,151 494,621 e'?^, Cost of Goods Sold 70050 •Cost of Sales-Whlse Cars Gross 20,354 32,633 20,610 73,598 70790 •Cost of Sales-Retail 10,993 20,448 0 31,441 Total COGS 31,347 53,081 20,610 105,039 Gross Profit 116,983 130,059 142,540 389,582 Expense Advertising&Promotion Expense 73000 •Television Expense 2,380 2,660 3,959 8,999 73100•Yellow Pages Expense 290 1,020 1,078 2,388 73200 • Newspaper Expense 1,503 4,257 3,823 9,583 73300 • Radio Expense 1,229 1,462 1,494 4,186 Pagel HECKMAN MOTORS, INC. 07/27/16 Profit & Loss-PA DT Budget Rentals/Bus/City Parking/Sales April through June 2016 Apr 16 May 16 Jun 16 TOTAL 73400 • Billboard Expense 1,200 1,200 1,629 4,029 73500• Rack Cards(Printing/Distrib.) 0 1,325 -1,104 221 73600•Website 35 35 35 105 73900•Advertising and Promotion 75 75 0 150 Advertising&Promotion Expense-Other -58 -58 -58 -174 Total Advertising&Promotion Expense 6,654 11,976 10,856 29,485 Direct Vehicle Expense 70100 • Depreciation Expense-Vehicle 12,626 15,505 16,720 44,851 70110 • Interest Expense-Vehicles 517 1,231 79 1,828 70200 • Insurance Exp.-Vehicles 2,909 3,183 3,231 9,323 70210 • Parts Expense 168 469 64 701 70220 •Tires Expense 0 3,719 865 4,583 70230 •Towing Expense 795 827 0 1,623 70300 •Outside Maintenace&Repairs 5,174 4,973 10,446 20,593 70310 •Vehicle Damage Repair 938 350 50 1,338 70370 •Windshield Replacement/Repair 0 39 1,088 1,126 70500• Monthly Car Fees 1,517 1,266 1,254 4,037 70700• Licenses-Vehicles 1,233 2,498 1,368 5,099 70705•VLF Passthrough Charge -136 -138 -162 -436 70750•Other Direct Vehicle Expenses 0 0 0 0 Direct Vehicle Expense-Other -960 -2,491 -1,961 -5,412 Total Direct Vehicle Expense 24,782 31,431 33,041 89,254 General&Admn.Expense 77100• Bad Debt Expense -125 0 0 -125 77110 Bank Charges 125 2 81 208 77120 Equip/Furn Exp-Less than$1000 19 59 781 858 77200 Office Supplies 136 895 841 1,872 77210 Postage and Freight 130 168 52 350 77220 Supplies 0 0 39 39 77230 Telephone Expense 972 961 674 2,608 77240 Cable Television 155 160 220 534 77260 Depreciation Expense 30 30 31 91 77310 Professional Fees-Legal 0 0 0 0 77400• Meals&Entertainment 0 15 0 15 77405•Travel&Meetings 0 0 22 22 77410 Dues and Subscriptions 27 48 -237 -162 77420 General Insurance Expense 0 0 0 0 77425 Customer Goodwill 412 0 154 566 77430 Other General Expenses Bluebird Wizard Accounting 100 100 100 300 BRAC Wizard Monthly Fees 195 216 211 622 Continuing Education Expense 25 0 0 25 OBL Hotel(ALL HOTELS) -164 -57 -114 -335 Snacks/Water/Blankets for Buses Snacks/Water for Buses 645 541 820 2,006 Blankets and Laundry Expense 99 89 88 277 Total Snacks/Water/Blankets for Buses 744 630 909 2,283 Vehicle Owner Info from DOL 3 11 11 25 77430 •Other General Expenses-Other 4 0 0 4 Total 77430•Other General Expenses 907 900 1,116 2,924 77510• Uniform Expense 285 158 299 742 77820 Computer Equipment-Maintenance 65 360 -152 274 77830 Copy Machine Maintenance 0 370 0 370 77900 Taxes&Licenses-Business 77901 •Business Licenses 457 3,014 0 3,471 77902• Business Taxes 1,993 2,228 2,311 6,533 Total 77900•Taxes&Licenses-Business 2,450 5,243 2,311 10,004 Page 2 HECKMAN MOTORS, INC. 07/27/16 Profit & Loss-PA DT Budget Rentals/Bus/City Parking/Sales April through June 2016 Apr 16 May 16 Jun 16 TOTAL General&Admn.Expense-Other -196 -301 -390 -887 Total General&Admn.Expense 5,393 9,067 5,843 20,302 Occupancy Expense 75110• Rent 5,285 5,386 5,336 16,008 75200• Utilities 656 641 780 2,077 75300• Insurance-Buildings/Bus Stops 0 710 -617 93 75400 Maintenance&Repair-Facilities 432 0 12 444 75600 Sign Expense 4 0 0 4 75800 Other Occupancy Expense 12 0 0 12 Occupancy Expense-Other -400 -576 -1,245 -2,222 Total Occupancy Expense 5,988 6,161 4,267 16,416 Operating Expense 72100•Garage&Washing Supplies 88 372 38 498 72110•Oil/Transmission Fluid Expense 0 35 70 104 72510• Drop-off Collection -87 -307 -440 -834 72600•Vehicle Transfer 1,537 1,110 758 3,405 72700•Other Operating Expense Parking Tickets Parking Ticket Expense 30 0 0 30 Parking Ticket Recovery Charges 0 -30 0 30 Total Parking Tickets 30 -30 0 0 Bridge Tolls 6 12 6 24 Taxicab/Courier Expense 31 0 0 31 Vehicle Rental/Charter 1,119 0 0 1,119 Total 72700•Other Operating Expense 1,186 -18 6 1,174 72750 • Port Fees 209 223 209 642 72800 • Gasoline Expense 4,453 5,183 5,040 14,677 72850 •Gasoline Refueling Charge -133 -214 -605 -953 77415• Ferry Fees 8,175 10,754 11,135 30,064 Operating Expense-Other -402 -463 -426 -1,291 Total Operating Expense 15,027 16,675 15,784 47,486 Personnel Expense 76200 •Corporate Officers Wages 5,471 5,659 5,724 16,854 76300 •Accounting Wages 4,472 5,654 6,161 16,288 76620 Counter Agents Wages 9,890 12,890 11,768 34,548 76650 Parking Attendents Wages 151 176 124 451 76730 Service Wages 4,391 4,642 4,270 13,303 76810 • Incentive Pay 454 544 586 1,584 76850 • Bus Line Driver 15,397 15,419 14,186 45,003 76875 Vehicle Transfer Driver 0 135 1,080 1,215 76900 Payroll Tax Expense Employment Security 49 55 54 158 FICA 2,765 3,035 2,978 8,778 FUTA 91 83 75 249 Labor&Industries 1,292 1,374 1,422 4,088 Medicare 647 710 696 2,053 76900• Payroll Tax Expense-Other -421 -363 -403 -1,187 Total 76900 • Payroll Tax Expense 4,422 4,894 4,823 14,139 76910°Other Personnel Expenses Driver Training 0 581 204 785 Drug-Alcohol Tests/DOT Physical 454 175 0 629 76910 •Other Personnel Expenses-Other 4 0 0 4 Total 76910 •Other Personnel Expenses 458 756 204 1,418 76920• Medical Insurance 7,095 7,361 6,653 21,109 Page 3 HECKMAN MOTORS, INC. 07/27/16 Profit & Loss-PA DT Budget Rentals/Bus/City Parking/Sales April through June 2016 Apr 16 May 16 Jun 16 TOTAL Personnel Expense-Other -2,244 -3,749 -7,969 -13,961 Total Personnel Expense 49,958 54,382 47,611 151,951 Selling Expense 74100•Travel Agency Commissions 13 0 7 20 74300•Credit Card Commissions 1,359 1,343 1,528 4,230 74426• BusLines Greyhound Discounts 177 209 254 640 74500• Reservation Expense 1,417 1,560 2,053 5,030 74600•Other Selling Expenses AVIS/BRAC Rategain 49 39 39 128 NBTA 0 154 3 157 Total 74600 •Other Selling Expenses 49 194 42 285 Selling Expense-Other -25 -20 -20 -64 Total Selling Expense 2,990 3,286 3,865 10,141 Total Expense 110,792 132,978 121,266 365,035 ..._.._......_.._... Net Ordinary Income 6,192 -2,919 21,275 24,548 Net Income 6,192 -2,919 21,275 24,548 Page 4 6:46 PM Heckman Enterprises, Inc. "? 07/27/16 Profit & Loss-AVIS Downtown Accrual Basis April through June 2016 Apr 16 May 16 Jun 16 TOTAL Income 61100 •Mileage-Car 111.94 190.90 454.95 757.79 62115 GPS Rental 41.85 0.00 0.00 41.85 61200 Time/Daily Rental-Car 5,796.00 4,975.15 21,509.34 32,280.49 61300• Loss Damage Waiver(LDW) 173.94 666.77 521.82 1,362.53 61400• Discount -229.52 -74.11 -1,972.52 -2,276.15 61450•Adjustments -38.08 0.00 -207.50 -245.58 61550 •Cash Over/Short 0.00 0.00 -0.10 -0.10 61701 Intercity Car Rental(Revenue) 1,201.70 4,088.75 6,906.90 12,197.35 61702 Intercity Car Rental(Expense) -1,768.38 -890.15 -2,649.53 -5,308.06 62103 P.A.E.(Revenue) 17.85 0.00 5.95 23.80 62104 P.A.E.(Expense) -4.64 0.00 -1.55 -6.19 62107• Extra Driver Fee 0.00 0.00 13.00 13.00 62109• Underage Driver Fee 0.00 54.00 108.00 162.00 62300• Baby Seat Income 39.00 0.00 13.00 52.00 62701 •S.L.I.(Revenue) 69.75 97.65 613.80 781.20 62702 •S.L.I.(Expense) -36.27 -50.78 -319.18 -406.23 Total Income 5,375.14 9,058.18 24,996.38 39,429.70 Expense Advertising and Promotion 73100•Yellow Pages Expense 58.10 58.10 58.10 174.30 73900• Misc.Advertising and Promotion 0.00 0.00 0.00 0.00 Total Advertising and Promotion 58.10 58.10 58.10 174.30 Direct Vehicle Expense 70705•VLF Passthrough Charge -49.28 -48.40 -287.76 -385.44 70110 Interest Expense-Vehicles 126.58 439.78 42.19 608.55 70200 Insurance Exp.-Vehicles 259.37 427.50 661.28 1,348.15 70210 Parts Expense 32.09 167.56 25.25 224.90 70220•Tires Expense 0.00 451.90 390.26 842.16 70300•Outside Maintenance&Repairs 306.50 35.62 71.45 413.57 70310•Vehicle Damage Repair 0.00 175.00 25.00 200.00 70370•Windshield Replacement/Repair 0.00 13.79 0.00 13.79 70500 • Monthly Car Fees 442.14 432.73 1,515.51 2,390.38 70700 • Licenses-Vehicles 235.20 780.17 745.13 1,760.50 70750 •Other Direct Vehicle Expenses 0.00 0.00 0.00 0.00 Total Direct Vehicle Expense 1,352.60 2,875.65 3,188.31 7,416.56 General&Admin Expense 77000 •Amortization-Franchise 52.38 54.67 54.38 161.43 77110 • Bank Charges 0.00 0.20 0.00 0.20 77120• Equip/Furn Exp-Less than$1,000 0.18 5.69 163.59 169.46 77200•Office Supplies 9.35 86.81 25.19 121.35 77210 • Postage and Delivery 23.16 20.60 21.52 65.28 77220 •Supplies 0.00 0.00 19.56 19.56 77230 •Telephone Expense 40.79 54.67 79.02 174.48 77240•Cable Television Expense 10.61 15.53 45.32 71.46 77300• Professional Fees-Accounting 0.00 0.00 0.00 0.00 77310 • Professional Fees-Legal 0.00 0.00 0.00 0.00 77405•Travel&Meetings 0.00 0.00 3.75 3.75 77410• Dues and Subscriptions 28.32 27.09 60.13 115.54 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 0.00 0.00 0.00 0.00 Total 77430 •Other General Expenses 50.00 50.00 50.00 150.00 77510 • Uniform Expense 53.10 0.00 4.49 57.59 77820 •Computer Equipment Maintenance 4.48 31.49 -22.93 13.04 77830 •Copy Machine Maintenance 0.00 35.92 0.00 35.92 77900°Taxes&Licenses-Business Pagel 6:46 PM Heckman Enterprises, Inc. 07/27/16 Profit & Loss-AVIS Downtown Accrual Basis April through June 2016 Apr 16 May 16 Jun 16 TOTAL 77901 • Business Licenses and Permits 4.52 0.00 0.00 4.52 77902• Business Taxes 0.00 0.00 233.89 233.89 Total 77900 •Taxes&Licenses-Business 4.52 0.00 233.89 238.41 Total General&Admin Expense 276.89 382.67 737.91 1,397.47 Occupancy Expense 75110 Rent 358.78 518.42 1,094.16 1,971.36 75200 Utilities 41.50 57.95 150.72 250.17 75400 Maintenance&Repair-Facilities 0.18 0.00 0.00 0.18 Total Occupancy Expense 400.46 576.37 1,244.88 2,221.71 Operating Expense 72100 Garage&Washing Supplies 6.32 36.86 8.05 51.23 72510 Drop-Off Collection -750.00 0.00 0.00 -750.00 72600 Vehicle Transfer Expense 376.36 396.55 402.50 1,175.41 72800•Gasoline Expense 66.59 138.03 81.77 286.39 72850•Gasoline Refueling Charge -47.36 -259.57 -152.67 -459.60 Total Operating Expense -348.09 311.87 339.65 303.43 Personnel Expense 76200 •Corporate Officers Wages 374.95 549.10 1,181.50 2,105.55 76300•Accounting Wages 306.50 548.61 1,271.91 2,127.02 76620 •Counter Agent Wages 718.30 1,305.75 2,435.86 4,459.91 76730•Service Wages 316.09 470.76 910.20 1,697.05 76810• Incentive Pay 26.32 37.82 78.75 142.89 76875•Vehicle Transfer Driver Wages 0.00 48.28 573.75 622.03 76900• Payroll Tax Expense 180.60 304.98 684.99 1,170.57 76910 •Other Personnel Expenses 0.28 0.00 0.00 0.28 76920• Medical Insurance 320.63 483.52 831.67 1,635.82 Total Personnel Expense 2,243.67 3,748.82 7,968.63 13,961.12 Selling Expenses 74100•Travel Agency Commissions 138.32 81.11 118.99 338.42 74300•Credit Card Commissions 226.44 256.82 392.81 876.07 74500 • Reservation Expense 163.00 135.30 236.95 535.25 74600•Other Selling Expense AVIS/BRAC Rategain 24.63 19.67 19.67 63.97 AVIS"AID"Charges 0.00 42.95 233.28 276.23 AVIS Equifax Credit Reporting 0.00 0.00 0.00 0.00 AVIS Loyalty Earnings Fees 3.78 41.50 39.22 84.50 Total 74600•Other Selling Expense 28.41 104.12 292.17 424.70 Total Selling Expenses 556.17 577.35 1,040.92 2,174.44 80000 •Federal Income Tax Expense Income Tax Penalty 2.18 0.00 0.00 2.18 Total 80000• Federal Income Tax Expense 2.18 0.00 0.00 2.18 Total Expense 4,541.98 8,530.83 14,578.40 27,651.21 Net Income 833.16 527.35 10,417.98 11,778.49 Page 2