Question: really need help walking through this in excel, please help!! 5. The demand for item T in the next 10 weeks is presented in the

really need help walking through this in excel, please help!!
really need help walking through this in excel,
5. The demand for item T in the next 10 weeks is presented in the table below. Demand for T ( 10 -week period) To simplify the matter, let's assume that the lead time for the items is 0 . The ordering cost is $15 each time and the holding cost is $0.3 per unit per week. The demand pattern is not expected to change in years. Let's try to compare the total inventory cost under the following two methods: EOQ and L4L. L4L (lot for lot) is essentially an "order as much as you need each time" approach. For example, you will order 20 units in week 1, 10 units in week 2, etc. (Hint: You need to evaluate each parameter carefully in order to obtain values needed to calculate EOQ.) Please set up this problem properly in Excel. No matter what set up you use, you will need to complete the following table to find out the answer. Which inventory ordering method has the least total inventory cost during this 10 -week period

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!