Get startedGet started for free

Building a sensitivity analysis for gross profit

Txs Tools is now ready to use these dependencies in the gross profit forecast.

The following forecast unit sales have been provided:

Jul = 700 Aug = 350 Sep = 650

The dependencies for sales and cogs are based on the following:

  • Sales dependency sales_dep: The sale price is the net price after 1 USD commission. Commissions paid increase from 1 USD per unit to 2 USD per unit for every unit above 350 units sold.
  • Cost dependency cost_dep: When sales per unit increase above 500 units, an additional production line needs to be used, causing an increase in the cost per unit above 500 of 2 USD per unit.

The basic cost price base_cost_price = 7 and basic sales price base_sales_price = 15 has already been set.

This exercise is part of the course

Financial Forecasting in Python

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Create the sales_usd list
sales_usd = [____, ____, ____]
Edit and Run Code