NQuiz #4 covers the materials for Week 7. Please use the data in the provided Excel file to implement all relevant calculations and then answer the set of questions. 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 4.15x 1. What is the EOQ? (Please round to the nearest interger: e.g.) 432.49432,329.50330 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 ? \begin{tabular}{lcc} Parameter & Notation & Value \\ \hline Annual demand & D & 6,240 units/year \\ Order placement cos & S & $18.0 per order \\ Holding cost factor & k & 37% per year per $ of invento \\ Unit value & C & $27 per unit \\ Holding cost & H & per unit per year \\ Order quantity & Q & units per order \end{tabular} Lead time =1 week NQuiz #4 covers the materials for Week 7. Please use the data in the provided Excel file to implement all relevant calculations and then answer the set of questions. 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 4.15x 1. What is the EOQ? (Please round to the nearest interger: e.g.) 432.49432,329.50330 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 ? \begin{tabular}{lcc} Parameter & Notation & Value \\ \hline Annual demand & D & 6,240 units/year \\ Order placement cos & S & $18.0 per order \\ Holding cost factor & k & 37% per year per $ of invento \\ Unit value & C & $27 per unit \\ Holding cost & H & per unit per year \\ Order quantity & Q & units per order \end{tabular} Lead time =1 week