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
Hello! I am trying to determine how to make inventory adjustments of raw materials due to breakage, loss, or defects. For example, having 1000 glass bottles in inventory. I manufacture 750 products using this glass, but after completion, due to breakage and a few defective bottles, I only have 200 left. According to the raw material inventory in the spreadsheet, I should have 250 left. How do I make a -50 adjustment to the current inventory to make it line up with actual?
Currently, you will have to enter a dummy sale order with 100% sale amount discount to consider it as loss.
We take customization project for additional fee. Requesting to write to support@indzara.com for estimation.
Best wishes.
My Template does not have the BOM sheet
Thanks for purchasing.
Please enter the BOM info in the Manufacturing_Details sheet.
Please let us know if any questions.
Thanks & Best wishes.
How do you combine two or more raw materials to make a completed product. Example of a restaurant using different ingredients to make a meal sold as an item.
Thanks for purchasing.
Step by step instructions are available here: https://support.indzara.com/support/solutions/articles/62000151391-manufacturing-inventory-and-sales-manager-excel-step-by-step-user-guide
Please let us know if any questions.
Thanks & Best wishes.
I have two other requests,
can you tell me how to add two more custom columns in the invoice sheet that woud reference to a two other custom columns on the order details sheet? With the same functionality of the already build in custom columns on those two sheets.
The profit table in the sales report does not work.
Thanks
Regarding adding two custom order details columns to invoice,
Requesting to share your sheet to support@indzara.com to process the same.
Regarding concern on profit table,
Requesting to share your sheet to support@indzara.com to check further.
Best wishes.
Hi, the MANUFACTURING – INVENTORY AND SALES MANAGER v2.0 Template is really useful, especially after customising it to meet my needs. But still there is one thing, in the order details sheet I would like to enter wasted row materials and wasted final products, how do I do that?
Thank you for sharing your valuable feedback.
Addition of Raw Material Loss and Product Loss order type can be taken as a customization project for additional fee. Requesting to write to support@indzara.com for estimation.
Best wishes.
I just purchased the manufacturing and inventory spread sheet and none of the cells contain formulas for calculations and there are no drop down cells as shown in the videos. It is essentially a a static group of cells without any functions.
Thank you for purchasing the template.
You will get a email response from our support team shortly.
Best wishes.
hi
i got MANUFACTURING – INVENTORY AND SALES MANAGER v2.0, but i want to know how to make the material stock since i bought material in MT. and manufacturing in KG.
for example: water tank 1000 us/gallon total weight is 90kg and have 3 layer’s first layer is 50kg, second layer 17kg & third layer 23kg & we have another like 1000 us/gallon total weight is 103kg and have 4 layer’s first layer is 50kg, second layer 14kg, third layer 17kg & forth layer 22kg.
please let me know about this and how to add them to the program so i can know my stock after manufacturing.
Thank you for purchasing the template.
You will have to convert the MT to KG during the time of purchase or you will have to convert the KG to MT in Manufacturing details tab. For ex.,
Manufacturing details
Product A – Layer 1 – 0.05 MT
Product A – Layer 2 – 0.017 MT
Product A – Layer 3 – 0.023 MT
Best wishes.
Hi Indzara,
I am using ounces. How do you suggest I fix the issue Im having? its not creating any finished goods and no sales reports are generated.
Hello,
I am using v2 of the template. I need to add additional columns to the products (PRODUCT ID#), and raw materials (RAW MATERIALS ID#, SUPPLIER, SUPPLIER ID#) sheets without disrupting existing formulas. I then need the manufacturing_details sheet to pull the product/raw materials ID# rather than the product/raw materials name. How can I do this?
Hi,
I have the V2 of the template, but when I place any type of order MFG, SALES or PURCHASE none of the inventory levels are updating. I have tried using the refresh button as you suggest but this doesn’t seem to be making any difference. I am desperate to get my system up and running as I am spending hours updating everything manually in another set of spreadsheets. please can you help.
Thanks for using our template.
At times a broken link or a deleted formula can be a reason for these issues. We will request you to download the file again and use it. In case the issue persists, please email your file along with the list of issues to contact@indzara.com.
Best wishes
How would I track batch numbers associated with the raw materials into a specific product? Every new order of raw materials would have a different batch number and I would need to know which batch I used to make a specific product in case of recall (for example)?
Thanks.
The template does not track the raw materials used to a specific order. If possible, you can use the custom column in Order Details to record the batch number of raw materials used in a Sale or Mfg order. It has to be manually entered.
Please let us know your feedback.
Best wishes.