Weekly purchasing budgets
From sales inputs to a budget for each location.
Weekly sales figures and purchasing rules need to be brought together before each location receives its budget.
Power Automate brings together sales data and Excel budget inputs, applies the agreed calculations and prepares location and management emails.
Each location receives its purchasing budget in a consistent format, with a consolidated view for management.
Tools used Power Automate, Excel, Business Central, Outlook