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
Other questions on the subject: Business
Business, 21.06.2019 21:00, castiaulii16
The market for corn in country a is highly competitive. at the current market price of $5/bushel there is a shortage of 100,000 bushels of corn in this country. media reports claim that the price of corn will rise drastically in the near future. according to these reports, the neighboring country b had witnessed a similar situation recently. at the same price, the shortage in country b was also 100,000 bushels and eventually the equilibrium price in b went up to $10/bushel. both countries are known to have equal number of corn producers and the market supply of corn is identical at all prices. this, combined with the fact that consumers in the two countries also have similar tastes and preferences, led the media to conclude that the price of corn in country a would soon be as high as $10/bushel. the new equilibrium price turns out to be below $10/bushel, what inferences can be drawn?
Answers: 3
Business, 22.06.2019 00:00, billey32
Exercise 4-6 the following balances were taken from the books of alonzo corp. on december 31, 2017. interest revenue $86,000 accumulated depreciation—equipment $40,000 cash 51,000 accumulated depreciation—buildings 28,000 sales revenue 1,380,000 notes receivable 155,000 accounts receivable 150,000 selling expenses 194,000 prepaid insurance 20,000 accounts payable 170,000 sales returns and allowances 150,000 bonds payable 100,000 allowance for doubtful accounts 7,000 administrative and general expenses 97,000 sales discounts 45,000 accrued liabilities 32,000 land 100,000 interest expense 60,000 equipment 200,000 notes payable 100,000 buildings 140,000 loss from earthquake damage 150,000 cost of goods sold 621,000 common stock 500,000 retained earnings 21,000 assume the total effective tax rate on all items is 34%. prepare a multiple-step income statement; 100,000 shares of common stock were outstanding during the year. (round earnings per share to 2 decimal places, e. g. 1.48.)
Answers: 2
Business, 22.06.2019 21:40, brianmondesir1owahud
Rebel technology maintains its records using cash-basis accounting. during the year, the company received cash from customers, $43,000, and paid cash for salaries, $23,500. at the beginning of the year, customers owe rebel $1,000. by the end of the year, customers owe $6,600. at the beginning of the year, rebel owes salaries of $5,600. at the end of the year, rebel owes salaries of $3,300. determine cash-basis net income and accrual-basis net income for the year.
Answers: 2
Do you know the correct answer?
Newton Manufacturing produces scientific calculators. The models are N350, N450, and the N900. Newto...
Questions in other subjects:
English, 21.01.2021 01:00
History, 21.01.2021 01:00
Biology, 21.01.2021 01:00
