How to calculate Expense with Price increase per year

Attachment 7808


Hi, I have the above problem, and I am wondering how would I calculate the profit with the annual increase for the material for the next few years.

Hi,

Much better than a Jpeg ... why don't you upload a zipped copy of your worksheet ...?

sorrie, here is the worksheet with the info

Hi,

It seems to me some descriptions of your calculations were not correct, or not in line the numbers shown ... so I have modified them ...
It should be OK now ... if not, feel free to change the formula ...

thank you for the help, the equation help a lot, can i also ask, is there a way to print the worksheet displaying the hidden equations or will it only print what i see

second, if the question doesnt specify that the fix cost is ($/unit) will I still have to multiple the expenses for A and B by the fixed cost or just added it to the total expense?

and the 1+B6 with B6 = 5%, will excel auto know to make that into 1.05?