Revenue by city doesn't add up

A colleague calculated revenue by city, but the total for the three cities is less than the overall revenue.

Find the mistake in the formulas in G2:G4 and fix them.