ABCDEFGH
1
2
3
4
Please Note: This document is proprietary and confidential. It may not be disclosed in any manner to a third-party without the prior consent of Atomix Logistics, LLC.
5
6
7
8
Shipping Calculator
9
10
User Manual Steps:
11
1. Input Product Weight for Shipment
12
2. Review Lowest Cost Output
13
14
Only For Standard Shipping (3-5 Day )
15
Input:
16
1_Product Weight (lbs):0.99
rounded (<0.99, 1, 2, 3...)
17
1_Product Quantity:1
18
2_Product Weight (lbs):0
19
2_Product Quantity:0
20
Destination Zip Code:98952
21
22
Output:
23
Origin Zip Code:53233snip
24
Total Weight:0.99
25
Zone:8
26
Carrier:
27
Cost Per Carrier: $ 4.68 USPS
28
 $ 14.26 UPS
29
 $ 13.02 FEDEX
30
Lowest Shipping Cost: $ 4.68
31
32
CHECKequation used
33
USPS0.998
=vlookup(C27&$B$24&$B$25,'Standard Shipping'!$D$3:$E$1000,2,false)
34
UPS0.998
=vlookup(C28&$B$24&$B$25,'Standard Shipping'!$D$3:$E$1000,2,false)
35
FEDEX0.998
=vlookup(C29&$B$24&$B$25,'Standard Shipping'!$D$3:$E$1000,2,false)