Coffee House

2017 - 2018

Charts
-20.02% 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 5,985,000 5,805,000 5,890,000 5,890,000 5,890,000

Expenses
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
General Assistance / Benefits 2,326,435 2,225,007 2,434,437 2,434,437 2,434,437
Administrative / Programmatic 3,612,846 3,515,107 3,403,664 3,403,664 3,403,664
Total Expense 5,939,281 5,740,114 5,838,101 5,838,101 5,838,101

Reconciliation
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 45,719 64,886 51,899 51,899 51,899
Charts
1.46% 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

310,000 301,000 305,000 305,000 305,000
11001 ---

0 0 0 0 0
12000 Sales - Non-Taxable

5,900,000 5,719,000 5,795,000 5,795,000 5,795,000
12001 ---

0 0 0 0 0
13000 Catering Sales - Taxable

20,000 25,000 30,000 30,000 30,000
14000 Catering Sales - Non-Taxable

10,000 10,000 10,000 10,000 10,000
14100 Dot2Dot Retail Income

0 0 0 0 0
15500 Agreement Income

0 0 0 0 0
16000 ---

0 0 0 0 0
16500 ---

0 0 0 0 0
17000 Credit Card Charges

-275,000 -270,000 -270,000 -270,000 -270,000
17001 ---

0 0 0 0 0
18000 Manufacturers Rebates

20,000 20,000 20,000 20,000 20,000
18500 ---

0 0 0 0 0
19000 Over and Short

0 0 0 0 0
19001 ---

0 0 0 0 0
Total Income 5,985,000 5,805,000 5,890,000 5,890,000 5,890,000
Charts
-3.17% 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
20000 Common Goods Assessment

EH&S inspections, Phone/Data charges

0 60,000 37,483 37,483 37,483
21000 Common Goods Assessment

0 0 0 0 0
30000 Copying & Printing

Copying needs, including sub slips, TxMx order sheets, handbooks

2,000 2,500 2,500 2,500 2,500
31000 Mail

Mailing pertinent info to accounts payable, employee references, etc

50 50 50 50 50
32000 Office Supplies

Pens, paper, pencils, markers, tape, scissors, tissue

12,000 15,000 25,000 25,000 25,000
32001 ---

0 0 0 0 0
33000 Transportation

Airfare for director & managers to misc educational events including but not limited to NACUFS regional (Boulder, CO, 3@$200) and national conference (Nashville, TN, 3@$500)

1,000 1,700 2,200 2,200 2,200
34000 Telephone Equipment

As charged-primarily covered by CGA

5,800 1,000 1,000 1,000 1,000
34001 ---

0 0 0 0 0
35000 Telephone Long Distance

Calls to distributors, business contacts, employees-Covered by CGA

400 0 0 0 0
36000 Equipment Purchase

Misc. kitchen equipment failure replacement

4,000 4,000 10,000 10,000 10,000
36001 ---

0 0 0 0 0
37000 Repair & Maintenance

Misc. repairs

10,000 5,000 5,000 5,000 5,000
37001 ---

0 0 0 0 0
38000 Maintenance Contracts

Annual register maintenance, custodial contract, Aggie Cash agreement

250,000 300,000 250,000 250,000 250,000
40000 Equipment Rental

As needed

100 0 0 0 0
50000 Merchandise for Resale

41% (target food cost) x sales income = cost of food

2,575,000 2,400,000 2,472,000 2,472,000 2,472,000
50001 ---

0 0 0 0 0
50100 Paper Supplies

100% compostible products

250,000 250,000 250,000 250,000 250,000
50101 ---

0 0 0 0 0
50300 Sanitation Supplies

Sanitation/Janitorial supplies

110,000 110,000 115,000 115,000 115,000
50400 Small Wares

Small wares for kitchen and serveries

10,000 10,000 10,000 10,000 10,000
51000 Services Rendered

As needed

0 0 0 0 0
52000 Publicity/Marketing

Aggie advertising, sponsorship of campus farmer's market, etc.

1,000 1,500 1,000 1,000 1,000
53000 Linen

Towels for cleaning; aprons for employees

30,000 30,000 35,000 35,000 35,000
53100 First Aid

First aid items

100 100 0 0 0
54000 PCI Compliance

PCI compliance costs

50,000 20,000 5,000 5,000 5,000
55000 Subscriptions/Conferences

Registration to conferences including but not limited to NACUFS regional registration (3@$200) + hotel (2@$800) and national registration (3@$630) + hotel (2@$1000)

3,000 5,500 7,800 7,800 7,800
55555 Dot2Dot Retail for Sale

0 0 0 0 0
56000 Uniforms

Employee t-shirts

2,500 2,500 2,700 2,700 2,700
57000 Catering Equipment

As needed for catering program

250 0 0 0 0
58000 Staff Development

Employee incentive programs

1,000 1,000 1,000 1,000 1,000
58100 Business Development/T&E

0 0 0 0 0
58500 Food Credit (for Employees)

0 0 0 0 0
59000 Sales Tax

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

67,500 66,413 64,126 64,126 64,126
59500 End-of-Quarter Study Program

Coffee for late night hours

0 0 0 0 0
60100 HR Reclassificaion/Equity Increases

0 0 0 0 0
71000 Replacement Reserve

Unforseen replacement needs

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

Facility, Grounds, Accounting, Fire, EH&S, etc.

200,000 200,000 200,000 200,000 200,000
72001 ---

0 0 0 0 0
79000 OP Tax

1,600 4,044 4,200 4,200 4,200
90000 Admin Recharge

Payroll, accounts payable, accounts receivable, purchasing

60,000 63,000 64,605 64,605 64,605
90500 Network Recharge

Website, marketing support

8,046 0 0 0 0
90600 Creative Media Recharge

0 13,000 13,000 13,000 13,000
91000 ASUCD-Catering

Catering for ASUCD units

-2,500 -1,200 0 0 0
92000 ASUCD-Coho South/Coho To Go

CoHo-To-Go branded items sold to CoHo South Cafe, CoHo BioBrew and MU Convenience Store (at cost)

-50,000 -60,000 -180,000 -180,000 -180,000
Total Expenses 3,612,846 3,515,107 3,403,664 3,403,664 3,403,664
Charts
-9.41% 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

570,000 484,000 682,500 682,500 682,500
b Assistant II

861,000 379,373 0 0 0
c Assistant II

78,750 630,000 957,000 957,000 957,000
d Assistant III

165,000 106,425 111,550 111,550 111,550
e Assistant III

101,250 136,275 139,080 139,080 139,080
f Assistant IV

72,000 32,400 34,375 34,375 34,375
g Assistant IV

31,250 41,250 45,500 45,500 45,500
Total Hourly 1,879,250 1,809,723 1,970,005 1,970,005 1,970,005
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
a Assistant II 6/13/16-12/31/17 65000.00 10.50 1 1 682,500
b Assistant II 6/13/16-6/12/17 0 10.75 1 1 0
c Assistant II 1/1/18-6/12/18 87000.00 11.00 1 1 957,000
d Assistant III 6/13/16-12/31/17 9700.00 11.50 1 1 111,550
e Assistant III 1/1/18-6/12/18 11590.00 12.00 1 1 139,080
f Assistant IV 6/13/16-12/31/17 2750.00 12.50 1 1 34,375
g Assistant IV 1/1/18-6/12/18 3500.00 13.00 1 1 45,500

Career
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
---

0 0 0 0 0
a Principle Food Service Manager

77,900 79,458 85,524 85,524 85,524
aa Food Svc Mgr 2

0 0 0 0 0
b Food Service Manager

53,577 53,056 57,107 57,107 57,107
bb Food Svc Mgr 1

0 0 0 0 0
c Food Service Assistant Manager

45,290 46,030 48,823 48,823 48,823
cc Food Svc Supv 2

0 0 0 0 0
g Food Service Assistant Manager

40,620 42,099 42,848 42,848 42,848
g Programmer III

44,970 0 0 0 0
gg Food Svc Supv 1

0 0 0 0 0
h Assistant Cashier

15,321 13,200 13,200 13,200 13,200
i Career Staff Overtime

1,000 500 500 500 500
j Administrative Assistant - 85%

0 24,585 39,999 39,999 39,999
jj ___ Asst 2 (85%)

0 0 0 0 0
k Exec. Chef 4

0 0 0 0 0
Total Career 278,678 258,928 288,001 288,001 288,001
Start-End Num. Months Paid Pay Per Month Quantity Total
--- --- 0 0 0 0
a Principle Food Service Manager 7/1/17-6/30/18 12 7,127.00 1 85,524
aa Food Svc Mgr 2 --- 0 0 0 0
b Food Service Manager 7/1/17-6/30/18 12 4,758.93 1 57,107
bb Food Svc Mgr 1 --- 0 0 0 0
c Food Service Assistant Manager 7/1/17-6/30/18 12 4,068.62 1 48,823
cc Food Svc Supv 2 --- 0 0 0 0
g Food Service Assistant Manager 7/1/17-6/30/18 12 3,570.67 1 42,848
g Programmer III 7/1/17-6/30/18 12 0 1 0
gg Food Svc Supv 1 --- 0 0 0 0
h Assistant Cashier 7/1/17-6/30/18 12 1,100.00 1 13,200
i Career Staff Overtime 7/1/17-6/30/18 1 500.00 1 500
j Administrative Assistant - 85% 7/1/17-6/30/18 12 3,333.22 1 39,999
jj ___ Asst 2 (85%) --- 0 0 0 0
k Exec. Chef 4 --- 0 0 0 0

Employee Benefits
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 1,879,250 1,809,723 1,970,005 1,970,005 1,970,005
b Total Career 278,678 258,928 288,001 288,001 288,001
Total General Assistance 2,157,928 2,068,651 2,258,006 2,258,006 2,258,006
Employee Benefits Casual (a * 0.01500) 24,430 23,526 29,550 29,550 29,550
Employee Benefits Career (b * 0.51000) 144,077 132,830 146,881 146,881 146,881
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 168,507 156,356 176,431 176,431 176,431