PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS Pan Casero, S.A., purchases and then sells (as hot bread), 2.6 million bushels of wheat annually. Wheat must be purchased in multiples of 2,000 bushels....

PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS

Pan Casero, S.A., purchases and then sells (as hot bread), 2.6 million bushels of wheat annually. Wheat must be purchased in multiples of 2,000 bushels. Order costs are $5,000 per order. Annual transportation costs are 2% of the purchase price of five dollars per bushel. The lead time is six weeks. At what inventory level should an order be placed?