Answered step by step
Verified Expert Solution
Link Copied!

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..
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.
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial & Managerial Accounting, The Financial Chapters

Authors: Tracie Miller Nobles, Brenda Mattison

7th Edition

0136505279, 9780136505273

More Books

Students also viewed these Accounting questions

Question

Describe the factors influencing of performance appraisal.

Answered: 1 week ago