Product Management Using Excel

Product Management Using Excel

The Excel book provided to you in this post can handle: Estimation of Product Costs (materials, labor, tax, shipping) Estimation of Material Costs (per product, per month, per year) Inventory of Products and Materials (increase or decrease) This post will walk you through utilizing these sheets to help manage your products. Enable Macros Please make sure you enable macros, or the sheet will not work.  You may be prompted when first opening the sheet.  If you need specific steps to do this, please click here. Download [click to download] This Excel document contains 3 separate sheets. Price Calculator  Being able to estimate product costs and profits is an essential part to product management.  The 'Price Calculator' sheet will help accomplish these goals. Any column with an orange header is calculated automatically, you do not need to touch these columns, they are dynamic. The Columns Name: The name of your product Profit: Dynamic column, no need for input, automatically calculated Sell Price: How much do you want to tell the product...
Read More