(in pounds) 1 12345 5 6 7 8 9 10 11 412 13 14 15 Click here for the Excel Data File 1 $ 4.75 $ 4.85 $ 5.00 $ 5.15 $ 5.40 $ 5.55 $ 5.75 $ 6.00 $6.20 $ 6.40 $ 6.60 $ 6.80 $ 7.00 $ 7.15 $ 7.35 Req A1 Req A2 2 $ 4.90 $ 5.15 $ 5.40 $ 5.60 $5.80 $ 6.00 $ 6.15 $ 6.35 $ 6.55 $ 6.70 $ 6.90 $ 7.10 $ 7.35 Req B $7.55 $ 7.80 Transit inventory cost for air transportation Total cost using air transportation Transit inventory cost for ground transportation Total cost using ground transportation 3 $5.25 $ 5.65 $ 6.00 Complete this question by entering your answers in the tabs below. $6.30 $ 6.60 $6.75 $ 6.90 $ 7.10 $7.25 $ 7.40 $ 7.55 $ 7.70 $ 7.85 $ 8.00 $ 8.15 Suppose you have a package weighing 8 pounds that needs to be shipped to zone 6. The value of the material is $6,000 and the annual inventory holding rate is 25 percent of the product value. < Req A1 $5.35 $5.80 $ 6.25 $ 6.60 a-1. Calculate the total shipping and transit inventory cost using the air and ground transportations. a-2. Which transportation mode (air or g