Building an alternate forecast
We will now build an alternative forecast for Txs Tools. The new quarter forecast is based off actual data for Jul - Aug as well as adjusted forecast data for September. The data (units sold) is as follows:
Jul = 700
Aug = 220
Sep = 520
The dependencies calculations have already been completed from the previous exercise. The following information applies:
base_cost_price = 7
base_sales_price = 15
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.
def ____(____, ____, ____):
res = []
for sales in sales_usd:
if sales >= 350:
sales_dep = (350 * base_sales_price) + ((sales - 350) * (base_sales_price - 1))
else:
sales_dep = sales * base_sales_price
if sales >= 500:
cost_dep = (500 * base_cost_price) + ((sales - 500) * (base_cost_price + 2))
else:
cost_dep = sales * base_cost_price
res.append(sales_dep - cost_dep)
return ____