Experience Level: Intermediate
Based on several logic criteria I am looking to calculate the planned write-off's and return the wastage value in the cell where it occurs. Imagine you run a food factory, you have 100 cases of product in stock, with a few days of shelflie left on it, but you need to plan further ahead. So based on your minimum production qty, forward forecast consumption, shelflife restriction, the processing time, how can the potential waste be calculated ahead? Dummy file attached for your info.
Mindaugas C.0% (0)
22 Oct 2018
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
There are no clarification messages.