تجاوز إلى المحتوى الرئيسي
User Image

Dr. BOKKASAM SASIDHAR

Professor

PROFESSOR

كلية إدارة الأعمال
Building No. 67, Second Floor, Office No. S280
المنشورات
مقال فى مجلة
2019

Scheduling in a Single-stage, Multi-item Compatible Process using Multiple Arc Network with Gains Model using Excel Solver

Sasidhar, Bokkasam . 2019

Availability of Solver package in Microsoft Excel has increased the use of spreadsheet optimization models by functional managers and industry experts. This has enabled the industries to explore a more customer driven approach to production scheduling. In reality, the customers’ orders are categorized as either normal or prioritized, keeping in mind the customers’ priorities. The problem of scheduling a given set of equipments in a single-stage, multi-item compatible environment, with the objective of maximizing capacity utilization has been formulated (Bokkasam, 2018) as a maximal flow problem in a Multiple Arc Network (MAN) with gains. This methodology takes into account the stage yield for the product as well, which reflects the actual quantity of material delivered to the customer. This enables direct comparison of the production with the ordered quantities. The methodology provides optimal production schedule with an objective of maximizing capacity utilization, so that the customerwise delivery schedules are fulfilled, keeping in view the priorities of the customers. The results of a working implementation of the MAN with gains model using excel solver are presented in this paper. The same has been validated with results obtained using two examples. In future the managers will be able to use the worksheet for obtaining the results immediately, for scaled-up scenarios.

رقم المجلد
5
رقم الانشاء
8
مجلة/صحيفة
http://www.ijarem.org/papers/v5-i8/8.IJAREM-D5076.pdf
الصفحات
40-49
مزيد من المنشورات
publications

The importance of scheduling in the industrial world is growing rapidly. Customer-driven production scheduling is the need of the hour in the present business environment.

بواسطة Bokkasam Sasidhar
2023
تم النشر فى:
Asian Journal of Advances in Research
publications

Fixed charge transportation problem (FCTP), which can be considered as a
distribution problem, is considered to be an NP-hard problem. One of its versions is the Step Fixed
charge…

بواسطة Mahmoud M. El-Sherbiny, Ibrahim A. Aljasser, Bokkasam Sasidhar
2021
تم النشر فى:
International Journal of Advance Engineering and Research Development
publications

Service quality is a competitive weapon in the banking industry. Better understanding of customer’s perception
of service quality in the banking industry and the drivers of such perceptions…

بواسطة Ibrahim Abdullah Aljasser, Bokkasam Sasidhar
2019