Simply put Profit is revenue - costs

It always excludes GST

Revenue and costs can be

1. At the line level of the order (eg: Product Sell price after discounts, Product average cost or Purchase Order cost)
2. At the header of the order (eg: Order Discount, Freight Revenue or costs for the overall order)

What are the profit measures

1. GP
   1. Gross profit for an order = Revenue - Costs
   2. Gross Margin % for an order = (Revenue - Costs ) / Revenue
2. SP
   1. Sales Profit  = Sales Revenue - Costs
   2. Sales Margin = (Sales Revenue - Costs) / Sales Revenue 
      1. Where
         1. Sales Revenue = Revenue - freight cost x (1+ Target Margin)
3. Line Values
   
   1. Line Revenue - line costs + % by line overall revenue of (Order Level Revenue - Order Level costs)

Calculation Logic

1. Find Line Revenue for each line
   1. = Qty x price after discount and remove GST if it is included in the price
      1. Which price should be used
         1. Wholesale order, Interfranchise Order,  = Discounted Price
            1. if none then unit price
         2. Marketplace Order
            1. Req Price after discount %
         3. POS Order
            1. Price after discount
         4. Service (inspection)
            1. Gift Cards (normally GST inc)

Costs

• Plan Orders
  • Marketplace (Kits are exploded)
  • Other orders
    • Check for kit average cost
      • if none then calculate kit cost from components
• Authorised Orders
• Picked Orders