الفهرس 
IntroductionOnly 14 pages are availabe for public view
 |  | from | 152 |  |  |
| | | from | 152 | | |
Abstract
This study investigates how to get the optimum aggregate production plan in order to minimize the total production cost, maximize the total profit, increase the return on investment, and consequently strengthen the national economy.
To achieve so, two integrated production planning, distribution, and investment model was developed for two multinational firms working in Egypt; Nissan (vehicle industry) and Ridgewood (water desalination). Two ALP models have been developed in order to cover the continuous type of production and service, whereas two Excel data solver techniques have been used to solve these ALP models.
ALP model could not be developed at first in case of water desalination because there was no finished product inventory. Therefore, Six Sigma project has been implemented in the case of water desalination in order to solve this problem. The DMAIC methodology has been applied while the water desalination methods have been surveyed and the problem has been defined through the Define phase. Several alternatives have been studied through the Analyze phase. Moreover, the most feasible alternative discovered is to apply a new technology of storing the product water underground which is called ASR. Then the aggregate planning model has been developed and implemented to determine the optimum monthly production through the Improved phase.
The models and the techniques have been applied on both firms for one fiscal year. Comparing the results of our study against the normally planned production outcome, a saving for about (8%) has been achieved in case of Nissan and about (5.9 %) in case of Ridgewood..