I am trying to create an excel sheet that will calculate a variable based on a certain profit margin. It's for a manufacturing process where my formula looks like this:
Function 1 (cost)-----[(Material Cost*Part Weight)+(Hourly Labor Wage*CYCLETIME)+ ((CYCLETIME/60)*.75)] * Parts Needed = Cost
Function 2 (profit)----Revenue- Cost= Profit
Function 3 (profit margin)----(Profit/Revenue)*100= Profit Margin
Everything will be given in Function 1 except CYCLETIME. I am trying to have Excel do it tell me what CYCLETIME will be with 10% profit margin and the same for 30% profit margin.
I'm stuck on this and can't figure out how to get all three formulas to tie together!
Bookmarks