Activity #2: EOQ Calculation x Video Excel Online Structured Activity: EOQ Calculation The Las Vegas Corporation purchases a critical component from one of its key suppliers. The operations manager wants to determine the economic order quantity, along with when to reorder, to ensure the annual inventory cost is minimized. The information obtained from historical data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers according to the input instructions for each question but use the unrounded values in the further calculations. Open spreadsheet Questions 1. What is the economic order quantity? Round your answer to the nearest whole number. 700 units 2. What is the annual purchase cost? Round your answer to the nearest dollar. $ 3. What is the annual holding cost? Round your answer to the nearest dollar, $ Back Autosaved at 6:04 PM Next 2. What is the annual purchase cost? Round your answer to the nearest dollar. $ 3. What is the annual holding cost? Round your answer to the nearest dollar. $ 4. What is the annual order cost? Round your answer to the nearest dollar. $ 5. What is the total annual inventory cost? Round your answer to the nearest dollar. $ 6. What is the reorder point? Round your answer to the nearest whole number. units 7. What is the number of orders placed per year? Round your answer to the nearest whole number. orders 8. What is the time between orders? Round your answer to the nearest whole number. days Check My Work Reset