Assigned Task 9- Karthik Nethikunta
xlsx
keyboard_arrow_up
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
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