Reference no: EM13909272
You will assume the role of the inventory manager for Simkin's Hardware. Use the initial simulation attachment, which uses a reorder policy of order 10 units when inventory falls to 5 or less. Run the simulation over 20 days and answer the following:
1. Using the initial simulation results, determine the estimated total annual inventory cost using the cost parameters provided in the example. Break out between order cost, holding cost, and stockout cost.
2. Critically assess the model as given. What assumptions have been made and how may the model be changed or enhanced?
3. Considering the costs determined in question 1 above, posit 2 additional reorder policies (reorder point and units ordered) that you hypothesize may decrease total annual inventory cost. Run the policies through the 20 day simulation and critically assess the results compared to the initial simulation.
Average ending inventory = (41 total units)/10 days = 4.1 units per day
Average lost sales = (2 sales lost)/10 days = 0.2 units per day
Average number of orders placed = 3 orders/10 days = 0.3 orders per day
Daily order cost = $10 per order x 0.3 order per day = $3
Daily Holding cost = $0.03 per unit per day x 4.1 units per day = $0.12
Daily stockout cost = $8 per lost sale x 0.2 lost sales per day = $1.60
Total Daily inventory cost = $4.72
Attachment:- sim.xlsx
|
What will the annual savings be
: Community Hospital has annual net patient revenues of $150 million. At the present time, payments received by the hospital are not deposited for six days on average. The hospital is exploring a lock-box arrangement will promises to cut the six days t..
|
|
Compute the sales level required in both dollars
: Astro Co. sold 20,000 units of its only product and incurred a $50,000 loss (ignoring taxes) for the current year as shown here.
|
|
What is the future worth of your investment in actual dollar
: General price inflation is estimated to be 3% for the next 5 years, 5% the 5 years after that, and 8% the following 5 years. If you invest $10,000 at 10% for those 15 years, what is the future worth of your investment in actual dollars at that time a..
|
|
Show that the expected time until the first occurrence
: Show that the expected time until the first occurrence of a = (a1, ... , ak) is given by k Ii E [Y ], ni i=1 £=1 pa£. Find the expected inter-renewal interval; use Blackwell's theorem.
|
|
Determine estimated total annual inventory cost
: Using the initial simulation results, determine the estimated total annual inventory cost using the cost parameters provided in the example. Break out between order cost, holding cost, and stockout cost.
|
|
T and o it manufactures these products in separate factories
: Vanna Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels.
|
|
What is the benefit of doing step five of the apv process
: What is the benefit of doing Step 5 of the APV process? What are some potential problems that could be involved with this type of value decomposition?
|
|
Healthcare reform, immigration reform, privacy rights
: The topic of your project needs to be a contemporary societal problem, such as healthcare reform, immigration reform, privacy rights, euthanasia, First Amendment Rights, stem cell research, capital punishment, corporate prisons, legalizing drugs, age..
|
|
Manufacturing and selling the product required
: Manufacturing and selling the product required $ 200,000 of fixed manufacturing costs and $ 325,000 of fixed selling and administrative costs.
|