September 23, 2021
CHALLENGE
A global aircraft lessor needed to perform what-if workload planning and analysis for contract managers’ workloads.
Zeevo Group worked with the lessor to develop an end-user tool that enabled management to perform what-if scenario workload planning and results analysis via a suite of BI dashboards and reports.
APPROACH
- Developed an MS Excel end-user tool to enable the creation of workload what-if scenarios based on the macro-enabled extraction of lease agreement and contract manager data from Leasepoint®
- Identified transaction types, task milestones, and lead and lag times, as well as the required resource allocation and impact factor input parameters
- MS Excel end-user tool used macros to format and save the what-if scenario data to the reporting data warehouse
OUTCOME
- The client benefited from an end-user tool that provided management with the ability to perform on-demand what-if versus actual workload planning and analysis for contract managers
- Available dashboard and business intelligence reports for reviewing the current actual workload plan and different what-if workload scenario results
- Lessor gained early visibility into upcoming transaction processing and resource allocation issues
ZEEVO’S VALUE ADD
- In-depth knowledge of Leasepoint, including the underlying data model
- Designed, developed, and implemented the MS Excel end-user tool
- Designed, developed, and implemented the Leasepoint integration and the requested business intelligence reports
DOWNLOAD CLIENT CASE STUDY (.pdf)
Related reads:
- Implementing an End-user Tool to Track International Interest and Contract of Sale Details for Registry Filing Transactions
- Implementing a Power BI-driven Report Solution Integrated with Leasepoint for Aircraft and Engine Insurance Coverage Review
- Implementing the Integration Solution for Fleet and Contract Summary Data between Leasepoint and Microsoft Dynamics CRM
- Creating Master List of Overdue Terms and Remediating Applicable Payment Schedules and Invoice Templates in Leasepoint
- Deploying Power BI Dashboard to Automate Reporting of Contract Summary and Asset Data from Leasepoint
- Boosting Reporting Capabilities with a Power BI Business Intelligence Tool
- Deploying a Solution to Perform Repeatable Fleet Utilization Analysis
- Designing and Implementing a Technical Specification Report with an Optimized ADS Template
- Enhancing Aircraft Technical Project Management with Web Application Integrating Fleet and Contract Summary Data
- Automating Aircraft Transition Reporting to Ensure Compliance with Lease Obligations
- Maintaining Accurate Utilization and Technical Data for Aircraft Components
- Sourcing, Inputting, and Validating Technical and Contractual Data in Leasepoint
LET’S TALK
John McCartney
Phone: +1 760 933 8607
jmccartney@zeevogroup.com