May 05 2021 07:04 PM
Hello!
I am currently studying logistics. I recently got a project to create a production calculator. It is supposed to work on the principle that:
-The factory can produce up to 9 batches of the product.
-Until the fifth batch, each subsequent batch is 10% cheaper to produce.
-6 to 9 batches are 50% cheaper to produce.
That is, the first product has a 10% lower cost of production. So when producing two products, the first products will have a 10% lower production cost and the second products will have a 20% lower production cost.
I hope I have explained the situation in an understandable way. My problem is that I can't do it with Excel. I cannot correctly use the IF function to create this calculator.
So I am asking for help on how to do this because I have not found the answer anywhere else. Is it even possible in Excel?
May 05 2021 09:57 PM
May 06 2021 07:24 AM
SolutionMay 10 2021 12:26 PM
May 06 2021 07:24 AM
Solution