Excel Formula

[Bittureddy]

I have 52 weeks as columns and 30 products as rows. There are 3 machine machine 1, machine 2, machine 3. Each product takes certain amount of time on each machine to get completed.
Sales

	W1	W2	W3
P01	xx	xx	xx

Processing Time in minutes

Product	Machine 1	Machine 2	Machine 3
P 01	0.6	2.5	1.2
P 02	2.2	1	0.9

I want total processing time on Machine 1, machine 2, machine 3 for W 1 based on the sales. Can any tell me easy way to do this as there are 54 weeks and 30 products.

 

[Jon21990]

Hi
Yes this can be done - I think you're asking for something like:

(for product 1) minutes on each machine / (sales for the week / cost per product) ...

Do you have any cell references so I can write something?

Thanks
jon