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

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?

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.

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