The hard but accurate way to figure out the effect of tariffs on your product line draws a page from ABC accounting. Examine each and every SKU. Apparently Home Depot has done this. The results should be a finer-grained snapshot of tariffs’ effect.
It should also supply information for decisions as the tariff situation changes in the short term, as it most certainly will. The article states that at a similar company, Lowe’s, tariffs cost it 40 basis points of gross margin. That’s a lot in a business where markups are not that large.