Purchase Solution

Transportation :SUMIF and SUMPRODUCT functions

Not what you're looking for?

Ask Custom Question

This is a study guide for me to use to study for an upcoming exam. I need detailed solution so I can be familiar with how to do a step by step solution. Excel is very hard for me unless I can see it clearly.

Please see attachment.

PROBLEM 1. Given the following information and diagram, determine the lowest cost routes to ship furniture from production sites 1 and 2 to stores at locations 3 and 4. The costs of shipping along the arrows are listed on each arrow and the quantity supplied or demanded is listed by each location. Complete an actual Excel worksheet in the format given below, solve it using the Excel Solver Program, and submit your excel file as the solution to this problem. This problem must be solved using the SUMIF and SUMPRODUCT functions.

Attachments
Purchase this Solution
Solution Summary

Excel file contains solution of transportation problem using solver tool and SUMIF and SUMPRODUCT functions..

Solution Preview

Hi,

Please see attached files for complete response to your ...

Purchase this Solution
Free BrainMass Quizzes
Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

View More Free Quizzes
Related BrainMass Solutions

  • Excel Functions - Sumif, Sumifs and Dropdowns AIS

    442330 Excel Functions - Sumif, Sumifs and Dropdowns AIS 1. Open the excel file and click on the data worksheet. Use the SUMIF function to calculate the total amount of sales in dollars (A/R Change) for each of the four types (Blue, Red, etc).

  • Greeting Card Sales: Analyze by Seller and by Type of Card

    Did this give you the right values for the total profit on boxes of Birthday, All Occasion, Thank You and Mixed Cards? Using the SUMPRODUCT function, enter a formula in cell H6 giving Ann's total profit from selling all types of cards.

  • Family Reunion spreadsheet using Excel

    The functions you are required to use are IF and SUMIF. You may also use other functions, but these 2 are part of the minimal requirements. The only other minimal requirement is the use of data validation.

  • Using the simplex method in mathematics

    In cells D18-D20, input the the following formula which calculates the amount of Vitamin A taken and ensures that the number of pills satisfies the requirements for vitamins A, B and C: Cell D18: sumproduct(B14:C14,B18:C18) Cell D19: sumproduct(B14:

  • Musumeci's Expected Portfolio Return

    ASSET PORTFOLIO WEIGHT EXPECTED RETURN Money market securities 10% 4% Corporate bonds 20 8 Equities 70 12 Expected portfolio return = Sumproduct of Portfolio weight * Expected return =10%*4%+20%*8%+70%*12% =10.4% The

  • Pivot table and "IF" function

    The pivot tables and "IF" functions are examined.

  • Sum Product

    Below the model are further comments regarding the sumproduct and the "if" statements. See the attached file. The solution assists with the Sum Product feature when using Excel.

  • LP Model

    Answer is b) =sumproduct(B8:C8, $B$4:$C$4) 3. These are the variable. a) B4:C4 4.

  • Define physical distribution

    Typically it includes transportation, warehousing, inventory, and order processing functions of the firm.

View More Related Solutions