フリマの個別・同梱手取り比較シート(Excel)Flea Market Individual vs. Bundled Sales Profit Comparison Sheet (Excel)
- ダウンロード商品¥ 100

日本語 「3点で2,100円になりませんか?」と聞かれたとき、どこまで値引きしても個別に売ったときの手取りを保てるか計算するExcelシートです。トレカ、本、雑貨など、送料込みで出品したものを同じ相手にまとめて送るときに使えます。 単品ごとの価格・送料・梱包費と、まとめて発送する場合の費用、希望金額、販売手数料率を入力すると、個別発送と同梱の手取り、差額、個別と同じ手取りを確保する最低価格が出ます。入力用と記入例を収録。2〜10点を比較できます。 たとえば1,000円・800円・600円の3点を別々に売ると、送料と梱包費が各220円、販売手数料率10%で手取りの合計は1,500円。同梱の送料と梱包費が合計290円なら、2,100円でまとめて売ったときの手取りは1,600円です。同じ依頼でも、同梱の送料と梱包費が490円に上がると手取りは1,400円。今度は個別発送のほうが100円多くなります。梱包サイズが変わったときも、実際の送料で比較できます。 形式は .xlsx です。数式を再計算できる表計算ソフトで開いてください。Excel実機・スマートフォン・Googleスプレッドシートでの動作は未確認です。販売手数料は個別取引ごと・まとめ取引ごとに1円未満を切り捨てます。料率と送料はご自身の取引条件を入力してください。固定の決済手数料、キャンペーン還元、売上の振込手数料には対応していません。ここでの手取りは仕入原価や税金を引く前の金額です。販売成立や、希望額で売れることを予測する機能はありません。 個人の出品・ご自身の事業で何度でも使えます。シートそのものの再配布・再販売はご遠慮ください。 English Have you ever received a message from a buyer asking, “Would you take ¥2,100 for all three items?” This Excel spreadsheet helps you calculate how much you can discount a bundle while still earning at least as much as you would by selling each item separately. It’s ideal for trading cards, books, collectibles, and other items listed with shipping included, especially when you’re considering combining multiple purchases into a single shipment. Simply enter the following information: - Selling price of each individual item - Shipping and packaging costs for each item - Total shipping and packaging costs for the combined shipment - Proposed bundle selling price - Marketplace selling fee percentage The spreadsheet automatically calculates: - Total net proceeds from selling items separately - Net proceeds from selling the items as a bundle - The difference between the two options - The minimum bundle price needed to earn at least as much as selling the items separately The file includes a ready-to-use calculator and a completed example sheet. **Supports comparisons of 2 to 10 items.** Example: Is Bundling Three Items Worth It? Suppose you’re selling three items priced at ¥1,000, ¥800, and ¥600. If you sell them separately, with shipping and packaging costing ¥220 per item and a marketplace selling fee of 10%, your total net proceeds would be ¥1,500. Now, imagine a buyer offers ¥2,100 for all three items. If the combined shipping and packaging costs are ¥290, your net proceeds from the bundle would be ¥1,600. That’s ¥100 more than selling the items separately. However, if the combined shipping and packaging costs increase to ¥490, your net proceeds would drop to ¥1,400. In that case, selling the items separately would earn you ¥100 more. This calculator makes it easy to compare both options using your actual shipping costs, even when the package size changes. *File Format & Compatibility - File format: .xlsx - Designed for spreadsheet applications that support formula calculations - Compatibility with desktop Microsoft Excel, mobile devices, and Google Sheets has not been independently tested *Important Notes - Marketplace selling fees are calculated separately for each individual transaction or bundle transaction, with fractional amounts below ¥1 rounded down. - Please enter the actual selling fee percentage and shipping costs applicable to your transactions. - Fixed payment processing fees, promotional rewards, and payout or withdrawal fees are not included. - “Net proceeds” refers to the amount remaining after the specified selling fees, shipping costs, and packaging costs, but before deducting the original cost of the items or any applicable taxes. - This spreadsheet does not predict whether an item will sell or whether a buyer will accept your proposed price. * Terms of Use You may use this spreadsheet as many times as you like for your personal listings or your own business. Redistribution or resale of the spreadsheet itself is not permitted. Thank you for your interest!
