PLEASE SHOW EXCEL SOLUTION with formulas

Format as Table Paste B IV HOA == += = v $ % ) EM 22 Delete ! Format v Cell Styles Sort & Filter Find & Select Analyze Data F36 X fx A B B E G H I L M N 0 Q R 1 2 3 A company purchases an item from a supplier with an annual demand of 1,000 units. It costs the company $500 for every order placed, and $20 for every unit purchased. The company's carrying cost per unit per annum is $5. 4 5 1. Calculate the the economic order quantity (0.5 point), 2. Calculate total purchasing cost (0.5 point) 3. Calculate total ordering cost (0.5 point) 4. Calculate total holding cost (0.5 point). Please show the calculation otherwise you cannot get any score. You can do the calculation on a sheet of paper, and then paste it in this sheet 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36