A 1 2 3 4 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
B
C 15% 15%
D
E Legend
F
G
H
I
J
K
L
M
N
O
P
Insert LCL % here: Insert UCL % here:
= Below LCL = Above UCL = Enter data under the row
This buton sorts this sheet and the Chart 1- 3 in ascending order of Govt U/P.
Proposed Est. U/P
CLINs Govt Est LCL UCL CLINs Govt Est Offr No. 1 Offr No. 2 Offr No. 3 Offr No. 4
Offerors' Est. U/P Price Rank
Offr No. 1 Offr No. 2 Offr No. 3 Offr No. 4
0001 0002 0003 0004 0005 0006 0007 0008 0009 0010 0011 0012 0013 0014 0015 0016 0017 0018 0019 0020 0021 0022 0023 0024 0025 0026 0027 0028 0029 0030 0031 0032 0033 0034 0035 0036 0037
$0.30 $0.33 $0.27 $0.32 $0.37 $0.40 $0.34 $0.37 $1.01 $1.05 $0.91 $0.95 $1.54 $1.59 $2.02 $2.12 $1.92 $2.00 $1.19 $0.34 $2.14 $6.00 $7.84 $11.82 $1,145.00 $160.00 $450.00 $650.00 $50.00 $0.09 $1.73 $1.73 $22.00 $11.00 $27.00 $50.00 $2.50
$0.26 $0.35 $0.28 $0.38 $0.23 $0.31 $0.27 $0.37 $0.31 $0.43 $0.34 $0.46 $0.29 $0.39 $0.31 $0.43 $0.86 $1.16 $0.89 $1.21 $0.77 $1.05 $0.81 $1.09 $1.31 $1.77 $1.35 $1.83 $1.72 $2.32 $1.80 $2.44 $1.63 $2.21 $1.70 $2.30 $1.01 $1.37 $0.29 $0.39 $1.82 $2.46 $5.10 $6.90 $6.66 $9.02 $10.05 $13.59 $973.25 $1,316.75 $136.00 $184.00 $382.50 $517.50 $552.50 $747.50 $42.50 $57.50 $0.08 $0.10 $1.47 $1.99 $1.47 $1.99 $18.70 $25.30 $9.35 $12.65 $22.95 $31.05 $42.50 $57.50 $2.13 $2.88
0001 0002 0003 0004 0005 0006 0007 0008 0009 0010 0011 0012 0013 0014 0015 0016 0017 0018 0019 0020 0021 0022 0023 0024 0025 0026 0027 0028 0029 0030 0031 0032 0033 0034 0035 0036 0037
$0.30 $0.33 $0.27 $0.32 $0.37 $0.40 $0.34 $0.37 $1.01 $1.05 $0.91 $0.95 $1.54 $1.59 $2.02 $2.12 $1.92 $2.00 $1.19 $0.34 $2.14 $6.00 $7.84 $11.82 $1,145.00 $160.00 $450.00 $650.00 $50.00 $0.09 $1.73 $1.73 $22.00 $11.00 $27.00 $50.00 $2.50
$0.58 $0.69 $0.18 $0.28 $0.22 $0.28 $0.18 $0.23 $0.51 $0.63 $0.58 $0.63 $0.58 $1.38 $1.73 $2.88 $1.27 $2.30 $2.53 $0.17 $0.23 $3.68 $5.98 $8.63 $230.00 $115.00 $517.50 $862.50 $23.00 $0.46 $3.45 $4.60 $2.88 $2.30 $40.56 $28.00 $1.73
$0.35 $0.36 $0.26 $0.35 $0.26 $0.34 $0.26 $0.35 $0.75 $0.80 $0.72 $0.80 $0.90 $0.95 $2.45 $2.50 $2.00 $2.50 $2.50 $0.40 $2.15 $2.00 $10.00 $15.00 $50.00 $160.00 $350.00 $625.00 $30.00 $0.26 $2.50 $2.50 $25.00 $28.00 $30.00 $50.00 $3.20
$0.73 $0.87 $0.22 $0.36 $0.29 $0.44 $0.29 $0.44 $0.36 $0.51 $0.36 $0.51 $0.73 $0.87 $0.87 $1.09 $0.96 $1.31 $1.81 $0.29 $0.73 $2.90 $5.80 $8.70 $145.00 $108.75 $217.47 $290.00 $29.00 $0.06 $4.35 $5.80 $3.63 $2.90 $50.75 $29.00 $2.18
$0.30 $0.31 $0.28 $0.30 $0.34 $0.35 $0.33 $0.34 $0.68 $0.70 $0.66 $0.67 $1.37 $1.38 $1.98 $2.01 $2.05 $2.07 $1.48 $0.35 $0.35 $2.95 $4.72 $7.08 $147.50 $147.50 $318.60 $637.20 $23.60 $0.09 $1.77 $1.77 $29.50 $25.96 $41.30 $64.90 $5.02
3 3 1 1 1 1 1 1 2 2 2 2 1 3 2 4 2 3 4 1 1 4 3 2 4 2 4 4 1 4 3 3 1 1 2 1 1
2 2 3 3 2 2 2 3 4 4 4 4 3 2 4 3 3 4 3 4 4 1 4 4 1 4 3 2 4 3 2 2 3 4 1 3 3
4 4 2 4 3 4 3 4 1 1 1 1 2 1 1 1 1 1 2 2 3 2 2 3 2 1 1 1 3 1 4 4 2 2 4 2 2
1 1 4 2 4 3 4 2 3 3 3 3 4 3 3 2 4 2 1 3 2 3 1 1 3 3 2 3 2 2 1 1 4 3 3 4 4
Comparative Analysis of Proposals for CLINs w/ Gov't Est Under $3 unit price
$1,400.00
$1,200.00
$1,000.00
$800.00
Govt Est
Offr #1
Offr #2 Offr #3
$600.00
Offr #4
$400.00
$200.00
$0.00
Comparative Analysis of Proposals for CLINs w/ Gov't Est of $5-30 unit price
$1,000.00
$900.00
$800.00
$700.00
$600.00
Govt Est Offr #1
$500.00
Offr #2 Offr #3
$400.00
Offr #4
$300.00
$200.00
$100.00
$0.00 0026 0027 0028 0029 0030 0031
Comparative Analysis of Proposals for CLINs w/ Gov't Est over $50 unit price
$70.00
$60.00
$50.00
$40.00
Govt Est Offr #1 Offr #2 Offr #3
$30.00
Offr #4
$20.00
$10.00
$0.00 0032 0033 0034 0035 0036 0037