Gil Bloom is planning for the wedding of the mayor's daughter in his hotel. The reception, to be held in the grand ballroom, will be attended by 1000 people. From his sales histories of similar events, Gil knows that the average drinking habits of those attending receptions of this type are as follows:
25% select champagne
50% select white wine
25% select spirits
Assuming three drinks per person and a portion size of 3 ounces for champagne, 4 ounces for wine, and 1 ounce for spirits, how much of each product, in 750ml bottles, should Gil order? (Multiply fluid ounces by 29.57 to convert to milliliters.) Spreadsheet hint: Use the ROUNDUP function in the Total Bottles column to determine number of full bottles to order.
If you were Gil, would you order more than you think you would need?
Why or why not? If so, how much more would you order?