You need to design for your worst-case. This involves checking your boundary conditions: high tide and low tide. You need to make sure that your flow can pass through the culvert without flooding at high tide, but you may get a higher flow rate at low tide when you have a lower tailwater elevation.
The PM may be right that you don't need a HEC-RAS, but you will need some kind of modeling. Ask your PM what he/she suggests. If they say you can do these calculations in your head, use whatever software you're most comfortable with.
You should be able to account for the tides with tailwater elevation set to the high/low tide mark. I'm not sure how this would affect your flow rate/velocity upstream of the culvert, however, and you may indeed want to use HEC-RAS with ineffective flow areas specified below the high/low water elevation.