Reference no: EM13842545
The Stereo Warehouse in Georgetown sells stereo sets, which it orders from Fuji Electronics in Japan. Because of shipping and handling costs, each order must be for five stereos. Because of the time it takes to receive an order, the warehouse places an order every time the present stock drops to five or below. It costs $100 to place an order. It costs the warehouse $400 in lost sales when a customer asks for a stereo and the warehouse is out of stock (if a customer cannot purchase a stereo when they want it, the customer will not wait until one comes in, but will instead go to a competitor). It costs $40 per month to keep each stereo stored in the warehouse. The following probability distributions for demand and order lead time have been determined:
Demand/Month Prob. Lead Time Prob.
0 .04 1 .60
1 .08 2 .30
2 .28 3 .10
3 .40
4 .16
5 .02
6 .02
The warehouse presently has five stereos in stock. Orders are always received at the beginning of the month.
Build an Excel simulation model for this problem.
Simulate the Stereo Warehouse’s ordering and sales policy for 24 months, and do 1000 replications and put your results into a column data table on a separate sheet.
Compute and display the average, minimum, and maximum monthly cost.
Construct a 90% confidence interval for average month cost (Excel has tools to help you do this).
Construct an output distribution (frequency diagram) based on the output data using Excel’s chart feature.
|
Research on the required competencies for od practitioners
: Research on the required competencies for OD practitioners has been considerable. However, there is still much confusion about which of the following
|
|
Principles of bureaucracy-design organizational hierarchy
: How can the principles of bureaucracy help managers design the organizational hierarchy? When does bureaucracy become a problem in an organization? What can man- agers do to prevent bureaucratic problems from arising?
|
|
The aztecs forced the people they conquered to pay tributes
: The Aztecs forced the people they conquered to pay tributes
|
|
Research past scientific breakthroughs
: Research past scientific breakthroughs that may have pushed the boundaries of moral ethics and explain why you think it may have been morally wrong or right.
|
|
Compute the average-minimum and maximum monthly cost
: The Stereo Warehouse in Georgetown sells stereo sets, which it orders from Fuji Electronics in Japan. Because of shipping and handling costs, each order must be for five stereos. Simulate the Stereo Warehouse’s ordering and sales policy for 24 months..
|
|
Maintenance office of medium sized repair facility
: Scope: You are in the maintenance office of a medium sized repair facility. The senior manager has asked you to come up with a project plan and budget to move your 51-person maintenance facility from hangar 12 to the new and larger hangar 18. Create ..
|
|
Describe the symptoms of pedophilic disorder
: Describe the symptoms of pedophilic disorder and explain why pedophiles are so dangerous. Some states require that pedophiles remain incarcerated after their sentence ends if they have not successfully completed treatment for their condition
|
|
Change management
: "Change Management" Please respond to the following:. Provide at least two examples of how the change process is both a creative and rational process using the change..
|
|
Interest expense and net income
: Last year a company had $365,000 of assets, $28,275 of net income, and a debt-to-total-assets ratio of 42%. However, the president is convinced to increase the debt ratio to 54%. Sales and total assets will not be affected, but interest expenses w..
|