What is the range of values for the Total Discounted Cash Flow for these scenarios 10. Analyzing a Supply Chnin. Nexvion Manufacturing produces scientific calculators. The models are N350. N.450, Nond. Newton has planned its distribution of these products around eight customer zones: Brazil, China, France, Malaysia, U.S. Northeast, U.S. Southeast, U.S. Midwest, and U.S. West. Data for the current quarter (volume to be shipped in thousands of inits) for each product and each customer zone are given in the file Newton. Newton. 1 like to know the total number of units going to each customer zone and also the total is of each product shipped. There are several ways to get this information from the, wita set. One way is to use the SUMIF function. The SUMIF funcuon extends the SUM function by allowing the user to add the values of cells meeting a-logical condition. The general form of the function is =SUMIF(test range, condition, range to be summed) The test range is an area to search to test the condition, and the runge to be summed is the position of the data to be summed. So, for example, using the file Nenton. we use the following function to get the total units sent to Malaysia: =SUMIF(A3:A26,A3,C3,C26) Cell A.3 contitins the text "Malaysia". A3AA26 is the range of customer zones and C3.C26 are the volumes for each foduct for these customer zones. The SUMII looks for matches of "Malaysia" in coluphita and, if it mateh is found, adds the volume to the total. Lise the SUMIF function to get treal valume by exehzone and total wolume by ench product. What is the range of values for the Total Discounted Cash Flow for these scenarios 10. Analyzing a Supply Chnin. Nexvion Manufacturing produces scientific calculators. The models are N350. N.450, Nond. Newton has planned its distribution of these products around eight customer zones: Brazil, China, France, Malaysia, U.S. Northeast, U.S. Southeast, U.S. Midwest, and U.S. West. Data for the current quarter (volume to be shipped in thousands of inits) for each product and each customer zone are given in the file Newton. Newton. 1 like to know the total number of units going to each customer zone and also the total is of each product shipped. There are several ways to get this information from the, wita set. One way is to use the SUMIF function. The SUMIF funcuon extends the SUM function by allowing the user to add the values of cells meeting a-logical condition. The general form of the function is =SUMIF(test range, condition, range to be summed) The test range is an area to search to test the condition, and the runge to be summed is the position of the data to be summed. So, for example, using the file Nenton. we use the following function to get the total units sent to Malaysia: =SUMIF(A3:A26,A3,C3,C26) Cell A.3 contitins the text "Malaysia". A3AA26 is the range of customer zones and C3.C26 are the volumes for each foduct for these customer zones. The SUMII looks for matches of "Malaysia" in coluphita and, if it mateh is found, adds the volume to the total. Lise the SUMIF function to get treal valume by exehzone and total wolume by ench product
