Ravi Sir's Cards › Excel
Cloud Kitchen Management System in Excel (card 1 of 2)
Revision card 1 for Cloud Kitchen Management System in Excel: Food cost %: =C5/B5 gives 31.8%; Automatic order ID: ="Z"&TEXT(ROW()-4,"0000") gives Z0001; GST on the order: =ROUND(F5*Setup!$B$4,2) gives ₹15.00. Includes an example data table.
Read card text
What this card says
1 for Cloud Kitchen Management System in Excel: Food cost %: =C5/B5 gives 31.8%
Automatic order ID: ="Z"&TEXT(ROW()-4,"0000") gives Z0001
GST on the order: =ROUND(F5*Setup!$B$4,2) gives ₹15.00. Includes an
Example
data table
Learn this in the lesson: Cloud Kitchen Management System in Excel: Menu Costing, Orders, App Commission, Net Margin and Dashboard