Drinks for your confirmation: How much drink should you buy?

Confirmation
Type
Per person
In total
Champagne
Welcome drink
1 glass
8 bottles
White wine
Appetizer
3 glasses
24 bottles
Red wine
Main course
5 glasses
34 bottles
Dessert wine
Dessert
1 glass
8 bottles
Cognac/Liqueur
1 shot (4 cl)
3 bottles (70 cl)
Beer
2 cans
4 frames
Soda
2 cans
4 frames