A car dealer specializing in late model used cars collected the following data on the selling price and mileage of five cars of the same
A car dealer specializing in late model used cars collected the following data on the selling price and mileage of five cars of the same make and model year at an auto auction:
Mileage Price
43,890 ..........$12,500
35,750 ..........$13,350
27,300 ..........$14,600
15,500 ..........$15,750
8,900 .........$17,500
Because there seems to be a strong relationship between mileage and price, the dealer wants to use this information to predict this type of car’s market value on the basis of its mileage. The dealer thinks that the car’s selling price can be predicted as:
Estimated price = A + B × mileage
A and B represent numeric constants (which might be positive or negative). Using the data collected at last week’s auction, the dealer wants to determine appropriate values for A and B that minimize the following quantity:
.png)
This objective seeks to find values of A and B that minimize the sum of the absolute value of the deviations between the actual prices of the cars and the estimated prices.
a. Create an LP model using deviational variables whose solution provides the best values for A and B using the stated criteria. That is, what values of A and B minimize the sum of the absolute deviations between the actual and estimated selling prices?
b. Implement your model in a spreadsheet and solve it.
c. Using the values of A and B determined by your solution, what should the estimated selling price be for eachcar?
MIN: IA + B 43890-125001 + IA + B 35750-133501 + IA + B 27300-14600| + IA + B 15500-157501 + IA + B 8900-175001
Step by Step Solution
3.40 Rating (172 Votes )
There are 3 Steps involved in it
a b Estimated Deviations Adjusted Actual Mileage Price Under Over Price Est Price 43890 1250... View full answer
Get step-by-step solutions from verified subject matter experts
100% Satisfaction Guaranteed-or Get a Refund!
Document Format (1 attachment)
167-B-M-L-M-D-A (260).xlsx
300 KBs Excel File
See step-by-step solutions with expert insights and AI powered tools for academic success
-
Access 30 Million+ textbook solutions.
-
Ask unlimited questions from AI Tutors.
-
Order free textbooks.
-
100% Satisfaction Guaranteed-or Get a Refund!
Claim Your Hoodie Now!
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
Authors: Cliff T. Ragsdale
8th Edition
130594741X, 978-1337517317, 1337517313, 978-1305947412
Study Smart with AI Flashcards
Access a vast library of flashcards, create your own, and experience a game-changing transformation in how you learn and retain knowledge
Explore Flashcards
Study Help
