Question

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

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 is:

=SUMIF (test range, condition, range to be summed).

The test range is an area to search to test the condition, and the range to be summed is the position of the data to be summed. So, for example, using the Newton file, we would use the following function to get the total units sent to Malaysia:

=SUMIF (A3:A26, A3, C3:C26).

Here, cell A3 contains the text "Malaysia", A3:A26 is the range of customer zones, and C3:C26 are the volumes for each product for these customer zones. The SUMIF looks for matches of "Malaysia" in column A and, if a match is found, adds the volume to the total. Use the SUMIF function to get each total volume by zone and each total volume by product.

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
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

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. What is an ISP (Integrated Service Provider) for supply chains? (1 point) A. A consultant...
1. What is an ISP (Integrated Service Provider) for supply chains? (1 point) A. A consultant agency which integrates the supply chain for companies B. A 2 PL or a 3PL, but not a 4PL C. A company supplying transportation and warehousing services D. A logistics service company specialized in suppling VAS (value added services) 2. What characterizes a 4 PL? (1 point) A. They are non-asset based and provides integrated services primarily supplied by asset based providers, for example...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater access to the internet has allowed consumers in the region to be a major force in the global digital economy. The expansion looks set to continue at a rapid pace. According to a November 2018 report by Fitch Solutions, e-commerce sales in the region are forecast to increase by 14.2% this year, with an estimated average annual increase of 14% over the medium term...
Fueling Indonesians: Window of Opportunity or Regret? Kerosene is widely used as cooking fuel by Indonesian...
Fueling Indonesians: Window of Opportunity or Regret? Kerosene is widely used as cooking fuel by Indonesian households, with an annual usage of 10 million Kiloliters. It is a major subsidized fuel for household cooking, where its usage is over sixty percent of the 230 million population. The subsidy program costs the government heavily, where it amounts up to U.S.$4 billion a year. As the practice tends to bleed government expenditures quite heavily, the Indonesian government is embarking on a change...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT