Determine Shipping Charges. Trans-Port Inc., a distribution company located in Denver, Colorado, needs some assistance in computing the shipping charges for freight. The shipping charge is calculated by the total weight of the shipment. Any shipment with a total weight of 500 or over is computed by taking the total weight and multiplying it by $1.00. Any shipment with a total weight of 100 pounds or more, but less than 500 pounds is calculated by taking the total weight and multiplying it by .50. Anything shipped below 100 pounds is assessed a flat fee of $100. The owner of Trans-Port, Inc., Jake Plummer, has asked you to assist him in creating a macro function that will automatically assign shipping charges.
We need 3 more requests to produce this problem solution. Share with your friends to get the problem solution faster!
0 /3 have requested this problem solution