Item 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. Do not type any units of measurement (for example dollar ($) or percentage (%)). Numbers only. If you obtain a negative number, please use the "-" character (such as -X.XX). 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 To bar ($) From bar ($) 5/1 Lemons 20 5/3 Cream 12 5/10 Lemons 12 5/10 Cream 7 5/11 Wine 44 5/17 Sherry 5/20 Wine 51 5/23 Brandy 20 5/29 Lemons 41 9 TOTAL Amount ($) 4,320 9,360 13,680 Category Beginning inventory Beverage purchases Beverage available for sale Closing inventory Cost of beverage consumed Beverage sales Mixers Cooking liquor 4,005 9,675 48,995 417 351 Click Save and Submit to save and submit. Click Save All Answers to save all answers. PAFSA on th. Bank Mobile Add Payment Amount ($) 4,320 9,360 13,680 Category Beginning inventory Beverage purchases Beverage available for sale Closing inventory Cost of beverage consumed Beverage sales Mixers Cooking liquor Promotions 4,005 9,675 48,995 417 351 288 Beverage cost ($) 9,675 Beverage cost percentage (%) b. Please complete the blanks in the following table, considering that (1) the bar had the goal of not exceeding 21% in beverage cost percentage (2) a variance of 0.5% 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 like in Excel). 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? Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answers Clos