Formulation Publisher Shipping Decision Problem Formulation Your Publisher Clients' production facilities are located in: P Albany Zip Code: The production facility operates 250 days per year. 12250 His Customers' warehouses are located in: 1 2 3 4 5 Rye Irving Charlotte Sioux Falls Tustin New York Texas Nprth Carolina South Dakota California Zip Code: Zip Code: Zip Code: Zip Code: Zip Code: 10580 75015 28201 57117 92780 The books are usually shipped in one of two sized packages: A B Height 9 inches Height 10 inches Length 13 inches Length 6 inches Width 17 inches Width 12 inches Weight 45 pounds Weight 16 pounds Your Publisher ships 4 of the A packages and 8 of the B packages to each of the 5 warehouses daily Your task is to select the best shipper for the publisher. Do not schedule a pickup for these books as that may skew the results of the statistical test that we're trying to get you in a position to do. Also, if asked for a value of Assignment 4 - Week 1 Page 1 03/13/2017 Problem Formulation do. Also, if asked for a value of each package, enter $100.00. Assignment 4 - Week 1 Page 1 03/13/2017 Analysis of Shipping Costs Daily Shipping Weights (lbs.) To: From P 12250 10580 75015 28201 57117 92780 1 2 3 4 5 308 308 308 308 308 Daily Shipping Cost using FedEx To: From 10580 75015 28201 57117 92780 1 2 3 4 5 P 12250 Daily Shipping Cost using UPS To: From 10580 75015 28201 57117 92780 1 2 3 4 5 P 12250 Daily Shipping Cost using USPS To: From 12250 10580 75015 28201 57117 92780 1 2 3 4 5 P Assignment 4 - Week 1 Page 2 03/13/2017 Combination of Vendors Daily Shipping Cost using a combination of 2 or more services for lowest cost LOWEST COST SHIPPING SERVICE (from above) FedEx UPS USPS FedEx UPS {insert the lowest cost vendor for each route} To: From 10580 75015 28201 57117 92780 1 2 3 4 5 P 12250 Cost Conclusions: Assignment 4 - Week 1 Page 3 03/13/2017 Final Recommendation DECISION CRITERIA FedEx UPS USPS COSTS DELIVERY SPEED PICKUP SCHEDULES DROP-OFF LOCATIONS PACKAGE-TRACKING ABILITY WEB SITE USABILITY Reason for your recommendation: Assignment 4 - Week 1 Page 4 03/13/2017