mavrik_stet
New Member
- Joined
- Oct 28, 2020
- Messages
- 1
- Office Version
- 365
- 2019
Hi,
Basically I'm trying to calculate the cost of good sold every month (for 20 years) using first in first out.
Row 9 in my photo indicates the number of new inventory that goes in every month, row 10 is the cost to be applied for the inventories that flowed in (added) for that month.
Row 12 is essentially a schedule on how the inventories are going to be wind down/sold (see total for rows 9 and 12 are equal just diff signs). Now, I need to calculate cost of goods and that involves using the appropriate cost. (ie. first 3,603 should be multiplied by 53.49, after that next 533.64 should be multiplied by 23.09 and so forth). However, I don't know the correct formula that would give me the correct cost to be applied automatically rather than manually.
Does anyone know how I can do this automatically?
Thank you!
Basically I'm trying to calculate the cost of good sold every month (for 20 years) using first in first out.
Row 9 in my photo indicates the number of new inventory that goes in every month, row 10 is the cost to be applied for the inventories that flowed in (added) for that month.
Row 12 is essentially a schedule on how the inventories are going to be wind down/sold (see total for rows 9 and 12 are equal just diff signs). Now, I need to calculate cost of goods and that involves using the appropriate cost. (ie. first 3,603 should be multiplied by 53.49, after that next 533.64 should be multiplied by 23.09 and so forth). However, I don't know the correct formula that would give me the correct cost to be applied automatically rather than manually.
Does anyone know how I can do this automatically?
Thank you!