Ravi Sir's Cards › Excel
Bakery Management System in Excel (card 2 of 2)
Revision card 2 for Bakery Management System in Excel: Waste %: =IFERROR(D5/B5,0) gives 6.0%; Pieces baked: =SUMIFS(Production!$C$5:$C$1000,Production!$B$5:$B$1000,A5) gives 1,011; Pieces sold: =SUMIFS(Sales!$C$5:$C$1000,Sales!$B$5:$B$1000,A5) gives 950. Includes an example data table.
Read card text
What this card says
2 for Bakery Management System in Excel: Waste %: =IFERROR(D5/B5,0) gives 6.0%
Pieces baked: =SUMIFS(Production!$C$5:$C$1000,Production!$B$5:$B$1000,A5) gives 1,011
Pieces sold: =SUMIFS(Sales!$C$5:$C$1000,Sales!$B$5:$B$1000,A5) gives 950. Includes an
Example
data table
Learn this in the lesson: Bakery Management System in Excel: Recipe Costing, Daily Production, Sales, Waste and Dashboard