2 When shipping products two major costs are incurred: the 3 cost of insuring th

Question

2 When shipping products two major costs are incurred: the 3 cost of insuring the item and the actual freight cost. 4 Insurance is dependent on the value of the shipment 5 Quickstove has an agreement with shippers for a fixed 6 | rate that is determined by destination state and service |Regular : $ 5.00 | $ 6.00 $ 5.00 | 7 evel (regular, express or overnite Freight Cost CA WA NV UT MIT HI 3.00 $ 5.00 $ 6.00 | $ 6.00 | $ 5.00 $ 8.00 7. 60 $13.50 Overnite. $ 11.60 | $ 13. 70 $. 11.60 : $ 7.80 | $11.60 | $13.70 $13.70 | $11.60 $17.10 8 0 760 Express, 7.60 ProductI Shipping Insuranc Freight Shippin ValueClasse Cost Cost g Total Insurance Cost 10 OrderID Ship To Product Name 1003 AZ 1004 WA 1007 NV 011UT 1027 CA 1041NT Shipmen Insuran t Value ce Cost $-$0. 50 S10 1.00 $30 2.00 $ 50 2.50 S 100 S 3.00 200S 4. 00 5. 00 100 QuickStove 100jQuickStove 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells $68. 80Express $86.00 Express 13 $17.55 Overnite S 4. 00 Overnite $69. 98 Overnite ## Overnite 1042 CA 1050 OR 1058 UT 1059 AZ 1060 WA 1062 UT 1073 CO 1074 CO 1088 WA 1094 NV 1109 HI 17 400 . ress $15. 68 Regular $69. 98 Overnite 60. 80 Regular $34. 99 Overnite 19. 60 Overnite 23 24 25 26 27 4.00 :Overnite i 8.00 Express 8. 00 Express

Explanation / Answer

SCENARIO 1 Insurance cost has been taken marginally Order ID Ship To Product ID Product Name Value Shipping Class Insurance Cost Freight Cost Shipping total Calculation of insurance cost 1003 AZ 100 Quick Stove 68.8 Express 2.688 7.6 79.088 2.5 + [18.8*(0.5/50)] 1004 WA 100 Quick Stove 86 Express 2.86 8.4 97.26 2.5 + [36*(0.5/50)] 1007 NV 100 Quick Stove Regular 0.5 5 5.5 0.5 1011 UT 100 Quick Stove Express 0.5 4.7 5.2 0.5 1027 CA 100 Quick Stove 17.55 Overnite 1.3775 11.6 30.5275 1+[7.55*(1/20)] 1041 MT 102 Replacement Fuel Cells 4 Overnite 0.7 13.7 18.4 0.5+[4*(0.5/10)] 1042 CA 104 Quick Stove Can 69.98 Overnite 2.6998 11.6 84.2798 2.5+[19.98*(0.5/50)] 1050 OR 104 Quick Stove Can Overnite 0.5 13.7 14.2 0.5 1058 UT 104 Quick Stove Can Express 0.5 4.7 5.2 0.5 1059 AZ 102 Replacement Fuel Cells 15.68 Regular 1.284 5 21.964 1+[5.68*(1/20)] 1060 WA 104 Quick Stove Can 69.98 Overnite 2.6998 13.7 86.3798 2.5+[19.98*(0.5/50)] 1062 UT 102 Replacement Fuel Cells 60.8 Regular 2.608 3 66.408 2.5+[10.8*(0.5/50)] 1073 CO 104 Quick Stove Can 34.99 Overnite 2.12475 11.6 48.71475 2+[4.99*(0.5/20)] 1074 CO 102 Replacement Fuel Cells 19.6 Overnite 1.48 11.6 32.68 1+[9.6*(1/20)] 1088 WA 102 Replacement Fuel Cells 4 Overnite 0.7 13.7 18.4 0.5+[4*(0.5/10)] 1094 NV 102 Replacement Fuel Cells 8 Express 0.9 7.6 16.5 0.5+[8*(0.5/10)] 1109 HI 102 Replacement Fuel Cells 8 Express 0.9 13.5 22.4 0.5+[8*(0.5/10)] SCENARIO 2 Insurance cost has been taken as a Range(0,0-10,10-30 and so on) Order ID Ship To Product ID Product Name Value Shipping Class Insurance Cost Freight Cost Shipping total 1003 AZ 100 Quick Stove 68.8 Express 3 7.6 79.4 1004 WA 100 Quick Stove 86 Express 3 8.4 97.4 1007 NV 100 Quick Stove Regular 0.5 5 5.5 1011 UT 100 Quick Stove Express 0.5 4.7 5.2 1027 CA 100 Quick Stove 17.55 Overnite 2 11.6 31.15 1041 MT 102 Replacement Fuel Cells 4 Overnite 1 13.7 18.7 1042 CA 104 Quick Stove Can 69.98 Overnite 3 11.6 84.58 1050 OR 104 Quick Stove Can Overnite 0.5 13.7 14.2 1058 UT 104 Quick Stove Can Express 0.5 4.7 5.2 1059 AZ 102 Replacement Fuel Cells 15.68 Regular 2 5 22.68 1060 WA 104 Quick Stove Can 69.98 Overnite 3 13.7 86.68 1062 UT 102 Replacement Fuel Cells 60.8 Regular 3 3 66.8 1073 CO 104 Quick Stove Can 34.99 Overnite 2.5 11.6 49.09 1074 CO 102 Replacement Fuel Cells 19.6 Overnite 2 11.6 33.2 1088 WA 102 Replacement Fuel Cells 4 Overnite 1 13.7 18.7 1094 NV 102 Replacement Fuel Cells 8 Express 1 7.6 16.6 1109 HI 102 Replacement Fuel Cells 8 Express 1 13.5 22.5

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.