Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Inventory Simulation This work is similar to the class example. But now assume the weekly demand follows a normal distribution with mean 2 0 0

Inventory Simulation
This work is similar to the class example. But now assume the weekly demand follows a normal distribution with mean 200 and standard deviation 20. The purchase cost is $7.50 per unit with a refund of $2.50 for unsold and returned units. The unit sales price is $10.00. The manager has chosen to order 200 each week. Use simulation, Solver, SolverTable, and this discrete distribution to create 2,000 realizations of this simulation to identify a good estimate of average weekly profit for order quantities of 150 to 250 in increments of 10 units.
For simiplicity, you don't need to round your numbers. The optimal solution should be 190 or 200 units.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Project Management Made Simple

Authors: Terry Schmidt

1st Edition

0470411589, 978-0470411582

More Books

Students also viewed these General Management questions

Question

What is the status (prevalence) of unions today?

Answered: 1 week ago