A company just starting business made the following four inventory purchases in June: June 1 150 units $ 390 June 10 200 units 585 June 15 200 units 630 June 28 150 units 495 $2,100 A physical count of merchandise inventory on June 30 reveals that there are 200 units on hand. Using the average-cost method, the amount allocated to the ending inventory on June 30 is

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