Buy, Rent and Sale: Chasing better cash flows
Name
Monsalve et al_2023.pdf
Description
Capstone project
Size
654.46 KB
Format
Adobe PDF
Checksum (MD5)
b307f9f91a0b7b2905b8742cf737cb57
Author(s)
Do Couto Selem, Ana Patricia
Oyarzun Rodriguez, Juan Marcelo
Monsalve Uribe, Ricardo Leon
Date Issued
April 2, 2025
Abstract
This capstone project optimizes the inventory levels of a rental car company and improves the cash-to-cash cycle. The solution approach is a Mixed Integer Linear Program (MILP) model, considering a multiple-period inventory. The model provides purchasing and selling plans and cash and vehicle flow in the system for each quarter and each type of vehicle for five years. The analytical model was created to maximize the company’s gross margin, considering revenues from renting and sales, cost buy, opportunity cost, and general cost (maintenance, holding, and others). Moreover, it considers an initial inventory and helps the company manage these assets in the best way possible to meet the demand. The result shows an optimal solution of 3.3 billion Colombian pesos (COP) for five years in the base case scenario. Afterward, a sensitivity analysis for different perspectives related to renting period, budget, depreciation rate, and exchange rate impact was carried out. From that perspective, it is possible to understand that the primary trigger to create revenue is extending the renting period. Moreover, the sponsor company can interpret how factors in the market affect the total result success and create an action plan to anticipate these risks.
Subjects
dynamic-inventory management
cash-to-cash cycle
inventory-finance decision
Terms of Use
CC0 1.0 Universal
Persistent DSpace Link
