o Instruction: Answer what is being required. You may compute them manually or use the Excel QM. Number 2 pencils at the campus book-store are sold at a fairly steady rate of 60 per week. It cost the bookstore $12 to initiate an order to its supplier and holding costs are $0.005 per pencil per year. Determine The optimal number of pencils for the bookstore to purchase to minimize total annual inventory cost, Number of orders per year, The length of each order cycle, Annual holding cost, Annual ordering cost, and Total annual inventory cost. If the order lead time is 4 months, determine the reorder point. Illustrate the inventory profile graphically. What additional cost would the book-store incur if it orders in batches of 1000? o o O