SCM 315

SUM: - Answer-Used when you want to calculate the sum of multiple cells without having to enter the formula manually $ in front of the column reference (the letter) - Answer-Will keep the reference to the column absolute, no matter how you drag it MIN(number1, number2, ...) - Answer-Returns the smallest number in a set of values MAX(number1, number2, ...) - Answer-Returns the largest number in a set of values Ignores logical values and text SUMPRODUCT(array1, array2, array3,...) - A...

The International Chef, Inc., creates three blends of tea: Chamomile (C), French (F), and Oolong (O). To create each blend, the firm uses tea leaves from Sri Lanka, South Africa, and Brazil as shown in the table below. For example, to create 1 pound of Chamomile blend, they use 0.02 pounds of Sri Lanka tea leaves, 0.77 pounds of South Africa tea leaves, and 0.21 pounds of Brazil tea leaves. Net profit per pound for each blend is $1.20 for Chamomile, $1.05 for French, and $0.92 for Oolong. The...