Question: i just need the cost estimate question answered, using the high low method. I cant figure it out.. i attatched my spreadsheet with all of

E F G activity 1 F total cost 245 157 14519 245 91.5 vc/unit fc lo fc hi 153.5 153.5 A B C D Repair Date Number of Potholes Filled Final cost February 24 22 $ 2,291.00 min February 25 2 $ 286.00 February 25 2 $ 283.00 max February 25 2 $ 691.00 February 25 2 $ 181.00 February 25 2 $ 254.00 February 25 2 $ 241.00 February 25 4 $ 299.00 February 25 4 $ 424.00 February 25 4 $ 865.00 February 25 4 $ 422.00 February 25 4 $ 497.00 February 25 5 $ 650.00 February 25 5 $ 910.00 February 25 5 $ 552.00 February 25 7 $ 842.00 February 25 7 $ 1,026.00 February 25 7 $ 626.00 February 25 7 $ 690.00 7 $ 514.00 February 25 8 $ 733.00 February 25 February 25 9 $ 941.00 February 25 9 $ 785.00 February 25 9 $ 942.00 February 25 10 $ 1,109.00 ? Identify the high and low points. Low point 1 potholes, $ 245 repair cost High point 157 potholes, $ 14519 repair cost Using the high-low method to estimate the road repair cost function. (Round answers to 2 decimal places, e.g. 52.43.) Cost estimate - $ +($ x number of potholes repaired)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
