Page 266 - Aida Hovsepian Onboarding

INCOME STATEMENT
CENTRALIZED SUPPLY CHAIN SERVICES, LLC Period 7 of 2018 ending on 7/31/2018
All Cost Centers Period to Date Year to Date
Current Budget Variance Current Budget Variance
REVENUE
SOURCING FRENCH FRIES-APPLE 309,449 241,501 67,949 1,867,583 1,662,219 205,364
SOURCING SHRIMP-APPLE 0 0 0 847,711 847,711 0
SOURCING CHICKEN-APPLE 84,204 100,752 (16,548) 682,840 672,253 10,587
SOURCING PRODUCE-APPLE (29,493) 0 (29,493) 10,759 0 10,759
SOURCING GROUND BEEF-APPLE 115,205 75,533 39,673 811,691 694,148 117,542
REVENUE REBATE-APPLE 45,383 58,794 (13,411) 147,351 170,729 (23,379)
FREIGHT REBATE-APPLE 31,977 0 31,977 405,675 450,000 (44,325)
EQUIPMENT REBATE-APPLE 266 0 266 30,667 11,900 18,767
SOURCING DRY MIX-PANCAKE 246,680 160,497 86,183 1,650,551 1,630,081 20,470
SOURCING LIQUID EGGS-PANCAKE 239,646 240,604 (957) 1,535,797 1,480,385 55,412
SOURCING HASH BROWNS-PANCAKE 47,044 40,598 6,446 320,170 308,253 11,917
SOURCING PRODUCE-PANCAKE (4,800) 0 (4,800) 13,255 0 13,255
REVENUE REBATE-PANCAKE 46,311 62,743 (16,432) 150,243 179,616 (29,373)
FREIGHT REBATE-PANCAKE 55,898 0 55,898 203,878 160,000 43,878
EQUIPMENT REBATE-PANCAKE 379 0 379 31,622 19,000 12,622
TOTAL REVENUE 1,188,150 981,022 (207,128) 8,709,793 8,286,296 (423,497)
EXPENDITURES
OPERATING COST EXPENDITURES
PERSONNEL COSTS:
SALARIES 442,844 449,746 (6,902) 3,176,949 3,143,224 33,725
PAYROLL TAXES 24,459 26,623 (2,164) 266,862 283,850 (16,988)
MISSOURI WITHHOLDING CREDIT 0 0 0 (929) 0 (929)
BONUS ACCRUAL 76,675 76,675 0 503,034 536,725 (33,691)
VACATION PAY 0 0 0 0 0 0
TOTAL PERSONNEL COSTS 543,978 553,044 (9,066) 3,945,915 3,963,799 (17,884)
FRINGE BENEFITS:
LONG TERM INCENTIVE COMP 17,200 24,127 (6,927) 112,230 139,936 (27,706)
EMPLOYEE BENEFITS-GROUP INSURANCE 37,395 40,577 (3,182) 254,948 271,636 (16,688)
EXECUTIVE BENEFITS 1,583 1,350 233 9,765 11,305 (1,540)
FSA ACCT ADMINISTRATION 0 0 0 21 0 21
401K MATCH 30,711 15,955 14,756 138,253 121,685 16,568
TOTAL FRINGE BENEFITS 86,889 82,009 4,880 515,217 544,562 (29,345)
EMPLOYEE RELATED:
EMPLOYEE RELATIONS 1,327 1,429 (102) 20,548 10,004 10,543
RECRUITING EXPENSES 639 416 223 4,523 2,914 1,609
RESTAURANT VISITATION 4,691 6,000 (1,309) 38,202 37,500 702
TRAINING EXPENSES 2,975 333 2,642 20,946 18,533 2,413
TOTAL EMPLOYEE RELATED EXPENSES 9,633 8,179 1,454 84,220 68,952 15,268
TRAVEL:
TRAVEL 0 14,097 (14,097) 0 98,680 (98,680)
AIRFARE 6,290 0 6,290 39,182 0 39,182
LODGING 1,872 0 1,872 28,096 0 28,096
CAR RENTAL 111 0 111 1,700 0 1,700
MILEAGE 112 0 112 2,046 0 2,046
MEALS 357 0 357 5,675 0 5,675
PWC / OTHER 2,391 0 2,391 24,965 0 24,965
MEALS/ENTERTAINMENT 1,339 0 1,339 11,812 0 11,812
TAXI/PARKING 556 0 556 7,687 0 7,687
GLENDALE TRAVEL 8,261 7,500 761 43,543 52,500 (8,957)
TOTAL TRAVEL EXPENSES 21,291 21,597 (306) 164,706 151,180 13,526
ADMINISTRATIVE:
OFFICE SUPPLIES 508 2,589 (2,081) 4,119 9,125 (5,007)
POSTAGE & EXPRESS MAIL 207 550 (343) 2,184 3,850 (1,666)
DUES & SUBSCRIPTIONS 2,184 2,774 (590) 36,381 40,384 (4,003)
PRINTING 264 583 (319) 3,064 4,083 (1,020)
BANK CHARGES 899 750 149 6,235 5,250 985
PENALITIES (4,600) 0 (4,600) 0 0 0
SOFTWARE EXPENSE 3,620 13,444 (9,824) 27,767 33,014 (5,247)
COMPUTER SUPPLIES 8,955 3,192 5,763 31,801 22,342 9,460
OTHER MISCELLANEOUS (860) 150 (1,010) 5,372 1,050 4,322
MEETING MEALS 1,262 1,200 62 10,046 8,400 1,646
MEETINGS 1,852 2,669 (818) 10,829 18,684 (7,855)
TOTAL ADMINISTRATIVE EXPENSES 14,291 27,901 (13,610) 137,797 146,182 (8,385)
PROFESSIONAL/OUTSIDE SERVICES:
ACCOUNTING SERVICES 10,833 10,833 0 75,333 75,331 2
OUTSIDE LEGAL COUNSEL 22,524 8,500 14,024 165,869 59,500 106,369
AUDIT FEES 12,950 0 12,950 73,944 74,550 (606)
CONSULTANT FEES 11,549 10,533 1,016 74,831 73,733 1,097
IT RECURRING COSTS 1,106 1,348 (243) 7,708 9,436 (1,728)
IT PROFESSIONAL SERVICES 105 339 (233) 737 2,371 (1,633)
PRODUCE PROGRAM FEES-APPLE 60,000 60,000 0 180,000 180,000 0
PRODUCE PROGRAM FEES-PANCAKE 30,000 30,000 0 90,000 90,000 0
HAVI SUBSCRIPTION-APPLE 62,798 60,876 1,922 444,816 425,199 19,617
HAVI SUPPLIER FEES-APPLE 5,000 0 5,000 (209,375) (192,400) (16,975)
HAVI SUBSCRIPTION-PANCAKE 52,712 55,733 (3,021) 374,674 389,265 (14,591)
HAVI SUPPLIER FEES-PANCAKE 0 0 0 (155,625) (177,600) 21,975
TOTAL PROFESSIONAL/OUTSIDE SERVICES 269,577 238,162 31,415 1,122,912 1,009,385 113,527
OFFICE SERVICES:
RENT-MISSOURI 19,079 19,605 (526) 136,321 137,236 (915)
RENT-CALIFORNIA 196 196 0 1,372 1,372 0
EQUIPMENT LEASING 549 0 549 549 0 549
TELEPHONE & CELL PHONE 3,195 2,925 270 21,943 20,472 1,471
REPAIRS & MAINTENANCE 244 333 (89) 244 2,333 (2,089)
LICENSES & TAXES 0 0 0 3,220 3,374 (154)
BUSINESS INSURANCE 4,695 4,907 (212) 33,449 34,347 (898)
BOARD OF DIRECTOR EXPENSES 385 6,000 (5,615) 38,875 52,500 (13,625)
TOTAL OFFICE SERVICES 28,343 33,966 (5,623) 235,973 251,634 (15,661)
TOTAL OPERATING COST EXPENDITURES 974,002 964,858 9,144 6,206,741 6,135,695 71,045
DEPRECIATION 1,101 1,371 (270) 7,709 6,743 966
BAD DEBT EXPENSE 0 0 0 0 0 0
INTEREST EXPENSE-APPLE 0 0 0 0 0 0
INTEREST EXPENSE-PANCAKE 0 0 0 0 0 0
FEDERAL & STATE INCOME TAX 0 0 0 6,800 6,800 0
HAVI DEVELOPMENT 2,800 0 2,800 34,550 20,000 14,550
TOTAL EXPENDITURES 977,903 966,229 11,674 6,255,799 6,169,239 86,561
NET INCOME/(LOSS) 210,247 14,793 195,454 2,453,993 2,117,057 336,936