Assigning dependencies for sales and COGS

Txs Tools have built a monthly forecast for their gross profit. However, this is a very time-consuming process, as several dependencies have to be manually altered every month.

Set the dependencies for sales and cogs based on the below information:

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 baseline sale price per unit (base_sales_price) is 15 USD and the baseline cost per unit (base_cost_price) is 7 USD.

1
- Use an if statement for when sales are greater than or equal to 350 units, as there is a change in how the base_sales_price is applied.
- Using the predefined variables, set the dependency calculations to sales_dep and print sales_dep.
2
- Use an if statement for calculations when sales is greater or equal to 500 units.
- Using the predefined variables base_cost_price, set the dependency calculations to cost_dep and print cost_dep.

Exercise

Assigning dependencies for sales and COGS

Instructions 1/2