dynamic demand inventory control system by supamas viriyanusorn jitrayut junnapart
TRANSCRIPT
![Page 1: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/1.jpg)
Dynamic Demand Inventory Control System
By
Supamas Viriyanusorn
Jitrayut Junnapart
![Page 2: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/2.jpg)
Background
Inventory level of raw material is very important to operational of a manufacturing firm, it must be kept and monitored very well. Inventory control system can make this job easier.
![Page 3: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/3.jpg)
Concept of Inventory Control
There are three main kinds of inventory models:
1.Economic Order Quantity (EOQ) model
2.Economic Production Lot-Size model
3.Inventory model with Planned Shortage
![Page 4: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/4.jpg)
Economic Order Quantity model
Economic Order Quantity (EOQ) that the shortage of raw material is not allowed will be applied in this project
Concept of Inventory Control
![Page 5: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/5.jpg)
It is very important that the order is placed at the right time and for the right quantity.
Too large ordering quantity and the part is used up too slow increase carrying cost while too few ordering quantity will create high ordering cost (telephone, fax, etc.) because that must be done very often.
Economic Ordering Quantity
![Page 6: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/6.jpg)
Both reorder point and quantity can be calculate as:
Qor = (dmd) x (Lt) and
Qopt = (2CoD/Cc)1/2 Where Qor : Reorder point
Qopt : Optimum Ordering Quantity
dmd : Demand per day
Lt : Lead time (day)
Co : Ordering Cost per time
Cc : Carrying Cost per unit per day
Economic Ordering Quantity
![Page 7: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/7.jpg)
Reorder point and quantity
Economic Ordering Quantity
![Page 8: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/8.jpg)
The most important point is to track changing demand of each item in the system by monitoring time and quantity that each item is withdrawn. This withdrawal time and quantity can be used to calculate the current demand.
Economic Ordering Quantity
![Page 9: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/9.jpg)
1. File system: There are 2 main file types in this project
– Inventory data files – Part index file
Computer Program Development
![Page 10: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/10.jpg)
- Inventory data file: Each inventory has its own data file. There are 8 attributes that represent detail for each item
• Part name • Quantity• Demand or usage rate• Lead time
• Order Cost per time• Carrying Cost • Time having the Quantity• Status of the item
Computer Program Development
![Page 11: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/11.jpg)
- Part index file: A single file that contains current active part numbers in the system. The content of part index file is the name list of active inventory number.
Computer Program Development
![Page 12: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/12.jpg)
There are 9 functions of program:
1. List up part
This is the function that let the user know what part are in the system.
2. Add new part into system
This function is for adding new inventory item to the system.
Computer Program Development
![Page 13: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/13.jpg)
9 functions of program (continued):
3. Calculate
This function is for calculate data in the program.
4. Withdrawal part
This function is for user to withdraw inventory item from the system.
Computer Program Development
![Page 14: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/14.jpg)
9 functions of program (continued):
5. Update for part ordered
This function is for update data when reordering has been made for items.
6. Fill up inventory
This function is for user to fill up the material when reordered parts arrive at storage area.
Computer Program Development
![Page 15: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/15.jpg)
9 functions of program (continued):
7. Overwrite Part Data
This function is an engineering than user’s function. It must be used with care.
8. Remove Part
Once an item will not be used anymore, this function will be invoked to remove the part from the system.
Computer Program Development
![Page 16: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/16.jpg)
9 functions of program (continued):
9. Exit
This is used to exit from the program without perform any action
Computer Program Development
![Page 17: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/17.jpg)
After complete the program coding and preliminary test, the system is entered with inventory data. The program uses text menu to interface with users.
Main menu of program has 9 choices to select. They are:
Implementation
![Page 18: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/18.jpg)
1.List up part
To list up all the parts in system. Output types can be chosen
Parts list up
Implementation
![Page 19: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/19.jpg)
Add new part into system
2. Add new part into system
A new part can be added into the system using this function
Implementation
![Page 20: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/20.jpg)
Calculate for reordering and quantity
3.Calculate
Option 3 performs calculation, then informs user items and quantity that are needed to reorder.
Implementation
![Page 21: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/21.jpg)
Withdrawal part
4.Withdrawal part
When item is pulled out from store, this function cuts the remaining quantity from system
Implementation
![Page 22: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/22.jpg)
After withdrawal
Quantity of part number 2 reduces to 280
4.Withdrawal part (continued)
Implementation
![Page 23: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/23.jpg)
Update part ordered
5. Update for part ordered
Option 5 is for update to the system that an item has been reordered.
Implementation
![Page 24: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/24.jpg)
Fill up inventory
For part number 2 of 148 units
6. Fill up inventory
Adjust quantity of part in the system once the order is delivered.
Implementation
![Page 25: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/25.jpg)
Quantity of part 2 after fill up
The part’s quantity increase to 428 units
6. Fill up inventory (continued)Implementation
![Page 26: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/26.jpg)
Overwrite part data
7. Overwrite part’s data
This option is an engineering function than user function. It should be used with care.
Implementation
![Page 27: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/27.jpg)
Part Removal
8. Remove part
Option 8 removes part from the system in case that the part is not used anymore.
Implementation
![Page 28: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/28.jpg)
9.Exit
This function is provided for the case that user wants to quit from the program without doing any function.
Implementation
![Page 29: Dynamic Demand Inventory Control System By Supamas Viriyanusorn Jitrayut Junnapart](https://reader036.vdocuments.us/reader036/viewer/2022062318/5514d442550346b0478b512e/html5/thumbnails/29.jpg)
Conclusions
Inventory control can be done very well with help from computer programming. The program from this project can accept and build data files for each inventory item. The data file records name of the part, quantity, current demand, ordering lead-time, ordering cost, carrying cost, time having that quantity, and status of the item. The program recalculates for demand and can well inform user to order part with most economical ordering quantity.