Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office
Manufacturing industry will receive a large amount of customer orders according to its capacity to achieve enough business profit, so order scheduling is important to assign the production orders to various work stations in the plant. In fact, the existing file of Excel will contain clusters of da...
| Main Author: | |
|---|---|
| Format: | Monograph |
| Language: | English |
| Published: |
Universiti Sains Malaysia
2018
|
| Subjects: | |
| Online Access: | http://eprints.usm.my/54227/ http://eprints.usm.my/54227/1/Development%20Of%20Decision%20Support%20System%20For%20Scheduling%20Machine%20Loading%20By%20Using%20Microsoft%20Office_Khiew%20Fook%20Yun_M4_2018.pdf |
| _version_ | 1848882745482149888 |
|---|---|
| author | Khiew, Fook Yun |
| author_facet | Khiew, Fook Yun |
| author_sort | Khiew, Fook Yun |
| building | USM Institutional Repository |
| collection | Online Access |
| description | Manufacturing industry will receive a large amount of customer orders according to its capacity to achieve enough business profit, so order scheduling is important to assign the
production orders to various work stations in the plant. In fact, the existing file of Excel will contain clusters of data stored and the clusters of data are required to be managed orderly and this will cause to a failure for Excel to update new information which cause the industry to face problems. Therefore, Microsoft Access is introduced to use with Microsoft Excel because both tools are essential to be practised for managing the customer order data. The aim of this design project is to create a template for storing data and scheduling the machine loading by using Microsoft Access with assist of Microsoft Excel. By using Microsoft Access, database is created and used as a storage for the company to keep updating the new information since the records are free in database and kept unchanged overtime. Moreover, using Excel in this design made it easy to perform numerical calculations, format cells, and
adjust layouts to generate the output for sequencing machine loadings. Priority rules such as Earliest Due Date (EDD) and Shortest Processing Time (SPT) were used for sequencing the
jobs. In general, the SPT priority rule pushes most loads through the system to completion more quickly than will the EDD rule. Speed can be an advantage, but only if loads can be
delivered sooner than promised and revenue collected earlier. However, EDD rule can manage the jobs to be completed on time. All the results are the reference for the company to
do decision making according its competitive priorities. |
| first_indexed | 2025-11-15T18:39:48Z |
| format | Monograph |
| id | usm-54227 |
| institution | Universiti Sains Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T18:39:48Z |
| publishDate | 2018 |
| publisher | Universiti Sains Malaysia |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | usm-542272022-08-22T09:41:13Z http://eprints.usm.my/54227/ Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office Khiew, Fook Yun T Technology TJ Mechanical engineering and machinery Manufacturing industry will receive a large amount of customer orders according to its capacity to achieve enough business profit, so order scheduling is important to assign the production orders to various work stations in the plant. In fact, the existing file of Excel will contain clusters of data stored and the clusters of data are required to be managed orderly and this will cause to a failure for Excel to update new information which cause the industry to face problems. Therefore, Microsoft Access is introduced to use with Microsoft Excel because both tools are essential to be practised for managing the customer order data. The aim of this design project is to create a template for storing data and scheduling the machine loading by using Microsoft Access with assist of Microsoft Excel. By using Microsoft Access, database is created and used as a storage for the company to keep updating the new information since the records are free in database and kept unchanged overtime. Moreover, using Excel in this design made it easy to perform numerical calculations, format cells, and adjust layouts to generate the output for sequencing machine loadings. Priority rules such as Earliest Due Date (EDD) and Shortest Processing Time (SPT) were used for sequencing the jobs. In general, the SPT priority rule pushes most loads through the system to completion more quickly than will the EDD rule. Speed can be an advantage, but only if loads can be delivered sooner than promised and revenue collected earlier. However, EDD rule can manage the jobs to be completed on time. All the results are the reference for the company to do decision making according its competitive priorities. Universiti Sains Malaysia 2018-06-01 Monograph NonPeerReviewed application/pdf en http://eprints.usm.my/54227/1/Development%20Of%20Decision%20Support%20System%20For%20Scheduling%20Machine%20Loading%20By%20Using%20Microsoft%20Office_Khiew%20Fook%20Yun_M4_2018.pdf Khiew, Fook Yun (2018) Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office. Project Report. Universiti Sains Malaysia, Pusat Pengajian Kejuruteraan Mekanikal. (Submitted) |
| spellingShingle | T Technology TJ Mechanical engineering and machinery Khiew, Fook Yun Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office |
| title | Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office |
| title_full | Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office |
| title_fullStr | Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office |
| title_full_unstemmed | Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office |
| title_short | Development Of Decision Support System For Scheduling Machine Loading By Using Microsoft Office |
| title_sort | development of decision support system for scheduling machine loading by using microsoft office |
| topic | T Technology TJ Mechanical engineering and machinery |
| url | http://eprints.usm.my/54227/ http://eprints.usm.my/54227/1/Development%20Of%20Decision%20Support%20System%20For%20Scheduling%20Machine%20Loading%20By%20Using%20Microsoft%20Office_Khiew%20Fook%20Yun_M4_2018.pdf |