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
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Create the sales_usd list
sales_usd = [____, ____, ____]