An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

Exercise 3

Open the file Foster Rev. Select cells B6:E8 and name these cells Shipping_Cost. Select cells B19:E21 and name these cells Units_Shipped. Use these names in the SUMPRODUCT function in cell C14 to compute cost and verify that you obtain the same cost ($39,500).