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 19:30

How do primary and secondary industries differ

Answers: 1

Answer

Business, 22.06.2019 20:50

Swathmore clothing corporation grants its customers 30 days' credit. the company uses the allowance method for its uncollectible accounts receivable. during the year, a monthly bad debt accrual is made by multiplying 3% times the amount of credit sales for the month. at the fiscal year-end of december 31, an aging of accounts receivable schedule is prepared and the allowance for uncollectible accounts is adjusted accordingly. at the end of 2012, accounts receivable were dollar 586.000 and the allowance account had a credit balance of dollar 50,000. accounts receivable activity for 2013 was as follows: the company's controller prepared the following aging summary of year-end accounts receivable: prepare a summary journal entry to record the monthly bad debt accrual and the write-offs during the year. (if no entry is required for a particular event, select "no journal entry required" in the first account field.) prepare the necessary year-end adjusting entry for bad debt expense. (if no entry is required for an event, select "no journal entry required" in the first account field.) what is total bad debt expense for 2013? calculate the amount of accounts receivable that would appear in the 2013 balance sheet?

Answers: 2

Answer

Business, 23.06.2019 00:40

On june 3, teal company sold to chester company merchandise having a sale price of $2,600 with terms of 2/10, n/60, f.o.b. shipping point. an invoice totaling $91, terms n/30, was received by chester on june 8 from john booth transport service for the freight cost. on june 12, the company received a check for the balance due from chester company. prepare journal entries on the teal company books to record all the events noted above under each of the following bases. (1) sales and receivables are entered at gross selling price. (2) sales and receivables are entered at net of cash discounts.

Answers: 3

Answer

Business, 23.06.2019 06:00

If a society decides to produce consumer goods from its available resources, it is answering the basic economic question

Answers: 3

Answer

You know the right answer?

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

Questions