CoHo South Cafe

2017 - 2018

Charts
166.52% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
Income 686,000 684,880 716,452 716,452 716,452

Expenses
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
General Assistance / Benefits 257,143 301,206 303,803 303,803 303,803
Administrative / Programmatic 388,311 381,374 406,519 406,519 406,519
Total Expense 645,454 682,580 710,322 710,322 710,322

Reconciliation
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
Subsidy -40,546 -2,300 -6,130 -6,130 -6,130
Transfers To/From Reserve 0 0 0 0 0
Charts
4.61% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Income
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
11000 Sales (Taxable)

14,000 18,000 14,933 14,933 14,933
12000 Sales (NonTaxable)

695,500 683,680 731,719 731,719 731,719
13000 Catering Sales (Taxable)

1,200 1,000 1,500 1,500 1,500
14000 Catering Sales (Nontaxable)

300 200 300 300 300
16500 ---

0 0 0 0 0
17000 Credit Card Fees

-25,000 -18,000 -32,000 -32,000 -32,000
18000 ---

0 0 0 0 0
19000 Over and Short

0 0 0 0 0
Total Income 686,000 684,880 716,452 716,452 716,452
Charts
-6.59% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
21000 Common Goods Assessment

EH&S inspections, Phone/Data charges, etc.

0 7,500 4,565 4,565 4,565
30000 Copying & Printing

Copying needs (schedules, handbooks, payroll forms, etc.)

50 50 50 50 50
31000 Mail

Correspondence

20 20 20 20 20
32000 Office Supplies

Misc. office supplies (pens, tape, scissors, etc.)

1,000 1,000 750 750 750
33000 Transportation

Airfare for mgmt. to educational events including but not limited to NACUFS regional/national conferences

500 500 1,000 1,000 1,000
34000 Telephone Equipment

One telephone line, one data NAM

700 0 0 0 0
35000 Telephone Long Distance

Calls to distributors/employees

25 0 0 0 0
36000 Equipment Purchase

Equipment replacement due to unforeseen failures

2,000 1,000 1,200 1,200 1,200
37000 Equipment Repair & Maintenance

Food service equipment upkeep/maintenace

10,000 2,000 3,000 3,000 3,000
38000 Maintenance Contracts

0 0 0 0 0
38100 GEM Car Repair & Maintenance

Preventative maintenace program for GEM vehicle

5,000 10,000 10,000 10,000 10,000
50000 Merchandise for Resale

Target food cost of 40% (Target food cost % x sales income = cost of food)

226,600 236,065 245,000 245,000 245,000
50010 Merchandise for Resale -- Coffee House

Coffee House products purchased for re-sale (at cost)

50,000 30,000 45,000 45,000 45,000
50100 Paper Supplies

Plates, napkins, utensils, etc.

35,000 35,000 34,000 34,000 34,000
50300 Sanitation Supplies

Soap, sanitizer, windex

8,000 8,000 9,000 9,000 9,000
50400 Smallwares

Service utensils, pots and pans

1,500 1,000 1,000 1,000 1,000
51000 Services Rendered

0 0 0 0 0
52000 Publicity

Advertising

300 300 250 250 250
53000 Linen

Towels, aprons

3,200 4,000 4,500 4,500 4,500
53100 First Aid Supplies

First aid items (band-aids, gauze, etc)

50 50 50 50 50
54000 First Aid Supplies

0 0 0 0 0
54000 Rent

Rent (2% of previous year's gross sales)

13,200 13,984 14,256 14,256 14,256
55000 Conferences

Hotel/registration costs for educational events including but not limited to NACUFS regional/national conferces (Regional Conference 2016--Coeur D'Alene, ID)

1,000 650 500 500 500
56000 Uniforms

Uniforms (Staff T-Shirts) @ 9.00 each

500 750 750 750 750
58000 Employee of the Month

Employee incentive program--Monthly prizes

250 250 150 150 150
59000 Sales Tax

7.25% of taxable sales + 7.25% of 10% of non-taxable sales

6,266 6,600 6,499 6,499 6,499
71000 Replacement Reserve

Future cafe renovations, equipment purchases

10,000 5,000 5,000 5,000 5,000
72000 University Recharge

Utilities

7,500 10,000 12,000 12,000 12,000
79000 OP Tax

150 380 450 450 450
90000 Administrative Recharge

Payroll, accounts payable/receivable, purchasing

5,500 5,775 6,029 6,029 6,029
90600 Creative Media Recharge

0 1,500 1,500 1,500 1,500
Total Expenses 388,311 381,374 406,519 406,519 406,519
Charts
-0.86% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
There are no Stipend entries.
Total Stipend 0 0 0 0 0
Start-End Weeks Pay Per Week Num. Weeks Quantity Total
There are no stipend entries.

Hourly
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
a Assistant II

4,200 26,600 90,437 90,437 90,437
b Assistant II

68,000 46,200 75,141 75,141 75,141
c Assistant II

13,069 0 0 0 0
d Assistant II

60,988 97,020 0 0 0
e Assistant III

0 0 0 0 0
f Assistant III

0 0 0 0 0
g Assistant IV

9,900 10,080 32,625 32,625 32,625
h Assistant IV

22,440 13,680 26,910 26,910 26,910
i Assistant IV

1,838 0 0 0 0
j Assistant IV

14,578 28,500 0 0 0
Total Hourly 195,013 222,080 225,113 225,113 225,113
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
a Assistant II 6/12/17-12/31/17 297 10.50 29 1 90,437
b Assistant II 1/1/18-6/15/18 297 11.00 23 1 75,141
c Assistant II --- 0 0 0 1 0
d Assistant II --- 0 0 0 1 0
e Assistant III 6/12/17-12/31/17 0 0 0 1 0
f Assistant III 1/1/18-6/15/18 0 0 0 1 0
g Assistant IV 6/12/17-12/31/17 90 12.50 29 1 32,625
h Assistant IV 1/1/18-6/15/18 90 13.00 23 1 26,910
i Assistant IV --- 0 0 0 1 0
j Assistant IV --- 0 0 0 1 0

Career
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
a Food Service Ass't Manager

39,035 47,403 45,826 45,826 45,826
b Career Staff Overtime

250 100 50 50 50
c Administrative Assistant - 10%

0 2,886 4,000 4,000 4,000
Total Career 39,285 50,389 49,876 49,876 49,876
Start-End Num. Months Paid Pay Per Month Quantity Total
a Food Service Ass't Manager 7/1/17-6/30/18 12 3,818.83 1 45,826
b Career Staff Overtime 7/1/17-6/30/18 1 50.00 1 50
c Administrative Assistant - 10% 7/1/17-6/30/18 12 333.32 1 4,000

Employee Benefits
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 195,013 222,080 225,113 225,113 225,113
b Total Career 39,285 50,389 49,876 49,876 49,876
Total General Assistance 234,298 272,469 274,989 274,989 274,989
Employee Benefits Casual (a * 0.01500) 2,535 2,887 3,377 3,377 3,377
Employee Benefits Career (b * 0.51000) 20,310 25,850 25,437 25,437 25,437
General Automotive Employee Liability ((a+b) * 0.00000) 0 0 0 0 0
Composite Benefit Rate ((a+b) * 0.00000) 0 0 0 0 0
Total Employee Benefits 22,845 28,737 28,814 28,814 28,814