Wine Ordering System Simulation
Not what you're looking for?
The Wine Cellar places orders for a popular Pinot Noir on a weekly basis. The weekly demand for this wine was found to approximately follow the probability distribution shown below. The Wine Cellar buys this wine at $10 per bottle and sells it for $16 per bottle. The inventory carrying cost is $0.50 per bottle per week, and the shortage cost is $1.00 per bottle. The Wine Cellar does not permit backlogs, so shortages incur a cost only in the week they occur and then are ignored
Demand.......Probability
15....................0.20
16....................0.25
17.....................0.4
18....................0.15
Total................1.00
a) Using an order size of 16 bottles per week, simulate this ordering system for one year (52 weeks) and determine the expected profit. (Please include your simulation spreadsheet with this exam).
b) In at most 3 sentences, explain how your simulation system may be used to determine the best order size for this store.
Purchase this Solution
Solution Summary
The wine ordering system simulations are examined.
Solution Preview
The following text is included for search purposes -- please use the files to see the complete answer:
a) Using an order size of 16 bottles per week, simulate this ordering system for one year (52 weeks) and determine the expected profit. (Please include your simulation spreadsheet with this exam).
The simulation spreadsheet is attached. The simulation was done as follows:
-First, the demand was simulated for each of the 52 weeks in a year, using Excel's RAND() function. Following that, 100 such possible years were created. The demand for each year in each simulation is included in the first table in Excel, called 'Demand'.
-Next, the inventory remaining for each week was computed. The ...
Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.