Qisahn Support Technical Questions

For all answers on Google Sheets, please share access with admin@qisahn.com.

Very often, we need to compare prices. You are given 2 price lists, one from Supplier A, another from Supplier B:
Supplier A Pricelist
Supplier B Pricelist

Task:
Use Google Sheets to semi-automate the process of determining which supplier is cheaper, for which game.
Please create 3 tabs:

1. This is tab is what you will be marked on. I'll like to see an efficient way to compare the prices.
2. Supplier A. Supplier's A price list will be pasted here.
3. Supplier B. Supplier's B price list will be pasted here.

We sell both Pre-owned and Brand New Games. You have been tasked to review PlayStation 5 Pre-owned Games' prices. You are given our PlayStation Stock List.
Selling price = Column D
Buyback price = Column E

Here are our hard rules for pricing of preowned games:

1. Pre-owned games should be at least $10 cheaper than brand new games, unless the new game is less than $19.90.
2. Pre-owned games need to have profit of at least $5
3. Pre-owned games's maximum profit is that of the buy back price, unless it's less than $5.

For example, if a preowned game is purchased for $20, it must priced at $25 to $40.

Task:
Design a Google Sheet that will highlight preowned prices that are in violation of the pricing rules.
To use this Google Sheet, I will paste the Playstation Stock list into your Sheet, and your Sheet will instantly highlight preowned prices that are in violation of the pricing rules.