SITHKOP015_AT2_T2_Menu costing V2 Template
.xlsx
keyboard_arrow_up
School
Queensford College *
*We aren’t endorsed by this school
Course
MISC
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
34
Uploaded by MateDinosaur3864
New Menus Costing Summary
Menu
A la carte
$69.20
$13.17
$52.85
24.92%
Buffet
$30.69
$8.67
$29.40
29.49%
Degustation
$58.37
$11.12
$46.85
23.74%
Table d 'hote
$66.69
$13.34
$59.85
22.29%
Total
$224.95
$46.30
$188.95
24.50%
Profitability Summary
Budget Actual
Variance
Food cost %
30.00%
24.50%
-5.50%
Gross profit %
70.00%
75.50%
5.50%
Net profit %
15.00%
19.69%
4.69%
Total ingredient cost
$300.00
$224.95
-$75.05
Menu breakdown
Menu
Portion Cost:
A la carte
Caesar salad $30.38
$6.08
$19.95
30.48%
Chicken Parmigiana $31.35
$5.22
$19.95
26.17%
Eton Mess $7.47
$1.87
$12.95
14.44%
Buffet
Muffins
$3.87
$0.64
$4.50
14.22%
Fruit salad $17.94
$3.59
$9.95
36.08%
Spinach, beetroot, feta …
$8.88
$4.44
$14.95
29.70%
Degustation
Tomato Bruschetta
$7.78
$1.30
$12.95
10.04%
Vichyssoises
$33.91
$5.65
$14.95
37.79%
Falafel
$16.68
$4.17
$18.95
22.01%
Table d 'hote
Thai-style pumpkin soup
$8.25
$1.65
$14.95
11.04%
Roast pork
$41.99
$8.40
$29.95
28.05%
Banana fritters $16.45
$3.29
$14.95
22.01%
Total cost of ingredients for menu (inc. GST)
Total portion cost for all 3 courses
Total proposed menu cost for all 3 courses
Food cost based on sales price
Total cost of ingredients (inc. GST)
Proposed sale price per portion
Food cost per portion based on sales price
Net profit ($)
Net profit (%)
75.08%
$39.68
$25.00 $14.68
10.29%
70.51%
$20.73
$10.00 $10.73
19.20%
76.26%
$35.73
$20.00 $15.73
29.31%
77.71%
$46.51
$30.00 $16.51
19.20%
75.50%
$142.65
$85.00 $57.65
19.69%
69.52%
73.83%
85.56%
85.78%
63.92%
70.30%
89.96%
62.21%
77.99%
88.96%
71.95%
77.99%
Gross profit margin based on sales price
Gross profit ($) based on sales price
Net production costs
Profit margin per portion based on sales price
Standard Recipe Card Name of dish:
Caesar Salad
Ref.source:
Total Cost (GST Incl):
$30.39
Portion Cost:
$6.08
Sales Price
$20.25
Commodities
Item
Specification
Weight kg/l/Unit
GST
Cos lettuce
Head
1
11.5
N
Garlic cloves – whole peeled
Kg
1
8.45
N
Olive oil (1)
Ltr
20
69.9
Y
White bread
Slices
20
2.75
Y
Rashers of bacon – rind removed
Rasher
25
32.75
N
Eggs
Carton
180
43.5
N
Olive oil (2)
Ltr
20
69.9
Y
Lemon juice
Kg
15
47.95
N
Black pepper – finely ground
Kg
1
11.10
N
Anchovy fillets
Gr
30
15.95
Y
Dressing each
1
0.8
N
Poached egg
each
1
0.63
N
Pamersan
Kg
2.5
58.75
N
5ltr recipe break into 1 ltr 5 portions before using and date and label for food safety
Description Caesar salad as you knoiw it but better - crispy local, grown lettuce, hom
Method:
1 Wash the lettuce in cold water, tear into bite-sized pieces and leave to d
2 Remove the crust from the bread and evenly cut into 1 cm cubes.
3 Heat the peeled garlic cloves and olive oil (1) gently in a frying pan. Add
4 Drain the croutons on absorbent paper.
5 Slice the bacon rashers into 1 cm strips across the rashers (lardons).
6 Cook the bacon in the pan from which you just removed the croutons. E
7 Cut the anchovy fillets into small pieces and shave the parmesan using 8 Coddle the eggs by placing them into boiling water for 1 minute.
9 Break the eggs into a bowl, add the olive oil (2), lemon juice and pepper
10 Place the lettuce in the bowl and toss with the coddled egg dressing.
11 Plate lettuce. Scatter the croutons, bacon, and anchovy on top and finish
Variation top with a poached egg (Recipe #Gen19), particularly as a main course dish. Se
Equipment 1
Chopping boards white - bread/dairy
2
Chopping boards brown bacon
3
Chopping boards - green - veg
4
Chefs knife
5
tongs
6
measuring jug
7
Colander
8
Bowl for dressing
Unit Price (GST Excl)
Explanation: Enter all data in the yellow fields. You can change the sales price and portion numbers. All calculations will be done automatically.
9
whisk
10
frying pan
11
saucepan
Portion nos.:
5
Portion size.:
250
Proposed Sale Price at $20.26
30%
( Food Cost)
Food Cost %
30.0%
Cost per kg/l/Unit
Yield %
1.00
$11.50
80%
$14.38
0.05
$0.42
100%
$0.42
0.01
$0.03
100%
$0.03
10.00
$1.38
100%
$1.38
5.00
$6.55
100%
$6.55
5.00
$1.21
80%
$1.51
0.01
$0.03
80%
$0.04
0.07
$0.22
80%
$0.28
0.01
$0.11
80%
$0.14
5.00
$2.66
100%
$2.66
1.00
$0.80
100%
$0.80
1.00
$0.63
100%
$0.63
0.05
$1.18
100%
$1.18
Total Cost
$29.98
GST
10%
$0.41
Total Cost (GST inc)
$30.39
memade dressing and crisy croutons. Topped with an organic egg. drain well.
d the bread and cook while continually turning until the croutons are crisp and golden brown.
Ensure the pieces are separated. Cook until just crispy on the edges and not dried out.
a vegetable peeler or a slicer. Set these aside for further use.
r. Mix well.
h with the shaved parmesan. Serve immediately.
erve warm.
Recipe Qty
Actual cost (GST Exl)
Standard Recipe Card Name of dish:
Chicken Parma with Chips and Salad
Ref.source:
Total Cost (GST Incl):
$31.35
Portion Cost:
$5.22
Sales Price
$19.00
Price is determined by stud
Commodities
Item
Specification
Weight kg/l/Unit
GST
Eggs
Each
180
43.5
N
Garlic cloves – whole peeled
Kg
1
8.45
N
Parsley - finely chopped
Bunch
1
4.35
N
Panko breadcrumbs
Gr
200
2
Y
Fresh breadcrumbs
Kg
1
4.2
Y
Fresh parmesan cheese - grated
Kg
2.5
58.75
N
Onion powder
Gr
500
21.53
Y
Chicken breast fillets (singles)
Piece
4
9.9
N
Oil for shallow frying
Ltr
20
41
N
Sauce Provençale (Recipe #Gen25)
Ltr
1
3.82
N
Sauce Béchamel (Recipe #Gen24)
Ltr
1
3.82
N
Mozzarella Cheese
Kg
2
20.9
N
Fresh parmesan cheese - grated
Kg
2.5
58.75
N
Salad
kg
1
25
n
Chips - frozen kg
1
3.6
N
Description Method:
1
2 Add chicken into the egg, rotating to evenly coat each fillet in the mixture
3
4 Heat oil in a large pan over medium-high heat until hot and shimmering.
5 Place chicken on baking tray and top each breast with 125ml Provençal
6 Mix mozzarella, parmesan, and parsley together.
7 Top each chicken breast with 1/6 mixture (60g).
8 Bake for 15-20 minutes, or until cheese is bubbling and melted, and the Equipment 1
Chopping boards white - bread/dairy
2
Chopping boards brown bacon
3
Chopping boards - green - veg
4
Chefs knife
5
bowls x 2
6
plastic wrap
7
baking tray
8
Tongs
9
Ladle Unit Price (GST Excl)
Explanation: Enter all data in the yellow fields. You can change the sales price and portion numbers. All calculations will be done automatically.
Whisk together eggs, garlic, parsley, salt, and pepper in a shallow dish.
Mix breadcrumbs, parmesan cheese and onion powder together in a sep
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
Related Questions
mework Assignment i
Save & Exit
Submit
Saved
Help
Check my work
Assume that Ocean King Products sells three varieties of canned seafood with the following prices and costs.
Selling Price
per Case
$ 3
Variable Cost
Fixed Cost
per Case
$2
per Month
Variety 1
Variety 2
Variety 3
5
3
10
6.
Entire firm
$46,200
The sales mix (in cases) is 40 percent Variety 1, 35 percent Variety 2, and 25 percent Variety 3.
Required:
a. At what sales revenue per month does the company break even?
b. Suppose the company is subject to a 35 percent tax rate on income. At what sales revenue per month will the company earn
$40,950 after taxes assuming the same sales mix?
arrow_forward
Hello tutor give correct answer
arrow_forward
The Beach Umbrella is a take-out food store at a popular beach resort. Susan Miller, owner of the Beach Umbrella, is deciding how much refrigerator space to devote to four different drinks. Pertinent data on
these four drinks are as follows:
(Click to view the data.)
Miller has a maximum front shelf space of 12 feet to devote to the four drinks. She wants a minimum of 1 foot and a maximum of 6 feet of front shelf space for each drink.
Read the requirements.
Requirement 1. Calculate the contribution margin per case of each type of drink.
Selling price per case
Variable cost per case
Contribution margin per case
Requirements
$
Cola
Lemonade
18.25 $
14.40
20.75 $
15.60
Punch
27.70 $
20.10
Natural
Orange Juice
39.25
30.40
1.
Calculate the contribution margin per case of each type of drink.
2. A coworker of Miller's recommends that she maximize the shelf space devoted to those drinks with the highest contribution margin
per case. Do you agree with this recommendation? Explain briefly.
3.…
arrow_forward
Please do not give solution in image format thanku
arrow_forward
X
Search the web
EXPERT
SOLUTION
FOLLOW-UP
QUESTIONS
↓
Homework help starts here!
← Q&A Library
Solution -
1. Budget-
Sales (In Units)
Selling Price
Total Sales
Credit Collections:
In the Month of Sale
In the Following Month
Uncollectible
Ending Finished Goods Inventory
Beginning Finished Goods Inventory
Production
Each Unit Requires
Ending Raw Material Inventory
Beginning Raw Material Inventory
Raw Material Purchases
Cost per Foot
Credit Payments:
In the Month of Purchases
In the Following Month
30%
65%
5%
15%
4 Feet
50%
$ 0.80
June
Working Notes
July August September October November December
25,000 30,000 70,000
50,000
20,000
$ 12.00 $ 12.00 S 12.00 $ 12.00 $ 12.00
$ 840,000
$ 300,000
90,000
15,000
4,500
3,750
Milo Company manufactures beach umbrellas. The c...
$360,000
108,000
195,000
18,000
10,500
4,500
252,000 180,000
234.000
42,000
7,500
10,500
$ 600,000
72,000 134,000 91,000
51,500 72,000 134,000
WAS THIS HELPFUL?
67,000
45,500
25,750 36,000
103,000 144,000 268,000 182,000…
arrow_forward
Plz solve this 10 min and take a thumb up plz
arrow_forward
Cleveland Foods Data Note: You can download
the Excel file containing Cleveland Foods' data
by clicking the above link and perform the
necessary calculations for answering the
upcoming questions. Question 12 (1 point) □
What is the unit contribution of BlueLiq,
considering the given information? $0.70 $2.50 $
1.00 $1.70
$
$
J
0
20% Retail Margin
2.50 Price to consumers (Retail Price)
15% Wholesale Margin
2.00 Price to retailers (Wholesale Price)
$
1.70 Price to Wholesalers
Variable Costs
$ 0.70 per unit
Fixed Costs
Variable Manufacturing Costs
$300,000 annual
$200,000 Corporate Overhead
$250,000 Marketing and Advertising
$750,000 Total Fixed Costs
Cleveland Foods Data
Fixed Manufacturing Costs
Note: You can download the Excel file containing Cleveland Foods' data by clicking
the above link and perform the necessary calculations for answering the upcoming
questions.
Question 11 (1 point).
Listen
4
What is the price at which Cleveland Foods sells BlueLiq to wholesalers?
$1.70
$2.50
$1.00
arrow_forward
plz be fast em waiting
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Question 5
arrow_forward
please help in detail
arrow_forward
$60.02 per batch
$17.08 per customer order
$ 7.31 per assembly hour
orders
arrow_forward
A manufacturing company that produces a single product has provided the following data concerning its most recent month of
operations:
Units in beginning inventory
Units produced
Units sold
Units in ending inventory
Variable costs per unit:
8,900
8,500
9:07
400
Direct materials
24
26
Direct labor
2$
25
Variable manufacturing overhead
Variable selling and administrative expense
Fixed costs:
Fixed manufacturing overhead
Fixed selling and administrative expense
24
%24
$249,200
$ 17,000
What is the variable costing unit product cost for the month?
Multiple Choice
Mc
Graw
Hill
tv
W
MacBook Air
888
DI
DD
F2
F3
F4
F5
F6
F8
F9
11
23
$
&
*
3
6.
7
8.
9.
W
E
R
Y
U
一
[
D
F
H
J
K
C
V
N M
?
V -
arrow_forward
Price per 2-scoop sundae
$
5.00
Variable cost per sundae:
Ingredients
1.35
Direct labor
0.45
Overhead
0.20
Fixed cost per month
$
8,400
c. Variable costs increase by $0.50 per sundae.
4. Based on the original information, how many sundaes must Izzy sell to generate a profit of $46,000, if sales price increases by $0.50 and variable costs increase by $0.30?
arrow_forward
Required:
Prepare the Hiatt Hotel's bank reconciliation for January 20X2. lato qioon de
Annd
Problem 10
The Terica Café uses a standard cost approach to aid in controlling its food costs. Listed
below are the sales price, standard food cost, and quantity sold for its five sandwiches for
the week ended August 28.
Required
Item
Selling
Price
Standard
Food
Quantity
LanSold
benhg
holltila
Cost
Evalu e et
Pork Barrel
kal
$4.95
Idovs
$1.60
50
Chicken Breast
4.4509
100
1.40
ylim Burger Delightod orlt es ov sv-3.95
how 0.95 2sri orlw emc 150
tosa1.70la ed ei 80v
Ocean Catch in
4.95uf
edd2.95 won e 0.45 lesiti 40 r
IAGO
the o Egg Salad
aplgre
arrow_forward
eBook
Show Me How
Print Item
Direct Materials Purchases Budget
Romano's Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 12" and 16" frozen pizzas for September:
Units
12" Pizza
16" Pizza
Budgeted production volume
12,900
23,700
There are three direct materials used in producing the two types of pizza. The quantities of direct materials expected to be used for each pizza are as follows:
12" Pizza
16" Pizza
Direct materials:
Dough
0.90 lb. per unit
1.50 lbs. per unit
Tomato
0.60
1.00
Cheese
0.80
1.30
In addition, Romano's has determined the following information about each material:
Dough
Tomato
Cheese
Estimated inventory, September 1
550 Ibs.
240 Ibs.
330 Ibs.
Desired inventory, September 30
580 Ibs.
230 Ibs.
360 Ibs.
Price per pound
$1.50
$2.80
$3.20
Prepare September's direct materials purchases budget for Romano's Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative numbers use a
minus sign.…
arrow_forward
Subway, the fast food restaurant franchise, recently announced it is bringing back the "$5 Footlong" promotion. Hundreds of Subway franchise owners are
protesting the promotion, saying that they cannot afford to sell the footlong sub sandwiches for $5.
Assume that the costs related to a Subway footlong and a Subway franchisee include the following:
Cost per
Cost item
Details
sandwich
Food ingredients
Per footlong
2$
2.00
Labor $14.00/hour wage rate,
Labor cost per footlong
each worker can make 7
2.00
sandwiches per hour
Credit card transaction fee 1.0% + $0.10 per transaction
0.15
$360 per month divided by 4,000
0.09
Electricity
orders per month
Rent $1,200 per month divided by
0.30
Rent
4,000 orders per month
Franchise and startup fees
$36,000 divided by 180 months
0.05
Franchise fee amortization
(15 years) divided by 4,000 orders
per month
0.40
Royalty fee
8.0% of sales
0.23
Advertising fee
4.5% of sales
$600 per month divided by 4,000
0.15
Equipment leasing cost
orders
arrow_forward
Question 18
View Policies
Current Attempt in Progress
E-Flix rents DVDS that are mailed out to customers upon demand. E-Flix has identified three activities involved in getting the videos to its
customers. Information on those activities for the month of July follows:
Estimated
Expected Use of
Cost Drivers
Cost Pools
Cost Drivers
Overhead Cost
Order taking costs
Number of orders
$20,592
187,200 orders
Technology support
Number of minutes
$11,700
234,000 minutes
Picking and shipping
Number of DVDS
$39,624
330,200 DVDS
costs
During July, the Tucker family placed 17 orders consisting of 21 DVDS. Tucker required 7 minutes of tech support. Customers pay $9.00 per
month to rent unlimited DVDS. Using ABC, how much overhead is applied to the Tucker family account for technology support?
O Some other answer
O $1.87
O $0.05
o$0.35
2:28 P
)
10/13/23
arrow_forward
Solve this problem no use ai
arrow_forward
Cheese
0.80
1.30
In addition, Tobin's has determined the following information about each material:
Dough
Tomato
Cheese
Estimated inventory, November 1
560 lbs.
180 lbs.
360 lbs.
Desired inventory, November 30
Price per pound
590 lbs.
$1.30
170 lbs.
390 lbs.
$2.40
$3.40
Prepare November's direct materials purchases budget for Tobin's Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative numbers use a
minus sign.
Tobin's Frozen Pizza Inc.
Direct Materials Purchases Budget
For the Month Ending November 30
Line Item Description
Dough
Tomato
Cheese
Total
Units required for production:
12" pizza
16" pizza
Total units available
Total units to be purchased
Unit Price
Total direct materials to be purchased
x $
x $
x $
arrow_forward
Alternative 3,200 units meals
arrow_forward
$
Price per cake
Variable cost per cake
Ingredients
17.00
2.50
Direct labor
1.40
Overhead (box, etc.)
Fixed cost per month
0.20
$3,850.00
Required:
1. Determine Cove's break-even point in units and sales dollars.
%24
arrow_forward
Activity Levels and Cost Drivers Steve’s Slop Shop, a small hamburger shop, has identified theresources used in its operations (assume each customer’s order is a batch for this example):a. Breadb. Hourly workers that cook hamburgersc. Store rentd. Ground beefe. Catsupf. Advertising for Triple-Burger specialg. Salary for the store managersh. Utilitiesi. $1-off-coupon for each orderj. Bags for each orderRequired1. Classify its costs as unit-level, batch-level, product-level, or facility-level costs.2. Suggest a possible cost driver for each of the above items.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- mework Assignment i Save & Exit Submit Saved Help Check my work Assume that Ocean King Products sells three varieties of canned seafood with the following prices and costs. Selling Price per Case $ 3 Variable Cost Fixed Cost per Case $2 per Month Variety 1 Variety 2 Variety 3 5 3 10 6. Entire firm $46,200 The sales mix (in cases) is 40 percent Variety 1, 35 percent Variety 2, and 25 percent Variety 3. Required: a. At what sales revenue per month does the company break even? b. Suppose the company is subject to a 35 percent tax rate on income. At what sales revenue per month will the company earn $40,950 after taxes assuming the same sales mix?arrow_forwardHello tutor give correct answerarrow_forwardThe Beach Umbrella is a take-out food store at a popular beach resort. Susan Miller, owner of the Beach Umbrella, is deciding how much refrigerator space to devote to four different drinks. Pertinent data on these four drinks are as follows: (Click to view the data.) Miller has a maximum front shelf space of 12 feet to devote to the four drinks. She wants a minimum of 1 foot and a maximum of 6 feet of front shelf space for each drink. Read the requirements. Requirement 1. Calculate the contribution margin per case of each type of drink. Selling price per case Variable cost per case Contribution margin per case Requirements $ Cola Lemonade 18.25 $ 14.40 20.75 $ 15.60 Punch 27.70 $ 20.10 Natural Orange Juice 39.25 30.40 1. Calculate the contribution margin per case of each type of drink. 2. A coworker of Miller's recommends that she maximize the shelf space devoted to those drinks with the highest contribution margin per case. Do you agree with this recommendation? Explain briefly. 3.…arrow_forward
- Please do not give solution in image format thankuarrow_forwardX Search the web EXPERT SOLUTION FOLLOW-UP QUESTIONS ↓ Homework help starts here! ← Q&A Library Solution - 1. Budget- Sales (In Units) Selling Price Total Sales Credit Collections: In the Month of Sale In the Following Month Uncollectible Ending Finished Goods Inventory Beginning Finished Goods Inventory Production Each Unit Requires Ending Raw Material Inventory Beginning Raw Material Inventory Raw Material Purchases Cost per Foot Credit Payments: In the Month of Purchases In the Following Month 30% 65% 5% 15% 4 Feet 50% $ 0.80 June Working Notes July August September October November December 25,000 30,000 70,000 50,000 20,000 $ 12.00 $ 12.00 S 12.00 $ 12.00 $ 12.00 $ 840,000 $ 300,000 90,000 15,000 4,500 3,750 Milo Company manufactures beach umbrellas. The c... $360,000 108,000 195,000 18,000 10,500 4,500 252,000 180,000 234.000 42,000 7,500 10,500 $ 600,000 72,000 134,000 91,000 51,500 72,000 134,000 WAS THIS HELPFUL? 67,000 45,500 25,750 36,000 103,000 144,000 268,000 182,000…arrow_forwardPlz solve this 10 min and take a thumb up plzarrow_forward
- Cleveland Foods Data Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 12 (1 point) □ What is the unit contribution of BlueLiq, considering the given information? $0.70 $2.50 $ 1.00 $1.70 $ $ J 0 20% Retail Margin 2.50 Price to consumers (Retail Price) 15% Wholesale Margin 2.00 Price to retailers (Wholesale Price) $ 1.70 Price to Wholesalers Variable Costs $ 0.70 per unit Fixed Costs Variable Manufacturing Costs $300,000 annual $200,000 Corporate Overhead $250,000 Marketing and Advertising $750,000 Total Fixed Costs Cleveland Foods Data Fixed Manufacturing Costs Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 11 (1 point). Listen 4 What is the price at which Cleveland Foods sells BlueLiq to wholesalers? $1.70 $2.50 $1.00arrow_forwardplz be fast em waitingarrow_forwardPlease do not give solution in image format thankuarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you