subject
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

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 07:10
Walsh company manufactures and sells one product. the following information pertains to each of the company’s first two years of operations: variable costs per unit: manufacturing: direct materials $ 25 direct labor $ 12 variable manufacturing overhead $ 5 variable selling and administrative $ 4 fixed costs per year: fixed manufacturing overhead $ 400,000 fixed selling and administrative expenses $ 60,000 during its first year of operations, walsh produced 50,000 units and sold 40,000 units. during its second year of operations, it produced 40,000 units and sold 50,000 units. the selling price of the company’s product is $83 per unit. required: 1. assume the company uses variable costing: a. compute the unit product cost for year 1 and year 2. b. prepare an income statement for year 1 and year 2. 2. assume the company uses absorption costing: a. compute the unit product cost for year 1 and year 2. b. prepare an income statement for year 1 and year 2. 3. reconcile the difference between variable costing and absorption costing net operating income in year 1.
Answers: 3
question
Business, 22.06.2019 18:00
Bond j has a coupon rate of 6 percent and bond k has a coupon rate of 12 percent. both bonds have 14 years to maturity, make semiannual payments, and have a ytm of 9 percent. a. if interest rates suddenly rise by 2 percent, what is the percentage price change of these bonds?
Answers: 2
question
Business, 22.06.2019 19:40
The martinez legal firm (mlf) recently acquired a smaller competitor, miller and associates, which specializes in issues not previously covered by mlf, such as land use and intellectual property cases. given the increase in the firm's size and complexity, it is likely that its internal transaction costs willa. decrease. b. increase. c. become external transaction costs. d. be eliminated.
Answers: 3
question
Business, 22.06.2019 20:20
Xinhong company is considering replacing one of its manufacturing machines. the machine has a book value of $39,000 and a remaining useful life of 5 years, at which time its salvage value will be zero. it has a current market value of $49,000. variable manufacturing costs are $33,300 per year for this machine. information on two alternative replacement machines follows. alternative a alternative b cost $ 115,000 $ 117,000 variable manufacturing costs per year 22,900 10,100 1. calculate the total change in net income if alternative a and b is adopted. 2. should xinhong keep or replace its manufacturing machine
Answers: 1
You know the right answer?
Newton Manufacturing produces scientific calculators. The models are N350, N450, and the N900. Newto...
Questions
question
English, 29.10.2020 01:30
question
Mathematics, 29.10.2020 01:30
question
Social Studies, 29.10.2020 01:30
question
Business, 29.10.2020 01:30
question
Mathematics, 29.10.2020 01:30
question
Mathematics, 29.10.2020 01:30
question
Mathematics, 29.10.2020 01:30
Questions on the website: 13722359