SCD Training Bulletin

1
SCD Training Bulletin 225 March 2005

• Cost Benefit Analysis (CBA) Cost Structure
  Worksheet (CSW) Supplement

2
Common CSW Mistakes

• Dollar entries are required (by the embedded CSW
  note) to be made in "thousands" of dollars.
  Users often mistakenly make their entries in
  millions of dollars
• Dollar totals for each fiscal year in Section I
  (Investment Section) must match dollar totals in
  each fiscal year of Section II (Appropriation
  Section)
• In many cases, the totals do not match,
  generating an error message.
• Users ignore the error message that is alerting
  them that something is incorrect in the CSW
• Sections I II (Investment Section and
  Appropriation Section respectively)
• Section cumulative totals must match between
  sections. Often they do not, and users ignore
  the error message that this generates
• Appropriations Section requires Submitters to
  enter the Appropriation, Budget Line Item, and
  Program Element Number and to identify the Major
  Claimant from a drop-down menu.
• Often the users simply do not provide all of the
  required entries. This is all "mandatory"
  information
• In Section IV (Fielding Plan), the TPU (Total
  Production Units) do not match the sum of the
  number of units installed on the ship(s) and the
  number of units installed ashore
• They must match, or an error message appears.
  Users will often ignore the error message rather
  than correcting the mismatch

3
Where do I get cost data?

• Program Office Business and Financial Manager
  (BFM)
• Command BFM or Comptroller
• Independent Cost Estimate (ICE) or Life-Cycle
  Cost Estimate (LCCE)
• Program Ship Changes
• In-Service Engineering Agent (ISEA)
• NSWC PHD, NSWC KPT, NUWC NPT, NSWCDD, NAVSSES
  PHIL
• Fleet Ship Changes
• TMA/TMI/TSP CWP/ERM CIL (SEA O5N)
• Regional Maintenance Center (RMC) Division/Branch
  Heads
• Fleet Technical Support Leads
• Port Engineers

Cost Data in Phase I is expected to be rough
order of magnitude in nature
4
The following example CSW is completed correctly
for a fictional Fleet Ship Change.
Note On some monitors, the test in the CSW may
not be clear. A recommended setting using the
Control Panel/Display/Settings feature is 1280 by
1024 resolution with 32 Bit True Color. Actual
settings may vary by computer or monitor.
5
Submitter or Initiator Enters data in these color
coded cells if no entries or cells are not
applicable check the box to input Null Values

• Appropriation Types include
• Operations and Maintenance (OM)
• Other Procurement (OPN)
• RDTE (Research, Development, Test and
  Evaluation)
• Others as required (SCN, WPN)

Subtotal of 260K dollars (note entries are in
THOUSANDS not MILLIONS of DOLLARS)
Note matching Amounts In Section I and II
CAUTION If an error message appears when data is
entered, DO NOT ignore the message or attempt to
save the worksheet. Correct the error, otherwise,
the SCD will be rejected by the Cost Review Team,
thus requiring rework. This Section has been
completed indicates that the information entry
is complete.
In this example Fleet Ship Change, 1B4B funding
is placed in the Budget Line Item row close
coordination with your commands business and
financial manager or comptroller will ensure that
the correct budget line and program element is
listed
6
Data Entry is always in Then Year Dollars which
are adjusted (escalated) for inflation. The FMP
Website has a tutorial on building the program
budget . Inflation Factors for calculations are
listed under the SCD Related Documents menu.
www.fmp.navy.mil
Totals in Section I and Section II should match.
Check the sheet before saving.
To Complete means funding required beyond the
Modernization Plan or FYDP. It is expressed in
Constant Year (not adjusted for inflation)
dollars (in thousands).
CAUTION If an error message appears when data is
entered, DO NOT ignore the message or attempt to
save the worksheet. Correct the error, otherwise,
the SCD will be rejected by the Cost Review Team,
thus requiring rework. This Section has been
completed indicates that the information entry
is complete.
7
For ship changes that have a projected savings or
cost avoidance, enter the data in THOUSANDS of
dollars in this section. As an example, a Top
Management Attention (TMA) ship change might have
an annual projected OS Savings that would be
delineated across the FYDP/Modernization Plan for
each FY of the expected service life of the
change or platform. Note this section is used
along with the Investment costs entered in
Section I to automatically calculate the Return
on Investment (ROI) and Payback Period.
Always select this box if there will be Null or
Zero Values in any cell
Column and row totals must be consistent. If
shore installations are required and/or spares
for training etc. are required, ensure those are
accounted in Section IV. In this example case,
there are 6 hulls affected, with a 2, 2, 2
installation profile.
When the Initiator or Submitter selects a ship
class, or hull or set of hulls from a ship
class(es), this information is automatically
entered in this section. An entry is required for
EVERY hull or shore site.
8
For Additional Information, Please visit the FMP
Website and Select the SHIPMAN Related
Information Button Most Recent Postings shows
information listed in the last 30 days