10:31 Can I approximate the time it would take to package an entire batch and not tick it or should I work out how long it would take me to package only one unit?
Hi there! You have basically 2 options. You can define the time to create 1 product and i this situation you should tick the box, or you could enter the time to create your whole batch and in this case you leave the checkbox unticked. Thanks!
Nice session. For on line sellers or start-ups this is perfect Comments: internal sku should be automatically populated when either materials or # of units. When you added in-0027 was added the format was different
Hi there! Sure! In Question 2 you simply have to enter the amount of money you want to make with this product and the spreadsheet will give you the quantity of product you have to sell to generate this amount of money (with and without discount). In Question 3, you simply have to enter the amount of money you want to reduce your production cost and the spreadsheet will display the new profit and profit margin of the product. Thanks
Hi there! To calculate the price for another product, you should delete all the data inside the PRICE CALCULATOR tab. Then, to add your price in the PRICE LIST tab you simply have to copy and paste the data at the top of the page. Thanks!
Hi there! No, $58.49 is the price for each product with this spreadsheet. The "divided by 10" is already done if you left the checkbox untick in the "Per Unit" column. Thank you!
So in the pricing calculator tab, under raw materials costs, should materials be auto populated in the dropdown from the materials tab? Mine is still blank after I've filled in the materials tab
Hi! Have you selected a material using the dropdown menu and entered a quantity? The rest of the columns (units, unit price and total cost per unit) will be auto populated. And if you do not see anything in the dropdown menu, it means that you might need to fill in the material tab. Don't hesitate to reach out directly to us on Etsy, it might be easier to help you if needed!
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/n.gif)
10:31 Can I approximate the time it would take to package an entire batch and not tick it or should I work out how long it would take me to package only one unit?
Hi there! You have basically 2 options. You can define the time to create 1 product and i this situation you should tick the box, or you could enter the time to create your whole batch and in this case you leave the checkbox unticked. Thanks!
Nice session. For on line sellers or start-ups this is perfect
Comments: internal sku should be automatically populated when either materials or # of units. When you added in-0027 was added the format was different
great product you have there. Can you help me understand the alternative questions 2 &3 below in the pricing tabs?
Hi there! Sure! In Question 2 you simply have to enter the amount of money you want to make with this product and the spreadsheet will give you the quantity of product you have to sell to generate this amount of money (with and without discount). In Question 3, you simply have to enter the amount of money you want to reduce your production cost and the spreadsheet will display the new profit and profit margin of the product. Thanks
@@Prioridigitalstudio ohhh I see, thank you.
Bonjour, comment ajouter une page PRICE CALCULATOR pour d'autres produits ? Et pouvoir la rajouter a PRICE LIST. Merci
Hi there! To calculate the price for another product, you should delete all the data inside the PRICE CALCULATOR tab. Then, to add your price in the PRICE LIST tab you simply have to copy and paste the data at the top of the page. Thanks!
Help Please so the price on this example. shouldnt that 58.49 be divided by the 10 units in that batch?
Hi there! No, $58.49 is the price for each product with this spreadsheet. The "divided by 10" is already done if you left the checkbox untick in the "Per Unit" column. Thank you!
So in the pricing calculator tab, under raw materials costs, should materials be auto populated in the dropdown from the materials tab? Mine is still blank after I've filled in the materials tab
Hi! Have you selected a material using the dropdown menu and entered a quantity? The rest of the columns (units, unit price and total cost per unit) will be auto populated. And if you do not see anything in the dropdown menu, it means that you might need to fill in the material tab.
Don't hesitate to reach out directly to us on Etsy, it might be easier to help you if needed!