Case Study on Publisher’s Shipping Decision Problem Formulation

Case Study on Publisher’s Shipping Decision Problem FormulationThe 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 (www.fedex.com), UPS (www.ups.com), and the United States Postal Service (www.usps.com).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.

 

Assignment 3 Grading Criteria Maximum PointsAccurately calculated the shipping costs. 20Used a valid methodology to justify recommendations. 15Demonstrated creativity in justifying recommendations. 15Total 50

 

Need this in APA format with in-text citations.  Academic references and no wiki websites, please.

2

>

P

roblem Formulation

P

lbany

22

0

1

Zip Code:

2

Zip Code:

Zip Code:

Zip Code:

5

Zip Code:

A

Height

Length

Width

Weight

Publisher Shipping Decision Problem Formulation

Your Publisher Clients’ production facilities are located in:

A

Zip Code:

1

5

The production facility operates 250 days per year.

His Customers’ warehouses are located in:

Rye

New York

10580

Irving

Texas

75015

3

Charlotte

Nprth Carolina

28201

4

Sioux Falls

South Dakota

57117

Tustin

California

92780

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

Height

9 inches

Length

13 inches

Width

17 inches

Weight

45 pounds

B

10 inches

6 inches

12 inches

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

&C&A
&LAssignment 4 – Week 1&CPage 1&R&D

Analysis of Shipping Costs

10580 75015 28201 57117 92780

1 2 3 4 5

P

308 308 308 308

To: 10580 75015 28201 57117 92780
From 1 2 3 4 5

12250 P

To: 10580 75015 28201 57117 92780
From 1 2 3 4 5
12250 P

To: 10580 75015 28201 57117 92780
From 1 2 3 4 5
12250 P

Daily Shipping Weights (lbs.)
				To:
				From
				12250					308
Daily Shipping Cost using			FedEx
Daily Shipping Cost using			UPS
Daily Shipping Cost using		USPS

&C&A
&LAssignment 4 – Week 1&CPage 2&R&D

Combination of Vendors

FedEx UPS USPS FedEx UPS

To: 10580 75015 28201 57117 92780
From 1 2 3 4 5
12250 P

Daily Shipping Cost using a combination of 2 or more services for lowest cost

LOWEST COST SHIPPING SERVICE (from above)

{insert the lowest cost vendor for each route}

Cost Conclusions:

&C&A
&LAssignment 4 – Week 1&CPage 3&R&D

Final Recommendation

FedEx UPS USPS

DECISION CRITERIA

COSTS

DELIVERY SPEED

PICKUP SCHEDULES

DROP-OFF LOCATIONS

PACKAGE-TRACKING ABILITY

WEB SITE USABILITY

Reason for your recommendation:

&C&A
&LAssignment 4 – Week 1&CPage 4&R&D