Ravi Sir's Cards › Excel
Shop Billing and Inventory System in Excel (card 1 of 2)
Revision card 1 for Shop Billing and Inventory System in Excel: Margin % of the item: =(E6-D6)/E6 gives 13.3%; Purchase amount: =D5*E5 gives ₹2,080; Profit of the sale: =F5-G5 gives ₹96. Includes an example data table.
Read card text
What this card says
1 for Shop Billing and Inventory System in Excel: Margin % of the item: =(E6-D6)/E6 gives 13.3%
Purchase amount: =D5*E5 gives ₹2,080
Profit of the sale: =F5-G5 gives ₹96. Includes an
Example
data table
Learn this in the lesson: Shop Billing and Inventory System in Excel: Items, Purchases, Sales, Stock Reorder, Profit and Daily Cash Book