Do you sell a range of products that you manufacture or assemble.
A well-constructed financial model driven by a sales unit forecast and fed by product price, component assembly lists and cost tables will output Sales $, component demand and individual product profit forecasts.
Include component order lead times and minimum stock levels and output component order forecasts.
Include expenses and produce 3 way financials – profit & loss, cash flow and balance sheet.
Build it with the ability to flex key variables and you will be able to run scenarios to test different sales, costs combinations.
Keep your sales unit forecasts and input tables live (up to date) and it will be a powerful tool for decision making/managing your business.