Assigned Task 9- Karthik Nethikunta

xlsx

School

Conestoga College *

*We aren’t endorsed by this school

Course

MGMT8300-1

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

xlsx

Pages

14

Uploaded by HighnessMinkMaster514

Report
1 Student Number: (enter one digit per box) 8 8 0 6 3 4 8 Name: Activate this worksheet by entering your student ID in the boxes below. Be sure to type in only ONE digit per cell. Please write your name in the Blue cell. KARTHIK NETHIKUNTA
2
3 Recipe: Minestrone Portions: 40 Ingredients: MQuantity unit Ingr. Yield Olive oil 5 200 ml 100% $11/1000ml Garlic 2 80 g 78% $6.99/1000g Onion, small dice ## 4000 g 80% $3.50/1000g Celery, small dice ## 2000 g 90% $5.30/1000g Carrots, small dice ## 2000 g 84% $4.99/1000g Chicken broth ## 10560 ml 100% $2.50/1000ml Tomato, tinned 0 6.4 cans 100% $3.55/796ml Kidney beans, tinned ## 5.6 cans 100% $1.39/540g Green beans, fresh, trimmed ## 3200 g 94% $6.99/1000g Spinach, stemmed ## 400 g 85% $7.80/1000g Zucchini, diced ## 1400 g 88% $2.59/1000g Shell pasta ## 1600 g 100% $5.00/1000g Salt 1 40 g 100% $5.49/1000g Pepper 1 40 g 100% $16.00/1000g Total Recipe Cost Portion Cost Food Cost objective: 24.00% Answer: (show your work) portion food cost%=portion cost/menu price 24%=7.79/menu price menu price= 32.45 menu price=32.45 EXERCISE 1 A: Adjust AP prices into EP prices where appropri determine to total EP cost, and the portion cost. (don't forget for 1- B below) As Purchased Price EXERCISE 1 B: What portion price should you charge on your are trying to achieve the following food cost %?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4 KARTHIK NETHIKUNTA EP Price EP Cost 11 4.95 8.961538 0.716923 4.375 17.5 5.888889 11.77778 5.940476 11.88095 2.5 26.4 3.55 0.02272 1.39 0.007784 7.43617 23.79574 9.176471 3.670588 2.943182 4.120455 5 8 5.49 0.2196 16 0.64 113.7025 7.79 iate. Then t scroll down r menu if you
5 KARTHIK NETHIKUNTA BREAKFAST January 1-31 Menu Mix % Buttermilk pancake 802 14.29335234361 high French toast 977 17.412225984 high Fried eggs and Toast 79 1.407948672 Low Scambled Egg and toast 635 11.3170557 high Belgian waffles 452 8.05560506 Low Ham and Cheese Omelet 480 8.554624844 Low Poached Eggs Benedict 900 16.0399215 high Granola, berries and yoghurt 596 10.621992 high Protein Green Smoothie 690 12.29727321 high TOTAL 5611 EXERCISE 2 - Fill the menu engineering matrix below. Number of Portions Sold Menu Mix (Low or High?) (Your % should add up to 100%)
6 Category CM High Star Retain High Star Retain High Puzzle Retain Low Powhorse Increase Low Dog Remove Low Dog Remove High Star Retain Low Powhorse Increase Low Powhorse Increase Enter your answers in the yellow c Category? (Star, Puzzle, Powhorse or Dog?) Strategy? (Retain, Increase Price, Decrease Price, Remove)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
7 WHY? Explain the impact of your strategy. We don’t want to disturb stars as they are doing exceptionally well on the menu. We don’t want to disturb stars as they are doing exceptionally well on the menu. This is only item on menu which is a puzzle-and we don’t want any changes on it to backfire so we will let it re This item is among top3 of menu so I can take risk and increase the price of it. With the least popularity and least profit we don’t want this to be on the menu. It doesn’t make sense to conti With the least popularity and least profit we don’t want this to be on the menu. It doesn’t make sense to conti We don’t want to disturb stars as they are doing exceptionally well on the menu. I will increase but not to a great extent as it is on the border line of a popular item so just a nickle above but n I will increase but not to a great extent as it is on the border line of a popular item so just a nickle above but n cells only.
8 etain and time and again just give combo offers tagging it to popular items. tinue with this item. tinue with this item. ot for long run if the popularity goes down. ot for long run if the popularity goes down.
9 Exercise 3 Make a list of all the costs associated with the plate of steak presented in the vi List the amounts next each item. Cost Item Description Amount Beef/ Steaak $8.00 Garlic- mashed potatoes $0.78 Steamed Asparagus $0.85 Graded horse raddish $0.15 Blue cheese sauce $0.36 Salt and pepper $0.04 Utilities $0.76 Rent, equipment and repair $2.48 Menu development $0.67 Marketing $0.76 Staff wages and training $8.82 Miscellaneous expenses $2.10 Total 25.77 Exercise 4 In the article: The Secret Tricks Hidden Insid could you apply towards your Case Study? 1.As Rapp suggests, the first factor I'd consider is the proportion of items I'd like t Bournemouth University poll, customers at fast food restaurants preferred to choo options. 2. The second rule is to avoid displaying food images on the menu because "when explains Rapp. "A lot of the time, the meal doesn't look as good as it does in the pi 3.The third consideration is how to organise the items in a menu. Even displayed at the top of the menu, the things that follow appear to be co by multitudes."
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
10
11 ideo shown in class. de Restaurant Menus by Richard Gray, what THREE ideas ? Why and how? to have on a slider under each type. More than seven is excessive, five is appropriate, and three is spect ose from six products in each category. They preferred more variety in expensive chain restaurants, with n the mind sees a picture, it tastes the meal a little bit, so when the food arrives, it may not be as delicio icture." reordering the meals on the menu could have a significant impact. Although the most im onsiderably more economical. "By just adjusting the products on the menu, we can increa
12
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
13 tacular. According to a h between seven and ten ous as they thought," mportant thing is ase a hotel's income
14