Beverages for your confirmation: How much should you buy?

Confirmation
Type
Per person
Total
Champagne
Welcome Drink
1 glass
8 bottles
White Wine
Starter
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 cases
Soda
2 cans
4 cases