20corcaigh
New Member
- Joined
- Aug 12, 2016
- Messages
- 6
Hi all,
I have been starring at the screen for 2 hours and this is sending me crazy.
I would upload the excel file but I don't see an option for it.
Essentially I am look at our budget cost for 2021 and looking to increase it based on the tonnage increase we are seeing.
You can see both sites are increasing in tonnage by 20% and 50% respectively.
However when I use these percentages to calculate the "updated Budget" the sum of the factories equal 4200 whilst the TOTAL equals 4,154.
I know it is related to how the % on each line is calculated vs. the total but I don't know how to adjust the individual lines so they sum to 4,154.
Any help greatly appreciated.
I have been starring at the screen for 2 hours and this is sending me crazy.
I would upload the excel file but I don't see an option for it.
Essentially I am look at our budget cost for 2021 and looking to increase it based on the tonnage increase we are seeing.
You can see both sites are increasing in tonnage by 20% and 50% respectively.
However when I use these percentages to calculate the "updated Budget" the sum of the factories equal 4200 whilst the TOTAL equals 4,154.
I know it is related to how the % on each line is calculated vs. the total but I don't know how to adjust the individual lines so they sum to 4,154.
Any help greatly appreciated.