For whatever reason, I’m having tough time getting MF and RV for MBs and BMWs from Google/Edmond this time around. I am doing the reverse calculation from MB and BMW corporate lease advertisements for each model but I so hope that we somehow automate the process to get this info for all cars and models every month.
Well the problem I’m trying to solve is being able to have all of this data in one table where we can then sort by high RV and low MF to identify best leasing opportunities for any given month. With market in terrible shape due to supply chain disruptions, it could help in quickly identifying which specific make/model to go after if you have to have a car.
Without considering MSRP, or pulling incentives? It could be a starting point, but more likely a huge time-sink.
I appreciate what you’re trying to do, but without a brands program sheet for this month (the bulletin the manufacturer sends F&I, for your region, for all relevant brands) or a desking tool, it’s like turning hamburger back into cow.
I am not at all in disagreement…I understand the complexities involved in obtaining a great deal. I oversimplified in stating what I was trying to do. Anyhow no worries! Thanks again for your prompt responses!