Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Here are the answers to A & B. Just need help figuring out C, the Slope and Intercept functions. COST FUNCTION? The city of Brownswood

Here are the answers to A & B. Just need help figuring out C, the Slope and Intercept functions. image text in transcribed
image text in transcribed
COST FUNCTION?
The city of Brownswood is trying to understand its road repair costs. As a starting point, Mark Winston, the city's finance manager, asked public works manager Rachel Morris to gather relevant data. Rachel provided Mark with a data set containing a list of completed pothole repair work orders and the related costs for a recent week. Mark has asked you to analyze this data set and provide some initial insights about the city's road repair costs. Click here to view the Excel dataset. (b) Your answer is correct Identify the high and low points. Low point 1 potholes. $ 245 repair cost High point 157 potholes, 5 14519 repair cost Am Using the high-low method to estimate the road repair cost function (Round answers to 2 decimal places, eg. 52.43.) Cost estimate = $ 153.50 +($ 91.50 * number of potholes repaired) eTextbook and Media Assistance Used Attempts: 2 of 3 used (c) Use the SLOPE and INTERCEPT functions in Excel to estimate the road repair cost function using regression (Round answers to 4 decimal places, eg. 52.4321.) Cost function = ($ x number of pothole repaired) + $ The city of Brownswood is trying to understand its road repair costs. As a starting point, Mark Winston, the city's finance manager, asked public works manager Rachel Morris to gather relevant data. Rachel provided Mark with a data set containing a list of completed pothole repair work orders and the related costs for a recent week. Mark has asked you to analyze this data set and provide some initial insights about the city's road repair costs. Click here to view the Excel dataset. (b) Your answer is correct Identify the high and low points. Low point 1 potholes. $ 245 repair cost High point 157 potholes, 5 14519 repair cost Am Using the high-low method to estimate the road repair cost function (Round answers to 2 decimal places, eg. 52.43.) Cost estimate = $ 153.50 +($ 91.50 * number of potholes repaired) eTextbook and Media Assistance Used Attempts: 2 of 3 used (c) Use the SLOPE and INTERCEPT functions in Excel to estimate the road repair cost function using regression (Round answers to 4 decimal places, eg. 52.4321.) Cost function = ($ x number of pothole 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

College Accounting Ch 1-12

Authors: Dansby

5th Edition

0763834955, 978-0763834951

More Books

Students also viewed these Accounting questions

Question

Do you set targets to reduce complaints?

Answered: 1 week ago