Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... 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

Quantitative Analysis For Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna

11th Edition

9780132997621, 132149117, 132997622, 978-0132149112

More Books

Students also viewed these Accounting questions

Question

How is the adjoint used in finding the inverse of a matrix?

Answered: 1 week ago

Question

What is a time-series forecasting model?

Answered: 1 week ago