Multiple variables in array with formula

I have a Complex Formula (as below)
Formula.png
for which values for certain cells are changing each week (variables, yellow highlighted)and I have to arrive at Net Landed costs for each week.
variable.png
I have for each different values (variables, yellow highlighted) that will change the landed costs. I wish to arrive at Net Landed cost for each month.
As i understand excel, I need to create different worksheets for each week to get correct results.
can anybody suggest better way.

Thanks in Anticipation.

Hi Paresh,

May I know how you calculate the Net Landed Costs. I am not able to figure out the formula for freight, total cost, and cenvat.

You would want to have table 2 data input into the same formula and generate weekly reporting?

Thanks
Edwin