Skip to main content

2016 | OriginalPaper | Buchkapitel

Excel Solver for Deterministic Inventory Model: INSOLVER

verfasst von : Pratiksha Saxena, Bhavyanidhi Vats

Erschienen in: Information Systems Design and Intelligent Applications

Verlag: Springer India

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

An excel solver is proposed for optimized result of deterministic inventory models. Seven inventory models including price break models can be solved by using this Excel Solver. This solver is designed by using yes-no algorithm. INSOLVER has benefit of solving even quantity discount inventory models with different price breaks, which makes it unique.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat T.C.E Cheng,: An EOQ model with demand dependent unit production cost and imperfect production processes. IEEE Transactions, 23, 23–28 (1991). T.C.E Cheng,: An EOQ model with demand dependent unit production cost and imperfect production processes. IEEE Transactions, 23, 23–28 (1991).
2.
Zurück zum Zitat Carl R. Scuhltz,: Forecasting and Inventory Control for sporadic demand under periodic review. The Journal of the Operations Research Society, 38(5), 453–458 (1987). Carl R. Scuhltz,: Forecasting and Inventory Control for sporadic demand under periodic review. The Journal of the Operations Research Society, 38(5), 453–458 (1987).
3.
Zurück zum Zitat Zvi Drzener, HareshGurnani and Barry A. Pasternack,: An EOQ Model with substitutions between products. Journal of the Operations Research Society, 46(7), 887–891 (1995). Zvi Drzener, HareshGurnani and Barry A. Pasternack,: An EOQ Model with substitutions between products. Journal of the Operations Research Society, 46(7), 887–891 (1995).
4.
Zurück zum Zitat Sameer Prasad,: Classification of Inventory Models and Systems. International Journal of Production Economics, 34, 309–322 (1994). Sameer Prasad,: Classification of Inventory Models and Systems. International Journal of Production Economics, 34, 309–322 (1994).
5.
Zurück zum Zitat Wedad Elmaghraby, Pinar Keskinocak,: Dynamic Pricing in the presence of Inventory Considerations: Research Overview, Current Practices and Future Directions. Management Science, 49(10), 128–1309 (2003). Wedad Elmaghraby, Pinar Keskinocak,: Dynamic Pricing in the presence of Inventory Considerations: Research Overview, Current Practices and Future Directions. Management Science, 49(10), 128–1309 (2003).
6.
Zurück zum Zitat Cengiz Haksever, John Moussourakis,: A model for optimizing multi product inventory systems with multiple constraints. International Journal of Production Economics, 97, 18–30 (2005). Cengiz Haksever, John Moussourakis,: A model for optimizing multi product inventory systems with multiple constraints. International Journal of Production Economics, 97, 18–30 (2005).
7.
Zurück zum Zitat S. Bose, A. Goswami, K.S. Chaudhuri,: An EOQ Model for Deteriorating Items with Linear Time Dependent Demand Rate and Shortages under Inflation and Time Discounting. Journal of the Operations Research Society, 46, 771–782(1995). S. Bose, A. Goswami, K.S. Chaudhuri,: An EOQ Model for Deteriorating Items with Linear Time Dependent Demand Rate and Shortages under Inflation and Time Discounting. Journal of the Operations Research Society, 46, 771–782(1995).
8.
Zurück zum Zitat Hui Ming Wee,: Deteriorating Inventory Model with Quantity Discounts, Pricing and Partial Backordering. International Journal of Production Economics, 59, 511–518 (1999). Hui Ming Wee,: Deteriorating Inventory Model with Quantity Discounts, Pricing and Partial Backordering. International Journal of Production Economics, 59, 511–518 (1999).
9.
Zurück zum Zitat S.K. Goyal, B.S. Giri,: Recent Trend in Modeling of Deteriorating Inventory. European Journal of Operations Research, 134, 1–16 (2001). S.K. Goyal, B.S. Giri,: Recent Trend in Modeling of Deteriorating Inventory. European Journal of Operations Research, 134, 1–16 (2001).
10.
Zurück zum Zitat Prakash L. Abad,: Optimal Price and Order size for a reseller under partial Backordering. Computers and Operations Research, 28, 53–65 (2001). Prakash L. Abad,: Optimal Price and Order size for a reseller under partial Backordering. Computers and Operations Research, 28, 53–65 (2001).
11.
Zurück zum Zitat B.C. Giri, K.S. Chaudhuri,: Theory and Methodology: Deterministic Models of Perishable Inventory with stock dependent demand rate and non linear holding cost. European Journal of Operations Research, 105, 467–474 (1998). B.C. Giri, K.S. Chaudhuri,: Theory and Methodology: Deterministic Models of Perishable Inventory with stock dependent demand rate and non linear holding cost. European Journal of Operations Research, 105, 467–474 (1998).
12.
Zurück zum Zitat Raida Abuizam,: Optimization of (s,S)Periodic Review Inventory Model with Uncertain Demand and Lead Time using Simulation. International Journal of Management and Information System, 15(1), 67–80 (2011). Raida Abuizam,: Optimization of (s,S)Periodic Review Inventory Model with Uncertain Demand and Lead Time using Simulation. International Journal of Management and Information System, 15(1), 67–80 (2011).
13.
Zurück zum Zitat Amir Ahmadi-Javid, Amir Hossein Seddighi,: A Location Routing Inventory Model for Designing Multisource Distribution Networks. Engineering Optimization, 44(6), 637–656 (2012). Amir Ahmadi-Javid, Amir Hossein Seddighi,: A Location Routing Inventory Model for Designing Multisource Distribution Networks. Engineering Optimization, 44(6), 637–656 (2012).
14.
Zurück zum Zitat Tom Jose V., Akhilesh Jaya kumar, Sijo M. T.,: Analysis of Inventory Control Techniques: A Comparative Study. International Journal of Scientific and Research, 3(3), 1–6 (2013). Tom Jose V., Akhilesh Jaya kumar, Sijo M. T.,: Analysis of Inventory Control Techniques: A Comparative Study. International Journal of Scientific and Research, 3(3), 1–6 (2013).
15.
Zurück zum Zitat Sara Shahpouri, ParvizFattahi, Ali Arkan, Kia Parsa,: Integrated Vendor Buyer Cooperative Inventory Model with controllable lead time, Ordering cost reduction and service level constraint. International Journal on Advanced Manufacturing Technology, 65, 657–666 (2013). Sara Shahpouri, ParvizFattahi, Ali Arkan, Kia Parsa,: Integrated Vendor Buyer Cooperative Inventory Model with controllable lead time, Ordering cost reduction and service level constraint. International Journal on Advanced Manufacturing Technology, 65, 657–666 (2013).
16.
Zurück zum Zitat R. Venkateshwarlu, M.S. Reddy,: Time Dependent Quadratic Inventory Models under Inflation. Global Journal of Pure and Applied Mathematics, 10(1), 77–86 (2014). R. Venkateshwarlu, M.S. Reddy,: Time Dependent Quadratic Inventory Models under Inflation. Global Journal of Pure and Applied Mathematics, 10(1), 77–86 (2014).
Metadaten
Titel
Excel Solver for Deterministic Inventory Model: INSOLVER
verfasst von
Pratiksha Saxena
Bhavyanidhi Vats
Copyright-Jahr
2016
Verlag
Springer India
DOI
https://doi.org/10.1007/978-81-322-2755-7_20

Premium Partner