Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and
Fantastic news! We've Found the answer you've been seeking!
Question:
Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references.
Hint: You will need to use a function within the HLOOKUP function to determine the appropriate row. Please provide formula .
Transcribed Image Text:
A B D E G H K. L 1 When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of 4 the shipment 5 Quickstove has an agreement with shippers for a fixed rate that is 6 determined by destination state and service level (regular, express or 7 overnite). Freight Cost AZ WA NV UT CA MT OR CO HI 3.00 $ 5.00 $ 4.70 $ 7.60 $ 8.40 S Regular 5.00 $ 6.00 $ 5.00 $ 6.00 $ 5.00 ($ 8.00 8.40 $ 7.60o ($ 13.50 13.70 $ 13.70 I$ 11.60) $ 17.10 6.00 $ Express 7.60 $ 8.40 $ 7.60 $ Overnite 11.60 $ 13.70 $ 11.60 $ 7.80 $ 11.60 $ Shipping Insurance Shipping Insurance Cost 10 OrderiD Ship To ProductID Product Name Value Class Cost Freight Cost Total Shipment Insurance $ 68.80 Express $ 86.00 Express $ 120.39 Regular 11 1003 AZ 100 QuickStove 2.50 Value Cost 1004 1007 12 WA 100 QuickStove 2.50 $ 0.50 $ $ 120.39 Express $ 17.55 Overnite $ 4.00 Overnite $ 69.98 Overnite $ 274.32 Overnite $ 274.32 Express $ 15.68 Regular $ 69.98 Overnite $ 60.80 Regular $ 34.99 Overnite $ 19.60 Overnite $ 4.00 Overnite 13 NV 100 QuickStove 3.00 24 10 $ 1.00 UT 100 QuickStove 30 | $ 2.00 50 s 14 1011| 3.00 15 1027 CA 100 QuickStove 1.00 2.50 1041 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 16 MT 0.50 $ 100 $ 3.00 17 1042 CA 2.50 $ 200 $ 4.00 18 1050 OR 4.00 400 $ 5.00 19 1058 UT 4.00 20 1059 AZ 1.00 21 1060 WA 2.50 22 1062 UT 102 Replacement Fuel Cells 2.50 23 1073 CO 104 Quick Stove Can 2.00 1074 102 Replacement Fuel Cells 102 Replacement Fuel Cells 24 CO 1.00 25 1088 WA 0.50 A B D E G H K. L 1 When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of 4 the shipment 5 Quickstove has an agreement with shippers for a fixed rate that is 6 determined by destination state and service level (regular, express or 7 overnite). Freight Cost AZ WA NV UT CA MT OR CO HI 3.00 $ 5.00 $ 4.70 $ 7.60 $ 8.40 S Regular 5.00 $ 6.00 $ 5.00 $ 6.00 $ 5.00 ($ 8.00 8.40 $ 7.60o ($ 13.50 13.70 $ 13.70 I$ 11.60) $ 17.10 6.00 $ Express 7.60 $ 8.40 $ 7.60 $ Overnite 11.60 $ 13.70 $ 11.60 $ 7.80 $ 11.60 $ Shipping Insurance Shipping Insurance Cost 10 OrderiD Ship To ProductID Product Name Value Class Cost Freight Cost Total Shipment Insurance $ 68.80 Express $ 86.00 Express $ 120.39 Regular 11 1003 AZ 100 QuickStove 2.50 Value Cost 1004 1007 12 WA 100 QuickStove 2.50 $ 0.50 $ $ 120.39 Express $ 17.55 Overnite $ 4.00 Overnite $ 69.98 Overnite $ 274.32 Overnite $ 274.32 Express $ 15.68 Regular $ 69.98 Overnite $ 60.80 Regular $ 34.99 Overnite $ 19.60 Overnite $ 4.00 Overnite 13 NV 100 QuickStove 3.00 24 10 $ 1.00 UT 100 QuickStove 30 | $ 2.00 50 s 14 1011| 3.00 15 1027 CA 100 QuickStove 1.00 2.50 1041 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 16 MT 0.50 $ 100 $ 3.00 17 1042 CA 2.50 $ 200 $ 4.00 18 1050 OR 4.00 400 $ 5.00 19 1058 UT 4.00 20 1059 AZ 1.00 21 1060 WA 2.50 22 1062 UT 102 Replacement Fuel Cells 2.50 23 1073 CO 104 Quick Stove Can 2.00 1074 102 Replacement Fuel Cells 102 Replacement Fuel Cells 24 CO 1.00 25 1088 WA 0.50
Expert Answer:
Answer rating: 100% (QA)
The formuale to be used is the hlookup and inside th... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
Jack Turner is your client. He recently graduated from College and is considering purchasing a business. While in College, Jack drove a cab to pay his way through school. Jack learned a great deal...
-
Ksp for PbCrO4 = 2.8 x 10-13 at 25 C. Which of the following statements about the concentration of the ions in PbCrO4 solutions is always true whatever its molarity? [Pb+ (aq)]5.2 x 10-7 mol L-1 and...
-
Give the line and angle formulas for the following compounds: a) (CH3)2CHCH(C2H5)CH2CH2CH3 b) CH2=C(C2H5)CH2C(CH3)2CH3 c) (CH3)2C=CHC(C2H5)=CH2 d) CH3(CH2)30COCH3CH2NH2 e) (CH3)3CC=CCH2CH=C(CH3)2...
-
Sparkle is one firm of many in the market for toothpaste, which is in long-run equilibrium. a. Draw a diagram showing Sparkles demand curve, marginal-revenue curve, average total- cost curve, and...
-
Angie Rase bought merchandise with a list price of $4,000. Angie was entitled to a 30% trade discount as well as a 3% cash discount. What was Angies actual cost of buying this merchandise after the...
-
Figure P25.40 shows several equipotential lines each labeled by its potential in volts. The distance between the lines of the square grid represents 1.00 cm. (a) Is the magnitude of the field larger...
-
In the spring of 1999, Source Associates, Inc. (Source), and Conrad A. Mamajek, Inc. (CAM), entered into a joint venture to act as a middleman for the sale of polymers manufactured by Mitsui...
-
For the past several years, Jolene Upton has operated a part-time consulting business from her home. As of July 1, 2019, Jolene decided to move to rented quarters and to operate the business, which...
-
Structured query language (SQL) is divided into two categories: data definition language (DDL) commands and data manipulation language (DML) commands. Data manipulation language (DML) is a set of...
-
Analyze, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of ADP Inc. Note: Complete the entire question using the following Excel...
-
Consider a two-dimensional extended surface, which moves with constant velocity V along the x-axis. Assume conduction in the moving direction is negligible. The inlet temperature is uniform, 0o. For...
-
Jamar earned $2,500 from his summer job at the grocery store. This is $350 more than twice what his friend Todd earned. How much did Todd earn from his summer job?
-
A company is expecting its sales to decline and has announced that it will be reducing its annual dividend by 5.75% a year for the next two years. After that, it will maintain a constant dividend of...
-
A new comedy movie featuring aging movie stars is filming near where Mark lives. He has a friend who knows the executive producer and has been told that the production company is looking for some...
-
The dividend for Should I, Inc., is currently $2.05 per share. It is expected to grow at 24 percent next year and then decline linearly to a perpetual rate of 6 percent beginning in four years. If...
-
Explain the concept of thermoregulation and how the body maintains core body temperature within a narrow range through mechanisms such as vasodilation, vasoconstriction, sweating, and shivering, and...
-
give two different reasons why Hayek expected an economic collapse in every socialist country. Each reason (A and B) must use economic fundamentals to demonstrate the problems expected by Hayek....
-
In Exercises, find the equation of the tangent line at the given point on each curve. 2y 2 - x = 4; (16, 2)
-
The marginal costs, average variable costs (AVC), and average total costs (ATC) for a firm are shown in Figure 13P-2. In the figure, mark the quantity the firm will choose to produce in the short run...
-
Describe an economic model you know. What assumptions does the model make? Are the assumptions reasonable?
-
Suppose a city has a chain of fitness centers (gyms) all owned by the same company, Fit Fun. A new company is considering opening a gym in the city. Give an example of an aggressive tactic Fit Fun...
-
What is the half-life of uranium-238?
-
Who discovered that energy and mass are two different forms of the same thing?
-
Is it possible for a hydrogen nucleus to emit an alpha particle? Why? (a) yes, because alpha particles are the simplest form of radiation (b) no, because it would require the nuclear fission of...
Study smarter with the SolutionInn App