ill only rate you if the work is done using excel correctly and no copy paste other answers!!

thanks a lot

Problem 13 The traffic manager of the Monarch Electric Company has just received a rate reduction offer from a trucking company for the shipment of fractional horsepower motors to the company's field warehouse. The proposal is a rate of $3 per hundredweight/cwt if a minimum of 40,000 pound is moved. Currently, shipments of 20,000 pounds or more are moved at a rate of $5 per cwt. If the shipment size falls below 20,000 pounds, a rate of $9 per cwt applies. The annual demand on warehouse is 5,000 motors per year Warehouse replenishment orders is 43 orders per year Weight of each motor is 175 lb per motor Standard cost of motor in warehouse $200 per motor Stock replenishment order handling costs is $15 per order Inventory carrying costs as a percentage of average value is 25% per year Handling cost at warehouse is $.30 per cwt Warehouse space is unlimited Should the company implement the new rate