We need to establish a way for us to track our fill rate %. Our current method of using lines entered vs. lines shipped is not accurate.
Does anyone have any suggestions on how we can determine what our fill rate % is for our orders? Could we calculate fill rate by SKU?
If so, does anyone have a template or can they explain to me how this would be done? I've been thrown into a Demand Planner role with little to no excel experience. Any help is greatly appreciated.

If you need additional information, please do not hesitate to ask.