Cost Estimating Worksheet for The Bungalow Project

This cost estimating worksheet provides parametric, analogous, and three-point estimates for The Bungalow project. It includes expected costs, equations, and weightings for each activity.

COST ESTIMATING WORKSHEET
Project Title:
The Bungalow
project
Date
Prepared: 15-08-2018
Parametric Estimates
A 18200 9100 2 18200
B 35100 11700 3 35100
C 25400 12700 2 25400
D 6800 6800 1 6800
E 10000 5000 2 10000
F 67000 13400 5 67000
G 15300 5100 3 15300
H 10200 5100 2 10200
J 30600 5100 6 30600
K 21900 10950 2 21900
L 15600 5200 3 15600
M 9600 4800 2 9600
N 4700 4700 1 4700
P 9800 4900 2 9800
Q 17100 8550 2 17100
R 15300 5100 3 15300
S 36600 9150 4 36600
T 27900 9300 3 27900
Analogous Estimates
WBS ID Previous
Activity
Previous
Cost
Current
Activity
Multiplier Cost
Estimate
A Clear ground $ 14,600.00 Clear ground 3 18200
B Lay foundation $ 18,000.00 Lay foundation 2 35100
C Build dwarf walls $ 9,800.00 Build dwarf walls 1 25400
D Oversite concete $ 5,600.00 Oversite concete 2 6800
E Floor joists $ 8,200.00 Floor joists 5 10000
F Main walls $ 28,000.00 Main walls 3 67000
G Door and Window
nad frame
$ 12,600.00 Door and Window
nad frame
2 15300
H Celing joists $ 8,400.00 Celing joists 6 10200
Page 1 of 1

J Roof timbers $ 25,200.00 Roof timbers 2 30600
K Tiles $ 10,800.00 Tiles 3 21900
L Floorboards $ 12,900.00 Floorboards 2 15600
M Celing boards $ 7,800.00 Celing boards 1 9600
N Skirtings $ 3,800.00 Skirtings 2 4700
P Glazing $ 8,000.00 Glazing 2 9800
Q Plastering $ 6,600.00 Plastering 3 17100
R Electrics $ 12,600.00 Electrics 4 15300
S Plumbing and
heating
$ 15,600.00 Plumbing and
heating
3 36600
T Painting $ 22,500.00 Painting 2 27900
Three Point Estimates
WBS ID Optimistic
Cost
Most Likely
Cost
Pessi
mistic
Weighting
Equation
Expected
Cost
A 27300 18200 14560 E=
(4Cm+C0+CP)/
19110
B 52650 35100 28080 E=
(4Cm+C0+CP)/
36855
C 38100 25400 20320 E=
(4Cm+C0+CP)/
26670
D 10200 6800 5440 E=
(4Cm+C0+CP)/
7140
E 15000 10000 8000 E=
(4Cm+C0+CP)/
10500
F 100500 67000 53600 E=
(4Cm+C0+CP)/
70350
G 22950 15300 12240 E=
(4Cm+C0+CP)/
16065
H 15300 10200 8160 E=
(4Cm+C0+CP)/
10710
J 45900 30600 24480 E=
(4Cm+C0+CP)/
32130
K 32850 21900 17520 E=
(4Cm+C0+CP)/
22995
L 23400 15600 12480 E=
(4Cm+C0+CP)/
16380
M 14400 9600 7680 E=
(4Cm+C0+CP)/
10080
N 7050 4700 3760 E=
(4Cm+C0+CP)/
4935
P 14700 9800 7840 E=
(4Cm+C0+CP)/
10290
Q 25650 17100 13680 E=
(4Cm+C0+CP)/
17955
R 22950 15300 12240 E=
(4Cm+C0+CP)/
16065
S 54900 36600 29280 E=
(4Cm+C0+CP)/
38430
T 41850 27900 22320 E=
(4Cm+C0+CP)/
29295
This template is sourced from Snyder, C. S. (2013). A project manager’s book of forms: A companion to the
PMBOK guide (2nd ed.). Indianapolis, IN: Wiley Publishing.
Page 1 of 1