Business, 04.05.2021 15:50 Student658

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. Click on the datafile logo to reference the data. 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 isNewton Scientific CalculatorsCustomer ZoneModelVolume (000 units)MalaysiaN350399.0ChinaN350315 8.3FranceN3501406.0BrazilN350163.5U S NortheastN35068.7US SoutheastN350999.7US MidwestN350544.9US WestN3501804.0MalaysiaN450228.0Chin aN450540.9FranceN450289.8BrazilN450 240.5US NortheastN450313.2US SoutheastN450681.3US MidwestN4501720.3US WestN4502922.3MalaysiaN9001301.6Chi naN9001629.3FranceN9001790.8BrazilN 900740.7US NortheastN90048.3US SoutheastN9001522.3US MidwestN9002217.5US WestN9001243.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 ZoneTotal Volume (000 units)BrazilChinaFranceMalaysiaUS MidwestUS NortheastUS SoutheastUS West Total(b)Complete the below table for the total units of each product shipped. If required, round your answers to one decimal place. ProductTotal Volume (000 units)N350N450N900 Total

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 18:30

What is the communication process? why isnt it possible to communicate without using all the elements in the communication process?

Answers: 3

Answer

Business, 21.06.2019 20:40

Alocal club is selling christmas trees and deciding how many to stock for the month of december. if demand is normally distributed with a mean of 100 and standard deviation of 20, trees have no salvage value at the end of the month, trees cost $20, and trees sell for $50 what is the service level?

Answers: 2

Answer

Business, 22.06.2019 14:40

You are purchasing a bond that currently sold for $985.63. it has the time-to-maturity of 10 years and a coupon rate of 6%, paid semi-annually. the bond can be called for $1,020 in 3 years. what is the yield to maturity of this bond?

Answers: 2

Answer

Business, 22.06.2019 18:20

Now ray has had the tires for two months and he notices that the tread has started to pull away from the tire. he has already contacted the place who sold the tires and calmly and accurately explained the problem. they didn’t him because they no longer carry that tire. so he talked with the manager and he still did not get the tire replaced. his consumer rights are being violated. pretend you are ray and write a letter to the company’s headquarters. here are some points to keep in mind when writing the letter: include your name, address, and account number, if appropriate. describe your purchase (name of product, serial numbers, date and location of purchase). state the problem and give the history of how you tried to resolve the problem. ask for a specific action. include how you can be reached.

Answers: 3

Answer

You know the right answer?

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

Questions