Manufacturing – Inventory and Sales Manager – Google Sheets Template

Description
If your business requires to buy raw materials and convert them to products by assembling or manufacturing, then managing the inventory of products and raw materials is surely a task! This simple Google sheets template is just what you need.


HIGHLIGHTS
1. Manage inventory at a manufacturing/assembly business.
2. Automate inventory calculations of raw materials based on products.
   a. Detail on the inventory status after each manufactured product.
   b. Know the current inventory levels of each product and raw material.
3. Choose whether you hold manufactured goods or not (at the product level).
4. Easy to apply price changes to raw materials, and the template can handle price changes on future dates as well.
5. Identify the products and raw materials to be re-ordered.
6. Order details with the ability to handle unit-level discounts at the product level.
7. Print automatically created invoices.
   a. Additional information on the feasibility of the invoiced order is available.
8. Product report: Detailed product-level report with extensive product-level details.
9. Raw Material report: Detailed raw materials report with extensive inventory details.
10. Extensive Report page:
   i. Current status of products and raw materials with accounts receivable and payable.
   ii. Product sale v. raw material purchase report with gross and net profit, respectively.
   iii. Key inventory and sales metrics and monthly trend analysis.
   iv. Identify your best-performing products.
   v. Know how different product categories contribute to sales.
   vi. Product performance report
   vi. Partner performance report