Question 1
A company's five sales representatives each recorded distinct monthly sales. Use the clues to analyze:
- Ira sold more units than Vihaan.
- The highest sale was in Jun.
- Nihal sold fewer units than Cyrus.
Question: Who recorded the highest sales?
Spreadsheet Reasoning
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Ira | Jan | 200
Vihaan | Jun | 253
Nihal | Feb | 227
Cyrus | Jul | 243
Laksh | Nov | 219
Identify the maximum sales row to answer the query.
Verification:
- Ira sold more units than Vihaan.
- The highest sale was in Jun.
- Nihal sold fewer units than Cyrus.
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Ira | Jan | 200
Vihaan | Jun | 253
Nihal | Feb | 227
Cyrus | Jul | 243
Laksh | Nov | 219
Identify the maximum sales row to answer the query.
Verification:
- Ira sold more units than Vihaan.
- The highest sale was in Jun.
- Nihal sold fewer units than Cyrus.