Please assist Jim to calculate his beverage cost % in November based on below information extracted...

 

Transcribed Image Text:

Please assist Jim to calculate his beverage cost % in November based on below information extracted from his operation records. Total Sales: $135,367 - Food Sales: $100,000 Employee Meal: $2,500 Inventory Record Beverage Only October December Purchasing Record Items Sparkling Wine Olives House Whisky Pork Chop Lemon Vodka Ribs Red Wine Coffee Date 28/10 31/10 02/11 07/11 15/11 23/11 28/11 02/12 03/12 Transfer Record Date Item 01/11 Lemons 05/11 Coffee Cream 11/11 Chablis Ice Cream Apple 13/11 Juice Sherry 18/11 Celery 23/11 Olives 26/11 Brandy Beginning Inventory $25,535 $24,335 10 qt. 5 gal. 3 gal. 5 gal. 3 gal. 5 kg. 5 kg. 5 btl. Spec# 085 Quantity Unit Cost 200 pcs $5.00 60 lb. $25.00 $15.00 $90.00 $26.65 025 088 033 048 091 031 095 077 $19.00 $82.60 $8.60 $12.50 $60.00 Unit btl. Box btl. Kg Box Case Ending Inventory $28,681 $25,855 Kg btl. Bag ✓ ✓ ✓ ✓ ✓ Qty 3 ✓ | || 50 1 1 20 To Bar From Bar Issued By Received By ✓ T.A. B.P. T.A. B.P. T.A. B.P. B.P. T.A. T.A. B.P. 5 3 Unit Price $170 T.A. B.P. T.A. T.A. B.P. $250 $95 $85 $150 $550 $135 $88 $130 B.P. T.A. B.P. B.P. T.A. Please assist Jim to calculate his beverage cost % in November based on below information extracted from his operation records. Total Sales: $135,367 - Food Sales: $100,000 Employee Meal: $2,500 Inventory Record Beverage Only October December Purchasing Record Items Sparkling Wine Olives House Whisky Pork Chop Lemon Vodka Ribs Red Wine Coffee Date 28/10 31/10 02/11 07/11 15/11 23/11 28/11 02/12 03/12 Transfer Record Date Item 01/11 Lemons 05/11 Coffee Cream 11/11 Chablis Ice Cream Apple 13/11 Juice Sherry 18/11 Celery 23/11 Olives 26/11 Brandy Beginning Inventory $25,535 $24,335 10 qt. 5 gal. 3 gal. 5 gal. 3 gal. 5 kg. 5 kg. 5 btl. Spec# 085 Quantity Unit Cost 200 pcs $5.00 60 lb. $25.00 $15.00 $90.00 $26.65 025 088 033 048 091 031 095 077 $19.00 $82.60 $8.60 $12.50 $60.00 Unit btl. Box btl. Kg Box Case Ending Inventory $28,681 $25,855 Kg btl. Bag ✓ ✓ ✓ ✓ ✓ Qty 3 ✓ | || 50 1 1 20 To Bar From Bar Issued By Received By ✓ T.A. B.P. T.A. B.P. T.A. B.P. B.P. T.A. T.A. B.P. 5 3 Unit Price $170 T.A. B.P. T.A. T.A. B.P. $250 $95 $85 $150 $550 $135 $88 $130 B.P. T.A. B.P. B.P. T.A.

Answer rating: 100% (QA)

To calculate the beverage cost for November we need to determine the cost of the beverage sold durin... View the full answer