LOADING
Click here to view your shopping cart contents and to proceed to the Checkout. All prices are once-off and there is no time limit on the use of our templates.
   
 
100% Unique Excel Templates!
  • Accounting in Excel
  • Financial Statements
  • Management Accounts
  • Cash Flow Forecasts
  • Fixed Assets Registers
  • Product Costings
And A Lot More!
  • Try Before You Buy!
  • Click the Trial buttons and enable our 100% safe trial version
  • macros to try out the templates...
  • No Macros? View Our Samples!
  • Click the Sample buttons to view the layout of the templates
  • in a file format that cannot be edited...
  • Ready To Buy?
  • Simply click the Buy Now buttons to add the appropriate
  • template to your shopping cart...
  • Download all our unique templates!
  • Register for a full membership in order to download
  • ALL 40+ of our unique templates!
Click to select & buy any 3 of
our unique templates for
only ZAR600!
For a full membership to buy
ALL 40+ templates for
only ZAR2,400!
 
  This page lists all our Excel Costing & Inventory templates. Our 40+ unique templates are listed on the following template pages:  
  • 30 Product Costing Template
This practical Excel template enables users to compile product costings for an unlimited number of manufactured products. The product costings are based on the purchase prices that are entered for all bought-in stock items and the bills of material (“recipes”) that are compiled for each manufactured product. A bill of material can be compiled by linking a manufactured product to the components that are used in the manufacturing of the product and entering an input quantity and a yield for each stock component. The template includes a detailed product cost review sheet, what-if cost calculations for cost analysis purposes and quantity forecast calculations that can be used for requirements planning and stock usage measurement.
  • Includes the following features:
  • Suitable for any type of manufacturing business
  • Create stock codes for all bought-in and manufactured products
  • Enter purchase prices and what-if costs for all bought-in products
  • Create bills of material for all manufactured products
  • Automated calculation of product costing for all manufactured products
  • Includes detailed product cost and comprehensive what-if cost analysis
  • Includes requirements planning and stock usage forecast
  • Calculates gross profit margins based on product and what-if costings
  • Calculates what-if selling prices based on existing gross profit percentages
  • Accommodates multiple level bills of material (up to 7 levels)
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. excel cost templateClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. product cost modelClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel costing templateClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. costing templateClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR400 ($31 £25 €29) File Size: 346KB File Size: 107KB File Size: 209KB File Size: 78KB
  • 31 Job Costing Template
This template enables users to compile job costings for all manufactured products by comparing actual costs to standard costs and measuring the total production variance as well as the usage & price variances on an individual job and total basis. The standard costs are based on the individual standard prices that are specified for all bought-in stock items and the bills of material (“recipes”) that are compiled for each manufactured product. The actual costs are based on the components that are issued to each manufacturing job and the actual prices of all bought-in products. The template also includes a unique production variance summary report and a production forecast report which can be used for materials requirements planning (MRP) purposes.
  • Includes the following features:
  • Suitable for any type of manufacturing business
  • Create stock codes for all bought-in and manufactured products
  • Enter standard prices & create bills of material for manufactured products
  • Create jobs for all manufactured products
  • Record actual component usage & prices for each job
  • Review actual vs standard cost and usage & price variances of each job
  • View a summary of usage & price variances for all jobs
  • Compare actuals & standards for all components & manufactured products
  • Calculate material requirements (MRP) based on any production forecast
  • Accommodates multiple level bills of material (up to 7 levels)
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. excel job cost templateClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. job costing modelClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. job costing templateClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. excel job costingClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR400 ($31 £25 €29) File Size: 763KB File Size: 187KB File Size: 412KB File Size: 120KB
  • 32 Inventory Control Template - Trade Based
This unique inventory control template enables users to analyze the profitability of any trade based business by calculating the gross profit margins of all inventory items. The functionality that has been included in this template enables users to control inventory by creating stock codes for all individual inventory items; recording inventory purchases, sales and adjustments; performing physical stock counts and analyzing stock take variances; calculating stock valuations and measuring sales, cost of sales & gross profits based on any user defined date range. All inventory valuations are performed on an average cost basis and a comprehensive stock valuation, movement and gross profit margin report is automatically compiled for each stock code that is created.
  • Includes the following features:
  • Suitable for trade based businesses that buy and sell the same products
  • Create stock codes for all inventory items
  • Record purchases, sales and inventory adjustments
  • Inventory valuation on an average cost basis
  • Includes physical stock count feature & calculation of stock count variances
  • Automated calculation of theoretical inventory balances
  • Includes comprehensive analysis of inventory movements
  • Analysis of sales, cost of sales and gross profit based on any date range
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. stock templateClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel stock templateClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. inventory templateClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. excel inventory templateClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 ($23 £19 €22) File Size: 734KB File Size: 235KB File Size: 419KB File Size: 188KB
  • 33 Inventory Control Template - Usage Based
This inventory template enables users to analyze the profitability of a business by comparing sales to inventory usage. In many business environments, it is impractical to perform accurate calculations of cost of sales and it is a lot more feasible to compare inventory usage to sales. The functionality that has been included in this template enables users to control inventory by creating stock codes for all individual inventory items; recording inventory purchases, usage and adjustments; performing physical stock counts and analyzing stock take variances; calculating stock valuations and measuring sales, cost of sales & gross profits based on any user defined date range. Cost of sales is defined as the sum of all usage and adjustment transactions for this purpose.
  • Includes the following features:
  • Suitable for any business that requires inventory usage measurement
  • Create stock codes for all inventory items
  • Record purchases, inventory usage and inventory adjustments
  • Inventory valuation on an average cost basis
  • Includes physical stock count feature & calculation of stock count variances
  • Automated calculation of theoretical inventory balances
  • Includes comprehensive analysis of inventory movements
  • Analysis of sales, cost of sales and gross profit based on any date range
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. excel stock templatesClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. stock templatesClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel inventory templatesClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. inventory templatesClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 ($23 £19 €22) File Size: 447KB File Size: 171KB File Size: 332KB File Size: 139KB
  • 34 Inventory Quantity Control Template
This unique template enables users to control inventory by recording opening stock quantities, capturing all inventory movement transactions, performing stock takes and calculating stock quantities on hand for any user defined date range. The template makes provision for stock purchase, sale, receipt, issue and adjustment transaction types and can be used by any business and for any type of inventory.
  • Includes the following features:
  • Suitable for any business and any type of inventory
  • Create stock codes for all inventory items
  • Record purchases, receipts, sales, usage and inventory adjustments
  • Includes physical stock count feature & calculation of stock count variances
  • Automated calculation of theoretical inventory balances
  • Includes comprehensive analysis of inventory movements
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. stock quantity templatesClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel stock quantityClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel inventory quantityClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. inventory quantity templatesClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 ($23 £19 €22) File Size: 295KB File Size: 112KB File Size: 228KB File Size: 92KB
  This page lists all our Excel Costing & Inventory templates. Our 40+ unique templates are listed on the following template pages:  
                     
You have 0 templates in your cart