9 101) Cakulate EP unit costs per ingredient. Next find total value of the inventory on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Project Management The Managerial Process
ISBN: 9781260570434
8th Edition
Authors: Eric W Larson, Clifford F. Gray
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
If Euros sell for $1.50 per euro, what should dollars sell for in Euros per dollar?
-
Which method (direct or indirect) of presenting the statement of cash flows is more intuitively logical? Why?
-
A Ltd owns 90% of the ordinary share capital of B Ltd and 70% of the ordinary share capital of C Ltd. C Ltd owns 70% of the ordinary share capital of D Ltd. (a) Which companies are related 51% group...
-
In February 2007, The Elliot Group, Inc., an Illinois real estate developer, made a deal with the Village of Arlington Heights to develop property in that village. Arlington Market, LLC, was...
-
Selected comparative financial statements of Bennington Company follow. Required 1. Compute each years current ratio. 2. Express the income statement data in common-size percents. 3. Express the...
-
Capitalized Interest (LIVELY ACE Ch 9 Pt 2) On January 1, Year 1, Romano Tire Service, Inc. signed a contract to have a new service center built for $900,000. On the same day, Romano borrowed...
-
Kofi Allon, who is 32 years old and single, is employed as a technical consultant for a large electronics distributor. He lives at 678 Birch Street, LaMesa, CA 91941. Kofi's Social Security number is...
-
Prepare new user and schema Create new USER and Grant the appropriate privileges to this new USER so that this USER is able to..... CREATE/ALTER/DROP any tables and sequences. INSERT/UPDATE/DELETE...
-
1. Choice either or What was Chairman Powell's general assessment of the economy? The economy will likely (Continue to grow/ fall into recession) . There is more (certainty/uncertainity) of that...
-
As a Manager, In this article ( Short Sellers Feel the Pain in Stock Market's 2023 Rally ) in this weeks' Wall Street Journal that would be significant and important to you as a Manager. Important...
-
It may be wishful thinking today, but someday, hopefully, you may have a lot of money to put somewhere other than in a pillow case or in a shoe box in your closet! For this discussion let's say you...
-
L K Q MPL VMPL Wage MP Q/L FC K TOTAL VC #Worker hired TC FC+VC TR Profit 0 4 1 4 20 20 $80 $20 $60 $20 $20 $40 $80 $40 2 4 37 17 $68 $20 $48 $20 $40 $60 $148 $88 3 4 51 14 $56 $20 $36 $20 $60 $80...
-
Find the following z values for the standard normal variable Z. (You may find it useful to reference the z table. Negative values should be indicated by a minus sign. Round your answers to 3 decimal...
-
Question 2 [25 Marks] Cavema Limited is a retailer listed on the Namibian Stock Exchange. The following information has been given to you: 1. The authorised share capital comprises 10 000 000...
-
The rate at which the temperature of an object changes is proportional to the difference between its own temperature and the temperature of the surrounding medium. Express this rate as a function of...
-
The G&E Company is preparing a bid to build the new 47,000-seat Shoreline baseball stadium. The construction must start on June 10, 2019, and be completed in time for the start of the 2022 season. A...
-
What additional information would you like to have in order to assess performance on the project?
-
How important is a fun culture for innovation?
-
a. Show that the mean-squared forecast error \(E\left[\left(\hat{y}_{T+1}-y_{T+1} ight)^{2} \mid I_{T} ight]\) for a forecast \(\hat{y}_{T+1}\), that depends only on past information \(I_{T}\), can...
-
Consider the AR(1) model \(y_{t}=\delta+\theta y_{t-1}+e_{t}\) where \(|\theta|)=0\) and \(\operatorname{var}\left(e_{t} \mid I_{t-1} ight)=\sigma^{2}\). Let \(\bar{y}_{-1}=\sum_{t=2}^{T} y_{t}...
-
Consider a stationary model that combines the \(\operatorname{AR}(2)\) model \(y_{t}=\delta+\theta_{1} y_{t-1}+\theta_{2} y_{t-2}+e_{t}\) with an \(\mathrm{AR}(1)\) error model \(e_{t}=ho...
Study smarter with the SolutionInn App