Wayfair Interview Question

the final round consists three cases. one using excel