Project Budget Tracking – power apps

Challenge

  • The client is a government contractor who supplies technological resources and solutions to US government
  • The client wanted a tracker to manage the project billing and resources and overall progress of multiple projects
  • Required formulas and customization are  to be implemented to achieve the form
  • Various details like contract type, status, contact details , funding expenditure can be captured, edited and
  • Form functionality is designed to evaluate the details entered and update the required field status

Solution

  • SharePoint site is built using Power Apps
  • Required customization and formulas are applied to successfully implement the form
  • User can create, edit and view the records using different
  • User can delete , save and add comments wherever
  • Various field data is evaluated and formulas are applied to calculate funding expenditure , (if more than or less than 70%) , based on the user submitting the expenditure details .

Impact

  • Increased project visibility to management
  • Automated Notifications for better tracking on escalations