answer all questions

Problem 11-8 (Algo) points Print References The table below provides shipping rates for packages using UPS next day air or ground service options. The rates vary according to both the weight of the package and the distance of the shipment farger numbered zones are farther away). Note that the zone number also indicates the number of days required to deliver a package using ground service. For example, it would take three days and cost $740 to send a 10-pound package to zone 3 using ground service Table of shaping to Next Day service weight Donetic Zones - Transit Tine in Days 2 1 lbs $16.25 $19.25 $ 22.25 $24.75 $ 27.80 5.28.25 $29.00 $ 12.3 5 20.75 $25.50 $ 27.75 5.35 5315 $32.00 S 19.00 5 21.75 $28.25 5. $33.50 5 34.75 $ 35.50 $ 20.00 5 22.75 $ 31.00 $3.50 $36.50 $ 37.5 $38.50 $ 21.25 $24.25 5:33.50 $35.25 $ 39.50 $ 0.25 $41.5 $ 22.00 $25.25 $36.00 5 39.00 $42.75 $44.00 $45.00 7 $22.75 $ 27.00 $13.50 $42.00 $47.00 543.23 $23.75 $28.35 5.41.00 $44.75 549.25 $10.28 $51.25 5 24.50 $ 29.75 547.75 $147.50 $ 52.50 $ 53.75 5 54.5 10 525.25 $31.00 5. 46.25 5.50.25 555.25 56.75 $57.75 11 $26.25 5 32.50 $48.5 5.52.75 55.00 $ 60.00 5 4.75 12 $ 27.00 $ 3.50 5 51.25 $ 55.50 560.75 563.00 563.25 13 $ 22.75 $ 53.75 $ 58.00 $65.25 5.5.15 $ 14 $8.50 536.00 $ 55.75 5.60 $65.75 $ 6.5 5625 15 $29.50 $37.50 563.00 $68.25 $20.25 6 8 Servis Weight Domestorani na 7 1 Ls 55.5 1 E $5.25 55.65 55. $6.30 $6.60 4 5 5 35.55 56.25 5 0. 7.10 5 7.40 7.65 3 2.05 3 36.45 222 point 7 $ 31.25 $4.5 5.5.0 55.15 5 5.40 55.55 55.25 16.00 5620 56.40 3.9.60 $ 0.00 5.00 32.15 17.35 $ 4.90 15 $5.4 $15. $5.00 $6.00 6.15 SM $6.55 56 56.00 7.10 $ 35 $2.54 5 2.0 3 5.3 . 16.25 6.60 6.99 13.20 $ 7.45 17 17.00 . 15:25 13.45 $ 8.65 12. 9.03 $6. 5. 7.10 $7.25 $2.40 $7.55 $ 2.0 $ 7.85 $5.00 $8.15 5.70 6.40 $ 6.50 7.30 7.25 $ 1.05 3.35 5 $ 9.25 $9.90 $10.00 11.35 $ 12.03 13.75 $11.45 . $8.95 $ 85 $92 59. 51.55 $11.25 12.95 51.95 $13.00 3:14.65 $15.95 10 11 12 13 14 15 19,20 5.60 $10.5 $10.00 5 11.15 Tent erences Polcture click here for the Excel Data File Suppose you have a package weighing 4 pounds that needs to be shipped to zone 5 The value of the material is $7.000 and the annual inventory holding rate is 30 percent of the product value 6-1 Cakulate the total shipping and transit inventory cost using the air and ground transportation (Use 365 days in a year. Do not round Intermediate calculations. Round your answers to 2 decimal places.) Transit inventory cost for air transportation Total cost using air transportation Transit inventory cost for ground transportation Total cost using ground transportation a-2 which transportation mode (air of ground) minimizes the total shipping and transit inventory cost (Round your answer to 2 decimal places.) 2.27 points Ground book Print References b. How high would the inventory holding rate have to be in order to justify next day air service? (Use 365 days in a year. Do not round Intermediate calculations. Round up your answer to the next whole number) for holding rate