Coffee House

2012 - 2013

Charts
0% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
Income 4,425,000 4,419,426 4,334,009 4,334,009 4,334,009

Expenses
2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
General Assistance / Benefits 1,038,372 1,337,883 0 1,307,936 1,307,936
Administrative / Programmatic 3,096,761 3,081,543 3,026,073 3,026,073 3,026,073
Total Expense 4,135,133 4,419,426 3,026,073 4,334,009 4,334,009

Reconciliation
2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
Subsidy -289,867 0 0 0 0
Transfers To/From Reserve 0 0 1,307,936 0 0
Charts
-1.93% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Income
2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
11000 Sales - Taxable

Items sold that are taxed such as soda

220,000 263,446 240,000 240,000 240,000
11001 ---

0 0 0 0 0
12000 Sales - Non-Taxable

Items sold that are not taxed such as food items

4,320,000 4,250,000 4,202,000 4,202,000 4,202,000
12001 ---

0 0 0 0 0
13000 Catering Sales - Taxable

Catering orders from university affliated groups are taxed

15,000 15,000 15,000 15,000 15,000
14000 Catering Sales - Non-Taxable

Catering orders from student groups are not taxed

20,000 15,000 15,009 15,009 15,009
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

Charge from credit card companies and UCD (including $.045/transaction fee); 2010-11 fee was approximately 7% of total credit card purchases

-150,000 -159,020 -168,000 -168,000 -168,000
17001 ---

0 0 0 0 0
18000 Manufacturers Rebates

Rebate income based on prompt payment (1%) and delivery drop size of over $5,000 (2%) from US Foodservice; manufacturing rebate income for periodic case discount programs

0 35,000 30,000 30,000 30,000
18500 ---

0 0 0 0 0
19000 Over and Short

0 0 0 0 0
19001 ---

0 0 0 0 0
Total Income 4,425,000 4,419,426 4,334,009 4,334,009 4,334,009
Charts
-1.8% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
20000 Common Goods Assessment

0 0 0 0 0
21000 Common Goods Assessment

0 0 0 0 0
30000 Copying & Printing

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

5,000 5,000 5,000 5,000 5,000
31000 Mail

Mailing pertinent info to accounts payable, employee scheduling card

100 100 100 100 100
32000 Office Supplies

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

10,000 10,000 10,000 10,000 10,000
32001 ---

0 0 0 0 0
33000 Transportation

Airfare for director & managers to misc educational events including but not limited to NACUFS regional (San Diego, CA 2@$300) and

2,700 2,800 3,100 3,100 3,100
34000 Telephone Equipment

As charged

10,272 10,272 5,800 5,800 5,800
34001 ---

0 0 0 0 0
35000 Telephone Long Distance

Calls to distributors, business contacts

1,000 1,000 800 800 800
36000 Equipment Purchase

Misc. kitchen equipment failure replacement

8,000 8,000 8,000 8,000 8,000
36001 ---

0 0 0 0 0
37000 Repair & Maintenance

Misc. repairs

21,000 21,000 37,000 37,000 37,000
37001 ---

0 0 0 0 0
38000 Maintenance Contracts

Annual register maintenance

94,100 94,100 85,000 85,000 85,000
40000 Equipment Rental

As needed

200 200 200 200 200
50000 Merchandise for Resale

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

2,058,750 2,044,551 2,012,404 2,012,404 2,012,404
50001 ---

0 0 0 0 0
50100 Paper Supplies

100% compostible products

250,000 250,000 235,185 235,185 235,185
50101 ---

0 0 0 0 0
50300 Sanitation Supplies

Sanitation/Janitorial supplies

100,000 100,000 100,000 100,000 100,000
50400 Small Wares

Small wares for kitchen and serveries

2,000 1,460 2,000 2,000 2,000
51000 Services Rendered

As needed

200 200 0 0 0
52000 Publicity/Marketing

Aggie advertising

15,500 15,500 15,000 15,000 15,000
53000 Linen

Towels for cleaning; aprons for employees

18,000 18,000 20,000 20,000 20,000
53100 First Aid

First aid items

425 432 500 500 500
54000 PCI Compliance

3.5% x sales (income)

148,688 147,662 145,340 145,340 145,340
55000 Subscriptions/Conferences

Registration to educational events including but not limited to NACUFS regional conference registration (2@$400) + hotel (2@$450);

6,500 6,940 6,000 6,000 6,000
55555 Dot2Dot Retail for Sale

0 0 0 0 0
56000 Uniforms

230 x $15 - employee t-shirts

3,450 3,450 3,450 3,450 3,450
57000 Catering Equipment

As needed for catering program

100 100 100 100 100
58000 Staff Development

Employee incentive programs

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

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

0 0 0 0 0
59000 Sales Tax

Formula

40,000 40,000 38,000 38,000 38,000
59500 End-of-Quarter Study Program

Coffee and cookies for late night hours

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

0 0 0 0 0
71000 Replacement Reserve

45,000 45,000 45,000 45,000 45,000
72000 University Recharge

200,000 200,000 170,247 170,247 170,247
72001 ---

0 0 0 0 0
79000 OP Tax

0 0 21,562 21,562 21,562
90000 Admin Recharge

46,230 46,230 46,239 46,239 46,239
90500 Network Recharge

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

Marketing

0 0 0 0 0
91000 ASUCD-Catering

Catering for ASUCD units

-2,500 -2,500 -2,000 -2,000 -2,000
92000 ASUCD-Coho South/Coho To Go

0 0 0 0 0
Total Expenses 3,096,761 3,081,543 3,026,073 3,026,073 3,026,073
Charts
0% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2010 - 2011 2011 - 2012 2012 - 2013 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
2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
a Assistant II

234,000 234,000 0 240,000 240,000
b Assistant II

160,875 495,000 0 445,500 445,500
c Assistant II

64,175 25,500 0 42,500 42,500
d Assistant III

105,156 105,156 0 84,834 84,834
e Assistant III

54,039 54,039 0 57,554 57,554
f Assistant IV

20,740 39,000 0 34,000 34,000
g Assistant IV

42,517 16,380 0 18,480 18,480
Total Hourly 681,502 969,075 0 922,868 922,868
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
a Assistant II 6/10/12-6/08/13 30000.00 8.00 1 1 240,000
b Assistant II 6/10/12-6/08/13 54000.00 8.25 1 1 445,500
c Assistant II 6/10/12-6/08/13 5000.00 8.50 1 1 42,500
d Assistant III 6/10/12-6/08/13 9426.00 9.00 1 1 84,834
e Assistant III 6/10/12-6/08/13 6222.00 9.25 1 1 57,554
f Assistant IV 6/10/12-6/08/13 3400.00 10.00 1 1 34,000
g Assistant IV 6/10/12-6/08/13 1760.00 10.50 1 1 18,480

Career
2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
---

43,000 42,426 0 45,010 45,010
a Principle Food Service Manager

64,621 64,621 0 65,000 65,000
aa Food Svc Mgr 2

0 0 0 0 0
b Food Service Manager

46,791 46,791 0 49,640 49,640
bb Food Svc Mgr 1

0 0 0 0 0
c Food Service Assistant Manager

46,791 46,791 0 49,640 49,640
cc Food Svc Supv 2

0 0 0 0 0
g Food Service Assistant Manager

37,000 39,516 0 35,500 35,500
g Programmer III

0 0 0 0 0
gg Food Svc Supv 1

0 0 0 0 0
h Assistant Cashier

13,928 13,928 0 13,928 13,928
i Career Staff Overtime

0 0 0 0 0
j Administrative Assistant - 85%

0 0 0 0 0
jj ___ Asst 2 (85%)

0 0 0 0 0
k Exec. Chef 4

0 0 0 0 0
Total Career 252,131 254,073 0 258,718 258,718
Start-End Num. Months Paid Pay Per Month Quantity Total
--- 7/01/12-6/30/13 12 3,750.83 1 45,010
a Principle Food Service Manager 7/01/12-6/30/13 12 5,416.67 1 65,000
aa Food Svc Mgr 2 --- 0 0 0 0
b Food Service Manager 7/01/12-6/30/13 12 4,136.67 1 49,640
bb Food Svc Mgr 1 --- 0 0 0 0
c Food Service Assistant Manager 7/01/12-6/30/13 12 4,136.67 1 49,640
cc Food Svc Supv 2 --- 0 0 0 0
g Food Service Assistant Manager 7/01/12-6/30/13 12 2,958.33 1 35,500
g Programmer III --- 0 0 0 0
gg Food Svc Supv 1 --- 0 0 0 0
h Assistant Cashier 7/01/12-6/30/13 12 1,160.67 1 13,928
i Career Staff Overtime --- 0 0 0 0
j Administrative Assistant - 85% --- 0 0 0 0
jj ___ Asst 2 (85%) --- 0 0 0 0
k Exec. Chef 4 --- 0 0 0 0

Employee Benefits
2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 681,502 969,075 0 922,868 922,868
b Total Career 252,131 254,073 0 258,718 258,718
Total General Assistance 933,633 1,223,148 0 1,181,586 1,181,586
Employee Benefits Casual (a * 0.01300) 19,014 12,598 0 11,997 11,997
Employee Benefits Career (b * 0.44200) 85,725 102,137 0 114,353 114,353
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 104,739 114,735 0 126,350 126,350