Implementation of Annual Budgeting Process for a leading liquor manufacturer based out of India

Customer is one of the largest manufacturers of Indian Made Foreign Liquor (IMFL) in India.
It has a total production capacity of nearly 200 million liters and operates 25+ bottling units across the country.
The Key Business verticals include export supply, domestic, and defense supply.
One of the largest providers of IMFL to the Canteen Store Departments of GOI.

End-to-End planning process from Quantity Planning, Overhead Cost Planning, Royalty and Other Income to Cost Cards and Financial Statements planning.

Project Scope: It covered the automation of the following Planning Processes.

Sales Quantity Plan
Production Quantity Plan
Overhead Cost Plan
Royalty and Other Income Plans
Sales and Distribution Expenses Planning
State-wise Cost Cards Plan to calculate MRP of Cases, Net Contribution using Production Mix Ratio
Implementation of Complex scenarios considering logic to calculate duties and taxes defined by relevant SGs
Cost of Production Planning

State-wise Cost Sheets using dynamic calculation logics considering state-wise variations.
Planned Financial Statements at Plants, State and Country level by considering Planned values using system and linking them with Financial GL codes.
Significant reduction in Planning time because of seamless data integration, inbuilt logic in the system, and higher accuracy because of minimal manual intervention.
Overall P&L Report by consolidating data from Three Models, 5 Centralized Reports, and 27 State-wise Cost-sheets.
Scenario analysis using data on different versions of Actual, Plan and Forecast.
Ensured authorized access by assigning roles to regional and admin users, setting up DAC at Model Level, and viewing, editing, and deleting rights at the story level.