Question: Please see the data provided in the Excel file. First, please determine the economic order quantity (EOQ) and then use this EOQ-along with the other

Please see the data provided in the Excel file.Please see the data provided in the Excel file.

Please see the data provided in the Excel file. First, please determine the economic order quantity (EOQ) and then use this EOQ-along with the other information provided in the DRP table-to complete the DRP table for Store 924-S. Important: Please *do not* round D, S, k, C, or H when calculating the EOQ. Please *do* round the EOQ to the nearest integer and then use this rounded value when completing the DRP table. Based on your calculations, please answer the questions below. Excel Data Sheet: NQuiz4_2.xlsx 1. What is the EOQ? (Please round to the nearest interger: e.g., 432.49 => 432, 329.50 =>330 2. How many units in total will be ordered over the next eight weeks? 3. What is the planned receipt for Week 6 4. What is the planned order volume for Week 4? 5. How many orders will be placed over the next eight weeks? 6. What is the ending inventory in Week 8? For Blank 4 Notation D s Parameter Annual demand Order placement costs Holding cost factor Unit value Holding cost Order quantity k C Value 2,080 units/year $11.3 per order 30% per year per $ of inventory $32 per unit per unit per year units per order H Q 2 3 3 4 6 8 1 40 5 40 7 40 40 40 40 40 40 Store 924-S Forecast/Usage Planned receipt Ending Inventory Planned order Lead time = 1 week 60

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!