peterzwart
New member
- Joined
- Sep 27, 2021
- Messages
- 4
Hi All,
Presently, I am engaged in conducting a financial assessment for a company. I have encountered a mathematical challenge that is proving to be quite perplexing. However, I am confident that there is a single solution for these equations.
I will try to be more specific: I want to know the revenue for various revenue categories (e.g. from projects, products, trade, etc.) by giving in a total number of available labor hours. Additionally, I give in the revenue distribution among the revenue categories, the material percentage (as percentage of the cost price, and the gross margin.
Please find a screenshot below:
What I would like to have is the formulas that automatically calculate the number of hours for each category. The Excel sheet can be found here: Online excel sheet These formulas should respect the total number of available hours and the revenue distribution. Also, all other orange cells are input values that I would like to vary.
Is there anyone that can resolve this challenging problem?
Please let me know if any additional clarifications are required.
Thank you in advance,
Kind regards,
Peter
Presently, I am engaged in conducting a financial assessment for a company. I have encountered a mathematical challenge that is proving to be quite perplexing. However, I am confident that there is a single solution for these equations.
I will try to be more specific: I want to know the revenue for various revenue categories (e.g. from projects, products, trade, etc.) by giving in a total number of available labor hours. Additionally, I give in the revenue distribution among the revenue categories, the material percentage (as percentage of the cost price, and the gross margin.
Please find a screenshot below:
What I would like to have is the formulas that automatically calculate the number of hours for each category. The Excel sheet can be found here: Online excel sheet These formulas should respect the total number of available hours and the revenue distribution. Also, all other orange cells are input values that I would like to vary.
Is there anyone that can resolve this challenging problem?
Please let me know if any additional clarifications are required.
Thank you in advance,
Kind regards,
Peter