Business, 07.04.2020 21:33 eeromaki1321

Newton Manufacturing produces scientific calculators. The models are N350, N450, and the N900. 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 units) for each product and each customer zone are given in the file Newton. Newton would like to know the total number of units going to each customer zone and also the total units of each product shipped. There are several ways to get this information from the data set. One way is to use the SUMIF function.

The SUMIF function 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

Newton Scientific Calculators
Customer Zone Model Volume (000 units)
Malaysia N350 399.0
China N350 3158.3
France N350 1406.0
Brazil N350 163.5
US Northeast N350 68.7
US Southeast N350 999.7
US Midwest N350 544.9
US West N350 1804.0
Malaysia N450 228.0
China N450 540.9
France N450 289.8
Brazil N450 240.5
US Northeast N450 313.2
US Southeast N450 681.3
US Midwest N450 1720.3
US West N450 2922.3
Malaysia N900 1301.6
China N900 1629.3
France N900 1790.8
Brazil N900 740.7
US Northeast N900 48.3
US Southeast N900 1522.3
US Midwest N900 2217.5
US West N900 1243.6
(a) Complete the below table for total number of units distributed in each customer zone.
If required, round your answers to one decimal place.
Customer Zone Total Volume (000 units)
Brazil
China
France
Malaysia
US Midwest
US Northeast
US Southeast
US West
Total
(b) Complete the below table for the total units of each product shipped.
If required, round your answers to one decimal place.
Product Total Volume (000 units)
N350
N450
N900
Total

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 14:10

Needs 83,000 optical switches next year (assume same relevant range). by outsourcing them, worldsystems can use its idle facilities to manufacture another product that will contribute $ 140,000 to operating income, but none of the fixed costs will be avoidable. should worldsystems make or buy the switches? show your analysis.

Answers: 3

Answer

Business, 21.06.2019 20:30

Which of the following is an example of formal management controls? answers: a firm's culturethe willingness of employees to monitor each otherbudgeting and reporting activitiesmanagerial motivation

Answers: 3

Answer

Business, 22.06.2019 01:00

In order to gauge public opinion about how to handle iran's growing nuclear program, a research group surveyed 1010 americans by telephone and asked them to rate the threat iran's nuclear program poses to the world on a scale of 1 to 10. describe the population, sample, population parameters, and sample statistics. identify the population in the given problem. choose the correct answer below.

Answers: 2

Answer

Business, 22.06.2019 05:10

The total value of your portfolio is $10,000: $3,000 of it is invested in stock a and the remainder invested in stock b. stock a has a beta of 0.8; stock b has a beta of 1.2. the risk premium on the market portfolio is 8%; the risk-free rate is 2%. additional information on stocks a and b is provided below. return in each state state probability of state stock a stock b excellent 15% 15% 5% normal 50% 9% 7% poor 35% -15% 10% what are each stock’s expected return and the standard deviation? what are the expected return and the standard deviation of your portfolio? what is the beta of your portfolio? using capm, what is the expected return on the portfolio? given your answer above, would you buy, sell, or hold the portfolio?

Answers: 1

Answer

You know the right answer?

Newton Manufacturing produces scientific calculators. The models are N350, N450, and the N900. Newto...

Questions