Microsoft Excel Activity #2: EOQ Calculation x Question 1 0110 Submit 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 ta rearder, to ensure the annual inventory cost is minimized. The information abtained 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. A-Z Open spreadsheet Questions 1. What is the economic order quantity? Round your answer to the nearest whole number units 2. What is the annual purchase cost? Round your answer to the nearest doller. $ 3. What is the annual holding cost? Round your answer to the nearest dallar. $ 4. What is the annual order USL? Round your answer to the nearest dollar. 5 5. What is the total annual inventory cost? Round your answer to the nearest dollar Rack Next Type here to search O 1C Mostly cloudy AO 0 ENG 10:55 PM 2021-11-14 Microsoft Excel Activity #2: EOQ Calculation X Question 1 0110 2. What is the annual purchase cost? Kound your answer to the nearest doller. Submit $ 3. What is the annual holding cost? Round your answer to the nearest dallar. $ 4. What is the annual order cost? Round your answer to the nearest dollar. 4 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 Problem Back Next Type here to search O 1C Mostly cloudy AO 40 ENG 10:55 PM 2021-11-14 File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments Arial 10 B V ov A V ... ab Merge Tv AYO... 310 B C D E F H 1 L M N 0 P R 5 1 - 7.200 $100 16% $25 6 360 Formulas #NA A 1 EOQ Calculation 2 3 Annual requirement in units (R) Setup cost (S) 5 Holding rate (k) 6 Unit Cost (C) / Onder lead time (LT, days) 8 Number of days per year 9 10 EOQ 11 12 Annual purchase cost 13 Annual holding cost 14 Annual order cost 15 Total inventory cost 16 Reorder point (RON, deys) 17 Number of orders per year 18 Time between orders (days) 19 20 21 22 23 24 25 26 27 28 #NA #NA #N/A #NA UNA #NA #NA = Sheet1 + Waiting for excelofficeapps.live.com... Type here to search Loading Add-ins - Give Feedback to Microsoft - 100% + 1055 PM 1C Mostly cloudy A4 ENG 2021-11-14 O 11