Top part of the spreadsheet. B C D F G H K Cheese, M N Cheddar,

B C D F G H K Cheese, M N Cheddar, Shred OZ 10 # CS S 47.55 4.75 100% S 0.28 S 0.28 2 Cases $95.10 Coney Sauce fl oz 10# S 52.00 0.33 75% 0.58 S 0.58 8 Cases $ 416.00 9 Onions OZ 50# $ 26.00 0.52 70% S 0.06 $ 0.06 2 Cases $ 52.00 1 case = 4 10 Mustard fl oz gallons S 37.00 9.25 100% $ 0.07 S 0.07 1 Case $ 37.00 11 $843 End of the month inventory 12 13 Inventory value as of May 31, 2019 $600 14 15 Food Cost Report June 30th 16 Opening Inventory $ 600.00 17 Purchases $ 7,500.00 18 Transfers in $ 100.00 19 Closing inventory $ 843.00 20 Transfers out 100.00 21 Employee Meals S 200.00 22 Promos S 300.00 also added to marketing and promo on income statement 23 Cost of sales (Cogs) + 24 25 26 27 28 Profit and Los … + : Instructions Inventory Recipe Costs * Menu Analysis-Eng June recap Ready To Accessibility: Investigate.

Help x Jx A B C D E F G H Z-Dogs (Famous Hot Dogs) K L M N 0 P Q N 3 Note: Extended unit cost is only different than Ep/cost if Recipe EP is higher than one. Example 2 oz instead of oz. Recipe Converte Ingredienty or Purchase Inventor Inventor d AP/ Extended 4 nts Unit y On y Value Unit AP/Cost Cost % Yield Ep/Cost Unit Cost hand June 30th 10# CS at 4- Hot Dogs per 5 Hot Dogs each 1-1b S 32.00 $0.80 100% 0.80 $ 0.80 4 cases $128 1 case = 4 bags of 8 Hot Dog ea hot dog 6 Buns each buns S 23.00 0.719 100% $ 0.72 $ 0.72 5 cases $ 115.00 Cheese, Cheddar, 7 Shred Oz 10 # CS S 47.55 4.75 100% $ 0.28 $ 0.28 2 Cases $95.10 Coney 8 Sauce fl oz 10# S 52.00 0.33 75% $ 0.58 $ 0.58 8 Cases $ 416.00 a Onions 50# S 26.00 0.52 70% 5 0.06 $ 0.06 2 Cases $ 52.00 OZ 1 case =4 S 37.00 9.25 0.07 1 Case 10 Mustard fl oz 100% 0.07 $ 37.00 gallons $843 End of the month inventory 11 12 + 13 Inventory value as of May 31, 2019 $600 14