The first tab focuses on Excel financial calculations and spreadsheet modeling. Candidates will see a table with product information including item descriptions, vendor costs, discounts, net costs, retail prices, profit, and gross margin percentages. The sheet also includes additional contextual data such as units sold and competitor pricing.
The tab presents two scenarios: a current scenario and a proposed pricing scenario, allowing candidates to compare how changes in retail pricing affect profitability and margins.