How to determine monthly production need based on monthly working days for a year?
Please assist me in calculating the the daily production needs per facility and product category given monthly production volume and using monthly working days. Need to build graphs and chart showing what I need to produce on a daily basis.
Also how can I create a dynamic calendar that will automatically calculate remaining working days in the year?
I tried to make a sample table based on your description,but I found it was a bit difficult without knowing the production of each category per facility and etc. So you'd better provide more details such as sample data and expected output to make your requirement more clear.
Best Regards, Kelly
Did I answer your question? Mark my post as a solution!
Certainly… attached are sample data for Monthly production volume per facility per month, also the production volume per category. What I need is to hae the production volume per facility and category to be determined per day in any given month: