Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the Value in cell E11 to lookup the appropriate cost on the

Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the Value in cell E11 to lookup the appropriate cost on the "Insurance Cost" reference table (range K11:L18). Make sure to use relative and absolute references appropriately. please provide formula

image text in transcribed

2When shipping products two major costs are incurred: the cost of insuring 3 the item and theactual freight cost. Insuranceis dependent on thevalue 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 orR Freight Cost CA OR Regular5.006.005.00 3.00 5.006.006.00$ 5.00$8.00 Express 7.60$8.40 7.60 4.70 7.60 8.40 $ 8.40 7.60 13.50 Overnite 11.60 S13.70 $ 11.60 $ 7.80 $ 11.60 $13.70 $ 13.70 $11.60 $ 17.10 overnite Shipping Insurance Shipping nsurance Cost 101 OrderID ShipTo ProductID Product Name Value Cost Freight Cost Total Shipment Insurance 1003 AZ 68.80 Express 86.00 Express 120.39 Regular $120.39 Express $17.55 Overnite 4.00 Overnite 69.98 Overnite 100 QuickStove 1 -_-- 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick StoveCan_ 102Replaement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells Value 12__1004)WA100 QuickStove 1007 NV 1011 1027CA 1041 MT 10421 CA $10 1.00 $302.00 $50 2.50 $ 100 3.00 200 4.00 400 5.00 18 1050 OR $274.32 Overnite 1058 UT 1059AZ 1060WA 1062 1073 1074] CCo $274.32 Express 15.68 Regular $ 69.98 Overnite 60.80 Regular 34.99 Overnite S 19.60 Overnite 4.00 Overnite $8.00 Express $8.00 Express 38.00 Express S 34.99 Overnite 102.87 Regular 24 25 1088WA102)Replacement Fuel Cells 1094 i NV ! 1109 1120OR 1255 OR 1262 UT 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can HI 28 30

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions