Anbuselvam K
Member
Dear Excel Genius
I have produced some products in my company which is having or used different raw materials purchased with different prices. I want to calculate the products price per kg by using (Raw Materials) FIFO Method.
Below is the example data I have calculated Products 1 to 5's RM 1 price manually in column X, where I need to calculate RM 1 to 10 for the Products 1 to 5. (actual RM more than 100, just for an example I added 10 RM Only)
Products 1 to 5 RM Usage is in below image (Actual will be more than 10,000 productions are there to calculate)

RM 1 to RM 10 Purchase qty with price is below

Products 1 to 5 RM 1 cost manual entry is in below image (Attachment Column X)

In the Attachment Column W, I need each products RM 1 to RM 10 Cost summation to be showed by excel formula. Attached the file for your reference.
We can split the data into different sheet (One sheet consumtion another sheet purchase data if required)
Also, You can add helper column and it can be hide too.
I want the expected results in Column W by one excel formula.
I have produced some products in my company which is having or used different raw materials purchased with different prices. I want to calculate the products price per kg by using (Raw Materials) FIFO Method.
Below is the example data I have calculated Products 1 to 5's RM 1 price manually in column X, where I need to calculate RM 1 to 10 for the Products 1 to 5. (actual RM more than 100, just for an example I added 10 RM Only)
Products 1 to 5 RM Usage is in below image (Actual will be more than 10,000 productions are there to calculate)

RM 1 to RM 10 Purchase qty with price is below

Products 1 to 5 RM 1 cost manual entry is in below image (Attachment Column X)

In the Attachment Column W, I need each products RM 1 to RM 10 Cost summation to be showed by excel formula. Attached the file for your reference.
We can split the data into different sheet (One sheet consumtion another sheet purchase data if required)
Also, You can add helper column and it can be hide too.
I want the expected results in Column W by one excel formula.