SUO_MIS3101_W1_A3_Mclean_M.xls.
xls
keyboard_arrow_up
School
South University, Savannah *
*We aren’t endorsed by this school
Course
3101
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
xls
Pages
7
Uploaded by Aysha_Aysha2013
Problem Formulation
Assignment 4 - Week 1
Page 1
11/11/2023
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 a
Problem Formulation
Assignment 4 - Week 1
Page 1
11/11/2023
asked for a value of each package, enter $100.00.
Analysis of Shipping Costs
Assignment 4 - Week 1
Page 2
11/11/2023
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
308
308
308
308
308
Cost
37576
37576
37576
37576
37576
187880
Rate per lb is $122
Daily Shipping Cost using UPS
To:
10580
75015
28201
57117
92780
From
1
2
3
4
5
12250
P
308
308
308
308
308
Cost
56210
56210
56210
56210
56210
281050
Rate per lb is $182.50
Daily Shipping Cost using USPS
To:
10580
75015
28201
57117
92780
From
1
2
3
4
5
12250
P
308
308
308
308
308
Cost
10934
10934
10934
10934
10934
54670
Rate per lb is $ 35.50
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Combination of Vendors
Assignment 4 - Week 1
Page 3
11/11/2023
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
308
308
308
308
308
Cost
37576
56210
10934
37576
56210
198506
Cost Conclusions:
Total cost $198506
Final Recommendation
Assignment 4 - Week 1
Page 4
11/11/2023
DECISION CRITERIA
FedEx
UPS
COSTS
The pricing structure is determine by the weight of the
Package weight or cou
the item being transported, fuel fees, and other expensive,
DELIVERY SPEED
One day for local orders and 2 Days from the order pick up
Same as FedEx
PICKUP SCHEDULES
The pick-up service can be scheduled according to the client's preferences,
Pick -up service can be
with additional fees applicable for pick-ups during non-standard hours.
DROP-OFF LOCATIONS
All the cities where the service is required
All the cities where the
PACKAGE-TRACKING ABILITY
On the company website, having the tracking nr.
This can be followed o
Also the merchant prov
WEB SITE USABILITY
Detailed information is not provided
Very confusing
Reason for your recommendation:
FedEx is mostly used by Business organizations due to its speedy
Poor service and longe
shipping, However the fees a high because of 7 days of operation.
I sell many products on Mercari website and use the USPS service because it is cheaper and faster.
Final Recommendation
Assignment 4 - Week 1
Page 4
11/11/2023
USPS
urier
Global Express Guaranteed -$36
plus additional charges for delivery confirmation
1-3 Business days
e scheduled online
e service is required
All the cities where the service is required
on the company website.
On the website using the label or reciete nr
vide proof of delivery.
Easy access with details about the each route.
er delivery.
Most economical service and package delivery takes 3-4 business days.
The service is characterized by its efficiency and convenience since carriers can collect parcels without any associated charg
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Final Recommendation
Assignment 4 - Week 1
Page 4
11/11/2023
ges, irrespective of their kind. The cost for on-demand pick-up services is $15.30 per pick-up.