 |
|
|
|
|
|
Our Excel (97 or above - Mac Or Windows) Costing provides:
Standard costs, activity based costs, overhead cost recovery ratios, cost drivers, absorption costs and cost allocation ratios in Excel.
Complete range of product costing formula with eight ready to use costing templates iin the first workbook with Excel costing formula provide unit costs for pricing and profit recovery calculations.
Excel database supplies accurate costs into costing formula.
Benchmark costing ratios.
A – Z spreadsheets for Marginal costing - Standard costing – Activity based costing – Cost drivers – Absorption Costing values and Most economic quantity.
Formula and equations each step of the way.
The new 2008 edition includes the risk analysis of achieving your gross profit margin goal. Include up to 30 individual product ranges (or services, or any revenue generating activity) and up to 15 unit cost forecasts within the analysis and the spreadsheets consolidates all 30 x 15 variables within the boundaries of your best case, median and worst case cost forecasts to calculate the overall probability of reaching your profit margin goal.
The new 2008 edition includes the risk analysis of reaching your gross profit margin goals when customer spending patterns change and these changes impact your unit costs. Runs Monte Carlo simulations of the most probable outcomes and returns the probability of achieving whatever target is set.
Zip file download or select CD edition shipping.
Using Costing-Templates PRO you can allocate overheads more accurately for calculating real product and divisional costs, contributions to profits, and for estimating/pricing data. Costing-Templates PRO helps you focus on how overheads can be managed more efficiently, and will help you identify unprofitable products or services and eliminate unproductive overhead resources.
With Costing-Templates PRO you can calculate your unit overhead cost drivers to link indirect and overheads costs more directly to products and customers.
Costing-Templates PRO provides you with Excel spreadsheets that calculate product/divisional costs and profit margins using direct volume allocated overhead costing systems, variable volume and transaction overhead allocation systems, overhead cost pooling systems, and the Activity Based Costing (ABC) system which uses real activities and cost hierarchy methods to focus where and why overhead costs are consumed.
The costing formulas are fully readable in the open Excel worksheets.
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.
Costing Templates Pro
$169.95 $69.95
Secure Payment Options
Buy as part of
All Excel
Templates Gold Edition - HUGE Value
- 80% Discount!
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $138.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft