nick205
|
| posted on 27/7/18 at 09:08 AM |
|
|
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
|
|
|
|
|
bi22le
|
| posted on 29/7/18 at 06:54 PM |
|
|
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
|
|
|
bart
|
| posted on 29/7/18 at 08:56 PM |
|
|
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
|
|
|
nick205
|
| posted on 30/7/18 at 12:42 PM |
|
|
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
|
|
|
