2 This problem is based on data from the Red White & Blues Bar. The problem has two parts: a and b. a. Please calculate the beverage cost percentage for the Red White & Blues Bar based on the data presented below. Please fill in the blanks in the tables below. Please do not type dollar ($) characters. For the beverage cost percentage below use the following format: XX.X (please round off to one digit). Please do not type the percentage (%) sign. Just numbers. Date Item To bar ($) From bar ($) 5/1 Lemons 5/3 Cream 5/10 Lemons 5/10 Cream 5/11 Wine 5/17 Sherry 20 10 8 12 45 35 5/20 Wine 40 5/23 Brandy 32 5/29 Lemons 10 TOTAL Category Beginning inventory Beverage purchases Amount ($) 3,215 7,851 Beverage available for sale Closing inventory 4,090 Cost of beverage 6,886 consumed Beverage sales Mixers Cooking liquor Promotions Beverage cost ($) Beverage cost percentage 35,120 210 170 230 (%) b. Please complete the blanks in the following table, considering that (1) the bar had the goal of not exceeding 22% in beverage cost percentage (2) a variance of 0.4% in beverage cost percentage is acceptable For the maximum acceptable beverage cost percentage use the following format: XX.X (please round off to one digit). Please do not type the percentage (%) sign. Just numbers Did the manager do a good job in controlling the beverage costs? Yes or No? What would be the maximum acceptable beverage cost percentage in this case