Budget Forecast

At the Fiscal year, the entire budget is prepared and forecasted based on the previous year spent. Major expenditures are taken into consideration carefully under each expense heads and if required more budget are allocated for the current Financial Year.

The budget is initially prepared for the entire Fiscal Year. Based on Quarterly actuals, the budget can be increased or decreased for the next quarter (or) for next half-yearly.

Actual Spent

Against each budgeted line time, the actual spent is entered and monitored category wise. This would provide us an indication on the actual amount spent is above (or) within the budget. The entire annual budget is broken down into 12 months based on the fiscal year and the actual amount spent is tracked against each budgeted line item monthly. This will provide the variance (+/-) based on the monthly budgeted forecast. The system would derive the Cost/Sq. Ft. and Cost/Employee based on the total Sq. Ft. Occupied and Total headcount of employees in the premises.

Financial Reporting

Based on the data fed, the system could generate Financial reports for each quarter, half-yearly and annually with variance analysis. The forecast would predict the variance, cost/sq. ft. and cost/employee based on the previous quarter results if there is any increase or decrease based on the goal set. If the goal is changed with parameters, the results would change and we can save the reports with different goal sets and objectives.

Data Analytics

With Tableau, the system can generate different analytics with historic financial data for last 3 years (or) 5 years. The financial data of each quarter can be compared with other quarters of current Financial Year and previous quarters of Financial Year with scenario’s defined in the system.