Sample SPAR Cost Model Cost Estimating Reports

Sample SPAR Cost ModelCost Estimating ReportsSample 150 Meter Offshore Patrol VesselSpecial Note: The sample reports contained in thispresentation do NOT necessarily apply to any actualship design, only to a fictitious design developed forthis presentation1

The SPAR Cost Model generates cost estimatesfor the following:1.Non-Recurring Design, ProductionEngineering & Detail Production Planning2.Lead Ship Construction3.Follow Ships ConstructionDetails of the estimates are generated atapproximately SWBS 3-digits levels.2

The cost model is very easy to use and offers many options to specify shipsystems and equipment. The cost model allows users to add and modifysystems, equipment and costing information to suit any special requirements.All cost for a particular cost estimate are generated for a specific base year.Labor rates are entered as input. Material costs are all catalogued by date ofentry into the model and automatically adjusted by commodity-basedescalation tables to produce material costs appropriate for the specified baseyear.While the cost model is based on standard U.S. labor and material costs, anoption is provided to specify foreign currency reports.Special factors may be defined to adjust costs for anticipated specificshipbuilding level of productivity and for estimated level of designproducibility.As the estimate evolves, the cost model automatically generates acomprehensive set of reports.3

LEAD SHIP1. Non-Recurring Design, ProductionEngineering & Detail Production Planning(“NRE”)2. Lead Ship Construction4

Summary “Should Cost” Estimate for Lead Ship & NRE5

NOTEThis notional ship estimate does not includecosts for advanced electronics andcommunications (C4) nor weapons systems.The user may add these costs as required to thecost model.6

Summary “Should Cost” Estimate for Lead Ship7

Time Distribution of Lead Ship Labor Hours8

Estimated Lead Ship Manpower Requirements9

Estimated Total Lead Ship Manpower Requirements10

Estimated NRE Manpower Requirements11

Estimating Potential Impact of Cost Risk Labor Hours12

Estimating Potential Impact of Cost Risk on Schedules13

Estimating Potential Impact of Cost Risk on Total Cost14

FOLLOW SHIPSThe cost model can be easily set to generate costs forjust a lead ship or a series of ship for a multi-shipconstruction program15

16

Estimated Follow Ship Production Schedules17

18

The Cost Model allows changes to follow ship productionschedule durations and their overlaps with prior ship schedules.19

The user can specify the expected labor learning from follow ship to followship (also estimated material cost discounts). The cost model automaticallyadjusts the labor learning according to the extent of follow ship overlappingschedules; the greater the overlap, the less expected learning potential.20

NRE, Lead Ship & Follow Ship Production Schedules (from Low RateProduction to High Rate Production options) with estimated manpowerrequirements are quickly and easily modeled by the user.21

Estimating Time-Lines for Total Costs22

Estimating Time-Lines for Total Costs23

Estimating Annual Costs24

The cost model will accommodate costs in nonU.S. currencies.While the material costs are based on U.S.material dollar costs, the cost model providesfactors for currency exchange rates as well as ageneral factor to increase/decrease materialcosts that more accurately reflect local costsversus those of the U.S.The labor hour and material cost data embeddedwithin the cost model can be easily modified andexpanded by the user.25

The cost models enable the estimator tovary ship design dimensional characteristics(linear, volumetric and area) , speed, typeand size of propulsion and electrical powersystems. Other variables include crew sizeand type, structural configuration, includingselections of type structural materials.The cost models further provide a widerange of selections for outfit and auxiliarysystems and equipment.26

The Excel cost models provide only summary SWBS Group-Level estimate reportsand many charts and tables. For more format reports, the data contents of the costmodel can be down-loaded into the PERCEPTION ESTI-MATE database system. Thefollowing slides illustrate only three of the many varieties of formats that areavailable in PERCEPTION. PERCEPTION also has features for customizing formats forspecific reporting requirements.PERCEPTION has many features for modifying/adding/deleting the estimate detailsfrom the cost model. New estimates can be easily copied and modified from earlierestimates residing on the database. PERCEPTION provides many powerful databasefeatures for storing and managing detail cost data in libraries that are capable ofgenerating cost estimates with or without using the cost models.EXCEL CostModelPERCEPTIONDatabase System Add/Change/Delete Cost Items Generate Summary & Detail Reports Develop & Management Cost Librariesfor Future Estimates Prepare Estimate Data for Transfer toProduction Requisitions & Work Orders Plan & Manage Production Costs andSchedules27

The cost model is a large comprehensiveExcel workbook containing the variousworksheets as listed in this slide. Alsoindicated are the number of individualcost line items arranged in worksheetscorresponding to SWBS Groups. Theseline items are mostly parametric andutilize many different metrics such aspower (kW), linear dimensions, surfaceareas, volumes, crew size, etc.28

Cost Item Detail Value Report: A Selection of Estimated Structural Costs29

SWBS Account Summary Report: A Selection of Estimated Structural Costs30

Bid Format Report: A Selection of SWBS Estimated Structural Costs(Shipyard’s Own Logo Can be Defined for the Report)31

Over 40 Years Serving the Shipbuilding &Repair Industry32

Estimating Time-Lines for Total Costs . 23 Estimating Time-Lines for Total Costs . 24 Estimating Annual Costs . 25 The cost model will accommodate costs in non- . worksheets as listed in this slide. Also indicated are the number of individual cost line items arranged in worksheets corresponding to SWBS Groups. These