Staff Cost Allocation Input Back

Customer

A developer, investor, and operator of power production and desalination facilities, our client has numerous assets under construction, operation, or advanced development in 13 nations. They can produce 6.2 million m3/day of desalinated water from their portfolio, which has an investment value of more than USD 66.5 billion and can create 42.7 GW of power. They develop environmentally friendly business practices to save the environment for future generations.

Industry Electricity
Technology Power Apps
Challenge

The intricate Excel worksheet that was utilized to help with the staff cost allocation process grew so difficult to use and understand that only a small number of people had complete control over its pivot tables, macros, and calculations.

The method was laborious, time-consuming, prone to mistakes, and inaccurate in its existing state. Manual Processes of cost allocation to the staff were difficult. Teams typically manually copy and paste data into another system, such as Excel, to extract pertinent information from emails. Our client was no different in this regard. The information on each new cost for each staff was manually entered into a spreadsheet to determine the cost allocation capacity and approvals.

Solution

The TechnomaX team prepared an assessment of the entire procedure, made recommendations, and put through a power app into place. Reminders are now sent, data is checked for accuracy, and then it is linked and fed into the new system. The data is updated and closed quarterly.

Benefits
  • Automating the process of cost allocation and billing for shared services
  • Less effort is needed to organize, prepare, and create shared service invoices for international clients.
  • Budgeting procedures that are simplified and simply compared.
  • Compared actual expenses to budgeted expenditures.
  • Improved disclosure of the cost allocation calculation
  • Increased accuracy and transparency while reducing labor expenses and improving efficiency
  • The adoption of automation has reduced the amount of time spent each month on data validation and manual process execution by a total of 25 hours.
  • Automating report-sending reminders
  • Due to Power Automate’s complete control over status monitoring, there is no longer any need to keep track of various threads in the inbox.