ALLEGHANY COUNTY PUBLIC SCHOOLS

MONTHLY FINANCIAL COMPARISON

 

MAY

MAY

 

 

 

2018

2017

Variance

% Change

Cash Balance

 

 

 

 

   Beginning Cash Balance

$392,068

$417,948

-$25,880

-6.19%

   Cash Adjustments

$0

$0

$0

#DIV/0!

Revenues

 

 

 

 

   Student Meal Sales

$8,293

$8,246

$47

0.57%

   A La Carte & Adult Meal Sales

$9,912

$8,919

$993

11.14%

   Rebates

$0

$0

$0

#DIV/0!

   Interest Earned

$145

$0

$145

#DIV/0!

   Subsidies/Loans

$0

$0

$0

#DIV/0!

   Other Revenue - Catering

$7,968

$7,007

$961

13.72%

   Other Revenues - A La Carte (only) Schools

$0

$0

$0

#DIV/0!

   Other Revenues - Misc.

$3

$173

-$170

-98.46%

   Program Reimbursement (Federal Funds)

$64,381

$54,420

$9,961

18.30%

   State Funds

$744

$486

$258

53.01%

   Grants

$0

$0

$0

#DIV/0!

   Repayment of Loans/Fund Transfers

$0

$0

$0

#DIV/0!

   Cash in Lieu of USDA Commodities

$4,094

$0

$4,094

#DIV/0!

Total Revenues

$95,540

$79,250

$16,290

20.56%

Expenditures

 

 

 

 

   Personal Services

$24,727

$27,869

-$3,141

-11.27%

   Employee Benefits

$9,191

$9,598

-$407

-4.24%

   Purchased Services

$715

$0

$715

#DIV/0!

   Internal Services

$0

$0

$0

#DIV/0!

   Other Charges

$70

$823

-$753

-91.46%

   Material & Supplies

$4,599

$6,766

-$2,167

-32.03%

   Food Products

$59,239

$74,604

-$15,365

-20.60%

   Capital Outlay

$0

$0

$0

#DIV/0!

   Other Uses of Funds

$0

$0

$0

#DIV/0!

   Fund Transfer

$0

$0

$0

#DIV/0!

   Loan Repayment

$0

$0

$0

#DIV/0!

   Repayment of Over-Claims

$0

$0

$0

#DIV/0!

Total Expenditures

$98,542

$119,660

-$21,118

-17.65%

Ending Cash Balance

$389,067

$377,538

$11,529

3.05%

Accounts Receivable

 

 

 

 

   Program Reimbursement - Previous Unpaid

$53,639

$40,996

$12,643

30.84%

   Other Receiveables

$0

$0

$0

#DIV/0!

   Total Accounts Receivable 

$53,639

$40,996

$12,643

30.84%

Accounts Payable

 

 

 

 

   Accounts Payable

$25,183

$0

$25,183

#DIV/0!

Net Cash

 

 

 

 

   Sum - Cash Balance

$417,523

$418,534

-$1,011

-0.24%

   USDA Commodities Received

$0

$0

$0

#DIV/0!

Inventory Value

 

 

 

 

   Purchased Food Value

$8,184

$12,629

-$4,445

-35.19%

   Purchased Materials & Supplies Value

$3,674

$3,523

$151

4.29%

   USDA Commodities Value

$0

$0

$0

#DIV/0!

Average Daily Meals Served

 

 

 

 

   School Breakfast

515

473

42

8.88%

   School Lunch

952

912

40

4.39%

   Total Average Daily Meals Served

1,467

1,385

82

5.92%

Miscellaneous Information

 

 

 

 

   Free & Reduced Lunch Percentage

54.02%

55.25%

-1.23%

N/A

   Number of Days Served - Breakfast

17

14

3

21.43%

   Number of Days Served - Lunch

17

14

3

21.43%