Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

? asked in Business & FinancePersonal Finance · 2 weeks ago

How would I approach this problem using spreadsheet software? I typically use Excel.?

Say dealership A and B both sell a car for $20,600. Each will lower the cost of said car until the other is forced to stop selling the car. At the end of each day, dealership B’s policy will lower the cost of the car by 1% of dealership A end of day cost. Dealership A will lower their cost by $50. Of dealership B’s end of day cost.

I thought of using the forecast function but not sure how I would know the exact day which company would be forced to stop selling and what the final cost of each dealership would be.

1 Answer

Relevance
  • 2 weeks ago

    3 columns:  Date, Dealer A Price, Dealer B Price.

    Dealer A Price = prior day Dealer B Price * 99%

    Dealer B Price = prior day Dealer A Price - $50

    Populate the date column and drag the two cells down as far as you want to go.  The prices will be accurate based on your guidelines.

    Also note, they are lowering their selling price not their cost. They don't control the cost of their merchandise.

Still have questions? Get your answers by asking now.