Excel Supplier Pricing Update

I need reliable help updating my product pricing sheet.

Here’s what the job involves:
• I already have links to four supplier websites. For each of my 180 product lines you’ll look up the current price from all four suppliers (that’s 720 price points in total) and record them in the correct columns of my existing Excel template.
• My sheet already holds the basic product data, but it does not yet calculate profit or tax. Please add two new columns—one for profit, one for tax—and write formulas that:
– multiply the supplier price by my quantity column,
– add the profit percentage I specify,
– apply the tax rate I provide,
– and return a final landed cost.

Accuracy is critical; I will cross-check a random sample against the supplier pages. All formulas must be clear and reference-based so I can adjust percentages later without rewriting anything.

Deliverable: the updated Excel file, fully populated with all prices and working formulas.

If you work confidently with Excel lookup and math functions and can keep meticulous records, let’s get started right away.