Direct Costing with Excel

By Admin
In Excel Tools
Mar 7th, 2017
0 Comments
182 Views

Direct Costing with Excel

Template prepared to realize basic calculations of profitability with the method Direct Costing.

The calculation of Direct Costing only takes into account the variable costs in the products for the calculation of the profitability of them, unlike the Full Costing system that distributes the fixed costs in the cost of the product.

The system calculates for each product the gross or contribution margin, with the variables quantity, unit price, unit cost ….

The summary of total return calculates the difference of the Total Margin of all the products and the Fixed Costs.

 

direct-costing-excel-example

 

The tool incorporates fields to perform simulations with unit sales prices and costs.

The template is open and editable so you can adapt it to your company.

Balanced Scorecard download

Free file download here 

 

Dani Granero

Dani Granero

(ODOO Consultant and Controller)

www.indaws.es

Valencia – España

See you in Linkedin

Google+

Send me a note

Telephone: 00 34 963 81 64 34

Want to talk by skype or hangout? just contact us

 

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *