| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | Foraged All-In Price Calculation Tool | ||||
2 | Instructions: 1. In the top left of the sheet, click "File" -> "Make a Copy", which will allow you to edit the calculator 2. Add original product price without shipping (retail price) 3. Add Height, Width, and Length of the box the item will ship in 4. Select "One Day" for items that require One Day shipping, "Two Day" for Two Day shipping, or "Non-Perishable" 5. Enter estimated weight of packed box (including packing materials, product, and box) in lbs 6. Use the "Free Shipping Product Price" as the new price for the item with free shipping | ||||
3 | |||||
4 | |||||
5 | Calculator | ||||
6 | Original Product Price | 15 | |||
7 | Height (in) | 10 | |||
8 | Width (in) | 10 | |||
9 | Length (in) | 10 | |||
10 | Shipping Type | Two Day | |||
12 | Weight (lbs) | 2 | |||
13 | Estimated Shipping Cost | $21.41 | |||
14 | Free Shipping Product Price | $36.41 | |||
15 | |||||
16 | |||||
17 | |||||
18 | Methodology: | ||||
19 | The pricing in the calculator above is based on real-life historical shipping costs incurred by Foragers on the platform over the last year across primarily UPS and USPS carriers. While prices vary due to distance and carrier, using the Free Shipping Product Price averaged to $0 net difference between estimated shipping cost and actual incurred charges. | ||||
20 | |||||