Drinks for your 30th birthday: How much should you buy?

30th birthday
Type
Per person
In total
Champagne
Welcome drink
1 glass
8 bottles
White wine
Appetizer
2 glasses
16 bottles
Red wine
Main course
3 glasses
21 bottles
Cognac/Liqueur
4 shots (4 cl)
10 bottles (70 cl)
Dessert wine
Dessert
1 glass
8 bottles
Ready-to-drink
Ready-to-drink
2 cans
4 frames
Beer
4 cans
7 frames
Soda
2 cans
4 frames