Page 321 - Onboarding May 2017
P. 321
INCOME STATEMENT
CENTRALIZED SUPPLY CHAIN SERVICES, LLC Period 10 of 2016 ending on 10/31/2016
All Cost Centers Period to Date Year to Date
Current Budget Variance Current Budget Variance
REVENUE
SOURCING-APPLE FRENCH FRIES 198,484 250,199 (51,715) 2,427,236 2,635,272 (208,036)
SOURCING-APPLE STEAK 0 87,012 (87,012) 213,242 953,040 (739,798)
SOURCING-APPLE CHICKEN 80,785 102,987 (22,202) 970,838 996,890 (26,052)
SOURCING-APPLE PRODUCE (34,109) 0 (34,109) 54,840 0 54,840
SOURCING -APPLE GROUND BEEF 85,583 0 85,583 820,282 0 820,282
REBATE-APPLE 63,905 0 63,905 1,004,955 427,200 577,755
FREIGHT REBATE-APPLE 23,412 6,000 17,412 765,409 540,000 225,409
EQUIPMENT REBATE-APPLE 5,074 0 5,074 283,970 63,000 220,970
SOURCING-PANCAKE DRY MIX 262,527 172,689 89,838 2,478,550 2,237,878 240,672
SOURCING-PANCAKE LIQUID EGGS 185,637 178,416 7,221 2,352,468 2,041,489 310,979
SOURCING-PANCAKE HASH BROWNS 39,669 50,552 (10,883) 449,811 426,675 23,136
SOURCING-PANCAKE PRODUCE (15,499) 0 (15,499) 34,108 0 34,108
REBATE-PANCAKE 69,804 0 69,804 451,692 161,400 290,292
FREIGHT REBATE-PANCAKE 44,661 2,500 42,161 331,369 248,800 82,569
EQUIPMENT REBATE-PANCAKE 2,055 0 2,055 166,538 51,000 115,538
TOTAL REVENUE 1,011,987 850,355 161,632 12,805,307 10,782,644 2,022,663
EXPENDITURES
OPERATING COST EXPENDITURES
PERSONNEL COSTS:
SALARIES 440,217 440,785 568 4,435,750 4,427,174 (8,576)
PAYROLL TAXES 23,094 24,035 941 338,400 360,350 21,950
MISSOURI WITHHOLDING CREDIT (16,603) (15,716) 887 (229,252) (231,426) (2,174)
BONUS ACCRUAL 70,723 70,723 0 707,230 707,230 0
TEMPORARY LABOR 0 0 0 0 0 0
VACATION PAY 0 0 0 0 0 0
TOTAL PERSONNEL COSTS 517,431 519,827 2,396 5,252,128 5,263,328 11,200
FRINGE BENEFITS:
LONG TERM INCENTIVE COMP 33,816 41,365 7,549 293,053 351,603 58,550
EMPLOYEE BENEFITS-GROUP INSURANCE 34,879 37,573 2,694 352,727 385,730 33,003
EXECUTIVE BENEFITS 1,057 1,350 293 16,056 15,355 (701)
FSA ACCT ADMINISTRATION 0 0 0 (3) 0 3
401K MATCH 14,664 15,394 730 167,718 167,214 (504)
TOTAL FRINGE BENEFITS 84,417 95,682 11,265 829,551 919,902 90,351
EMPLOYEE RELATED:
EMPLOYEE RELATIONS 1,603 1,146 (457) 18,616 11,458 (7,157)
RECRUITING EXPENSES 250 416 166 2,570 4,163 1,594
RELOCATION EXPENSES 2,202 0 (2,202) 41,461 70,000 28,539
RESTAURANT VISITATION 5,336 6,182 846 58,406 61,819 3,413
TRAINING EXPENSES 857 2,083 1,227 7,922 20,833 12,911
TOTAL EMPLOYEE RELATED EXPENSES 10,248 9,828 (420) 128,974 168,274 39,300
TRAVEL:
TRAVEL 0 13,597 13,597 0 135,972 135,972
AIRFARE 6,342 0 (6,342) 51,799 0 (51,799)
LODGING 5,417 0 (5,417) 52,620 0 (52,620)
CAR RENTAL 622 0 (622) 5,166 0 (5,166)
MILEAGE 998 0 (998) 4,729 0 (4,729)
MEALS 886 0 (886) 9,994 0 (9,994)
OTHER 0 0 0 25 0 (25)
MEALS/ENTERTAINMENT 3,735 0 (3,735) 13,310 0 (13,310)
TAXI/PARKING 865 0 (865) 9,321 0 (9,321)
GLENDALE TRAVEL 7,227 4,000 (3,227) 68,420 40,000 (28,420)
TOTAL TRAVEL EXPENSES 26,091 17,597 (8,494) 215,385 175,972 (39,413)