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

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 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.
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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!