1. The demand for a particular part called SKU 005 is 1,500 units a year. The cost of one SKU 005 is $50.00. It costs $60.00 to place an order SKU 005, and the user of SKU 005 has a per year inventory carrying cost of 25% of unit cost. Assume that there are 250 working days in the year where SKU 005 is used.

What is the combined annual holding and ordering cost of an order size of 200 units for SKU 005?

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