Desklib Case Study: Menu, Equipment List, Yield Test, Business KPIS and Budgeted Financial KPI

This case study covers the menu, required equipment list, yield test, business KPIS, sales and budgeted profit and loss a/c, GST cash flow budget, aged debtors, and budgeted financial KPI for Desklib.

Contents
Case study 1:.....................................................................................................................2
A la carte...........................................................................................................................2
Choice menu:....................................................................................................................4
Required equipment list....................................................................................................6
Highest and lowest cost food:...........................................................................................7
Yield test...........................................................................................................................7
Business KPIS..................................................................................................................8
Sales and budgeted profit and loss a/c..........................................................................8
Case study 2......................................................................................................................9
GST cash flow budget..................................................................................................9
Aged debtors.................................................................................................................9
Budgeted financial KPI...............................................................................................10
Evaluation.......................................................................................................................10
References.......................................................................................................................11

Case study 1:
A la carte
Soups:
{Yum chicken broth soup}
9.5
{Lemon Turkey soup}
9.96
{Thai noodle soup}
15.931
Entrée:
{Lamb streaks}
19.00
{Prawn squares}
19.00
{Crispy Pork Belly with steamed bun and pickled cucumber}
19.00
{Cheese fritters}
19.00
Main course:
{Lobster Mac and cheese}
1 BBC Food. Simple Thai noodle soup, 2018. Accessed 30 June 2018.
https://www.bbc.co.uk/food/recipes/thaiinspirednoodleso_92377

32.5
{Fish and chips}
32.5
{Barramundi in sweet and sour broth}
32.5
{Sprouted patty with mayo}
32.5
Desserts:
{Chocolate chips cookie}
14.5
{Apple Crumble cheese cake}
14.5
{Vanilla Panna cotta}
14.5
{Fruit cream}
14.5

Choice menu:
Entrée:
Lamb streaks with tomato sauce $ 28.00
{Sauces can be replaced with Pesto/ mayo/ mustar) $ 02.00
(Could be served to 5 people at a time)
Cheese fritters $ 19.00
{Extra cheese} $ 3.00
(Could be served to 5 people at a time)
Crispy Pork Belly $ 26.00
{Bun type: multigrain/garlic} $ 3.5
(Could be served to 5 people at a time)
Main course:
Fish and chips $ 42.00
{Extra spices garlic/ onion/ tomato} $ 5.99
(Could be served to 5 people at a time)
Lobster Mac and cheese $ 38.00
{Can be served with /onion rings} $ 5.00
(Could be served to 5 people at a time)
Barramundi in sweet and sour broth $ 32.50
{Add: corns/peas/onion} $ 07.00
(Could be served to 5 people at a time)
Desserts:

Chocolate chips cookie $ 08.00
{Types of chocolate: Belgium dark/ mud chocolate/ $ 02.00
White chocolate}
{Extra Chocó chip}2 $ 1.00
(Could be served to 1 people at a time)
Apple Crumble cheese cake $ 11.00
{Eggless}3 $ 11.60
(Could be served to 5 people at a time)
Fruit cream $ 06.00
{Extra fruits or dry fruits} $ 01.00
(Could be served to 5 people at a time)
2 All recipes Australia. Chicken Entree - All recipes Australia NZ. Allrecipes.com.au, 2018.
Accessed 30 June 2018. http://allrecipes.com.au/recipes/tag-6720/chicken-entree.aspx
3 Food Network. Araya's Place Tom Yum Soup, 2018. Accessed 30 June 2018.
http://www.foodnetwork.com/recipes/arayas-place-tom-yum-soup-recipe-1925277

Required equipment list:
1. Microwave
2. Griller
3. Mixer and grinder
4. Chopping board and knives
5. Induction
6. Mould
7. Ovens
8. Containers
9. Refrigerator
10. Exhaust fan
11. Chimney
12. Hot plates
13. Deep fryer
14. Reach in cooler
15. Sauté pans
16. Baking sheets
17. Sauce pans
18. Pasta bowls
19. Appetizer plates
20. Cleaning rags
21. Steam table4
22. Fire extinguisher
4 BBC Good Food. Lamb steaks with crispy potatoes & minted beans, 2018. Accessed 30
June 2018. https://www.bbcgoodfood.com/recipe/lamb-steaks-crispy-potatoes-minted-beans

Highest and lowest cost food:
Further, it has been found that the highest and lowest cost food of
the restaurant is as follows:
1. Highest cost food – Fish and chips
2. Lowest cost food - Fruit cream
Yield test:
Yum chicken Brth soup
Ingredients UOM Pack size Q price Amount Price
Chicken KG 1 Kg 0.25 $ 9.00 $ 2.25
Carrots KG 1 Kg 0.25 $ 2.00 $ 0.50
Onions KG 1 Kg 0.25 $ 1.40 $ 0.35
Beanshoot KG 1 Kg 0.2 $ 2.00 $ 0.40
Thyme Bunch 1 bunch 0.25 $ 2.50 $ 0.63
Garlic KG 1 Kg 0.1 $ 12.00 $ 1.20
Potatoes KG 1 Kg 0.15 $ 2.00 $ 0.30
Celery Each Each 1 $ 2.50 $ 2.50
Salt PKT 1 Kg 0.01 $ 4.92 $ 0.05
Parsley Bunch Bunch 0.1 $ 2.50 $ 0.25
Olive oil tin 10 kg 0.005 $ 32.36 $ 0.16
Pepper Jar 1 kg 0.05 $ 21.99 $ 1.10
Parmesan PKT 1 Kg 0.1 $ 25.00 $ 2.50
Egg noodle PKT 1 kg 0.3 $ 2.50 $ 0.75
Business KPIS:
Sales and budgeted profit and loss a/c
Sales and budgeted profit and loss a/c
Profit budget 2017/18 Qtr 1 Qtr 2 Qtr 3 Qtr 4
Revenue
Sales
$
4,617,814.82
$
1,200,631.85
$
1,200,631.85
$
1,200,631.85
$
1,200,631.85
Gross profit $ $ $ $ $

3,709,840.71 964,558.58 964,558.58 964,558.58 964,558.58
Gross profit % 80.34% 80.34% 80.34% 80.34% 80.34%
Expenses
Accounting fees
$
40,000.00
$
10,000.00
$
10,000.00
$
10,000.00
$
10,000.00
Interest
expenses
$
6,760.64
$
1,757.77
$
1,757.77
$
1,757.77
$
1,757.77
Bank charges
$
400.00
$
104.00
$
104.00
$
104.00
$
104.00
Depreciation
$
42,500.00
$
11,050.00
$
11,050.00
$
11,050.00
$
11,050.00
insurance
$
3,858.75
$
1,003.28
$
1,003.28
$
1,003.28
$
1,003.28
Store supplies
$
998.92
$
259.72
$
259.72
$
259.72
$
259.72
Advertising
$
195,287.00
$
50,774.62
$
50,774.62
$
50,774.62
$
50,774.62
Cleaning
$
7,892.65
$
1,854.77
$
435.87
$
102.43
$
24.07
Repairs and
maintenances
$
11,431.72
$
2,972.25
$
2,972.25
$
2,972.25
$
2,972.25
Rent
$
660,127.00
$
171,633.02
$
171,633.02
$
171,633.02
$
171,633.02
Telephone
$
4,028.86
$
1,047.50
$
1,047.50
$
1,047.50
$
1,047.50
Electricity
expenses
$
13,645.41
$
3,547.81
$
3,547.81
$
3,547.81
$
3,547.81
Luxury car tax
$
8,041.00
$
2,090.66
$
2,090.66
$
2,090.66
$
2,090.66
Fringe benefit
tax
$
7,000.00
$
1,820.00
$
1,820.00
$
1,820.00
$
1,820.00
Supper
annotation
$
149,333.85
$
38,826.80
$
38,826.80
$
38,826.80
$
38,826.80
Wages and
salaries
$
1,659,264.97
$
431,408.89
$
431,408.89
$
431,408.89
$
431,408.89
Payroll tax
$
78,815.09
$
20,491.92
$
20,491.92
$
20,491.92
$
20,491.92
Workers
compensation
$
33,185.30
$
8,628.18
$
8,628.18
$
8,628.18
$
8,628.18
Total expenses
$
2,928,138.08
$
761,315.90
$
761,315.90
$
761,315.90
$
761,315.90
Net profit
(before tax)
$
781,702.62
$
203,242.68
$
203,242.68
$
203,242.68
$
203,242.68
Income tax
$
234,510.79
$
60,972.80
$
60,972.80
$
60,972.80
$
60,972.80
Net profit
$
547,191.83
$
142,269.88
$
142,269.88
$
142,269.88
$
142,269.88

Case study 2:
GST cash flow budget
GST cash flow budget
Cash flow analysis -
GST total Qtr 1 Qtr 2 Qtr 3 Qtr 4
GST collected
$
461,781.48
$
120,063.19
$
120,063.19
$
120,063.19
$
120,063.19
Less: GST paid
$
292,813.81
$
76,131.59
$
76,131.59
$
76,131.59
$
76,131.59
GST payable
$
168,967.67
$
43,931.60
$
43,931.60
$
43,931.60
$
43,931.60
Aged debtors:
Aged Debtors
Aged debtors
budget total Qtr 1 Qtr 2 Qtr 3 Qtr 4
Sales
$
4,617,814.82
$
1,200,631.85
$
1,200,631.85
$
1,200,631.85
$
1,200,631.85
% debtors sale 80% 80% 80% 80% 80%
Total debtors %
$
1,248,657.13
$
1,536,808.77
$
1,921,010.97
$
1,921,010.97
Current %
$
960,505.48
$
960,505.48
$
960,505.48
$
960,505.48
30 days %
$
288,151.64
$
288,151.64
$
288,151.64
$
288,151.64
60 days %
$
288,151.64
$
288,151.64
$
288,151.64
90 days %
$
384,202.19
$
384,202.19
Budgeted financial KPI:
Budgeted financial outgoing KPIs
Aged debtors budget total Qtr 1 Qtr 2 Qtr 3 Qtr 4
Food cost % 60% 438495.0975 438495.0975 438495.0975 438495.0975
Beverage cost % 40% 169451.417 169451.417 169451.417 169451.417

Labour cost % 4% 16592.6497 4314.088922 4314.088922 4314.088922
Total expenses / total sales % 52.02% 50.99% 50.99% 50.99%
Evaluation:
According to the case, the menu has been prepared and the financial budgets of the
business have been prepared to evaluate the changes and the performance of the restaurant in
future. According to the study, it has been found that the overall performance of the business
has been improved. Few variances have taken place in the business but all are explaining
about the positive changes as well as the net profit position of the company is quite better.
Through analyzing the menu and the case, it has been found that the overall market
base of the company would be improved and it would help the business to improve the
performance. It has also been measured that the overall level of the restaurant would
definitely been improved.

References:
All recipes Australia. Chicken Entree - All recipes Australia NZ. Allrecipes.com.au, 2018.
Accessed 30 June 2018. http://allrecipes.com.au/recipes/tag-6720/chicken-entree.aspx
BBC Food. Simple Thai noodle soup, 2018. Accessed 30 June 2018.
https://www.bbc.co.uk/food/recipes/thaiinspirednoodleso_92377
BBC Good Food. Lamb steaks with crispy potatoes & minted beans, 2018. Accessed 30 June
2018. https://www.bbcgoodfood.com/recipe/lamb-steaks-crispy-potatoes-minted-beans
Food Network. Araya's Place Tom Yum Soup, 2018. Accessed 30 June 2018.
http://www.foodnetwork.com/recipes/arayas-place-tom-yum-soup-recipe-1925277