Purchase Solution

Seattle Sea Gear vlookup hlookup index shipping cost

Not what you're looking for?

Ask Custom Question

Need help with a tutorial for a project. Need to use the State-Region table on the Region tab and the VLOOKUP function to identify correct region for each order. Place this information in Column N. Shipping data is based on three different methods: Truck, Rail, or Air. Use the HLOOKUP function and the first table on the Shipping tab to find the correct number reference for the shipping method. Place in Column P. Finally, apply name "Ship1" and "Ship2" to the two shipping tables to make referencing easy. Then use an INDEX function to decide shipping cost. In Column S, add shipping cost to total cost before shipping to find total cost after shipping.

Attachments
Purchase this Solution
Solution Summary

Excel file provided for the example about Seattle Sea Gear. Please click in cells for tutorial.

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • Pivot Table - Excel Vlookup

    Hint: Use the IFERROR and HLOOKUP functions. The function for any order ID in the range that has been deleted should return the phrase "Not Found."

  • Operations, Supply Chain Management

    How would you determine the most cost effective means of transporting Main Landing Gear Assemblies from Tokyo, Japan, to St. Louis, Missouri? Provide an explanation The model deciphers cost based on total costs.

  • Negative numbers

    Example: We may think of things which may be categorized as negative - such as debt, going below sea level (maybe in a Submarine), below freezing temperature, driving a car in a reverse gear, giving away things (oh well!

  • VLOOKUP function

    The table for VLOOKUP function extends over three columns.

  • Linear Programming

    Shipping Cost/Unit to Destination: Seattle Denver Kansas city 5 7 8 10 8 6 9 4 3 12 6 2 4 10

  • Beta & Required Return

    15.00% Y X Quarter Stock Price rate of change Market Index rate of change 0 -15% -10% 1 15% -200.00% 10% -200.00% 2 25% 66.67% 15% 50.00% 3 35% 40.00% 25% 66.67%

  • Managerial accounting

    The costs of shipping Panasonic televisions to retail stores. __________ 10. The cost of leasing an ultra-scan diagnostic machine at the American Hospital in Paris. __________ 1. Variable cost 2. Fixed cost 3. Fixed cost 4.

  • Vlookup - If I have a dollar amount for my ticket

    100859 Vlookup I'm trying to setup a vlookup.

  • Transportation Assignment Network Models: Hardrock Concrete Co

    The shipping cost per truckload of concrete, daily plant capacities and daily project requirements are provided in the table above. (a) formulate an initial feasible solution to Hardrock's transportation problem using Northwest corner rule.

View More Related Solutions