Full Text Available
Note: Clicking the button above will open the full text document at the original institutional repository in a new window.
Optimization of Contractor’s Cash Flow Based on Subcontractor’s Payment Management Plans
In many counties, the construction industry relies heavily on outsourcing packages to execute their projects and expand their businesses to fit in the diverse market. Such extensive integration of outsourced subcontractors is becoming an influential factor in contractors' cash flow management. Accor...
Saved in:
| Main Author: | |
|---|---|
| Format: | Thesis |
| Published: |
AUC Knowledge Fountain
2023
|
| Subjects: | |
| Tags: |
No Tags, Be the first to tag this record!
|
| _version_ | 1867613422093336576 |
|---|---|
| access_status_str | Open Access |
| author | Ghali, Helen |
| author_browse | Ghali, Helen |
| author_facet | Ghali, Helen |
| author_sort | Ghali, Helen |
| collection | Thesis |
| description | In many counties, the construction industry relies heavily on outsourcing packages to execute their projects and expand their businesses to fit in the diverse market. Such extensive integration of outsourced subcontractors is becoming an influential factor in contractors' cash flow management. Accordingly, subcontractors’ price selection and their respective payment plans are important phenomena and pivotal components for the well-being of the contractor’s cash flow. Cash flow management is considered one of the most critical areas analyzed by contractors when getting into a project. Contractor’s cash flow is built from a pool of interrelated information depending on subcontractors, suppliers trade credit arrangement with the contractor, owner payment terms and the project schedule. Various researchers have developed models to optimize contractors’ cash flow financing costs however considering that activities are self-executed and neglect the subcontractor’s credit arrangements. Accordingly, limited research is available on a near-real presentation of a contractor’s cash flow model including the different subcontracted packages with their payment conditions. Also, during project procurement of subcontracting packages, contractors are usually presented with different subcontracting prices and payment conditions in which the contractor base its selection on the least price with little investigation of the effect on the contractor’s cash flow. Accordingly, the purpose of this work is to study the contractor’s cash flow with respect to the owner and subcontractor’s payment management plans. A model structure is developed to provide contractors with a cash flow profile that considers subcontracting of packages with variable payment conditions as advance payment, payment frequency, payment lag and retention percentages. The model is also used as a decision tool to assist contractors in evaluating different subcontractors’ commercial offers and their payment conditions and select the optimum subcontracting plan that minimizes the contractor’s negative cash flow and reduces its financing requirements. It helps contractors in selecting the optimum subcontracting combinations to reduce the required liquidity and increase contractor’s profits. The model is built using Microsoft Excel and a VBA user customized function to allow for dynamic integration of subcontractor’s payment conditions into contractor’s cash-out graph. Two different objective functions are considered namely maximizing the highest negative overdraft value and maximizing net present worth of the contractor’s net cash flow values. The results from the two objective functions are analyzed and the performance of both has shown potential uses in devising an optimum combination. The model is first developed on a prototype project which encompasses subcontracted activities and self-performed works and the prototype results of the two objective functions are discussed, then a sensitivity analysis is carried out on contractor’s cash flow objective functions when varying the subcontractor’s payment conditions. Finally, the model is validated on a full-scale project and the outcomes and results of the model are analyzed. |
| format | Thesis |
| id | oai:fount.aucegypt.edu:etds-3072 |
| institution | American University in Cairo (Egypt) |
| last_indexed | 2026-06-10T12:35:53.165Z |
| license_str | Not specified — see source repository |
| provenance_str_mv | Harvested via OAI-PMH from AUC Knowledge Fountain — bepress |
| publishDate | 2023 |
| publishDateRange | 2023 |
| publishDateSort | 2023 |
| publisher | AUC Knowledge Fountain |
| publisherStr | AUC Knowledge Fountain |
| record_format | dspace |
| source_str | AUC Knowledge Fountain — bepress |
| spelling | oai:fount.aucegypt.edu:etds-3072 Optimization of Contractor’s Cash Flow Based on Subcontractor’s Payment Management Plans Ghali, Helen In many counties, the construction industry relies heavily on outsourcing packages to execute their projects and expand their businesses to fit in the diverse market. Such extensive integration of outsourced subcontractors is becoming an influential factor in contractors' cash flow management. Accordingly, subcontractors’ price selection and their respective payment plans are important phenomena and pivotal components for the well-being of the contractor’s cash flow. Cash flow management is considered one of the most critical areas analyzed by contractors when getting into a project. Contractor’s cash flow is built from a pool of interrelated information depending on subcontractors, suppliers trade credit arrangement with the contractor, owner payment terms and the project schedule. Various researchers have developed models to optimize contractors’ cash flow financing costs however considering that activities are self-executed and neglect the subcontractor’s credit arrangements. Accordingly, limited research is available on a near-real presentation of a contractor’s cash flow model including the different subcontracted packages with their payment conditions. Also, during project procurement of subcontracting packages, contractors are usually presented with different subcontracting prices and payment conditions in which the contractor base its selection on the least price with little investigation of the effect on the contractor’s cash flow. Accordingly, the purpose of this work is to study the contractor’s cash flow with respect to the owner and subcontractor’s payment management plans. A model structure is developed to provide contractors with a cash flow profile that considers subcontracting of packages with variable payment conditions as advance payment, payment frequency, payment lag and retention percentages. The model is also used as a decision tool to assist contractors in evaluating different subcontractors’ commercial offers and their payment conditions and select the optimum subcontracting plan that minimizes the contractor’s negative cash flow and reduces its financing requirements. It helps contractors in selecting the optimum subcontracting combinations to reduce the required liquidity and increase contractor’s profits. The model is built using Microsoft Excel and a VBA user customized function to allow for dynamic integration of subcontractor’s payment conditions into contractor’s cash-out graph. Two different objective functions are considered namely maximizing the highest negative overdraft value and maximizing net present worth of the contractor’s net cash flow values. The results from the two objective functions are analyzed and the performance of both has shown potential uses in devising an optimum combination. The model is first developed on a prototype project which encompasses subcontracted activities and self-performed works and the prototype results of the two objective functions are discussed, then a sensitivity analysis is carried out on contractor’s cash flow objective functions when varying the subcontractor’s payment conditions. Finally, the model is validated on a full-scale project and the outcomes and results of the model are analyzed. 2023-01-31T08:00:00Z thesis application/pdf https://fount.aucegypt.edu/etds/2040 https://fount.aucegypt.edu/context/etds/article/3072/viewcontent/Helen_Saher_Ghali_Thesis.pdf Theses and Dissertations AUC Knowledge Fountain cash flow optimization payment plan payment management subcontractor payment Construction Engineering and Management |
| spellingShingle | cash flow optimization payment plan payment management subcontractor payment Construction Engineering and Management Ghali, Helen Optimization of Contractor’s Cash Flow Based on Subcontractor’s Payment Management Plans |
| title | Optimization of Contractor’s Cash Flow Based on Subcontractor’s Payment Management Plans |
| title_full | Optimization of Contractor’s Cash Flow Based on Subcontractor’s Payment Management Plans |
| title_fullStr | Optimization of Contractor’s Cash Flow Based on Subcontractor’s Payment Management Plans |
| title_full_unstemmed | Optimization of Contractor’s Cash Flow Based on Subcontractor’s Payment Management Plans |
| title_short | Optimization of Contractor’s Cash Flow Based on Subcontractor’s Payment Management Plans |
| title_sort | optimization of contractor s cash flow based on subcontractor s payment management plans |
| topic | cash flow optimization payment plan payment management subcontractor payment Construction Engineering and Management |
| url | https://fount.aucegypt.edu/etds/2040 https://fount.aucegypt.edu/context/etds/article/3072/viewcontent/Helen_Saher_Ghali_Thesis.pdf |
| work_keys_str_mv | AT ghalihelen optimizationofcontractorscashflowbasedonsubcontractorspaymentmanagementplans |