Question
ABC agricultural equipment retailer sells and services several brands of tractors. The data on demand for the last 200 weeks and lead time for the
ABC agricultural equipment retailer sells and services several brands of tractors. The data on demand for the last 200 weeks and lead time for the last 80 orders have resulted in the following frequency distributions for a particular model of tractors.
Demand Per Week | Lead Time in Weeks | ||
Demand | Frequency | Lead Time | Frequency |
0 | 5 | 1 | 5 |
1 | 25 | 2 | 10 |
2 | 40 | 3 | 15 |
3 | 60 | 4 | 30 |
4 | 35 | 5 | 20 |
5 | 20 | ||
6 | 10 | ||
7 | 5 | ||
Total |
The company is trying to determine a cost-minimizing strategy for its tractor inventory management. They are currently considering the following two strategies: a. Order quantity of 15 with a reorder point of 8. b. Order quantity of 20 with a reorder point of 10. The holding cost is $10.00 per week for each unit that is left in inventory at the end of the week. The stock out cost is estimated to be $450 per stock out and the ordering cost is $500 per order. Please simulate 30 weeks operation for EquiFarm assuming there are currently 12 units in inventory. Please report all the tables with your results as part of your submission for this problem. Note: Use the same random numbers for the two strategies so that differences in the simulation results then solely reflect the differences in the selected values of controllable variables – not random variation in the scenarios used. Based on your simulation results please determine the weekly stock out cost, ordering cost, weekly holding cost, and the total inventory cost for each of the two inventory management strategies under consideration. Which strategy will be more cost-effective for the company?
Step by Step Solution
3.40 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
The two strategies that the company is considering are a Order quantity of 15 with a reorder point o...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started