Reply-to: Geoffrey Fox To: Therese Miller Subject: Core financials need in ERDC monthly Date: Mon, 22 Apr 2002 16:11:35 -0500 From: Geoffrey Fox Geoffrey Fox gcf@indiana.edu FAX 8128567972 Phones Cell 315-254-6387 Home 8123239196 Lab 8128567977 CS 8128553788 ------- Forwarded Message Date: Mon, 22 Apr 2002 14:56:53 -0500 From: "Mastin, Charles W ERDC-ITL-MS Contractor" To: "'Bharat Soni'" , "'Geoffrey Fox'" , "'Sue Brown'" , "'Tinsley Oden'" cc: "Bill Zilliox (E-mail)" , "George Heburn (E-mail)" Subject: More on Financial Slides This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. - ------_=_NextPart_001_01C1EA37.D9A03782 Content-Type: text/plain; charset="ISO-8859-1" Conponent 3 FAPOCs, The following is more information on the financial slides. Thanks go to Bill Zilliox, ASC CPOC, for these details. The template provided each of you contains several references to budget metrics. Slide 8 mentions "funding status" for each project, which is not very explicit. Slide 9 calls for budget metrics to be included under "Core Financial Summary". And Slide 14 defines the budget metrics to be reported (but does not indicate where). For Slide 8, do not include any budget metrics. For Funding Status, I recommend you state the projects total value (contract value) and the "period of performance" (contract start and stop dates). Feel free to include any other notes with regard to funding like delays in issuing the subcontract or funding modifications. If it is decided to include other "budget metrics" on each project chart, Zak or I will make the change. You do not need to provide Slide 9; Zak or I will decide on the format and create those slides. What I will need from each of you however is the data described on Slide 14 for your FA: 1) Actual amount invoiced by CLIN - no need to supply this data, I will obtain it from MSU. 2) Actual $ vs. Planned $ - please supply a monthly expense total for each project and for your FA core support from the start date through March 2002. You may use estimated expenditures as you do in the monthly project reports. Planned expenditures may be the total core/project budget amount divided by the number of months unless you wish to denote some other spend plan. Recall that many on-sites were convered by PET I funds through September 2001. 3) Projected Actual $ vs. Planned $ - please supply a monthly expense total for each project and for your FA core support from April 2002 through the end date of the task. For core it will be 31 May 2002, for projects it will be 30 September 2002. The total expenditures in 2) and 3) may not exceed the budget or contract amount. If you intend to forecast an under-run, an explanation for the variance should be provided. The remaining budget metrics sub-items described on Slide 14 can be calculated from the above. So to summarize, you need to provide by COB this Friday (the 26th), a table of actual monthly expense and forecasted expense for core support and for each project in your FA. No charts or graphs! This is in addition to the rough draft slides for your FA presentation. After we decide how these budget data will be presented and the slides are prepared for each FA, you will be provided a copy before it is submitted to HPCMO on 7 May. I hope this is clear and saves you some time. Please contact me if there are any questions. ____________________________ Wayne Mastin, CEERD-IH-C 3909 Halls Ferry Road, TL-112 Vicksburg, MS 39180 Phone: (601) 634-3063 FAX: (601) 634-3808 Email: Charles.W.Mastin@erdc.usace.army.mil - ------_=_NextPart_001_01C1EA37.D9A03782 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable More on Financial Slides

Conponent 3 FAPOCs,

The following is more = information on the financial slides.  Thanks go to Bill
Zilliox, ASC CPOC, for these = details.

The template provided each of = you contains several references to budget metrics. Slide 8 mentions = "funding status" for each project, which is not very = explicit. Slide 9 calls for budget metrics to be included under = "Core Financial Summary". And Slide 14 defines the budget = metrics to be reported (but does not indicate where).

 
For Slide 8, do not include any = budget metrics. For Funding Status, I recommend you state the projects = total value (contract value) and the "period of performance" = (contract start and stop dates). Feel free to include any other notes = with regard to funding like delays in issuing the subcontract or = funding modifications. If it is decided to include other "budget = metrics" on each project chart, Zak or I will make the = change.

 
You do not need to provide = Slide 9; Zak or I will decide on the format and create those = slides.
 
What I will need from each of = you however is the data described on Slide 14 for your FA:
 
        1) Actual amount = invoiced by CLIN - no need to supply this data, I will obtain it from = MSU.
        2) Actual $ vs. Planned = $ - please supply a monthly expense total for each project and for your = FA core support from the start date through March 2002. You may use = estimated expenditures as you do in the monthly project reports. = Planned expenditures may be the total core/project budget amount = divided by the number of months unless you wish to denote some other = spend plan.  Recall that many on-sites were convered by PET I = funds through September 2001.

        3) Projected Actual $ = vs. Planned $ - please supply a monthly expense total for each project = and for your FA core support from April 2002 through the end date of = the task. For core it will be 31 May 2002, for projects it will be 30 = September 2002. The total expenditures in 2) and 3) may not exceed the = budget or contract amount. If you intend to forecast an under-run, an = explanation for the variance should be provided.

 
The remaining budget metrics = sub-items described on Slide 14 can be calculated from the = above.
 
So to summarize, you need to = provide by COB this Friday (the 26th), a table of actual monthly = expense and forecasted expense for core support and for each project in = your FA. No charts or graphs! This is in addition to the rough draft = slides for your FA presentation.

 
After we decide how these = budget data will be presented and the slides are prepared for each FA, = you will be provided a copy before it is submitted to HPCMO on 7 May.

 
I hope this is clear and saves = you some time.
 
Please contact me if there are = any questions.
____________________________

Wayne Mastin, CEERD-IH-C
3909 Halls Ferry Road, = TL-112
Vicksburg, MS  = 39180
Phone:  (601) = 634-3063
FAX:  (601) = 634-3808
Email:  = Charles.W.Mastin@erdc.usace.army.mil



- ------_=_NextPart_001_01C1EA37.D9A03782-- ------- End of Forwarded Message