Laserfiche WebLink
Item Selected:801-11642 Item Desc: Contract No:40600 <br />Contract:B 40600 # of Des:7 Awarded: Work Type: <br />Dist:L County: Award $: <br /> Advanced: Forecasting and Predicting the Price of Specific Quantity (using Same Selected Ranges, without slicers or manual filters) <br />1) Click On :2) Select Yes:3) One Unit only: <br />4) Enter quantity 1000 <br />Out of Limit Selected Ranges or filters don't match, Check manual filters/optional slicers or Refresh <br />5) Enter Range:50% <br />6) Resize Chart <br />Unit Price <br />Higher Estimate $299.20 <br />Middle Estimate $18.05 <br />Lower Estimate ($263.10) <br />Optional : Enter Graph Limit to plot the data for quantity: <br />25%Below, or 750 <br />25%Above, or 1250 <br /> Comments: <br />Name: <br />Date: <br />New item in <br />contract <br />$10,924,942.00 <br />Portable Changeable Message Sign <br />$18,050.00 <br />Total Amount: <br />12/09/2021 <br />St. Joseph <br />Bridge Replacement <br />Prime Contractor: Superior Construction Co Inc <br /> (1 < q < 2) <br />Optional: Dist <br />C F G <br />L S V <br />Optional: Letting Year <br />2023 2022 2021 2020 <br />2019 2018 2017 <br />Optional: Pre <br />B R T <br />Unit (Must show one only) <br />EACH <br />Unit <br />DAY EACH HRS <br />$76 <br />$81 <br />$86 <br />$91 <br />$96 <br />$101 <br />37.5 42.5 47.5 52.5 57.5 62.5 <br />Selected Ite... <br />$3,930.85 $4,272.35 $4,517.40 $4,825.16 $5,132.92 <br />$5,719.46 <br />95% Limit New Price -25% Range Average +25% Range 95% Limit <br />*3) Optional : % of Price Range to be included (Default 50%): <br />50.0%(or: +/- 25% from average) <br />from: to: <br />$4,517.40 < 50% Range < $5,132.92 <br />$3,930.85 < 95% Confid. < $5,719.46 <br />(95% or +/- 47.5 % from average) <br />*4) New Price: <br />$4,272.35 <br />Item # :801-11642 <br />At -38.7% from average (within <br />95% range) <br />Unit: EACH <br />N:34 <br />Min:$1,872.00 <br />Max:$14,285.00 <br />Straight Av.: $4,867.26 <br />Weighted Av.:$4,825.16 <br />Median $3,915.00 <br />Std Dev. $2,660.58