Hi, Sheet 1 in the excel file is empty, but I understand your needs and also I have the experience in forecasting via inventories.
I served as Chief Accountant at global parent companies. I have experience with implementing information systems in organizations and businesses (Intuit QuickBooks, SAP, ERP, etc.), within a multi-currency environment and the global marketplace, especially, in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, collections, payments, and taxation. Also, For more than 30 years I have used ERP's (like SAP) to conduct inventories and COGS.
I am a guru in Excel and VBA. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. With these skills, I develop financial modules including business valuation methodology & ratios for investors (including pitch decks, business plans, due diligence, financial modules like feasibility studies, and financial projections with dynamic scenarios).