[et_pb_section bb_built=”1″ admin_label=”section” fullwidth=”off” specialty=”off” transparent_background=”off” allow_player_pause=”off” inner_shadow=”off” parallax=”off” parallax_method=”on” custom_padding=”15px||0px|” make_fullwidth=”off” use_custom_width=”off” width_unit=”on” make_equal=”off” use_custom_gutter=”off”][et_pb_row admin_label=”row” make_fullwidth=”on” use_custom_width=”off” width_unit=”on” use_custom_gutter=”off” allow_player_pause=”off” parallax=”off” parallax_method=”on” make_equal=”off” parallax_1=”off” parallax_method_1=”off” parallax_2=”off” parallax_method_2=”off” custom_padding=”||0px|”][et_pb_column type=”1_3″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”right” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]
TOOLS AND SPREADSHEETS
[/et_pb_text][et_pb_image admin_label=”Image” src=”http://www.perryandkim.com/wp-content/uploads/2016/09/reading-box.jpg” show_in_lightbox=”off” url_new_window=”off” use_overlay=”off” animation=”off” sticky=”off” align=”left” force_fullwidth=”off” always_center_on_mobile=”on” use_border_color=”off” border_color=”#ffffff” border_style=”solid” custom_margin=”200px||30px|” custom_margin_tablet=”30px||30px|” custom_margin_last_edited=”on|desktop” /][/et_pb_column][et_pb_column type=”2_3″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid” max_width=”770px” module_class=”resource-page”]
Here are some spreadsheet tools we have created for our own use and for yours. We hope you find them useful for your business. If you have a suggestion or request, let us know.
Open the links below then save your own copy by choosing File: Make a Copy
- Batch analysis worksheet – View and analyze your sales by batch
- Calculated minimum prices based on COGs – Use this tool to calculate estimated minimum prices for your products based on your cost of goods. Bases estimated FBA fees on products you have sold recently. This is useful if most of your products are similar in size and weight.
- Cash flow worksheet – Helps you understand your incoming funds vs. your outgoing funds, including the growth of your inventory month over month. It’s only as accurate as the expenses you log in InventoryLab, so keep good records!
- Discount and sales tax calculator – See how sales tax and discounted gift cards or other discounts affect your ROI on individual items or your entire purchase
- Repricing Prodedure (Min based on Cogs, Max based on list price) – This is step by step instructions for our current repricing strategy for Bqool and InventoryLab users. Our own minimum price is set at an estimated 20% ROI over cost of goods. Our maximum price is 20% over the price at which we listed the item. You can tweak these numbers to fit your strategy.
- Sales analysis worksheet – View and analyze your sales based on number of days between the date you bought it and the date it sold
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]