Use Analytic Solver Platform to simulate the Outsourcing Decision Model under the assumptions that the production volume will be triangular with a minimum of 800, maximum of 1,700, and most likely value of 1,400, and that the unit supplier cost is normally distributed with a mean of $175 and a standard deviation of $12. Find the probability that outsourcing will result in the best decision.

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

Helen tells her nephew, bernard, that she will pay him $100 if he will stop smoking for six months. helen was hopeful that if bernard stopped smoking for six months, he would stop altogether. bernard stops smoking for six months but then resumes his smoking. helen will not pay him. she says that the type of promise she made cannot constitute a binding contract and that, furthermore, it was at least implied that he would stop smoking for good. can bernard legally collect $100 from helen

Asupermarket has been experiencing long lines during peak periods of the day. the problem is noticeably worse on certain days of the week, and the peak periods are sometimes different according to the day of the week. there are usually enough workers on the job to open all cash registers. the problem is knowing when to call some of the workers stocking shelves up to the front to work the checkout counters. how might decision models the supermarket? what data would be needed to develop these models?