Get startedGet started for free

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

View Course

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 ____
Edit and Run Code