The Microsoft Excel worksheet lists the daily shipping requirements between your publisher client and his customer warehouses. Complete the decision matrix by filling in shipping costs from three shippers: Federal Express, UPS, and the United States Postal Service.
Which service would you recommend to your client considering not only costs but also issues such as delivery speed, pick-up schedules, drop-off locations, package-tracking ability, and usability of the Web site? State the reasons for your recommendation.
Publisher Shipping Decision Problem Formulation
Your Publisher Clients' production facilities are located in:
P.........................Albany
Zip Code..............12250
The production facility operates 250 days per year.
His Customers' warehouses are located in:

The books are usually shipped in one of two sized packages:

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 each package, enter $100.00.

Transcribed Image Text:

1 Rye Zip New 10580 York Code: 2 Irving Техas Zip Code: 75015 Charlotte Nprth 3 Zip 28201 Carolina Code: 4 Sioux South Zip 57117 Falls Dakota Code: California Zip Code: 5 Tustin 92780 Weight 45 pounds 9 inches Length 13 inches Width 17 inches A Height 10 inches Length 6 inches Width 12 inches Weight 16 pounds B Height