Data Loading...

February 15, 2021 Directors Report - Regular Meeting

191 Views
70 Downloads
11.45 MB

Twitter Facebook LinkedIn Copy link

DOWNLOAD PDF

REPORT DMCA

RECOMMEND FLIP-BOOKS

February 15, 2021 Directors Report - Regular Meeting

Directors Report

Board Meeting

February 15 , 202 1

MEETING OF THE BOARD OF DIRECTORS MONDAY, FEBRUARY 15, 2021 VIRTUAL (Webinar/Phone) AGENDA EXECUTIVE SESSION – 10 A.M. PT Video Conference

Executive Sessions are provided by statute (Civil Code §4935) so Boards can address issues involving Privileged Information and matters of a Private Nature. As a result, Owners do not have a right to attend Executive Sessions. I.

CALL TO ORDER A. Minutes Approval B. Legal C. Contracts D. Personnel E. Member Discipline

REGULAR MEETING – 1 P.M. PT The meeting will be held via Zoom https://us02web.zoom.us/j/86484711135 Member Input on Business Items will be accepted after Item Presentation (limited to 2 minutes per speaker). Responses from the Board are at its discretion. I. CALL TO ORDER II. PRESIDENT’S REPORT A. Opening Remarks B. Approval of Agenda C. Executive Session Actions – President and/or General Manager III. TREASURER’S REPORT & RATIFICATION A. Financial Statement – January 31, 2020 IV. SECRETARY’S REPORT

Page 1 of 2

V.

GENERAL MANAGER’S REPORT A. Community Standards/A&A B. Maintenance C. Security D. Landscape

VI.

COMMITTEE REPORTS A. Planning B. Finance C. A&A

VII. CONSENT AGENDA Consent Agenda is used for those items which are non-controversial and appear to be unanimous in vote. Any Board member can ask for an item to be moved to Business. A. Minutes Approval

1. Board Meeting – January 18, 2021 2. Special Meeting – January 27, 2021 B. 2021 Committee Appointments 1. Tennis 2. A&A C. 2021 Reserve Study – Budgeted Reserve ($3,000) Consideration of Level II Study Award

VIII. UNFINISHED BUSINESS

A. Pickleball Noise Mitigation – Planning Committee Report Consideration of Future Direction B. Pickleball Survey Questions Review of Samples

IX.

NEW BUSINESS A. None

X.

DISCUSSION A. None

XI. OPEN FORUM Member Input on Non-Agenda Items (limited to 3 minutes per speaker). Responses from the Board are at its discretion. XII. ADJOURNMENT Next Scheduled Board Meeting – March 15, 2021 – 1 P.M. (PT) Virtual OR La Palma Clubhouse

February 15 , 202 1 Presidents Report

A. Opening Remarks B. Approval of Agenda C. Executive Session Actions

February 15 , 202 1 Treasurer’s Report & Ratification A. Financial Statement - January 31, 202 1

OUTDOOR RESORT - PALM SPRINGS Operating Balance Sheet Jan-21

GL Number

Current Month

Last Year

ASSETS

CASH

1002,1003-000

Petty Cash

5,996

5,750

1019-000 1014-000

Pacific Western - Operating - CD (Working Capital)

-

250,000 33,984 171,693 689,136

Pacific Western - Payroll Account Pacific Western - Operating Account First Foundation - CD (Working Capital)

11,372 205,750 697,772

1016,1216-000

1018-000

Total Operating Cash

920,891

1,150,563

RECEIVABLES

1205-000 1208-000 1209-000 1210-000 1230-000 1215-000 1213-000 1211-000 1212-000 1214-000

Assessment Receivables

27,635

160

A/R Reserve A/R Capital A/R Clearing

682

170,990 212,930

281,929

-

-

A/R Guest Ledger

(14,492)

(18,514)

A/R Vendini CC Activities A/R Leased Outlets A/R - House Accounts AR- Developement Fund

-

-

(309)

(1,333)

- - -

- - -

A/R Transfer Balance Zero Acct.

Total Accounts Receivable

295,446

364,231

OTHER CURRENT ASSETS

1305-000 1320-000 1325-000 1350-000 1470-000 1471-000 1473-000 1490-000

Prepaid Insurance

40,700 10,781

41,010 11,069

Other Prepaid Expenses Prepaid Worker's Comp

- -

- -

Land Available For Sale

Bar Inventory Store Inventory

9,312

6,717

-

-

Bar Happy Hour Food Inventory Golf Merchandise Inventory

256 330

256 330

TOTAL CURRENT ASSETS

61,379

59,382

OTHER ASSETS

1475-000 1480-000

Liquor License

8,812

6,667

Recycling Deposit

500

500

PROPERTY AND EQUIPMENT

1501-000 1502-000 1503-000 1504-000 1506-000 1507-000 1508-000 1509-000 1510-000 1515-000 1520-000 1525-000 1530-000 1535-000 1540-000

LP Recr Equip Furn & Other ES Recr Equip Furn & Other

190,884 154,920 70,099 12,993 48,597 140,372 97,766 30,521 729,614 45,566 158,547 102,103 118,007 10,115

190,884 156,389 70,099 12,993 48,597 140,372 97,766 30,521 565,080 45,566 158,547 118,002 118,007 10,115

Pool & Spa Equipment

Tennis Equipment

Golf Course Equipment Cafe Improvements Security Improvements Administration Building

Vehicles

Maintenance Equipment Lake & Irrigation Equipment

Office Equipment

Other

Store Equipment & Fixtures

Accumulated Depreciation

(1,562,868)

(1,525,598)

PROPERTY AND EQUIP, NET

347,235

237,340

TOTAL ASSETS

1,634,264

1,818,684

OUTDOOR RESORT - PALM SPRINGS Operating Balance Sheet Jan-21

GL Number

Current Month

Last Year

LIABILITIES

CURRENT LIABILITIES

2010-000 2011-000 2013-000

Accounts Payable

(750)

7,067

Accounts Payable Accrual's

37,938 45,908 34,318 16,936

60,335 18,518 74,990

Utilities Accruals Payroll Accrual

2012,2059,2062-000

2015-000 2016-000 2018-000 2019-000 2020-000 2063-000 2021-000 2030-000 2064-000 2100-000

Worker's Comp Accrual

7,502 4,193

Sales Tax Payable

1,788

Use Tax

-

-

Occupancy Tax

(5,739)

597

Capital Lease Payable

-

-

Employee Appreciation Day Fund

(242)

(242)

Deferred Revenue Café Gratuities Payable Accrued Vacation Prepaid Assessments

-

-

(25)

380

79,366 185,585

40,714 172,963

2102,2014-000

Prepaid Activities ORPS Events

15

9,015 1,300

2104-000

Prepaid Bar Entertainment

-

Total Current Liabilities

395,098

397,331

OTHER LIABILITIES Sec Deposit Beauty Shop Sec Deposit Restaurant

2165-000 2170-000 2175-000 2431-000 2432-000 2405-000 2406-000 2407-000 2408-000 2409-000 2411-000 2412-000 2415-000 2420-000 2490-000

500

500

1,000

1,000

Sec Deposit Store Tennis Key Deposit Cable Box Deposit

500

500

1,850 2,150 2,585

1,750 2,800 5,941

Tennis Holding

Resorters Chorus Holding Fitness Center Holding

558

358

6,589

6,458

Computer Club

-

-

Pickle Ball Holding

4,265

7,781

ERT Holding

355

355

Big Star Holding

4,535 2,735

1,012 3,308

Stitch & Bees Quilt

Golf Holding

125

(2,334)

ORPS Golf Club

7,673

5,022

Total Other Liabilities

35,421

34,452

TOTAL OPERATING FUND LIABILITIES

430,518

431,783

OPERATING FUND BALANCE 2725-000,2600-000 Operating Fund Balance Beginning

1,332,224

1,473,232

2726-000 2600-000

Operating Fund BalanceTransfers Operating Fund Income(Loss)YTD

81,222

(128,478)

(167,553) (53,407) 1,333,494

Operating Reserve 2017 2018 Additional Funding

Total

1,203,745

TOTAL LIABILITIES AND FUND BALANCE

1,634,264

1,818,684

OUTDOOR RESORT - PALM SPRINGS Operating Summary Income Statement Jan-21

Budget to Date

Current Month

Budget

Variance

Last year this month YTD

Variance

Revenue Administration Resort Services

413,391 46,879

418,079 77,816 32,945 21,198

(4,688) (30,937) (27,945) (21,198)

384,631 73,829 24,755 15,343

2,832,895

2,842,893

(9,998) (74,520) (62,784) (52,081)

149,024 15,639

223,544 78,423 54,788

Lifestyles

5,000

Bar

-

2,707 5,062

Golf

1,825

2,228

(403)

5,714

5,462

(400)

Total Revenues

467,095

552,266

(85,171)

504,273

3,005,326

3,205,110

(199,784)

Budget to Date

Current Month

Budget

Variance

Last year this month YTD

Variance

Expenses Administration Resort Services

70,224 22,719 18,349

70,892 18,989 42,914 17,609 14,759 116,580 36,516

668

119,887 13,683 33,062 19,539 16,557 112,040 47,782

496,007 114,716 73,575

533,739 120,776 145,703 51,693 62,329 859,760 275,006 30,321 162,944 418,872 44,518 518,964

37,732

(3,730) 24,565 17,568

6,060

Lifestyles

72,128 42,660 21,453

Bar

41

9,033

Golf

10,303 116,894 45,044

4,456

40,876 885,903 273,366 22,645 151,567 447,672 40,259 578,187

Grounds & Greens

(314)

(26,143)

Security Mailroom Facilities

(8,528)

1,640 7,676

2,855

4,977

2,122

6,506

31,670 75,545

26,304 60,334

(5,366) (15,211)

29,035 53,055

11,377

Maintenance & Repair Vehicles Maintenance

(28,800)

6,353

6,386

33

5,413

4,259

Utilities

76,097 476,095

87,589 503,849

11,492 27,754

76,706 533,265

(59,223)

Total Expenses

3,133,805

3,224,625

90,820

Net Income/Loss

(9,000)

48,417

(57,417)

(28,992)

(128,478)

(19,515)

(108,964)

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

INCOME

ADMINISTRATION

393,560

393,560

-

362,687

2,754,920

2,754,920

-

3100-100 Assessments

1,065

1,237

(172)

658

7,024

8,655

(1,631)

3106-100 Late Fees/Interest/NSF

(41)

38

(79)

-

(41)

266

(307)

3107-100 Special Individual Assessments

3,800

1,084

2,716

1,500

12,400

7,584

4,816

3109-100 Transfer Fees

3,100

625

2,475

-

9,750

4,375

5,375

3111-100 Escrow Demand Fee

500

1,250

(750)

1,200

2,350

3,550

(1,200)

3119-100 Permit Fee

376

209

167

100

1,251

1,459

(208)

3151-175 Key Replacement

275

100

175

-

2,620

2,725

(105)

3110-125 Vendor Fees

10,756

19,976

(9,220)

18,336

36,330

59,359

(23,029)

3160-850 Laundry

-

-

-

150

400

-

400

3144-100 Other Income

-

-

-

-

5,890

-

5,890

3148-100 Interest

-

-

-

-

-

-

-

3115-100 Fines and Suspensions

413,391

418,079

(4,688)

384,631

2,832,895

2,842,893

(9,998)

Total Administration Income

EXPENSE

ADMINISTRATION

-

-

-

-

13,750

12,500

(1,250)

4100-100 Audit /Tax Returns

476

274

(202)

416

2,880

661

(2,219)

4109-100 Bank Fees

107

1,347

1,240

6,439

13,151

9,429

(3,722)

4226-100 Board Expenses

-

1,887

1,887

1,887

373

4,011

3,638

4365-300 Credit Card

5,416

4,176

(1,240)

6,153

44,790

38,048

(6,742)

4115-100 Computer

1,206

(323)

4,513

9,174

8,442

(732)

4125-100 First Aid

1,529

(179)

(533)

4127-100 Dues & Subscriptions

492

313

314

4,984

4,451

85

1,108

4148-100

Permits

-

85

-

116

1,224

8,282

(203)

8,202

59,394

57,976

(1,418)

4139-100 Insurance

8,485

825

894

5,705

8,077

2,372

4142-100 Copier Service

270

1,095

772

(754)

3,472

7,115

5,263

(1,852)

4145-100 Legal Fees

1,526

381

1,656

4151-100 Meals & Entertainment

76

457

449

1,543

3,199

5

1,053

4154-100 Mileage & Travel

178

183

18

228 405

1,281

32

141

602

197

4159-100 Office Equipment

45

77

(530)

966

4,656

2,708

(1,948)

4161-100 Supplies

662

132

2,058

313

2,030

9,525

8,812

(713)

4166-100

Payroll Services

1,745

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

920

3,529

22,953

29,086

6,133

4996-100 401K - All

3,515

4,435

(934)

(1,789)

4169-100

Postage & FedEx Delivery

945

11

28

3,207

1,418

(580)

(4,093)

4172-100 Printing

682

102

1,038

5,978

1,885

100

473

-

700

700

4177-100 Radios

-

100

-

-

20,888

910

1,200

290

4178-100 Recruitment

-

267

214

4182-100 Safety /1st Aid Supplies

25

292 150

1,532

1,829 1,252

2,043 1,050

(18)

120

(202)

4179-100 Storage Costs

168

862

395

1,892

6,034

4,142

4187-100 Training & Education

-

862

63

-

1,965

1,491

(474)

4191-100 Website

150

213

-

-

-

14,343

21,550

7,207

4973-100 Bonuses

-

(5,149)

(1,994)

4901-100 Wages & Salaries

37,415

32,266

46,652

222,006

220,012

57

30

309

459

372

(87)

4971-100 Overtime

27

-

-

-

7,355

8,700

1,345

4972-100 Holiday Gifts

-

(667)

4,984

4975-100 Payroll Taxes

3,321

2,654 1,169

5,837

13,588

18,572

353

806

6,402

8,183

1,781

4990-100 Workers Comp

816

2,239

206

2,247

10,127

15,673

5,546

4995-100 Health Insurance

2,033

50

(70)

140

1,152

1,450

298

4997-100 Employee Substance Test

120

3,948

27,636

5100-100 Contingency Expense

-

3,948

- -

-

27,636

-

2,773

-

(2,773)

4999-100 Consulting

-

-

-

-

4102-100 Bad Debt Expense

-

-

-

-

-

-

(27)

4175-300 Business Tax

-

-

-

27

-

Total Administration Expense

70,224

70,892

668

119,887

496,007

533,739

37,732

Administrative Net Income/Loss

343,167

INCOME

RESORT SERVICES

3112-100 Website Listing

425

-

425

250

2,475

-

2,475

3113-100 Proximity Cards

141

325

(184)

358

1,031

1,547

(516)

3114-100 Transponders

883

975

(92)

988

3,994

5,783

(1,789)

3130-100 Beauty Shop Rent

-

318

(318)

300

300

1,166

(866)

3132-100 Espresso Bar Rent

-

64

(64)

100

-

190

(190)

3142-100 Café % of Sales

241

800

(559)

858

899

2,600

(1,701)

3133-100 Store Rent

500

613

(113)

500

1,500

2,449

(949)

3147-100 Real Estate % of Sales

3,993

4,167

(174)

2,587

16,584

29,167

(12,583)

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

3152-100 Real Estate % of Rental

-

1,884

(1,884)

-

4,342

13,182

(8,840)

3154-100 Other (Oracle Advertising)

375

2,250

(1,875)

900

4,265

5,175

(910)

3550-125 Resort Fees

39,825

66,420

(26,595)

66,358

112,817

162,285

(49,468)

3155-125 Advertising

-

-

-

-

-

-

-

3345-125 Copies & Faxes

117

-

117

242

230

-

230

3145-125

Directories

-

-

-

-

-

-

-

3330-300 Sundries

378

-

378

389

586

-

586

Total Rental/Reimburesement Income

46,879

77,816

(30,937)

73,829

149,024

223,544

(74,520)

EXPENSE

RESORT SERVICES

4103-125 Advertising & Marketing

-

-

-

24

8,072

8,474

402

4150-125 Credit Card Fees

1,452

2,271

819

2,438

4,401

6,066

1,665

4184-125 Front Desk Safety Supplies

-

150

150

74

-

550

550

4142-125 Photo Copier Services

1,100

-

(1,100)

-

1,418

878

(540)

4190-125 Uniforms

-

-

-

-

150

700

550

4198-125 Meals & Entertainment

-

33

33

-

149

231

82

4905-125 Wages & Saleries

16,652

14,148

(2,504)

9,157

84,508

87,191

2,683

4975-125 Payroll Taxes

1,901

1,109

(792)

1,381

7,670

7,758

88

4990-125 Workers Comp

203

55

(148)

36

1,343

385

(958)

4971-125 Overtime

159

19

(140)

6

301

118

(183)

4995-125 Health Insurance

1,253

1,204

(49)

566

6,706

8,425

1,719

4110-125

Cash Over/Short

-

-

-

-

-

-

-

Total Resort Services Expense

22,719

18,989

(3,730)

13,683

114,716

120,776

6,060

Resort Services Net Income/Loss

24,160

INCOME

LIFESTYLES

3170-200 ORPS Events

5,000

25,648

(20,648)

23,478

15,590

53,067

(37,477)

3174-200 Saturday - Coffee/Donuts

-

30

(30)

-

-

90

(90)

3175-200 Saturday Ice Cream

-

672

(672)

561

-

1,225

(1,225)

3200-200 Non-ORPS Events

-

3,595

(3,595)

622

-

5,041

(5,041)

3284-200 Sponsorship

-

3,000

(3,000)

-

49

19,000

(18,951)

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

3265-200 Flea Market Contributions

-

-

-

95

-

-

-

Total Lifestyles Income

5,000

32,945

(27,945)

24,755

15,639

78,423

(62,784)

EXPENSE

LIFESTYLES

4202-200 ORPS Events

10

18,417

18,407

8,009

2,512

31,714

29,202

4260-200 Decorations

-

500

500

-

276

1,500

1,224

4215-200 Ice Cream Social

-

275

275

232

338

1,100

762

4267-200 Linen Expense

-

200

200

387

199

566

367

4142-200 Copier Costs

-

362

362

-

75

1,537

1,462

4148-200 License & Permits

-

675

675

-

686

2,430

1,744

4272-200 Movie Rentals

-

26

26

-

2

102

100

4161-200 Office Supplies

171

214

43

201

673

1,070

397

-

4278-200 Paper Goods & Kitchen Supplies

-

143

143

110

226

712

486

4172-200 Printing

-

125

125

4,207

-

250

250

4190-200 Uniforms

-

214

214

53

428

1,070

642

4916-200 Wages & Salaries: Activities

14,845

16,134

1,289

14,190

57,202

75,551

18,349

4922-200 Tennis Courts/Set Up/Cleaning

(627)

-

627

-

-

-

-

4971-200 Overtime

3

129

126

879

142

604

462

4975-200 Payroll Taxes

2,071

1,598

(473)

3,251

6,020

7,990

1,970

4990-200 Worker's Comp.

616

521

(95)

440

3,649

2,605

(1,044)

4995-200 Health Insurance

1,260

3,381

2,121

1,064

1,148

16,902

15,754

Cash Over/Short

4110-200

-

-

-

15

-

-

-

4206-200 Comp Coffee & Supplies

-

-

-

-

-

-

-

4210-200 Non-ORPS Events

-

-

-

25

-

-

-

4212-200 Concerts & Entertainment

-

-

-

-

-

-

-

4218-200 Coffee & Donuts

-

-

-

-

-

-

-

Total Lifestyles Expense

18,349

42,914

24,565

33,062

73,575

145,703

72,128

Lifestyles Net Income/Loss

(13,349)

INCOME

BAR

3179-250 Happy Hour

-

15,684

(15,684)

11,684

93

37,146

(37,053)

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

3177-250 Food

-

2,061

(2,061)

104

-

5,518

(5,518)

3180-250 Entertainment Events

-

2,214

(2,214)

2,215

2,614

9,327

(6,713)

3184-250 Golf Scrambles

-

1,239

(1,239)

1,340

-

2,797

(2,797)

3182-250 Bar-FMCA Events

-

-

-

-

-

-

-

3183-250 Bar -Non ORPS Events

-

-

-

-

-

-

-

Total Bar Income

-

21,198

(21,198)

15,343

2,707

54,788

(52,081)

EXPENSE

BAR

4231-250 Bar Entertainment

-

887

887

3,770

1,200

3,061

1,861

4227-250 Bar Consummables

-

557

557

316

188

1,528

1,340

4228-250 Bar Food Cost

-

1,644

1,644

59

-

2,712

2,712

4230-250 Bar Supplies

6

418

412

504

243

1,276

1,033

4229-250 Bar Liquor

-

6,737

6,737

10,109

2,887

16,649

13,762

4918-250 Wages & Salaries/Contract Labor

30

5,742

5,712

4,781

3,937

19,971

16,034

4975-250 Payroll Taxes

4

510

506

-

368

2,040

1,672

4990-250 Worker's Comp.

-

517

517

-

234

2,068

1,834

4995-250 Health Insurance

-

597

597

-

(25)

2,388

2,413

Total Bar Expense

41

17,609

17,568

19,539

9,033

51,693

42,660

Bar Net Income/Loss

(41)

INCOME

GOLF

3400-400 Merchandise

454

406

48

2,963

1,269

467

802

3405-400 Golf Balls

512

158

354

137

1,714

502

1,212

3410-400 Club Rentals

9

384

(375)

385

18

1,219

(1,201)

3415-400 18 Holes

835

1,064

(229)

2,167

2,046

2,838

(792)

3420-400 9 Holes

15

216

(201)

63

15

436

(421)

Total Golf Income

1,825

2,228

(403)

5,714

5,062

5,462

(400)

EXPENSE

GOLF

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

4161-400 Office Equipment/Supllies

-

-

-

-

374

150

(224)

4132-400 Fore Tees Software/Maint

-

-

-

-

6,000

6,000

-

4172-400 Printing

-

-

-

-

207

500

293

4190-400 Uniforms

-

350

350

228

-

450

450

4600-400 Starter Shack Supplies

49

114

65

1,145

2,496

2,314

(182)

4610-400 Golf Merchandise

-

143

143

2,510

1,457

485

(972)

4650-400 Golf Balls

-

11,254

11,254

(454)

-

11,682

11,682

4950-400 Salaries & Wages

8,050

1,042

(7,008)

10,085

26,509

30,201

3,692

4975-400 Payroll Taxes

1,243

661

(582)

1,495

2,686

3,787

1,101

4971-400 Overtime

-

-

-

-

-

-

-

4990-400 Worker's Comp

374

1,195

821

489

1,311

3,177

1,866

4995-400 Health Insurance

588

-

(588)

1,059

(164)

3,583

3,747

4110-400 Cash Over/Short

-

-

-

-

-

-

-

Total Golf Expense

10,303

14,759

4,456

16,557

40,876

62,329

21,453

Golf Net Income/Loss

(8,478)

EXPENSE

GROUNDS & GREENS

4183-600 Contract Services

111,830

113,830

2,000

110,824

782,810

772,810

(10,000)

4148-600 License & Permits

-

-

-

-

-

-

-

4630-600 Irrigation Grounds & Golf

991

2,000

1,009

790

11,266

14,000

2,734

4660-600 Tree Trimming

-

-

-

-

40,800

40,000

(800)

4675-600 Flowers

-

-

-

-

38,448

27,700

(10,748)

4710-600 R&M Common Area

4,073

750

(3,323)

427

12,580

5,250

(7,330)

4670-600 Plants & Shrubs

-

-

-

-

-

-

-

Total Grounds & Greens Expense

116,894

116,580

(314)

112,040

885,903

859,760

(26,143)

EXPENSE

SECURITY

4144-150 Contract Fire Alarm

-

-

-

-

447

668

221

4142-150 Office Equipment

-

-

-

-

-

-

-

Supplies: Office

4161-150

-

29

29

-

24

203

179

4172-150 Printing

-

17

17

81

55

115

60

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

4184-150 Safety Supplies

-

42

42

-

416

290

(126)

4185-150 Proximity Cards

-

-

-

4,557

791

2,500

1,709

4186-150 Transponders

-

316

316

3,263

3,263

5,684

2,422

4190-150 Uniforms

-

413

413

299

4,652

2,887

(1,765)

4915-150 Wages & Salaries

33,736

25,550

(8,186)

29,878

193,781

191,623

(2,158)

4971-150 Overtime

2,771

417

(2,354)

175

9,765

2,915

(6,850)

4975-150 Payroll Taxes

1,856

2,514

658

4,537

19,481

17,598

(1,883)

4990-150 Worker's Comp.

1,274

1,808

534

1,276

9,157

12,654

3,497

4995-150 Health Insurance

5,409

5,410

1

3,717

31,535

37,869

6,334

Total Security Expense

45,044

36,516

(8,528)

47,782

273,366

275,006

1,640

EXPENSE

MAILROOM

4161-175 Supplies: Office

-

80

80

66

72

240

168

4190-175 Uniforms

-

-

-

-

-

200

200

4917-175 Wages & Salaries

2,485

4,374

1,889

5,759

20,328

26,220

5,892

4975-175 Payroll Taxes

359

506

147

662

2,173

3,542

1,369

4990-175 Worker's Comp

11

17

6

17

72

119

47

4971-175 Overtime

-

-

-

-

-

-

-

Total Mailroom Expense

2,855

4,977

2,122

6,506

22,645

30,321

7,676

EXPENSE

FACILITIES

4126-500 Holiday Decorations

-

-

-

-

-

644

644

4148-500 Licenses & Permits - Pools & Spas

-

-

-

-

9,247

7,714

(1,533)

4184-500 Supplies: Safety

-

-

-

-

-

600

600

4190-500 Uniforms

261

1,061

800

1,061

2,429

2,985

556

4500-500 Supplies: Housekeeping

2,589

2,782

193

3,583

17,316

21,157

3,841

4510-500 Pool Supplies: Pool

1,291

1,711

420

3,011

6,639

4,032

(2,607)

4530-500 Supplies: Tennis

-

-

-

-

-

100

100

4540-500 Pest Control

830

917

87

830

5,810

6,415

605

4930-500 Salaries & Wages: Housekeeping

20,737

15,532

(5,205)

15,425

85,014

89,236

4,222

4971-500 Overtime

689

31

(658)

39

1,827

179

(1,648)

4975-500 Payroll Taxes

2,293

1,057

(1,236)

2,312

6,646

7,394

748

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

4990-500 Worker's Comp

667

808

141

630

3,835

5,656

1,821

4995-500 Health Insurance

2,312

2,405

93

2,143

12,804

16,832

4,028

Total Facilities Expense

31,670

26,304

(5,366)

29,035

151,567

162,944

11,377

EXPENSE

MAINTENANCE & REPAIR

4142-700 Office Equipment/Copier Service

-

-

-

-

-

300

300

4161-700 Supplies: Office

363

42

(321)

19

463

290

(173)

4184-700 Supplies: Safety

364

292

(72)

381

3,892

2,040

(1,852)

4190-700 Uniforms

518

573

55

409

4,014

4,011

(3)

4757-850 Laundry Cards

-

1,130

1,130

481

960

2,810

1,850

4700-700 Administrative Building

69

417

348

137

1,186

2,915

1,729

4705-700 Lots (light bulbs/water repairs)

385

1,368

983

947

833

9,576

8,743

4715-700 Clubhouses

-

2,025

2,025

1,271

35,258

14,175

(21,083)

4720-700 Satellites (includes Guard Shack)

177

1,727

1,550

501

2,694

12,089

9,395

4725-700 Swimming Pools

2,681

459

(2,222)

460

19,743

5,560

(14,183)

4730-700 Tennis Courts

4,690

2,915

(1,775)

-

10,977

20,405

9,428

4733-700 R&M Recreation Equipment

-

167

167

163

2,086

1,169

(917)

4735-700 R&M Wells & Pumps

-

267

267

-

1,668

1,865

197

4740-700 R&M Lakes

2,427

3,232

805

2,315

16,155

16,972

817

4745-700 R&M Streets

3,474

300

(3,174)

-

10,916

3,322

(7,594)

4747-700 R&M Maintenance Building

-

189

189

-

894

1,323

429

4750-700 R&M Golf

-

50

50

-

-

350

350

4755-700 R&M Convience Store

-

-

-

-

-

-

-

4756-850 R&M Restauarant

998

829

(169)

135

9,472

5,795

(3,677)

4758-700 R&M Laundry Equipment

-

-

-

-

1,700

-

(1,700)

4759-700 Contracted Pool Service

-

-

-

-

9,782

-

(9,782)

4760-700 Supplies: Maintenance

2,322

833

(1,489)

956

12,339

5,831

(6,508)

4825-700 Small Tools

639

714

75

943

1,110

4,998

3,888

4960-700 Salaries & Wages: Maintenance & Repair

45,532

33,005

(12,527)

33,546

234,943

234,476

(467)

4971-700 Overtime

313

80

(233)

74

1,924

572

(1,352)

4975-700 Payroll Taxes

4,374

3,055

(1,319)

5,133

15,049

21,382

6,333

4990-700 Worker's Comp

1,356

2,212

856

1,305

10,963

15,480

4,517

4995-700 Health Insurance

4,865

4,453

(412)

3,881

38,651

31,166

(7,485)

Total Maintenance & Repair Expense

75,545

60,334

(15,211)

53,055

447,672

418,872

(28,800)

OUTDOOR RESORT - PALM SPRINGS Operating Income Statement Jan-21

Variance Last year this month This Year to Date

Budget to Date

GL Number

Description

Current Month

Budget

Variance

EXPENSE

VEHICLE MAINTENANCE

4148-800 License/Permits Vehicle/Equip

33

-

(33)

33

33

-

(33)

4190-800 Uniforms

105

163

58

105

1,050

1,141

91

4800-800 DMV Fees

-

85

85

-

1,340

1,357

17

4820-800 Shop Supplies

932

292

(640)

70

3,512

2,040

(1,472)

5025-600 Gasoline

469

632

163

585

2,279

3,496

1,217

4825-800 Tools

-

17

17

-

-

115

115

4830-800 R & M: Golf Carts

270

700

430

184

3,545

4,900

1,355

4835-800 R & M: Trucks

341

713

372

470

4,076

4,991

915

4965-800 Salaries & Wages

3,438

3,262

(176)

3,272

21,689

22,834

1,145

4971-800 Overtime

56

16

(40)

17

254

112

(142)

4975-800 Payroll Taxes

562

291

(271)

532

1,373

2,031

658

4990-800 Worker's Comp.

147

215

68

144

1,108

1,501

393

4810-800 Equipment Maintenance

-

-

-

-

-

-

-

Total Vehicle Expense

6,353

6,386

33

5,413

40,259

44,518

4,259

EXPENSE

UTILITIES

5000-100 Cable TV

15,688

15,524

(164)

14,339

119,906

104,960

(14,946)

5010-100 Electricity

20,310

17,418

(2,892)

17,419

226,871

182,956

(43,915)

5020-500 Natural Gas

16,261

17,046

785

15,831

42,828

49,520

6,692

5035-100 Telephone

3,761

5,364

1,603

5,764

26,348

25,192

(1,156)

5060-600 Refuse

5,894

5,034

(860)

5,597

25,524

21,640

(3,884)

5070-600 Dump Fees

1,668

3,158

1,490

3,269

8,472

11,847

3,375

5080-500 Water

9,881

19,234

9,353

9,475

110,153

104,027

(6,126)

5085-600 Sewer

2,634

4,811

2,177

5,012

18,084

18,822

738

Total Utilities Expense

76,097

87,589

11,492

76,706

578,187

518,964

(59,223)

Total Expense

476,095

503,849

27,754

533,265

3,133,805

3,224,625

90,820

OUTDOOR RESORT - PALM SPRINGS Reserve Balance Sheet Jan-21

GL Number

Current Month Last Year

ASSETS CASH

1065-000 1070-000 1075-000 1080-000

Checking Account - First Foundation Bank

1,290,787 416,222 266,771 266,550 158,898 158,679 2,357,409 2,304,593 4,073,865 3,146,044

Investment Account - Union Bank

Investment Account - Bank of Southern California

Investment Account - Morgan Stanley

RECEIVABLES

1230-000

Interest Receivable

0 0

0 0

OTHER CURRENT ASSETS

1345-000 1350-000 1355-000

Prepaid Other

0

0

Prepaid Federal Income Tax Prepaid State Income Tax

(3,360)

3,600 2,310 5,910

(591)

(3,951)

TOTAL ASSETS

4,069,914 3,151,954

LIABILITIES

CURRENT LIABILITIES Due to Operations Fund

2240-000 2305-000

512 (45,844) 0 512 (45,844) 0

Income Taxes Payable

512 (45,844)

TOTAL RESERVE FUND LIABILITIES

RESERVE FUND BALANCE Reserve Fund Balance Beginning Reserve Fund Income(Loss)YTD

2625-000

4,069,402 3,264,779 250,916 (66,981) 4,320,318 3,197,798

TOTAL LIABILITIES AND FUND BALANCE

4,069,914 3,151,954

OUTDOOR RESORT - PALM SPRINGS Reserve Fund Income Statement 31-Jan-21

July August September October November December January February March April May June Total ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL YTD

REVENUES

Reserve Fund Allocations

88,084

88,084

88,084

88,084

88,084

88,084 18,036 106,120

88,084

616,588 28,224 644,812 - 644,812

Interest Income

1,674

1,706

1,770

1,711

1,553

1,773

TOTAL

89,758

89,790

89,854

89,795

89,637

89,857

-

-

-

-

-

TOTAL REVENUES

89,758

89,790

89,854

89,795

89,637

106,120

89,857

-

-

-

-

-

EXPENSES: Real Estate Improvements & Repairs

32,486 95,422

32,045 81,429

8,662 9,875

1,376

55,058

13,904

143,531 250,366

Personal Property - Equipment Other Expenses/Bank Fee

41,010

21,579

1,051

- - - - -

- - - - -

Ameritrade Appreciation/Depreciation

Ameritrade Fees

Federal Income Tax State Income Tax

- -

TOTAL

41,010

127,908

113,474

18,537

22,955

55,058

14,954

-

-

-

-

-

393,896 - 393,896 - 250,916

Total Expenses

41,010

127,908

113,474

18,537

22,955

55,058

14,954

-

-

-

-

-

Net Income (Loss)

48,748

(38,118)

(23,620)

71,258

66,682

51,062

74,903

-

-

-

-

-

OUTDOOR RESORT - PALM SPRINGS Capital Balance Sheet 31-Jan-21

GL Number

Current Month Last Year

ASSETS CASH 1075-000 Cash Account - Union Bank

190,884 107,894 0 190,884 107,894 0

1345-000 Prepaid Expenses

RECEIVABLES

0

0

TOTAL ASSETS

190,884 107,894

LIABILITIES

CURRENT LIABILITIES 2250-000 Due to Operations Fund

281,929 212,930 281,929 212,930

281,929 212,930

TOTAL DEVELOP. FUND LIABILITIES

DEVELOP. FUND BALANCE

2630-000 Capital Balance Beginning

(79,327) (122,004) 16,968 (91,046) (105,036) (11,718)

Capital Income(Loss)YTD

TOTAL LIABILITIES

190,884 107,894

OUTDOOR RESORT - PALM SPRINGS Capital Income Statement 31-Jan-21

July August September October November December January February March April May June Total ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL YTD

REVENUES

Capital Fund Allocations

6,667 4,167

6,667 4,167

6,667 4,167

6,667 4,167

6,667 4,167

6,667 4,167

10,834

50,836 25,002

Development Fund Allocations

Interest Income

12

13

14

15

16

17

17

104

TOTAL

10,846

10,847

10,848

10,849

10,850

10,851

10,851

-

-

-

-

-

75,942 - 75,942

TOTAL REVENUES

10,846

10,847

10,848

10,849

10,850

10,851

10,851

-

-

-

-

-

EXPENSES: Real Estate Additions

1,000

28,276

31,064

- - -

1,523

25,798

87,660

Other Expenses

-

-

-

TOTAL

1,000

28,276

31,064

1,523

-

25,798

-

-

-

-

-

87,660 - 87,660 -

Total Expenses

1,000

28,276

31,064

-

1,523

-

25,798

-

-

-

-

-

Net Income (Loss)

9,846

(17,429)

(20,216)

10,849

9,327

10,851

(14,946)

-

-

-

-

-

(11,718)

Outdoor Resort Palm Springs Owners Association Operating Fund Working Capital Policy

Policy Statement

The Controller shall maintain one week to two weeks (2%-4%) of the Operating Fund's current annual budget as working capital for unforseen circumstances.

Working Capital at the end of any fiscal year exceeding 4% of the current annual budget will be realloacated as determined by the Board of Directors in accordance with our Governing Documents and California Civil Code.

Working Capital is defined as Current Assets minus Current Liabilities on the Operating Fund Balance Sheet.

Any recommendations to modify this policy should be reviewed with the General Manager and Controller prior to submission to the Board of Directors for final approval. (See Administative Policies and Procedures).

01/31/2021

01/31/2020

Current Assets Cash

223,119 295,446

211,427 364,231

Receivables

Other Current Assets

61,379

59,382

Total

579,944

635,040

Current Liabilities

Accounts Payable

79,145 130,378 185,585

90,709 122,965 172,963

Accruals (payroll items)

Owners Assessments prepaid Capital Lease Payable Other Current Liabilities

-

35,421

34,452

Total

430,528

421,089

Working Capital

149,416

213,951

2020-21

2019-20

Operating Fund Current Annual Budget

$

5,574,166

$

5,104,189

2% of Operating Budget 4% of Operating Budget

111,483 222,967

102,084 204,168

Actual - Working Capital as a Percentage of Operating Fund Current Annual Budget

2.68%

4.19%

OUTDOOR RESORT - PALM SPRINGS Forecast

31-Jan-21 Actual vs. Budget

Jul-20 Aug-20 Sep-20 Oct-20 Nov-21 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21

Total

Total

Variance

Revenue

Actuals Actual

Actual 400,056

Actual 402,595 13,996

Actual 409,656 35,411

Actual 408,876 32,507 10,000

Actual 413,391 46,879

Budget Budget Budget Budget

Budget Actual/Budget

Budget

Administration Resort Services

396,086 11,258

402,235

416,840 91,632 33,821 26,967

412,519 77,257 23,026 17,080

404,964 33,705

399,673 16,432

398,520 10,301

4,865,411

4,875,409

(9,998) (74,520) (62,784) (52,081)

5,038

3,935

378,351 72,486 46,754 11,334

452,871 135,270 98,835 11,734

Lifestyles

- - -

- - -

- - -

- - -

639

5,000

- -

- -

- - -

Bar

2,707 1,891

-

-

Golf

1,346

1,825

2,804

2,276

915

277

(400)

Total Revenues

407,345

407,273

403,991

416,591

450,304

452,729

467,095

572,064

532,158

439,584

416,382

408,821

5,374,336

5,574,119

(199,783)

Expenses Administration Resort Services

64,435

71,112 22,190 38,466 13,098 14,761 118,580 38,586

73,637 17,677 20,840

891,438 211,550 251,051 83,555 102,743

37,713

76,952 21,735

64,309 13,200 14,821

63,407 13,245 12,559

66,423 15,482 14,152

90,276 19,856 16,087

70,224 22,719 18,349

72,090 19,994 43,776 13,510 14,759 116,580 36,516

73,614 16,985

67,246 13,928

853,725 205,489 176,882 42,935 81,289

8,478

6,061

Lifestyles

(2,716)

74,169 40,620 21,454

322

113

113

Bar

6

7,294

6

6

3,511 7,855

5,116

347

41

- -

- -

Golf

(1,796)

10,894 116,580 49,291

-

-

14,467 114,341 30,669

10,046 116,071 40,239

10,303 116,894 45,044

Grounds & Greens

153,865 38,625

113,929 36,841

119,180 41,385

152,462 40,563

121,080 36,517

116,580 36,852

1,449,160

(26,982)

1,476,142

Security Mailroom Facilities

472,768 54,888 262,118 729,481 76,316 880,709 142,136

1,640 7,675

471,128 47,213 250,741 758,280 72,057 940,016

1,659

4,897

4,978

1,698

2,013

2,517

7,257

4,647

2,855

4,897

4,897

4,898

11,356 45,939

26,103 59,923

22,947 60,403

11,377

13,548 65,234

20,620 72,026

27,695 60,131

22,180 59,089

24,498 69,707

31,670 75,545

24,494 61,922

11,673 65,373

13,957 62,988

Maintenance & Repair Vehicles Maintenance

(28,799)

4,201

7,052

6,121

4,259

4,602

5,790

7,965

4,069

7,279

6,353

5,906

5,925

6,794

Utilities

89,558

81,482

71,781

(59,307) 142,136 232,015

103,989

72,827

74,472

82,400

78,928

76,097

73,026

69,323

66,133

Contingency

-

-

-

-

-

-

-

-

-

-

-

-

-

Total Expenses

413,610

438,856

426,177

466,382

435,645

477,981

476,095

487,470

496,250

462,443

405,500

389,489

5,375,898

5,607,913

Net Income/(Loss)

(6,265)

(31,583)

(22,186)

(49,791)

14,659

(25,252)

(9,000)

84,594

35,908

(22,859)

10,882

19,332

(1,562)

(33,794)

32,232