31:[{"id":"249a1966f3003ef83bb2737e12388579d9e12030d17fb5181f9e51114df8842036087ac9160d18a0196eea78b25c208c5b427b1413b2a1a3b29a436e0f5946d6","href":"https://static.observableusercontent.com/files/249a1966f3003ef83bb2737e12388579d9e12030d17fb5181f9e51114df8842036087ac9160d18a0196eea78b25c208c5b427b1413b2a1a3b29a436e0f5946d6","name":"shipping.db","type":"application/x-sqlite3","lastModified":1625450602967.913,"size":16384}] 2f:{"title":"Shipping Calculator","cells":[{"id":0,"value":"# Shipping Calculator\n\nThis calculator for shipping is a simple tool that helps you determine the volume and weight of your consignment and the shipping rate based on destination. Use it to calculate how much you should charge in shipping fee for items sold on ebay, Yahoo auctions, or Mercari.","pinned":false,"hidden":false,"mode":"md"},{"id":87,"value":"## Properties","pinned":false,"hidden":false,"mode":"md"},{"id":103,"value":"### Carton","pinned":false,"hidden":false,"mode":"md"},{"id":840,"value":"Information about your product or item being sold. Typically this is the size and weight information of your item in its original product package. If you have lost the product package or no longer have it, make the item as compact as possible and estimate the dimensions in its compact state.","pinned":false,"hidden":false,"mode":"md"},{"id":58,"value":"viewof l = Inputs.range([1, 400], { step: 1, label: \"Length (cm), l\", value: 30 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":62,"value":"viewof h = Inputs.range([1, 400], { step: 1, label: \"Height (cm), h\", value: 20 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"viewof w = Inputs.range([1, 400], { step: 1, label: \"Width (cm), w\", value: 10 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":67,"value":"viewof m = Inputs.range([0, 200], {\n step: 0.1,\n label: \"Weight (kg), m\",\n value: 1\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":313,"value":"### Consignment","pinned":false,"hidden":false,"mode":"md"},{"id":844,"value":"Information about your purchase order. Did you customer buy 1 unit or 100 units of the same item? Quanity will determine the package dimensions needed for shipping the order.","pinned":false,"hidden":false,"mode":"md"},{"id":66,"value":"viewof q = Inputs.range([1, 1000], { step: 1, label: \"Quantity, q\", value: 1 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":100,"value":"### Cargo","pinned":false,"hidden":false,"mode":"md"},{"id":190,"value":"Volume per carton, ${tex`V_{cbm} = `} ${CBM} ${tex`m^3`}","pinned":false,"hidden":false,"mode":"md"},{"id":225,"value":"Total Volume, ${tex`V_t = `} ${V_t.toFixed(2)} ${tex`m^3`}","pinned":false,"hidden":false,"mode":"md"},{"id":230,"value":"Total Weight, ${tex`M_t = `} ${M_t.toFixed(2)} ${tex`kg`}","pinned":false,"hidden":false,"mode":"md"},{"id":234,"value":"Volumetric Weight, ${tex`M_v = `} ${M_v} ${tex`kg`}","pinned":false,"hidden":false,"mode":"md"},{"id":110,"value":"### Shipping","pinned":false,"hidden":false,"mode":"md"},{"id":873,"value":"When shipping an item, you would put the packaged product into a box (typically a cardboard box) for the purpose of shipping.","pinned":false,"hidden":false,"mode":"md"},{"id":320,"value":"**Size** is calculated as the sum of Length, Width, and Height of your container in centimeter. Choose your max container size for your consignment:","pinned":false,"hidden":false,"mode":"md"},{"id":244,"value":"viewof d = Inputs.select(d_class, {\n label: \"Max Size (cm), d\",\n value: 100\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":567,"value":"The maximum number of cartons that you will be able to fit on a package or container of size ${d} ${tex`cm`} is ${Math.floor(carton_count)}. You ${q > Math.floor(carton_count) ? \"need\": \"do not need\"} a bigger size container because your quantity is ${q}.","pinned":false,"hidden":false,"mode":"md"},{"id":556,"value":"**Weight** is the maximum of ${tex`M_t`} or ${tex`M_v`}. Based on size ${d} ${tex`cm`} the max weight is ${dw} ${tex`kg`}. You ${Math.max(M_t, M_v) > dw ? \"need\": \"do not need\"} a bigger size container because your consignment weight is ${Math.max(M_t, M_v)} ${tex`kg`}.","pinned":false,"hidden":false,"mode":"md"},{"id":639,"value":"**Rate** is determined by the size of container, weight, departure, and destination regions. Carriers e.g. [Yamato](https://www.kuronekoyamato.co.jp/ytc/en/search/estimate/all_list.html), [Sagawa](https://www.sagawa-exp.co.jp/english/price/regular.html), and [JP Post](https://www.post.japanpost.jp/service/you_pack/charge/ichiran_en.html) charge fixed shipping rates based on these three parameters.","pinned":false,"hidden":false,"mode":"md"},{"id":659,"value":"viewof region_to = Inputs.select(region_list, {\n label: \"Destination (to)\",\n value: \"Kanto\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":663,"value":"viewof region_from = Inputs.select(region_list, {\n label: \"Departure (from)\",\n value: \"Kanto\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":763,"value":"The estimated shipping rate for your consignment is **${max_shipping_rate.toString().replace(/\\B(?=(\\d{3})+(?!\\d))/g, \",\")}** *JPY* when dispatching the package through Yamato Takkyubin (excluding discounts)","pinned":false,"hidden":false,"mode":"md"},{"id":777,"value":"### Shipping Fee (Models)","pinned":false,"hidden":false,"mode":"md"},{"id":783,"value":"viewof per_order = Inputs.range([0, 10000], {\n step: 1,\n label: \"Per Order (JPY)\",\n value: 120\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":786,"value":"viewof per_item = Inputs.range([0, 10000], {\n step: 1,\n label: \"Per Item (JPY)\",\n value: 20\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":813,"value":"In the **item based model**, you are charging a total of **${model_item_fee.toString().replace(/\\B(?=(\\d{3})+(?!\\d))/g, \",\")}** *JPY* shipping fee to your customers. ${model_item_fee > max_shipping_rate ? \"You are charging too much in shipping fees.\": \"\"} You can adjust the *Per Order* and *Per Item* amounts to charge an appropriate shipping fee to your customers.","pinned":false,"hidden":false,"mode":"md"},{"id":789,"value":"OR","pinned":false,"hidden":false,"mode":"md"},{"id":792,"value":"viewof per_kg = Inputs.range([0, 10000], {\n step: 1,\n label: \"Per Kg (JPY)\",\n value: 100\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":819,"value":"In the **weight based model**, you are charging a total of **${model_weight_fee.toString().replace(/\\B(?=(\\d{3})+(?!\\d))/g, \",\")}** *JPY* shipping fee to your customers. ${model_weight_fee > max_shipping_rate ? \"You are charging too much in shipping fees.\": \"\"} You can adjust the *Per Order* and *Per Kg* amounts to charge an appropriate shipping fee to your customers.","pinned":false,"hidden":false,"mode":"md"},{"id":365,"value":"## Appendix\n\nFormula and data used that was used to create the shipping calculator.","pinned":false,"hidden":false,"mode":"md"},{"id":162,"value":"### CMB","pinned":false,"hidden":false,"mode":"md"},{"id":370,"value":"CBM stands for cubic meters. It is a metric unit of volume that describes how much space your consignment takes. If you want to recalculate it to imperial units, use the following equation:\n\n${tex`1 V_{cbm} = 1m^3 = 35.3147 \\space cu \\space ft`}\n\nCalculating CBM for one carton is extremely easy. All you have to do is multiply all the dimensions of your box (length, width, and height):","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"{V_{cbm}} = \\frac{{l_{cm}} \\times {h_{cm}} \\times {w_{cm}}}{1 \\times 10^6}","pinned":false,"hidden":false,"mode":"tex"},{"id":122,"value":"CBM = (l * h * w) / 1e6","pinned":true,"hidden":false,"mode":"ojs"},{"id":404,"value":"Once you know the CBM of a single carton, you can easily find the total volume of your consignment. All you have to do is multiply this value by the quantity of cartons:","pinned":false,"hidden":false,"mode":"md"},{"id":31,"value":"V_t = {V_{cbm}}\\times q","pinned":false,"hidden":false,"mode":"tex"},{"id":137,"value":"V_t = CBM * q","pinned":true,"hidden":false,"mode":"ojs"},{"id":408,"value":"### Total weight vs. volumetric weight\n\nWhat is the difference between the two?\n\n**Total weight** describes how much your cargo weighs. It is the weight of a single box by the quantity of cartons in a consignment.","pinned":false,"hidden":false,"mode":"md"},{"id":45,"value":"M_t = m_{kg} \\times q","pinned":false,"hidden":false,"mode":"tex"},{"id":153,"value":"M_t = m * q","pinned":true,"hidden":false,"mode":"ojs"},{"id":420,"value":"**Volumetric weight**, on the other hand, is an artificial measure of how much space the shipped item occupies. Imagine the following situation: you are traveling on a plane, and take incredibly light luggage with you. In that case, you will be charged not for the weight, but rather for the volume of the item.\n\nVolumetric weight of the consignment is calculated according to the following formula:","pinned":false,"hidden":false,"mode":"md"},{"id":49,"value":"M_v = \\frac{{l_{cm}} \\times {h_{cm}} \\times {w_{cm}} \\times {q}}{5000} \\quad kg","pinned":false,"hidden":false,"mode":"tex"},{"id":159,"value":"M_v = (l * h * w * q) / 5000","pinned":true,"hidden":false,"mode":"ojs"},{"id":425,"value":"When estimating the shipment cost, many companies choose either total or volumetric weight, depending on which one is higher. This is called the Weight or Measurement Rule (W/M rule).\n\nAll carriers in Japan apply this pricing technique. Items of low density will typically be charged per kilogram of volumetric weight. Specific rates may, however, depend on carriers, origins, or destinations.\n\nAlso known as dimensional weight, volumetric weight typically favors shippers of heavy, dense goods, and makes it more costly to dispatch lightweight but sizable packages.","pinned":false,"hidden":false,"mode":"md"},{"id":429,"value":"### Containers","pinned":false,"hidden":false,"mode":"md"},{"id":446,"value":"\\begin{aligned}\n\\textrm{Size, } d &= l_{cm} + h_{cm} + w_{cm} \\\\\n\\textrm{Container Volume, } S_{cbm} &= \\left\\{ \\frac{\\left (\\frac{d}{3} \\right )^3}{1 \\times 10^6} \\colonequals \\frac{{l_{cm}} \\times {h_{cm}} \\times {w_{cm}}}{1 \\times 10^6} \\right\\}\n\\end{aligned}","pinned":false,"hidden":false,"mode":"tex"},{"id":264,"value":"s_cbm = {\n let sd = d / 3;\n return (sd * sd * sd) / 1e6;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":588,"value":"d_class = [60, 80, 100, 120, 140, 160]","pinned":true,"hidden":false,"mode":"ojs"},{"id":547,"value":"dw_class = ({\n 60: 2,\n 80: 5,\n 100: 10,\n 120: 15,\n 140: 20,\n 160: 25\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":549,"value":"dw = dw_class[d]","pinned":true,"hidden":false,"mode":"ojs"},{"id":344,"value":"\\textrm{Number of Cartons, } C_n = \\frac{S_{cbm}}{V_{cmb}}","pinned":false,"hidden":false,"mode":"tex"},{"id":276,"value":"carton_count = s_cbm / CBM","pinned":true,"hidden":false,"mode":"ojs"},{"id":710,"value":"### Shipping Rate","pinned":false,"hidden":false,"mode":"md"},{"id":863,"value":"This calculator uses Yamato's Takkyubin shipping rates","pinned":false,"hidden":false,"mode":"md"},{"id":643,"value":"db = FileAttachment(\"shipping.db\").sqlite()","pinned":true,"hidden":false,"mode":"ojs"},{"id":752,"value":"regions = db.query(`SELECT DISTINCT destination FROM takkyubin`)","pinned":true,"hidden":false,"mode":"ojs"},{"id":749,"value":"region_list = regions.map((d) => d.destination)","pinned":true,"hidden":false,"mode":"ojs"},{"id":645,"value":"rates = db.query(\n `SELECT size, destination, \"${region_from}\" FROM takkyubin where size like $1 AND destination like $2`,\n [`%${d}%`, `%${region_to}%`]\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":651,"value":"max_shipping_rate = parseInt(rates[0][region_from])","pinned":true,"hidden":false,"mode":"ojs"},{"id":804,"value":"model_item_fee = per_order + per_item * q","pinned":true,"hidden":false,"mode":"ojs"},{"id":806,"value":"model_weight_fee = per_order + M_t * per_kg","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}