117 X V fx =H10 2. Given the following information, determine beverage cost in each of the three bars: (12 MARKS) Please fill in all highlighted cells + Storeroom Inventory Data Bar Data Opening Purchases Closing Inventory Inventory Opening Inventory Closing Inventory Sales Art's $5,000 $8,000 $7,000 Art's $1,000 $1,000 5 20,000.00 1: Chez Pierr $8,325 $10,666 $9,327 Chez Pierre $2,325 $2,050 $ 41,412 50 R Carol's $4,872 $7,454 $3,856 Carol's $1,867 $1,988 $ 29,817.85 Art's Chez Pierre Carol's Storeroom: Art's Chez Pierre Carol's ening Inventory (HEADING $5,000 $8,325 $4,872 Bar Information: ening Inventory(HEADING $1,000 $2,325 $1,867 Cost of Beverage Sales: (2 MARKS) (1 MARK) (1 MARK) (1 MARK) (1 MARK) (1 MARK) (1 MARK) (1 MARK] Beverage Cost % (1 MARK) (1 MARK) (1 MARK) TOTAL 12 MARKS NAME