The spreadsheet (Excel) of a single-period inventory model with stochastic demand can be used as a simulation tool for engineering education or Decision Support System.
Based on spreadsheet techniques and examples described in the following sources:
Albright S. C., & Winston W. L. (2005). Spreadsheet modeling and applications: essentials of practical management science, South-Western Pub.
Albright, S. C. W. C., Winston, W., & Zappe, C. (2010). Data analysis and decision making. Cengage Learning.
Hill, A. V. (2011). The newsvendor problem. White Paper, 57-23.
Lawrence, J. A., & Pasternack, B. A. (2002). Applied management science. Willey, Chichester.
Microsoft. Office Dev Center (2017). Excel performance: Improving calculation per

Features

  • Graph of expected profit over order range
  • Setting demand parameters of normal distribution
  • Basic functionality requires no macros or add-ins
  • Convenient change of the inputs
  • Visual representation of demand probability distribution

Project Activity

See All Activity >

Categories

Data Analytics

Follow Newsvendor Model Simulation Spreadsheet

Newsvendor Model Simulation Spreadsheet Web Site

Other Useful Business Software
Gen AI apps are built with MongoDB Atlas Icon
Gen AI apps are built with MongoDB Atlas

Build gen AI apps with an all-in-one modern database: MongoDB Atlas

MongoDB Atlas provides built-in vector search and a flexible document model so developers can build, scale, and run gen AI apps without stitching together multiple databases. From LLM integration to semantic search, Atlas simplifies your AI architecture—and it’s free to get started.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Newsvendor Model Simulation Spreadsheet !

Additional Project Details

Registered

2020-04-03