Page 245 - Industrial Process Plant Construction Estimating and Man Hour Analysis

Sample estimates Chapter 11 223

Project: Air-cooled condenser—fan inlet cowl and fan screens
Foreman: John Smith Date: 0000 June 00
Craft: Boilermaker

Cost code Phase code description MH Qty

Fan inlet cowl and fan screens
000000 Fan screen supports 2.00 12.00
000000 Fan screen modules 3.00 5.00
000000 Mount fan cowl segments and top ring 2.00 12.00
000000 Bolt connection 0.15 36.00
000000 Install fan deck plates 2.00 12.00

Graphic analysis of data
Use Excel’s chart capabilities to plot the graph for the simple moving average
forecast.
To use the Excel chart capabilities, highlight the range E42-D52, and select
Insert, Scatter Chart, Chart Elements, Axis, Axis Titles, Chart Title, Grid-
lines, Legend, Trendline, and More Options: Display equation on chart and
Display R-squared value on chart.

2
Quantity 50 y = –11.339x + 36.151… R = 0.9698 Series1
0
0 1 2 3 4 Linear (Series1)
Man hour Linear (Series1)
FIG. 11.3.1 Fan inlet cow and fan screens.

2
The coefficient of determination is R ¼ 0.9698, and the correlation coef-
ficient, R ¼ 0.9847, is a strong indication of correlation (Fig. 11.3.1). 98.4%
of the total variation on Y can be explained by the linear relationship between
X and Y (described by the regression equation, Y ¼ 11.339x + 36.151). The rela-
tionship between X and Y variables is such.
Man-hour table…fan inlet cowl and fan screens

Description MH Unit
Fan inlet cowl and fan screens
Fan screen supports 2.0 EA
Fan screen modules 3.0 EA
Mount fan cowl segments and top ring 2.0 EA
Bolt connection 0.15 EA
Install fan deck plates 2.0 EA