Economic Order Policy Model. Need the answer for #9 on the spreadsheet. Also if I could get help answering these two questions based on the given data:

1.

• If the order quantity used by the company was greater than the computed economic order quantity (Q*), indicate how annual carrying costs, annual ordering costs and total annual costs would change (e.g. whether they will increase or decrease) relative to those using the Q*.
• If the order quantity used by the company was less than the computed economic order quantity (Q*), indicate how annual carrying costs, annual ordering costs and total annual costs would change (e.g. whether they will increase or decrease) relative to those using the Q*.

2. If the store wanted to use a periodic inventory system, what order interval (days) would approximate the economic order quantity computed in part b. Enter a formula in a cell labeled order interval for P system. See slide 44 in the inventory notes for an example computation.

THANK YOU!!!!!!!!

F24 B C D E F . T J K L M N 0 1 Assumption Inputs: 2 Annual Demand (D) 3 Ordering Cost/Order SI 4 Annual Carrying Cost/ unit (H) 5 Order Lead time (L) 6 Days/Year 7 8 375 30 9 20 365 9 Inventory Policy Outputs: System: 1. Optimal Order Quantity Q" 2. Number of Orders 3. Annual Order Cost 4. Average inventory (units) 5. Annual Carrying Cost 6. Total Cost 7. Daily Demand 8. Reorder Point 50 7.5 225 25 225 450 1.03 21 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 P System: 9. Fixed Period