Question

A-E please show excel equations

Lokoffee, a specialty coffeehouse in San Antonio, TX., sells Mexican coffee at a fairly steady rate of 4,500 pounds annually. The beans are purchased from a supplier in Chiapas, Mexico for $2.00 per pound Lokoffee estimates that it costs $45 in paperwork and transportation to place and get an order for the coffee, and holding costs are based on a 25% annual interest rate. a. Determine the optimal order quantity for Mexican coffee, in pounds b. What is the time between placement of orders, in days? (Lokoffee c. What is the annual cost of holding and ordering Mexican coffee for d. If replenishment lead time is 5 days, determine the reorder level e. If the coffee supplier in Chiapas, Mexico only takes orders by number operates 24/7) Lokoffee? based on the on-hand inventory, in pounds of coffee. of 200-lbs bags, how many bags you recommend to order and what will be the impact of this constraint on the total annual cost for Lokoffee?