Question

t below given the followi Complete the abbreviated standard food cost percentage report belowo data. (Hint: Review Exhibit 7 and its discussion.) CM Food Cost% Item No. Sold © Revenue Food Cost 187.50 47.75 231.25 62.50 297.25 92.40 340.00 99.50 Problem 5 a. What is the beverage cost of a gin and tonic given the following? Gin-1 oz. (liter bottle price = $12.75) Tonic -4 oz. (32 oz. bottle = 1.70) Lime-1 slice (12 slices per lime; .45/lime) b. What is the drink cost percentage if the drink's selling price is $4.79.

Answer 1

HI,

Please find below answer.

If you like the answer, please up vote.

I have attached formula sheet as well.

HI Item a b No. Sold 25 37 $ $ Revenue | Food Cost 187.50 $ 47.75 231.25 $ 62.50 297.25 $ 92.40 340.00 $ 99.50 F CM $ 139.75 $ 168.75 $ 204.85 $ 240.50 G Food Cost % 25.47 27.03 31.08 29.26 d 40 $ 10 Answer A. What is the beverage cost of a gin and tonic 11 12 13 14 15 16 Bottle vol. in Oz per bottle Cost per ounce (oz) cost Gin(1 litre 33.814 5 12.755 0.377 Tonic 32 $ 1.70 $ 0.053 Lime(Slice 12 $ 0.45$ 0.038 per slice 17 18 19 Required Beverage Volume (Oz) Gin Tonic LimeSlice 20 Cost 1 $ 4 $ 1 $ 0.377 0.213 0.038 Total Cost $ 0.627 Answer B. $ Sale price Drink cost % 4.75 13.20

Please find attached formula sheet.

Item No. Sold Revenue Food Cost CM 25 b 37 187.5 231.25 297.25 340 47.75 62.5 92.4 99.5 =D3-E3 =D4-E4 =D5-E5 -D6-E6 Food Cost % =(E3/D3)*100 =(E4/D4)*100 =(E5/D5)*100 =(E6/D6)*100 41 40 Answer A. What is the beverage cost of a gin and tonic per ounce (oz) cost Bottle vol. in Oz 33.814 Gin(1 litre) Tonic LimeSlice) per bottle Cost 12.75 1.7 0.45 32 =E13/D13 =E14/D14 =E15/D15 per slice Required Beverage Volume (Oz) Gin Cost =D19*F13 =D20-F14 =D21-F15 Tonic Lime(Slice) Total Cost =SUM(E19:E21) Answer B. Sale price Drink cost % 4.75 =(E23/E25) 100