LM_JonesGage

xlsx

School

Brigham Young University, Idaho *

*We aren’t endorsed by this school

Course

361

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

xlsx

Pages

Uploaded by SargentWaterBuffaloPerson1152

# Companies 9 Avergae Holding 35 Total 315 # Companies New 1 # Transformers 105 Reduction Qty 210 Reduction Pct 67%

A 6.9 1 22 B 4.5 0.5 34 C 2.9 6.5 16 D 3.8 1.1 14 Center of Gravity 4.70 1.84 City X Coordinate Y Coordinate Shipments

City Redwood City (Oracle) 0.8 6.7 4 Menlo Park 1.6 9 8 3.7 7.6 46 Mountain View (Google) 5.4 5.8 28 Sunnyvale (AMD) 7.1 6 14 Cupertino (Apple) 6.3 0.9 12 Santa Clara (Intel) 8.3 1.4 12 San Jose (Cisco) 11.3 1.6 9 Milpitas 9.5 5.3 2 Fremont 7.3 11.7 3 Center of Gravity 5.47 5.67 X Coordinate Y Coordinate Business Plans Palo Alto (HP & Stanford)

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

Criteria $6.27 $4.93 $5.55 $0.12 $0.30 $0.26 $0 $800 $860 $200 $280 $310 Total Cost $5,048 $5,048 $5,578 $0 Units 759 Domestic Foreign 1 Foreign 2 Price/Unit Packaging Cost/Unit International Shipping/Entire Shipment Inland Freight/Entire Shipment

Criteria $20.33 $16.34 $1.97 $2.39 $0 $1.51 $0 $0.08 $0 $1.54 $2.51 $2.88 $20.86 $112.48 Total Cost $618 $618 $0 Units 27 Domestic Foreign Price/Unit Packaging Cost/Unit International Shipping/Unit Freight Forwarder Fee/Unit U.S. Port Handling/Unit Inland Freight/Unit Flat Fee Admin Cost/Month (not per unit)

# Customers 7.38916256 LTL Cost 194 Total Cost 1433.49754 3PL FTL 600 Avg Order Weight 620 Break Fee / Cwt 14 Break Fee / Order 87 Local LTL 26 Total Cost 1433 Cost Difference 0

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

# Customers 13 LTL Cost 197 Total Cost 2629.13534 3PL FTL 710 Avg Order Weight 980 Break Fee / Cwt 11 Break Fee / Order 107.8 Local LTL 36 Total Cost 2629.13534 Cost Difference 0

Parcel Shipment Cost $117 # Shipments 32 Total Cost $3,722 Local P/U Fee 31 Avg Order Wgt 175 Consolidation Fee 31 TL Shipment 1010 Total Cost 3721.88976 Cost Difference $0

LM_JonesGage

Related Documents