Question: 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

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:
1 Rye Zip New 10580 York Code: 2 Irving Техas Zip Code: 75015 Charlotte Nprth 3 Zip 28201 Carolina Code: 4 Sioux Sout

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

Weight 45 pounds 9 inches Length 13 inches Width 17 inches A Height 10 inches Length 6 inches Width 12 inches Weight 16

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.

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

Step by Step Solution

3.43 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Let the cost of the shipment per pound for Reason for your recommendation It is recommended that USP... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

1019-B-C-A-S-S(1274).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!