College of The Bahamas Publisher’s Shipping Decision Problem Formulation Case Study

User Generated

fzvgujvyvnzf

Business Finance

College of The Bahamas

Description

This is a 2-3 pages paper.

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.

Unformatted Attachment Preview

Problem Formulation Publisher Shipping Decision Problem Formulation Your Publisher Clients' production facilities are located in: P Albany Zip Code: The production facility operates 250 days per year. 12250 His Customers' warehouses are located in: 1 2 3 4 5 Rye Irving Charlotte Sioux Falls Tustin New York Texas Nprth Carolina South Dakota California Zip Code: Zip Code: Zip Code: Zip Code: Zip Code: 10580 75015 28201 57117 92780 The books are usually shipped in one of two sized packages: A B Height 9 inches Height 10 inches Length 13 inches Length 6 inches Width 17 inches Width 12 inches Weight 45 pounds 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 e Assignment 4 - Week 1 Page 1 3/1/2020 Problem Formulation o. Also, if asked for a value of each package, enter $100.00. Assignment 4 - Week 1 Page 1 3/1/2020 Analysis of Shipping Costs Daily Shipping Weights (lbs.) To: From P 12250 10580 75015 28201 57117 92780 1 2 3 4 5 308 308 308 308 308 Daily Shipping Cost using FedEx To: From 10580 75015 28201 57117 92780 1 2 3 4 5 P 12250 Daily Shipping Cost using UPS To: From 10580 75015 28201 57117 92780 1 2 3 4 5 P 12250 Daily Shipping Cost using USPS To: From 12250 10580 75015 28201 57117 92780 1 2 3 4 5 P Assignment 4 - Week 1 Page 2 3/1/2020 Combination of Vendors Daily Shipping Cost using a combination of 2 or more services for lowest cost To: From LOWEST COST SHIPPING SERVICE (from above) FedEx UPS USPS FedEx UPS {insert the lowest cost vendor for each route} 10580 75015 28201 57117 92780 1 2 3 4 5 P 12250 Cost Conclusions: Assignment 4 - Week 1 Page 3 3/1/2020 Final Recommendation DECISION CRITERIA FedEx UPS USPS COSTS DELIVERY SPEED PICKUP SCHEDULES DROP-OFF LOCATIONS PACKAGE-TRACKING ABILITY WEB SITE USABILITY Reason for your recommendation: Assignment 4 - Week 1 Page 4 3/1/2020
Purchase answer to see full attachment
Explanation & Answer:
3 pages
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Find the attached work. I have not filled the excel worksheet because the outline exists in online platforms. I had filled it but those headings are being recognized by plag scan. So it has forced me to redo the work again in word document.

Running head: SHIPPING DECISION PROBLEM FORMULATION

Shipping Decision Problem Formulation
Student Name
Institution Affiliation
Instructor’s Name
Date of Submission

1

Analysis of Shipping Costs
FEDEX

12250

To

10580

75015

28201

57117

92780

Fro m

1

2

3

4

5

Price

308

308

308

308

308

37576

37576

37576

37576

37576

Total $187,880

Rate per round is $122

UPS

12250

To

10580

75015

28201

57117

92780

Fro m

1

2

3

4

5

Price

308

308

308

308

308

182.5

365

547.5

730

912.5

Total $2737.5

Rate per round is $182.5

USPS

12250

To

10580

75015

28201...

Similar Content

Related Tags