Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
i just need the cost estimate question answered, using the high low method. I cant figure it out..
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) i attatched my spreadsheet with all of the numbers needed to answer!
ps. dont pay attention to the random 245, there is only supposed to be the one on the top row.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started