diy Bar help

Our wedding is July 11th, 2020 and our venue doesn't have liquor license but they do provide a bartender (included). We have the choice to either get alcohol from a caterer or we can bring in our own. We have decided to bring in our own since we know that it'll be cheaper. This is what we've decided:


Beer: Bud light, Budweiser, Miller Lite
Wine: One red and one white
Signature drinks: Vodka Cranberry and Rum and Coke
So, we have invited 200 guests but we obviously don't have a final count. My side of the family, with the exception of a few, will probably only have 1-2 glasses of wine. While my fiance's family and most of our friends will likely be drinking heavily. We set the ceremony for 3:00, meaning guests will probably be in the reception hall by 4:00 and we have to stop serving alcohol at 11pm.
Problem is, I can't find a drink calculator that allows you to break it down to a bar like ours 😭 has anyone had any experience with this? Or have any advice? I plan on getting a bottle rum and a bottle of vodka every other week with my paycheck for the next few months until I feel like I have enough, but I'd rather have too much of everything vs not enough.
Thanks to anyone who read through all of that 🤣