How accurate was your alcohol calculator

Time to buy alcohol soon. I held a stock the bar raffle for the reception at my bridal shower. People who wanted to participate in the raffle (the prizes were really nice) brought a bottle of Sangria and almost everyone brought wine. I received a total of 22 bottles of wine and 2 4L jugs.


It was a huge help but now I need to buy what im missing. Im wondering how accurate was your calculations when using alcohol calculators. What types of drinks did you have leftover?
Im expecting 200ppl 6hr reception We are serving Sangria, Pinot Grigio, beer, 2 flavors of margaritas, sodas and during dinner we are having mexican Agua fresca drinks (Horchata and Jamaica).
The alcohol calculator says 50 bottles of red wine30 bottles of white wine25 bottles of liquor 225 Cans of sodas
Im planning to buy 2 kegs of beer. Mostly the men are the beer drinkers. And for margaritas I have enough alcohol for 5 or 6 batches of margaritas (I read that 1 batch is good for 50ppl)
Im wondering if I can get away with adjusting the numbers so I buy a little less wine because of the margaritas and a little less soda because of the agua fresca drinks.