Need to work out occupancy rates

Good afternoon

I need to work out the occupancy rates on the attached spreadsheet per location in column A

I have placed the locations and their occupancy in Cells B1 & B2, C1 & C2, D1 & D2

I need to work out the relevant occupancy rate whilst also filtering the locations.

Hope some one can help me.

Many Thanks