Omar Haaris receives 5000 tripods annually from TopGrade Sup

Omar Haaris receives 5000 tripods annually from Top-Grade Supplier to meet his annual demand. Omar runs a large photographic outlet, and the tripods are used primarily with 35mm cameras. The ordering cost is $15 per order, and the carrying cost is $0.50 per unit per year. Weekly demand is 100 tripods. A) What is the optimal order quantity? If someone could help tell me how to figure it out in excel, it would be appreciated!

Solution