JCM Spreadsheet
Home ] Up ]

 

 

Below is a copy of an official District report as of 3/31/01, showing projected sources of funding and expenditures:

District Funding Sources

A

B

C

D

Total Funding

Received as of 03/31/01

Balance to be Received

Cash Balance as of 03/31/01

Bond Issue - Bond Fund 70

$77,000,000.00

$77,000,000.00

$-

Interest thru 6/30/01 - projected

$10,499,075.00

$9,510,511.00

$988,564.00

Low re IRS share? Omitted from report

Projected Future Interest

$300,000.00

$-

$300,000.00

Total Bond Funds

$87,799,075.00

$86,510,511.00

$1,288,564.00

 

$13,649,797.00

                                                                                                     
                                                                                                                 

Prop 1A - School Facilities Fund 82

$14,497,079.00

$14,497,079.00

$-

Got inflation adj. From $13.8 M

                                                                                                       

Interest thru 6/30/01 - projected

$649,927.00

$149,233.00

$500,694.00

County omitted $204,000

 

$381,000 received thru April - 2 quarters - should do better than the $649,000

                                                                                                   

Projected Future Interest

$300,000.00

$-

$300,000.00

High?

                                                                                                       

Total Prop 1A Funds

$15,447,006.00

$14,646,312.00

$800,694.00

 

$14,671,146.00

                                                                                                     
                                                                                                                 

Office of Public Construction (FEMA)

$1,697,676.00

$540,203.00

$1,157,473.00

How likely??

                                                                                                       

Interest thru 6/30/01 - projected

$21,000.00

$15,927.00

$5,073.00

                                                                                                         

Projected Future Interest

$40,000.00

$-

$40,000.00

Total FEMA Funds

$1,758,676.00

$556,130.00

$1,202,546.00

 

$563,942.00

                                                                                                     
                                                                                                                 

Developer Fees - Capital Facilities Fund 73

$1,904,875.00

$1,642,322.00

$262,553.00

Need breakdown of how spending this

$1,189,372.00

                                                                                                     
                                                                                                                 

City Funds (Peters Auditorium) - Fund 15

$1,092,900.00

$-

$1,092,900.00

 

$-

                                                                                                     
                                                                                                                 

TOTALS

$108,002,532.00

$103,355,275.00

$4,647,257.00

$30,074,257.00

                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 
                                                                                                                 

The JCM Group

District Summary

Program Management

200 South Elm Drive

Beverly Hills,CA 90212

Budgeted, Commited, Forecasted Cost Report

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

BV

$18,080,000.00

$35,604,207.90

$17,524,207.90

$26,156,048.00

$464,306.50

$29,121.40

$8,954,732.00

$-

$-

$9,330,236.00

0%

   

High School

$32,545,000.00

$43,610,818.93

$11,065,818.93

$39,239,800.00

$3,648,718.93

$677,300.00

$45,000.00

$-

$-

$36,095,550.00

0%

   

Admin Recap

$960,000.00

$5,143,557.00

$4,183,557.00

$5,143,557.00

$-

$-

$-

$-

$-

$5,143,557.00

0%

   

El Rodeo

$9,169,000.00

$14,515,932.24

$5,346,932.24

$12,548,806.00

$1,343,116.83

$554,009.41

$70,000.00

$-

$-

$6,911,266.00

0%

   

Hawthorne

$9,169,000.00

$12,418,165.34

$3,249,165.34

$11,195,843.00

$963,547.93

$198,774.41

$60,000.00

$-

$-

$6,884,973.00

0%

   

Horace Mann

$8,046,000.00

$11,062,967.29

$3,016,967.29

$10,163,281.00

$462,884.64

$306,801.65

$130,000.00

$-

$-

$7,083,584.00

0%

   

Peters Aud.

$2,100,941.01

$2,100,941.01

$1,337,466.98

$143,916.74

$619,557.29

$-

$-

$-

0%

Total

$77,969,000.00

$124,456,589.71

$46,487,589.71

$105,784,801.98

$7,026,491.57

$2,385,564.16

$9,259,732.00

$-

$-

$71,449,166.00

     
                           
                           
                           

Total Funding Sources:

$108,002,532.00

*Less: Current Projection:

$124,456,589.71

Total Unfunded Projects:

$(16,454,057.71)

The JCM Group

School Site: High School

Program Management

CM: CCG, Inc.

200 South Elm Drive

Contractor: Tutor-Saliba

Beverly Hills,CA 90212

Budgeted, Committed, Forecasted Cost Report

Architect: NTD Architects

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

PCM3

$-

$12,994,133.00

$12,994,133.00

$12,994,133.00

$-

$-

$-

$-

$-

$12,994,133.00

0%

   

Owner Costs

$215,000.00

$1,423,613.00

$1,208,613.00

$1,423,613.00

$-

$-

$-

$-

$-

$1,423,613.00

0%

   

Soft Costs

$6,330,000.00

$3,575,150.00

$(2,754,850.00)

$3,299,850.00

$183,000.00

$47,300.00

$45,000.00

$-

$-

$1,332,296.00

0%

   

F,F & E

$2,000,000.00

$15,204.00

$(1,984,796.00)

$15,204.00

$-

$-

$-

$-

$-

$15,204.00

0%

   

Construction

$24,000,000.00

$25,602,718.93

$1,602,718.93

$21,507,000.00

$3,465,718.93

$630,000.00

$-

$-

$-

$20,330,304.00

0%

Total

$32,545,000.00

$43,610,818.93

$11,065,818.93

$39,239,800.00

$3,648,718.93

$677,300.00

$45,000.00

$-

$-

$36,095,550.00

     
                           
                           

Column D

Owner Costs

Missing estimate for temporary housing through completion .

                     

Column D

Soft Costs

Includes Architect's original contract ($1,715, 263), estimated CM & PM fees ($260,000), commitments for accessory services ($473,555), approx. $60,000 in inspection fees

                     
   

through completion and $791,032 soft costs expenditures, from L.H.

                     

Column E

Soft Costs

Architects approx. fee on C.O. work at estimated 7.5%.

                     

Column F

Soft Costs

Architects approx. fee on C.O.R. work at estimated 7.5%.

                     

Column G

Softs Costs

Approx. amount architect might be entitled to due to change in construction cost form estimate to accepted bid.

                     
                           

Some Change Order fees for the Architect may be questionable or even reversed due to Architect's responsibility in creating them. CM's to verify for merit.

                         

The JCM Group

School Site: Hawthorne

Program Management

CM: Osborn Architects

200 South Elm Drive

Contractor: Pinner

Beverly Hills,CA 90212

Budgeted, Committed, Forecasted Cost Report

Architect: Langdon Wilson

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

PCM3

$-

$2,816,919.00

$2,816,919.00

$2,816,919.00

   

$-

$-

 

$2,816,919.00

0%

   

Owner Costs

$120,000.00

$424,149.00

$304,149.00

$424,149.00

   

$-

$-

 

$424,149.00

0%

   

Soft Costs

$1,549,000.00

$1,159,184.22

$(389,815.78)

$1,070,075.00

$87,595.27

$1,513.95

$-

$-

 

$346,324.00

0%

   

F,F & E

$500,000.00

$19,032.00

$(480,968.00)

$19,032.00

   

$-

$-

 

$19,032.00

0%

   

Construction

$7,000,000.00

$7,998,881.12

$998,881.12

$6,865,668.00

$875,952.66

$197,260.46

$60,000.00

$-

$3,278,549.00

0%

Total

$9,169,000.00

$12,418,165.34

$3,249,165.34

$11,195,843.00

$963,547.93

$198,774.41

$60,000.00

$-

 

$6,884,973.00

     
                           
                           

Column D

Owner Costs

Missing estimate for temporary housing through completion .

                     

Column D

Soft Costs

Includes architect's original contract ($562,500), estimated CM & PM fees ($325,000), approx. $100,000 in inspection fees and $182,575 soft cost expenditures through 3.31.01, for LH.

                     

Column D

Construction

Represents portion of original construction contract, prorated to this site.

                     

Column E

Soft Costs

Architects approx. fee on C.O. work at estimated 10%. To be verified for merit.

                     

Column F

Soft Costs

Architects approx. fee on C.O.R. work at estimated 10%. To be verified for merit.

                     

Column G

Construction

Estimated cost of asbestos abatement and monitoring.

                     

Column G

Construction

Includes fees to architect based on C.O., C.O.R.'s and other fees that might be questionable due to architect's responsibility in creating them.

                     

The JCM Group

School Site: El Rodeo

Program Management

CM: Osborn Architects

200 South Elm Drive

Contractor: Pinner

Beverly Hills,CA 90212

Budgeted, Committed, Forecasted Cost Report

Architect: Langdon Wilson

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

PCM3

$-

$2,775,032.00

$2,775,032.00

$2,775,032.00

   

$-

$-

 

$2,775,032.00

0%

   

Owner Costs

$120,000.00

$326,296.00

$206,296.00

$326,296.00

   

$-

$-

 

$329,296.00

0%

   

Soft Costs

$1,549,000.00

$1,389,582.94

$(159,417.06)

$1,241,826.00

$122,101.53

$25,655.41

$-

$-

 

$414,881.00

0%

   

F,F & E

$500,000.00

$22,444.00

$(477,556.00)

$22,444.00

   

$-

$-

 

$22,444.00

0%

   

Construction

$7,000,000.00

$10,002,577.30

$3,002,577.30

$8,183,208.00

$1,221,015.30

$528,354.00

$70,000.00

$-

$3,372,613.00

0%

Total

$9,169,000.00

$14,515,932.24

$5,346,932.24

$12,548,806.00

$1,343,116.83

$554,009.41

$70,000.00

$-

$-

$6,911,266.00

                           
                           

Column D

Owner Costs

Missing estimate for temporary housing through completion .

                     

Column D

Soft Costs

Includes architect's original contract ($562,500), estimated CM & PM fees ($325,000), approx. $100,000 in inspection fees and $254,326 soft cost expenditures through 3.31.01, for LH.

                     

Column D

Construction

Represents portion of original construction contract, prorated to this site.

                     

Column E

Soft Costs

Architects approx. fee on C.O. work at estimated 10%. To be verified for merit.

                     

Column F

Soft Costs

Architects approx. fee on C.O.R. work at estimated 10%. To be verified for merit.

                     

Column G

Construction

Estimated cost of asbestos abatement and monitoring.

                     

Column G

Construction

Includes fees to architect based on C.O., C.O.R.'s and other fees that might be questionable due to architect's responsibility in creating them.

                     

The JCM Group

School Site: Horace Mann

Program Management

CM: Osborn Architects

200 South Elm Drive

Contractor: Pinner

Beverly Hills,CA 90212

Budgeted, Commited, Forecasted Cost Report

Architect: Langdon Wilson

                                                     
                                                     
 

Budget

   

Commitments

 

Forecasted

     

% Complete

                               
                                                     

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

PCM3

$-

$3,071,066.00

$3,071,066.00

$3,071,066.00

$-

$-

$-

$-

$-

$3,071,066.00

0%

                             

Owner Costs

$120,000.00

$367,575.00

$247,575.00

$367,575.00

$-

$-

$-

$-

$-

$367,575.00

0%

                             

Soft Costs

$1,426,000.00

$1,253,375.84

$(172,624.16)

$1,208,168.00

$42,080.42

$3,127.42

$-

$-

$-

$381,222.00

0%

                             

F,F & E

$500,000.00

$11,348.00

$(488,652.00)

$11,348.00

$-

$-

$-

$-

$-

$11,348.00

0%

                             

Construction

$6,000,000.00

$6,359,602.45

$359,602.45

$5,505,124.00

$420,804.22

$303,674.23

$130,000.00

$-

$-

$3,252,373.00

0%

Total

$8,046,000.00

$11,062,967.29

$3,016,967.29

$10,163,281.00

$462,884.64

$306,801.65

$130,000.00

$-

$-

$7,083,584.00

                               
                                                     
                                                     

Column D

Owner Costs

Missing estimate for temporary housing through completion .

                                               

Column D

Soft Costs

Includes architect's original contract ($562,500), estimated CM & PM fees ($325,000), approx. $100,000 in inspection fees and $220,668 soft cost expenditures through 3.31.01, for LH.

                                               

Column D

Construction

Represents portion of original construction contract, prorated to this site.

                                               

Column E

Soft Costs

Architects approx. fee on C.O. work at estimated 10%. To be verified for merit.

                                               

Column F

Soft Costs

Architects approx. fee on C.O.R. work at estimated 10%. To be verified for merit.

                                               

Column G

Construction

Estimated cost of asbestos abatement and monitoring.

                                               

The JCM Group

School Site:Beverly Vista

Program Management

CM: JCM Group

200 South Elm Drive

Contractor: Earl Corp.

Beverly Hills,CA 90212

Budgeted, Committed, Forecasted Cost Report

Architect: Osborn Arch.

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

PCM3

$-

$4,206,182.00

$4,206,182.00

$4,206,182.00

 

$-

$-

$-

 

$4,206,182.00

0%

   

Owner Costs

$1,030,000.00

$600,427.00

$(429,573.00)

$600,427.00

 

$-

$-

$-

 

$600,427.00

0%

   

Soft Costs

$2,450,000.00

$3,680,066.40

$1,230,066.40

$2,722,687.00

 

$2,647.40

$954,732.00

$-

 

$1,271,875.00

0%

   

F,F & E

$600,000.00

$8,198.00

$(591,802.00)

$8,198.00

   

$-

$-

 

$8,198.00

0%

   

Construction

$14,000,000.00

$27,109,334.50

$13,109,334.50

$18,618,554.00

$464,306.50

$26,474.00

$8,000,000.00

$-

$3,243,554.00

0%

Total

$18,080,000.00

$35,604,207.90

$17,524,207.90

$26,156,048.00

$464,306.50

$29,121.40

$8,954,732.00

$-

$-

$9,330,236.00

     
                           

Column A

Construction

Includes costs for Building B.

                     

Column D

Owner Costs

Missing estimate for temporary housing through completion .

                     

Column D

Soft Costs

Includes architects original contract $937,500 based on 10,000,000 estmated construction cost, estimated CM & PM fees ($700,000), approx. $216,000 in inspection fees and soft costs

                     
   

expenditures through 3.31.01, from L.H. However missing commitment to A/E team for accessory services, pending reconciliation underway.

                     

Column F

Soft Costs

Architects approx. fee on C.O.R. work at estimated 10%. To be verified for merit.

                     

Column G

Soft Costs

Represents $354,732 due to Osborn Architects upon adjustment of construction cost to 20.8 million, plus approx. $500,000 architect's fee adjustment to incorporate adjusted cost of Bldg. B.

                     

Column G

Construction

Represents current estimate for Building B.

                     

The JCM Group

Project: Venoco Piping

Program Management

200 South Elm Drive

Beverly Hills,CA 90212

Budgeted, Commited, Forecasted Cost Report

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

LAW Crandall

$-

$15,000.00

$(15,000.00)

$15,000.00

   

$-

$-

 

$-

0%

   

Advance

$-

$45,000.00

$(45,000.00)

$45,000.00

   

$-

$-

 

$-

0%

   
 

$-

$-

$-

$-

   

$-

$-

 

$-

0%

   

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

0%

                           

Total

$-

$60,000.00

$(60,000.00)

$60,000.00

$-

$-

$-

$-

$-

$-

     

The JCM Group

School Site:Peters Aud.

Program Management

CM: CCG, Inc.

200 South Elm Drive

Contractor: Tutor-Saliba

Beverly Hills,CA 90212

Budgeted, Committed, Forecasted Cost Report

Architect: OA

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

Owner Costs

$-

$-

$-

     

$-

$-

 

$-

0%

   

Soft Costs

$-

$313,974.18

$313,974.18

$244,567.45

$13,083.34

$56,323.39

 

$-

 

$-

0%

   

F,F & E

$-

$-

$-

$-

   

$-

$-

 

$-

0%

   

Construction

$-

$1,786,966.83

$1,786,966.83

$1,092,899.53

$130,833.40

$563,233.90

$-

$-

$-

0%

Total

$-

$2,100,941.01

$2,100,941.01

$1,337,466.98

$143,916.74

$619,557.29

$-

$-

$-

$-

     
                           
                           

Column D

Soft Costs

Represents architects original 10% fee ($109,289.95), structural engineer's fee ($15,277) and estimated CM&PM fees ($120,000).

                     

Column E

Soft Costs

Architects approx. fee on C.O. work at estimated 10%. To be verified for merit.

                     

Column F

Soft Costs

Architects approx. fee on C.O.R. work at estimated 10%. To be verified for merit.

                     

Column G

Soft Costs

Missing legal fees for contract separation.

                     

Final reconciliation of original contract vs. C.O.'s in underway.

The JCM Group

Project: Admin. Recap.

Program Management

200 South Elm Drive

Beverly Hills,CA 90212

Budgeted, Commited, Forecasted Cost Report

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

Owner Costs

$960,000.00

$5,143,557.00

$4,183,557.00

$5,143,557.00

   

$-

$-

 

$5,143,557.00

0%

   
 

$-

$-

$-

$-

   

$-

$-

 

$-

0%

   
 

$-

$-

$-

$-

   

$-

$-

 

$-

0%

   

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

0%

                           

Total

$960,000.00

$5,143,557.00

$4,183,557.00

$5,143,557.00

$-

$-

$-

$-

$-

$5,143,557.00

     

The JCM Group

Project: M&O Fire

Program Management

200 South Elm Drive

Beverly Hills,CA 90212

Budgeted, Commited, Forecasted Cost Report

                           
                           
 

Budget

   

Commitments

 

Forecasted

     

% Complete

     
                           

A

B

C

D

E

F

G

H

I

J

K

Original Budget

Current Projection D+E+F+G=B

Variance (B-A= C)

Contracts & PO's

Approved CO's

Pending COR's

Remaining to Complete

Projected Total

Projected Variance

Paid/App. Invoices

% Complete (I/H)

Johnson/Leif

$-

$-

$-

$-

   

$-

$-

 

$600.00

0%

   

Curtis Driver

$-

$3,000.00

$(3,000.00)

$3,000.00

   

$-

$-

 

$-

0%

   

JA Jones

$-

$10,252.00

$(10,252.00)

$10,252.00

   

$-

$-

 

$-

0%

   

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

0%

                           

Total

$-

$13,252.00

$(13,252.00)

$13,252.00

$-

$-

$-

$-

$-

$600.00

     

 

Home ] Up ] Brief Summary ] Nov 27 Statement ] Copy of Measure K ] Staff memo re Surplus ] GL Feb. 2000 spreadsheet ] Second staff memo re surplus ] Staff memo re small deficit ] Official cost estimates ] Original $77 million budget ] Bond advisor report ] Propoganda ] Official permit data ] [ JCM Spreadsheet ] Porkmap spreadsheet ]