We are seeking the development of a tool — either an Excel Macro (VBA) or a Python script — that incorporates a solver to optimize the management and assignment of a naval fleet’s crew. The main goal is to generate an optimal personnel plan, considering multiple operational and financial constraints. The system should be capable of performing, among others, the following tasks: Manage two vessels, each with two possible operational states: Sailing or In Port. Define crew requirements by position for each vessel and operational state. Consider a list of permanent employees and temporary (relief) personnel. Assign each employee their specific rank and role (Captain, Sailor, etc.). Suggest the optimal crew allocation for both vessels based on the expected operations. Implement a solver that evaluates and proposes the best personnel strategy, taking into account financial and operational factors such as: The cost of personnel termination. The company’s current cash position. The cost difference between hiring temporary staff and maintaining permanent employees. We are looking for a robust and reliable solution that enables the company to make data-driven decisions, maximize operational efficiency, and minimize costs related to crew management.