Manufacturing – Inventory and Sales Manager – Excel Template Support
This is the Support page for the Manufacturing – Inventory and Sales Manager – Excel Template. Please post any questions related to this template in the comments below.
Product Page:
Manufacturing – Inventory and Sales Manager – Excel Template
Version History:
- v2 published July 24, 2015
- v1 published Apr 25, 2015
Useful Links:
- How to Migrate data from v1 to v2 in less than 10 mins?
- Enhancements in v2 compared to v1
- v1 Support Page
145 Comments
Thanks for the template.
Ive entered a test set of data but calculations not done after raw materials been used. Is there any sheets available with for an example data set ?
Thanks for purchasing. The product page has the instructions with screenshots: https://indzara.com/product/manufacturing-inventory-sales-manager-excel-template/
After entering any data, please refresh data from the DATA ribbon as explained in the product page. The calculations will get updated immediately.
Please check whether your data entered is inside the correct tables. I have a video that explains data entry in Excel tables (though it uses a different template to explain the concept). https://www.youtube.com/watch?v=LInmjM_5qQQ
I have emailed you a sample file. Please use it for reference. If there are further questions, please email your file and I can look into why calculations are not updating.
Thanks & Best wishes.
Will this work on mac?
The template should work in Excel 2016 for Mac. For a template that works in Excel 2011 for Mac, I have one that has all sheets except the ‘Sales Report’. Please e-mail me at indzara at gmail dot com if there are any questions. Thanks for your interest. Best wishes.
Hello, I like your MFG template very easy to use but I have a problem to run the inventory. here is a problem we build module in our factory and also outsource to the vendor who will build same module for us too. now how do I generate a purchase order “Finish Goods” from the vendor? please advise thank you.
Thanks for the kind words. Please post your product review on the product page https://indzara.com/product/manufacturing-inventory-sales-manager-excel-template/, if possible.
Please correct me if I am not understanding your question correctly. If Product A can be manufactured in-house using purchased raw materials and the same Product A can also be bought from another vendor, then the two scenarios use different ‘recipes’. In such a case, it has to be entered separately as two separate products.
When you purchase a product (let’s say Product B) from vendor and sell as it is (i.e., retail), then you would enter that product recipe as 1 unit of Raw Material B = 1 unit of product B. In your purchase orders, you will purchase Raw Material B. In your sale orders, you will enter Product B.
Please let me know if there are any further questions.
Thanks & Best wishes.
I purchased your manufacturing inventory sales manager template. I have been looking for a template like this for many months. It certainly beats the 1,000s of dollars I have been quoted to have a new computer software installed. I have a pretty good knowledge and understanding of excel, but I do not possess the skills necessary to build this program on my own. Using it however is pretty simple.
There is more then enough information to be fully able to run your manufacturing business using this spreadsheet. My only recommendation (which I have done on my own) is to insert costs so you are better able to know what is the dollar amount that you currently have available in your inventory.
satisfied customer
Thank you so much for the positive feedback. I am very glad to hear that the template is useful for you. I take your recommendation for improving in the next version. Thanks for posting the product review on the product page. You are eligible for a free template as per the offer. https://indzara.com/2015/03/buy-one-write-review-get-one-free/ Please e-mail me the product name and I will send the free coupon code. Best wishes.
Hello,
I would like to know how to retrieve pieces out fo the raw material inventory without touching the initial inventory. Why? because our small assembly line repair damaged goods and use spare parts to fix them.
Thanks,
I am sorry that I am not following your exact scenario. Please email me at indzara at gmail dot com with example data on how the calculation is expected to work. Thank you.
Thank you so much..
Sir, your template is great. But I am facing some problems. I will elaborate this by giving an example. Suppose, I created a sales order of 4500 pieces/ year to one of my client but i am not sending the complete order together. I am sending parts monthly, based on how much I produce. Now I don’t know how to keep a track of the number of pieces I already sent and how many left to deliver. I want that on the same sales order that was made for 4500 pieces, i create different invoices of how much quantity i produce but whenever I put sales order on invoice, it shows 4500 pieces on quantity column but actually i want to send only 900 for time being and also i want the remaining balance to be shown on excel sheet on that sales order number. Please help me on this as soon as possible. or modify my template if possible.
Thanks for purchasing.
I am looking into your questions. I will respond soon by e-mail.
Best wishes,
hi indzara,
The templates you have created are pretty amazing and useful.
I am looking to purchase your Manufacturing Inventory and Sales Manager spreadsheet. I need to know if I would be able to change a few things, the only things I would need to tracking is the Purchase orders, Current inventory, Amount received and Amount removed from Inventory. I also would like to include picuters on inventory list if that is possible.
Please advsie. Thank you,
Thanks. You will receive a password to unprotect and edit as needed. However, it needs to be carefully done, without impacting existing formulas. Adding pictures can be done similarly if you are familiar with doing it. I want to clarify that it is not pre-built in the template. Please let me know if there are any questions. If you try and are not satisfied with the product, please email me and I will issue a refund immediately. Thanks & Best wishes.
I would like the item description to show up on me sales invoice. is there an easy way to do this? I could start hacking away at the spread sheet but I would rather not. can you help me out with this please? My email address is andre.corpus@live.com. From what I have used this spreadsheet is amazing and I have already recommended the retail sheet to my father. I think you have a great product here.
Thanks,
Andre
Thanks for the compliments. I have e-mailed you the file with the product description. Please let me know if there are further questions. Thanks & Best wishes.