Calculating sales and the cost of goods sold

Python ile Finansal Tahminleme

Victoria Clark

CGMA Financial Analyst

Calculating sales and the cost of goods sold

image description

Python ile Finansal Tahminleme

Calculating sales

Sales = Income = Revenue = Turnover

Data needed:

  • Sales price per unit sp_unit
  • Number of units sold units

Complexities

  • Discounts (Discounted Sales Price) d_sp
  • Credit sales
  • Sales mix sp_1 vs sp_2

  test

Python ile Finansal Tahminleme

Calculating Cost of Goods Sold (COGS)

Data needed:

  • fixed_costs
    • Costs independent of units
  • Variable_costs_per_unit
    • Costs incurred per unit produced
  • Inventory opening balance inv_ob
  • Inventory closing balance inv_cb

    image description

Python ile Finansal Tahminleme

What does the gross profit tell us?

  • Profit margin (%)
    • gp_margin
  • Analyze the profitability of our core product
  • Calculate the break even point
break_even = fixed_costs/(sp - variable_costs)
Python ile Finansal Tahminleme

Let's practice!

Python ile Finansal Tahminleme

Preparing Video For Download...