week 1 managment proj

SU_MIS3101_Publisher1.xls

Problem Formulation

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	New York	Zip Code:	10580
2	Irving	Texas	Zip Code:	75015
3	Charlotte	Nprth Carolina	Zip Code:	28201
4	Sioux Falls	South Dakota	Zip Code:	57117
5	Tustin	California	Zip Code:	92780

The books are usually shipped in one of two sized packages:
A	Height	9 inches	Length	13 inches	Width	17 inches	Weight	45 pounds
B	Height	10 inches	Length	6 inches	Width	12 inches	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 each package, enter $100.00.

&C&A

&LAssignment 4 - Week 1&CPage 1&R&D

Daily Shipping Weights (lbs.)

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



Daily Shipping Cost using FedEx

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



Daily Shipping Cost using UPS

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



Daily Shipping Cost using USPS

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

&C&A

&LAssignment 4 - Week 1&CPage 2&R&D


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:	10580	75015	28201	57117	92780
	From		1	2	3	4	5
12250	P



		Cost Conclusions:

&C&A

&LAssignment 4 - Week 1&CPage 3&R&D


DECISION CRITERIA	FedEx	UPS	USPS

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