Costing-Templates PRO For Excel

Costing-Templates PRO For Excel

For all versions of Excel

Contact us: admin@mlnsoft.com

Costing-Templates PRO supplies overhead cost application templates, materials receiving ledger form template, marginal costing calculations for products/product lines, departmental budgets, inventory economic ordering quantities (EOQ) and price decision/target costing equations, for all companies.

The traditional method template for allocating overhead costs over all sales outputs or labor staff costs.
The Variable Overhead Cost allocation method (VOC) using cost drivers.
The Activity Based Costing (ABC) system.
Applying the ABC system to calculate marginal costs and prices.
Applying the VOC and ABC systems to find and eliminate unproductive overheads costs.
Economic Order Quantities to minimise inventory holding costs.
Pricing (costing) templates - transfer pricing calculations - target costing methods.
Materials receiving ledger account template, stores requisition template, job costing template.
Depreciation tables.

Cost-Templates PRO supplies clear directions and explanations.

The Budgeting template (below) uses the VOC system to identify surplus overhead costs:

The ABC system calculates cost drivers applied to activity cost centers, supplying more accurate profit/loss data extracted from business divisions and product reporting.

Use the Marginal Costing-Pricing template to calculate the real marginal costs of your sales $.

EOQ is the ordering quantity level that minimises the costs of your holding and purchasing inventories whether you are a distributor or manufacturer based on output levels, transaction and holding costs. Costing-Templates PRO provides the template for calculating the quantity discount level that delivers the lowest overall inventory cost, including costs of storage, finance and processing expenses:

The Inventory template provides high and low stock warnings for individual stock item in Excel, calculates the current weighted average cost per unit held in stock, the total number of units and total value in stock. Use this template to create the inventory list control system next right.