Question: Can you help with the steps please, will thumbs up if correct. Thanks! The table below provides shipping rates for packages using UPS next day
Can you help with the steps please, will thumbs up if correct. Thanks!
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 (larger numbered zones are farther away). Note that the zone number also indicates the number of days required to deliver a package using ground service. A transportation manager must ship orders of materials weighing three pounds each to destinations in each of the seven zones listed in the table. The dally inventory holding rate is $9.50 per day for all orders. The manager has decided to use next day air service for all shipments. Table of Shipping Rates Text Day Service Weight Domestic Zones - Transit Time in Days 2 3 4 5 6 7 1 Lbs. $ 16.25 $ 19.25 $ 22.75 $24.75 $ 27.00 $ 28.25 $ 29.00 2 $ 17.25 $ 20.75 $25.50 $ 27.75 $ 30.25 $ 31.25 $ 32.00 3 $ 19.00 $ 21.75 $ 28.25 $ 30.50 $ 33.50 $ 34.75 $ 35.50 4 $ 20.00 $ 22.95 $31.00 $ 33.50 $36.50 $ 37.75 $ 38.50 5 $21.25 $ 24.25 $ 33.5e 5 36.25 $39.50 $48.75 $ 41.75 6 $ 22.00 $ 25.25 $36.00 $ 39.00 $ 42.75 $ 44.00 5 45.00 7 $ 22.75 $ 27.00 $38.50 $ 42.00 $ 46.00 $ 47.ee $ 48.25 8 $ 23.75 $ 28.25 $ 41.00 $44.75 $ 49.25 $ 50.25 $ 51.25 9 $24.50 $ 29.75 $ 43.75 $ 47.50 $ 52.50 $ 53.75 $ 54.50 ie $ 25.25 $31.00 $ 46.25 $ 58.25 $ 55.25 $ 56.75 $ 57.75 11 $26.25 $32.50 $ 48.75 $ 52.75 $ 58.00 $ 60.00 $ 60.75 12 $ 27.08 $ 33.50 $51.25 $ 55.50 $ 68.75 $ 63.00 $ 63.75 13 $ 27.75 $ 34.75 $ 53.75 $ 58.00 $ 63.25 $ 65.75 $ 66.50 14 $ 28.50 $36.00 $ 55.75 $ 60.50 $ 65.75 $68.50 $ 69.25 15 $ 29.50 $ 37.50 $ 58.00 $ 63.00 $ 68.25 $ 70.25 $ 72.00 Ground Service Weight Dostic Zones Transit in Days 9 54.90 59'55 1 tbs 2 > ST'S 5 SS 55.40 55.60 55.00 0995 1 $4.75 $ 3.85 55.00 55.15 5 5.40 5 5.55 55.75 $5.00 5.20 5500 5 5.70 $6.40 $6.90 $ 7.30 $ 7.75 5.05 5 7 $5.85 $ 6.50 $ 7.55 58.es $8.55 $ 8.85 $ 9.25 $9.90 9 0055 7 55.25 $5.35 55.65 $5.00 $6.00 56.25 56.30 . 56.60 $5.95 56.75 57.20 56.90 57.45 57.10 5 7.50 57.25 57.80 57.40 5. 8.00 57.55 58.25 5 7.70 $8.45 57.85 5 3.05 58.00 $ 3.85 $ 8.15 $9.05 $5.25 56.70 $7.10 57.00 57.65 $7.95 58.25 58.45 $8.50 59.20 59.60 $10.05 $10.60 $11.15 SEO 5 SET 5 9 10 11 55'OIS 56.15 56.35 55.55 56,20 55.90 57.10 $ 7.35 5 7.55 $ 7.00 B5 099 $ 55.30 37.00 5.15 57.15 59.25 59.0 $10.60 $ 11.35 $ 12.05 $ 12.75 5 13.45 $11.25 $ 12.05 $12.95 $ 13.30 5 14.65 $15.55 14 15 a. Calculate the additional shipping and transit inventory cost using the air and ground transportations (Negative answers should be indicated by a minus sign. Leave no cells blank be certain to enter "o wherever required. Round your answers to 2 decimal places) Additional invertory con ground shup Dased on days)

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
