electrichi01
New Member
- Joined
- Aug 10, 2009
- Messages
- 44
Hi
In this example, I want to be able to change in a spreadsheet the Overhead and Profit percentages to any number in the boxes.
As you look at the simple math, using 10% for example only gives you 7.94% real, as you need to divide to come up with the true 10%.
So, how would you write this algebraically?
Meaning, on another sheet, will be the data entry point for adjusting OH & Profit, so I would like it to always compute this correctly. When I have done it in the past, it comes up with a circular reference.
Example- open excel
Labor $1000 or 39.68% of total
Materials $1000 or 39.68% of total
Subtotal $2000
OH 10% $200 or 7.94% of total
Profit 10% $200 or 7.94% of total
Subtotal $2400 or 95.24% of total
Tax 5% or 4.76% of total
Grand Total $2250 or 100% of total
I don't know how to make attachments here, or if it is allowed? I can send the files to those that would like to assist.
Thanks
Keith
In this example, I want to be able to change in a spreadsheet the Overhead and Profit percentages to any number in the boxes.
As you look at the simple math, using 10% for example only gives you 7.94% real, as you need to divide to come up with the true 10%.
So, how would you write this algebraically?
Meaning, on another sheet, will be the data entry point for adjusting OH & Profit, so I would like it to always compute this correctly. When I have done it in the past, it comes up with a circular reference.
Example- open excel
Labor $1000 or 39.68% of total
Materials $1000 or 39.68% of total
Subtotal $2000
OH 10% $200 or 7.94% of total
Profit 10% $200 or 7.94% of total
Subtotal $2400 or 95.24% of total
Tax 5% or 4.76% of total
Grand Total $2250 or 100% of total
I don't know how to make attachments here, or if it is allowed? I can send the files to those that would like to assist.
Thanks
Keith