Manufacturing to Retail Cost Calculator

Thanks.... but how can I move the post?

Yes, indeed there are many overhead costs. My sample file is geared toward a screen where my customers may see the calculations, so some items are hidden. Typically how I calculate profit and overhead is where if my material costs are say $100 I take that times 1.5, and charge the customer $150, but this does not include the Labor to produce the product, see below row 60 for a labor table. Typically that is based upon say $50 per hour, but when bidding out a project I have to prorate labor depending upon total square feet of materials, kinda the basis for small projects taking more time than some larger projects are quicker overall per square foot of materials. The way the XLS file is constructed, my employee helped me get this started, it seems that it is way to vaque in calculating the final costs and not everything (expense) is taken into consideration. Like if I were to have a hidden table of what each wood type costs per square foot, or sometimes per item, and then the correct markup is calculated and so on, this way it is more accurate and as material costs increase I can easily go and change that hidden table with the correct new pricing. The way the lookup function seems to work, I would have to go to that cell and manually change the entire function to coinside with the correct prices and this would become very confusing to keep straight with the matching materials. I guess, I am wondering if there is a way to have my material data table on a different sheet, hidden away from the customer, and can pull that info into the drop down menus as I selectively choose each component or detail in making up the custom shelves. (I should note, to keep privacy, I made my chart somewhat generic, but the entire concept is entact)

do you need some kind of break-even analyzer?
if so, maybe this template can help you out:
http://www.spreadsheetzone.com/templateview.aspx?i=3
btw, you can download it for free.

hope helps =)

Thanks for the link, that would be helpful in other areas. Still need some advice on proper functions on my files...

okay, I looked your file in detail and attached the file in which I placed the formula you needed in the cells E8 and F8. I added the tables and the list right under the calculators.

you can play with the values and change them to the values you have,
you don't need to change the cells E8 and F8, though.

hope that helps.

SSM

Suzzy, Yes! That seems to be the right formula! I will also need to change the formula in cell I8 to the method you used in the other cells. This greatly helps. I will do some more research on how that formula works, but it definitely seems to be the proper function. Do you know if the data tables that the formula pulls from can be on a separate worksheet tab, I think that it would make for a less cluttered work area. Thanks again for your great help!