9 101) Cakulate EP unit costs per ingredient. Next find total value of the inventory on hand for the end of the month of June. 11 2) Calculate cost of goods sold (sales) 12 31 Cost out each individual recipe costs using what you calculated for EP on the inventory page (134) Calculate food cost % for each recipe 14 5) Complete the Menu Analysis worksheet 15 6) Complete the profit and loss statement 16 7) Calculate the Prime Costs and Prime Cost Percent 17 8. Evaluation: Put this evaluation in a separate word document. 18 19 20 Before you begin one note on something you may not know. Marketing and promotions are handled carefully in food service.. 7 Initially you account for the full sale, but at the end of the accounting period you only value the cost of the sale in calculating COGS and then putting in as an expense in marketing and promotions on the income statement. I put notes in the project to direct you. 21 22 23 25 26 27 REDRER 12 1. Did your company make money? Do you think this is enough money to sustain your business? Why or Why Not? A. If the owner of the company is also the only employee, does this change your answer? 2. How do you interpret problems with the company and sustaining profits based on possible problems that could occur. Base your answer on our discussion board on companies that went out of business, Example change in markets, economy, health concerns, theft, etc.... 1 What information did you pickup from prime costs? How relative to this example is prime costs? What factor is prime cost missing in the equation? 4. When going through the menu analysis, what detals stand out as concerns about the differest reenu options? What changed it any would you make to the different menu options, pricing and recipes? 5. Lastly, review the profit and loss statement. If you needed to make changes, what area of the statement stands out as a possible concern based on current figures? Hot Dog Buns Cheese, Cheddar, each Shred oz Coney Sauce fl oz Onions oz 0 Mustard 1 2 B fl oz 100% 9 Closing inventory 20 Transfers out 21 Employee Meals 22 Promos 23 Cost of sales (Cogs) 24 25 26 100% 75% 70% 100% 5 Food Cost Report June 30th 6 Opening Inventory 7 Purchases 8 Transfers in D 1 case 4 bags of 8 ea hot dog buns 10 # CS 10# 50# 3 Inventory value as of May 31, 2019: 4 1 case = 4 gallons $ sss $ 32.00 $ 15.00 $ 22.00 $ E 16.00 $ $ $ 17.00 $600 $ 1,800.00 $ 100.00 F H 1 J 5 cases 2 Cases 8 Cases 2 Cases 1 Case K 100.00 200.00 300.00 also added to marketing and promo on income statement L M N End of the month inventory 1 Single Dog 2 3 4 5 6 7 Quantity 1 1 Food cost % 9 10 Coney Dog 11 12 Quantity 13 1 14 1 15 2 fluid or 16 17 18 Food Cost % 19 20 The Works 21 22 Quantity 20 24 25 2 Buldoz 26 27 5 oz 100 28 5 fluid or 29 30 11 Food Cost % 32 33 Double Dog 34 15 Quantity 36 1 1 2 1 32 had or 37 19 40 41 46 47 All 42 43 44 Food cost % 45 49 5 of 1 or 5 fluid or B C D Menu price: Item Hot Dog Hot Dog Bun 7 Total Recipe Cost Menu price Rem Hot Dog Hot Dog Run Coney Sauce Total Item Hot Dog Hot Dog Bun Coney Sauce Onion Cheese, Shred Ched Mustard Menu price Total EP/Cost Hem Hot Dog Hot Dog Ban Coney Sauce Onion Cheese, Shred Ched Mustard E Total EP/Cost Menu price EP/Cost CP/Cost 4.25 4.95 5.95 6.95 Extended Ext. Ext. G Ext M N 6 9 Hot Dog 10 Coney Dog 11 The works 12 Double Dog MENU ITEM 13 COLUMN TOTALS 14 15 Number of Menu items 16 Benchmark (70%) 17 10 19 20 22 #SOLD 300 800 600 300 4 MENU MIX % (MM) 0.00% ITEM FOOD COSTS SALES PRICES (E-D) ITEM CMS 0.00 0.00 0.00 0.00 $0.00 Average CM G (0*8) H K (E*B) (FB) popularity profit MENU MENU MENU MENU S #sold MENU CM ITEM COSTS SEVENUES CATEGORY CATEGORY CLASS CM 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 O A 1 2 Sales Recap 3 Food Sales 4 No Beverage Sales 5 Sales tax 6 B 7 8 General Ledger 9 Dir. Oper. 10 Music and Enter. 11 Rep. and Maint. 12 Admin. And Gen. 13 Adv. And Promo 14 Utilities 15 Property Tax 16 Rent and Misc. 17 Insurance 18 Lease Amort.. 19 Interest LT 20 Depreciation 21 22 D June 30th 2019 Recap $ 628.87 $ 1,600.00 $ 200.00 200.00 $ E $ 150.00 $ 200.00 F Payroll Recap Wages Employee Bene. Employee meals $ 1,800.00 payroll $ 700.00 benefit $ 200.00 benefit $ 300.00 $ 100.00 This does not include promo under COGS $ 400.00 $ 300.00 $ 1,500.00 $ 300.00 $ 150.00 1 Scott's World Famous Hot Dogs 234 4 Sales 5 Food Sales 6 COGS 7 Food Cost 8 9 Gross Profit on Sales 10. 11 Operating Expenses 12 Payroll 13 Employee Benefits 14 Direct Operating 15 Music and Entertainment 16 Repair and Maintenance. 17 Administrative and General 18 Advertising and Promotional 19 Utilities 20 Total Operating Expenses 21 22 Profit Before Occupation Expenses 23 24 Occupation Expenses 25 Property Tax 26 Rentals and Miscellaneous 27 Insurance 28 Lease Amortization 29 Interest- long term 30 Depreciation 31 Total occupation expenses 32 33 Profit before income tax 34 35 36 Module 6 Prime Cost Calculation. 37 Prime Costs 38 Prime Cost Percent. 39 40 Profit and Loss Statement (or income statement) for the month of June 1% % 400 This is Adv and Promo + COGS Promo $400.00 total % % % % Instructions Inventory Recipe Costs Menu Analysis-Eng June recap Profit and Loss