Watch the video " the best stats youve ever seen " then answer the questions.​

Ardmore farm and seed has an inventory dilemma. they have been selling a brand of very popular insect spray for the past year. they have never really analyzed the costs incurred from ordering and holding the inventory and currently fave a large stock of the insecticide in the warehouse. they estimate that it costs $25 to place an order, and it costs $0.25 per gallon to hold the spray. the annual requirements total 80,000 gallons for a 365 day year.a. assuming that 10,000 gallons are ordered each time an order is placed, estimate the annual inventory costs.b. calculate the eoq.c. given the eoq calculated in part b., how many orders should be placed and what is the average inventory balance? d. if it takes seven days to receive an order from suppliers, at what inventory level should ardmore place another order?

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding

Fortress international, a large conglomerate, procures a few component parts from external suppliers and also manufactures some of the key raw materials in its own subsidiaries. aside from this, the company does not solely depend on outside distributors to reach its customers. in fact, it has its own retail stores to distribute its products. in this scenario, which of the following alternatives to vertical integration is fortress international applying? a. concentric integration b. taper integration c. horizontal integration d. conglomerate integration