
English: 
Hello friends!
I have been working on developing automated solutions
for a variety of purposes
The app I am going to show you today
performs automatic menu engineering
based on the concept of analysing menu
this application is based on shiny platform
which is developed in R software
first, I want to give you a quick overview
of menu engineering. 
it is a sales maximisation technique
used by restaurants
and the menu is analysed based on two factors
the contribution margin of each menu item
and the number of portions sold of that particular item
for a period, suppose we say a month

English: 
Hello friends!
I have been working on developing automated solutions
for a variety of purposes
The app I am going to show you today
performs automatic menu engineering
based on the concept of analysing menu
this application is based on shiny platform
which is developed in R software
first, I want to give you a quick overview
of menu engineering. 
it is a sales maximisation technique
used by restaurants
and the menu is analysed based on two factors
the contribution margin of each menu item
and the number of portions sold of that particular item
for a period, suppose we say a month

English: 
lets open the application to see the interface
I go to the terminal in R software
and i run my shiny software
It opens up a very clean interface
and it has a layout with 
an interface for inputting data in the form of
csv file
and two tabs to see the
table output view and plot view 
of the menu engineering task
a csv file is basically converted from an excel sheet
it is a comma separated file
it can easily be created by saving from excel sheet. 
so here is my menu in the form of a csv file
which can be converted from a excel sheet
this sheet has three columns

English: 
lets open the application to see the interface
I go to the terminal in R software
and i run my shiny software
It opens up a very clean interface
and it has a layout with 
an interface for inputting data in the form of
csv file
and two tabs to see the
table output view and plot view 
of the menu engineering task
a csv file is basically converted from an excel sheet
it is a comma separated file
it can easily be created by saving from excel sheet. 
so here is my menu in the form of a csv file
which can be converted from a excel sheet
this sheet has three columns

English: 
name of the item, the menu item
name of the item, the menu item
its contribution margin
and the number of portions sold
for the purpose of this video I am 
doing analysis for one month
so lets say these are the portions
sold for a particular month
now I go to my menu engineering software
and I click on the browse button
and select my menu file
next we need to click on the analyse button
now, it brings up the menu engineering analysis
which is performed automatically by my software
It classifies the items based on contribution margin
which is marked on the x axis

English: 
name of the item, the menu item
name of the item, the menu item
its contribution margin
and the number of portions sold
for the purpose of this video I am 
doing analysis for one month
so lets say these are the portions
sold for a particular month
now I go to my menu engineering software
and I click on the browse button
and select my menu file
next we need to click on the analyse button
now, it brings up the menu engineering analysis
which is performed automatically by my software
It classifies the items based on contribution margin
which is marked on the x axis

English: 
and the sales volume or number of portions sold
which is marked on the y axis
the items are categorized into 4 quadrants
dog, horse, puzzle and star
so this same can be viewed in the form of a table
by clicking on the table view.
so here you can see each menu item
has been assigned a quadrant
based on its contribution margin and 
its monthly sale
Based on the quadrant the menu item has been assigned
it will be further either modified upgraded
or removed
as deemed suitable by the chef

English: 
and the sales volume or number of portions sold
which is marked on the y axis
the items are categorized into 4 quadrants
dog, horse, puzzle and star
so this same can be viewed in the form of a table
by clicking on the table view.
so here you can see each menu item
has been assigned a quadrant
based on its contribution margin and 
its monthly sale
Based on the quadrant the menu item has been assigned
it will be further either modified upgraded
or removed
as deemed suitable by the chef
