Coffee House

2011 - 2012

Charts
-100.0% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
Income 1,740,500 4,425,000 4,419,425 4,419,425 4,419,426

Expenses
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
General Assistance / Benefits 718,600 1,038,372 1,337,883 1,337,883 1,337,883
Administrative / Programmatic 1,027,804 3,096,761 3,081,543 3,081,543 3,081,543
Total Expense 1,746,404 4,135,133 4,419,426 4,419,426 4,419,426

Reconciliation
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
Subsidy 5,904 -289,867 0 0 0
Transfers To/From Reserve 0 0 -1 -1 0
Charts
-0.13% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

Items sold that are taxed such as soda

73,000 220,000 263,446 263,446 263,446
11001 ---

0 0 0 0 0
12000 Sales - Non-Taxable

Items sold that are not taxed such as food items

1,697,000 4,320,000 4,250,000 4,250,000 4,250,000
12001 ---

0 0 0 0 0
13000 Catering Sales - Taxable

Catering orders from university affliated groups are taxed

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

Catering orders from student groups are not taxed

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

Charge from credit card companies and UCD (including $.045/transaction fee); 2008-09 fee was 8.6% of total credit card purchases

-40,000 -150,000 -159,021 -159,021 -159,020
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 0 35,000 35,000 35,000
18500 ---

0 0 0 0 0
19000 Over and Short

0 0 0 0 0
19001 ---

0 0 0 0 0
Total Income 1,740,500 4,425,000 4,419,425 4,419,425 4,419,426
Charts
-0.49% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2009 - 2010 2010 - 2011 2011 - 2012 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

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

Mailing pertinent info to accounts payable, employee scheduling card

50 100 100 100 100
32000 Office Supplies

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

2,300 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,000 2,700 2,800 2,800 2,800
34000 Telephone Equipment

As charged

4,109 10,272 10,272 10,272 10,272
34001 ---

0 0 0 0 0
35000 Telephone Long Distance

Calls to distributors, business contacts

238 1,000 1,000 1,000 1,000
36000 Equipment Purchase

Misc. kitchen equipment failure replacement

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

0 0 0 0 0
37000 Repair & Maintenance

Misc. repairs

6,000 21,000 21,000 21,000 21,000
37001 ---

0 0 0 0 0
38000 Maintenance Contracts

Annual register maintenance

10,000 94,100 94,100 94,100 94,100
40000 Equipment Rental

As needed

0 200 200 200 200
50000 Merchandise for Resale

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

661,984 2,058,750 2,044,551 2,044,551 2,044,551
50001 ---

0 0 0 0 0
50100 Paper Supplies

Paper products; increase due to switch to 100% compostible products

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

0 0 0 0 0
50300 Sanitation Supplies

Sanitation/Janitorial supplies

10,500 100,000 100,000 100,000 100,000
50400 Small Wares

Small wares for kitchen and serveries

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

As needed

0 200 200 200 200
52000 Publicity/Marketing

Aggie advertising

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

Towels for cleaning; aprons for employees

7,200 18,000 18,000 18,000 18,000
53100 First Aid

First aid items

200 425 432 432 432
54000 PCI Compliance

3.5% x sales (income)

62,318 148,688 147,662 147,662 147,662
55000 Subscriptions/Conferences

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

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

0 0 0 0 0
56000 Uniforms

250 x $15 - employee t-shirts

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

As needed for catering program

0 100 100 100 100
58000 Staff Development

Employee incentive programs

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

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

Coffee and cookies for late night hours

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

0 0 0 0 0
71000 Replacement Reserve

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

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

0 0 0 0 0
79000 OP Tax

0 0 0 0 0
90000 Admin Recharge

31,234 46,230 46,230 46,230 46,230
90500 Network Recharge

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

0 0 0 0 0
91000 ASUCD-Catering

Catering for ASUCD units

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

0 0 0 0 0
Total Expenses 1,027,804 3,096,761 3,081,543 3,081,543 3,081,543
Charts
-28.84% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

181,900 234,000 234,000 234,000 234,000
b Assistant II

85,680 160,875 495,000 495,000 495,000
c Assistant II

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

87,400 105,156 105,156 105,156 105,156
e Assistant III

18,000 54,039 54,039 54,039 54,039
f Assistant IV

33,600 20,740 39,000 39,000 39,000
g Assistant IV

0 42,517 16,380 16,380 16,380
Total Hourly 406,580 681,502 969,075 969,075 969,075
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
a Assistant II 7/1/11-6/30/12 29250.00 8.00 52 1 12,168,000
b Assistant II 7/1/11-6/30/12 60000.00 8.25 52 1 25,740,000
c Assistant II 7/1/11-6/30/12 3000.00 8.50 52 1 1,326,000
d Assistant III 7/1/11-6/30/12 11684.00 9.00 52 1 5,468,112
e Assistant III 7/1/11-6/30/12 5842.00 9.25 52 1 2,810,002
f Assistant IV 7/1/11-6/30/12 3900.00 10.00 52 1 2,028,000
g Assistant IV 7/1/11-6/30/12 1560.00 10.50 52 1 851,760

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

39,156 43,000 42,426 42,426 42,426
a Principle Food Service Manager

64,621 64,621 64,621 64,621 64,621
aa Food Svc Mgr 2

0 0 0 0 0
b Food Service Manager

46,791 46,791 46,791 46,791 46,791
bb Food Svc Mgr 1

0 0 0 0 0
c Food Service Assistant Manager

46,791 46,791 46,791 46,791 46,791
cc Food Svc Supv 2

0 0 0 0 0
g Food Service Assistant Manager

17,364 37,000 39,516 39,516 39,516
g Programmer III

0 0 0 0 0
gg Food Svc Supv 1

0 0 0 0 0
h Assistant Cashier

9,662 13,928 13,928 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 224,385 252,131 254,073 254,073 254,073
Start-End Num. Months Paid Pay Per Month Quantity Total
--- 7/1/11-6/30/12 12 3,535.50 1 42,426
a Principle Food Service Manager 7/1/11-6/30/12 12 5,385.08 1 64,621
aa Food Svc Mgr 2 --- 0 0 0 0
b Food Service Manager 7/1/11-6/30/12 12 3,899.25 1 46,791
bb Food Svc Mgr 1 --- 0 0 0 0
c Food Service Assistant Manager 7/1/11-6/30/12 12 3,899.25 1 46,791
cc Food Svc Supv 2 --- 0 0 0 0
g Food Service Assistant Manager 7/1/11-6/30/12 12 3,293.00 1 39,516
g Programmer III --- 0 0 0 0
gg Food Svc Supv 1 --- 0 0 0 0
h Assistant Cashier 7/1/11-6/30/12 9 1,547.55 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
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 406,580 681,502 969,075 969,075 969,075
b Total Career 224,385 252,131 254,073 254,073 254,073
Total General Assistance 630,965 933,633 1,223,148 1,223,148 1,223,148
Employee Benefits Casual (a * 0.01300) 11,344 19,014 12,598 12,598 12,598
Employee Benefits Career (b * 0.40200) 76,291 85,725 102,137 102,137 102,137
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 87,635 104,739 114,735 114,735 114,735