Exercise

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

Instructions 1/3

undefined XP
    1
    2
    3
  • Create a dependencies() function for sales and costs with the arguments base_cost_price,base_sales_price, and sales_usd. Pass the arguments into the function in this order.
  • Create the res list that will generate the forecast list.
  • Have dependencies() return the resulting new quarter alternate forecast list.