User Account

All Pages

Find total volume by each zone and by each product

Assignment Help Finance Basics
Reference no: EM131668715

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

= 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 file Newton, we use the following function to get the total units sent to Malaysia:

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

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 total volume by each zone and total volume by each product.

Reference no: EM131668715

Questions Cloud

Draw the small-signal equivalent circuit of the amplifier : ELEC2133: Analogue Electronics Mid-Term Examination Questions. Draw the small-signal equivalent circuit of the amplifier suitable for mid-band analysis
What profit can be anticipated with a demand of given copies : Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3500 copies?
How to get the net present value of lindsay retirement fund : Update your model previously developed in Problem using the NPV function to get the net present value of Lindsay's retirement fund.
Calculate the efficiency of each pump : Determine the nature of the relationship between variables - Determine the operating point for this pump with system - Calculate the efficiency of each pump
Find total volume by each zone and by each product : 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 total volume.
Identify three potential dam sites along any of water ways : Identify three potential dam sites along any of the water ways found within the map for a dam of approximately 200m x 100m x 5m.
Discuss the transportation model in the file williamson : Consider the transportation model in the file Williamson, which is very similar to the Foster Generators model discussed in the chapter.
Compute the quarterly forecasts for next year : Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year.
What else do you think we have learned from the holocaust : The tragedy reminds us that those who practice religion are definitely prone to persecution. Perhaps even severe persecution.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd