I need to create an application that has to do the following: Allow the end user to simulate projected inventory levels by date and by part number if a machine or machines were taken down for a period of time.
Here are some challenges that I have ran into:
So sum it up, I have to create a model that has these assumptions built in:
I gave up on enabling a user to be able to select a machine and date range to "take down" to simulate inventory levels in the UI, so I created an excel file with dates and machines hours that they can zero out the values and reload the app if needed.
I have a table created that has, Date, Part Number, and Demand Qty. I am stuck on how to assign machine hours per part based on the assumptions above. I am essentially trying to do what the example excel table is doing by allocating machine hours(Supply=Machine Hours *vManuTime) to each part number based on lowest to greatest inventory levels (Column G) each day (Column A) without making more than needed in total (example Row 8).
I'm sort of new as well and I've noticed that the more specific a question is the more likely to get a reply. I think that if you reduce your question to something more specific to Qlik and not to the domain, you'll see few answers coming. From smaller questions and answers you'll be able to build up
Hopes this helps,