Coffee House

2016 - 2017

Charts
-35.73% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
Income 5,140,000 5,985,000 5,805,000 5,805,000 5,805,000

Expenses
2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
General Assistance / Benefits 1,990,576 2,326,435 2,225,007 2,225,007 2,225,007
Administrative / Programmatic 3,149,424 3,612,846 3,550,609 3,574,605 3,515,107
Total Expense 5,140,000 5,939,281 5,775,616 5,799,612 5,740,114

Reconciliation
2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 0 45,719 29,384 5,388 64,886
Charts
-3.01% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Income
2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
11000 Sales - Taxable

267,000 310,000 301,000 301,000 301,000
11001 ---

0 0 0 0 0
12000 Sales - Non-Taxable

5,073,000 5,900,000 5,719,000 5,719,000 5,719,000
12001 ---

0 0 0 0 0
13000 Catering Sales - Taxable

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

12,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

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

0 0 0 0 0
18000 Manufacturers Rebates

15,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,140,000 5,985,000 5,805,000 5,805,000 5,805,000
Charts
-1.72% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
20000 Common Goods Assessment

EH&S inspections, Phone/Data charges

0 0 60,000 51,593 60,000
21000 Common Goods Assessment

0 0 0 0 0
30000 Copying & Printing

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

3,000 2,000 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 12,000 15,000 15,000 15,000
32001 ---

0 0 0 0 0
33000 Transportation

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

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

As charged

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

0 0 0 0 0
35000 Telephone Long Distance

Calls to distributors, business contacts, employees

500 400 0 0 0
36000 Equipment Purchase

Misc. kitchen equipment failure replacement

3,000 4,000 4,000 4,000 4,000
36001 ---

0 0 0 0 0
37000 Repair & Maintenance

Misc. repairs

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

0 0 0 0 0
38000 Maintenance Contracts

Annual register maintenance, custodial contract, Aggie Cash agreement

100,000 250,000 350,000 350,000 300,000
40000 Equipment Rental

As needed

100 100 0 0 0
50000 Merchandise for Resale

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

2,103,278 2,575,000 2,400,000 2,400,000 2,400,000
50001 ---

0 0 0 0 0
50100 Paper Supplies

100% compostible products

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

0 0 0 0 0
50300 Sanitation Supplies

Sanitation/Janitorial supplies

120,000 110,000 110,000 110,000 110,000
50400 Small Wares

Small wares for kitchen and serveries

7,500 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.

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

Towels for cleaning; aprons for employees

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

First aid items

500 100 100 100 100
54000 PCI Compliance

PCI compliance costs

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

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

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

0 0 0 0 0
56000 Uniforms

Employee t-shirts

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

As needed for catering program

250 250 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.5% of taxable sales + 7.5% of 10% of non-taxable sales

59,900 67,500 66,413 66,413 66,413
59500 End-of-Quarter Study Program

Coffee for late night hours

1,000 0 0 0 0
60100 HR Reclassificaion/Equity Increases

0 0 0 0 0
71000 Replacement Reserve

Unforseen replacement needs

20,000 10,000 10,000 10,000 10,000
72000 University Recharge

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

220,000 200,000 190,000 218,900 200,000
72001 ---

0 0 0 0 0
79000 OP Tax

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

Payroll, accounts payable, accounts receivable, purchasing

56,000 60,000 63,000 63,000 63,000
90500 Network Recharge

Website, marketing support

8,046 8,046 8,046 0 0
90600 Creative Media Recharge

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

Catering for ASUCD units

-2,000 -2,500 -1,200 -1,200 -1,200
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 -50,000 -60,000 -60,000 -60,000
Total Expenses 3,149,424 3,612,846 3,550,609 3,574,605 3,515,107
Charts
-4.36% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2014 - 2015 2015 - 2016 2016 - 2017 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
2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
a Assistant II

450,000 570,000 484,000 484,000 484,000
b Assistant II

763,125 861,000 379,373 379,373 379,373
c Assistant II

71,250 78,750 630,000 630,000 630,000
d Assistant III

140,000 165,000 106,425 106,425 106,425
e Assistant III

92,250 101,250 136,275 136,275 136,275
f Assistant IV

55,000 72,000 32,400 32,400 32,400
g Assistant IV

28,750 31,250 41,250 41,250 41,250
Total Hourly 1,600,375 1,879,250 1,809,723 1,809,723 1,809,723
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
a Assistant II 6/13/16-6/12/17 48400.00 10.00 1 1 484,000
b Assistant II 6/13/16-6/12/17 37012.00 10.25 1 1 379,373
c Assistant II 6/13/16-6/12/17 60000.00 10.50 1 1 630,000
d Assistant III 6/13/16-6/12/17 9675.00 11.00 1 1 106,425
e Assistant III 6/13/16-6/12/17 11850.00 11.50 1 1 136,275
f Assistant IV 6/13/16-6/12/17 2700.00 12.00 1 1 32,400
g Assistant IV 6/13/16-6/12/17 3300.00 12.50 1 1 41,250

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

38,400 0 0 0 0
a Principle Food Service Manager

62,052 77,900 79,458 79,458 79,458
aa Food Svc Mgr 2

0 0 0 0 0
b Food Service Manager

50,501 53,577 53,056 53,056 53,056
bb Food Svc Mgr 1

0 0 0 0 0
c Food Service Assistant Manager

42,420 45,290 46,030 46,030 46,030
cc Food Svc Supv 2

0 0 0 0 0
g Food Service Assistant Manager

37,308 40,620 42,099 42,099 42,099
g Programmer III

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

0 0 0 0 0
h Assistant Cashier

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

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

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

0 0 0 0 0
k Exec. Chef 4

0 0 0 0 0
Total Career 245,609 278,678 258,928 258,928 258,928
Start-End Num. Months Paid Pay Per Month Quantity Total
--- --- 0 0 0 0
a Principle Food Service Manager 7/1/16-6/30/17 12 6,621.49 1 79,458
aa Food Svc Mgr 2 --- 0 0 0 0
b Food Service Manager 7/1/16-6/30/17 12 4,421.36 1 53,056
bb Food Svc Mgr 1 --- 0 0 0 0
c Food Service Assistant Manager 7/1/16-6/30/17 12 3,835.87 1 46,030
cc Food Svc Supv 2 --- 0 0 0 0
g Food Service Assistant Manager 7/1/16-6/30/17 12 3,508.27 1 42,099
g Programmer III 7/1/16-6/30/17 12 0 1 0
gg Food Svc Supv 1 --- 0 0 0 0
h Assistant Cashier 7/1/16-6/30/17 12 1,100.00 1 13,200
i Career Staff Overtime 7/1/16-6/30/17 1 500.00 1 500
j Administrative Assistant - 85% 7/1/16-6/30/17 9 2,731.67 1 24,585
jj ___ Asst 2 (85%) --- 0 0 0 0
k Exec. Chef 4 --- 0 0 0 0

Employee Benefits
2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 1,600,375 1,879,250 1,809,723 1,809,723 1,809,723
b Total Career 245,609 278,678 258,928 258,928 258,928
Total General Assistance 1,845,984 2,157,928 2,068,651 2,068,651 2,068,651
Employee Benefits Casual (a * 0.01300) 20,805 24,430 23,526 23,526 23,526
Employee Benefits Career (b * 0.51300) 123,787 144,077 132,830 132,830 132,830
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 144,592 168,507 156,356 156,356 156,356