Printable Version | Subscribe | Add to Favourites
New Topic New Poll New Reply
Author: Subject: Help please - MS Excel template for product costing
nick205

posted on 27/7/18 at 09:08 AM Reply With Quote
Help please - MS Excel template for product costing

Morning all,

I've been asked to cost a couple of new manufactured products for work to arrive at a sale price for them.

We have an MS Excel template for this process, but to my knowledge this template was developed quite some years ago by an old director.

I can and will use this template to calculate some figures, but I'm sure there's people on here who have to do the same kind of task and I'm looking to see if anyone has an MS Excel template (or guidance) they might share with me?

Happy to move to U2U and email to discuss further if anyone can help.

Thanks,
Nick

View User's Profile View All Posts By User U2U Member
bi22le

posted on 29/7/18 at 06:54 PM Reply With Quote
I could certainly provide you with some advice depending on your starting template and what you are pricing up.

I don't have a singular Excel spread sheet to reference though. It would be a run down of inputs and considerations.

Are you costing up a full business plan ( need to consider ROI of product development expenditure for example) or itemised product cost only?





Track days ARE the best thing since sliced bread, until I get a supercharger that is!

Please read my ring story:
http://www.locostbuilders.co.uk/forum/13/viewthread.php?tid=139152&page=1

Me doing a sub 56sec lap around Brands Indy. I need a geo set up! http://www.youtube.com/watch?v=EHksfvIGB3I

View User's Profile View All Posts By User U2U Member
bart

posted on 29/7/18 at 08:56 PM Reply With Quote
I use excel costings all the time.but it's very product dependant and overhead dependant.really is no workbook std that could do it for you.best to develop one for your own use.should take no more than say 1/2 a day to make it work for you.sorry to not be more use.





BE ALERT > BRITAIN NEEDS LERTS

View User's Profile View All Posts By User U2U Member
nick205

posted on 30/7/18 at 12:42 PM Reply With Quote
Thanks both for the feedback.

bi22le
The requirement is to calculate product selling prices for 100, 250 and 500 pieces. We have itemised material costs and known labour costs + overheads.

As it stands I've made my own revision of the exisiting spreadsheet we used and made a few changes to it. It took me a few hours to fashion and test and I'm using it now to work out the required pricing - we'll see how it goes

Thanks again,
Nick

View User's Profile View All Posts By User U2U Member

New Topic New Poll New Reply


go to top






Website design and SEO by Studio Montage

All content © 2001-16 LocostBuilders. Reproduction prohibited
Opinions expressed in public posts are those of the author and do not necessarily represent
the views of other users or any member of the LocostBuilders team.
Running XMB 1.8 Partagium [© 2002 XMB Group] on Apache under CentOS Linux
Founded, built and operated by ChrisW.