• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel to Monitor workflow and productivity

kmakifl

Member
Hello Everyone, I would appreciate your comments or directions .. a template or how to setup the following:


I need to implement and maintain optimal workflow where production employees are required to 1) meet a minimum daily output e.g 200 widgets; 2) complete assembly within 2-3 days of them falling into the queue; 3) be able to enter volumne and or date to ensure that we are meeting contract needs. With conditional formatting, I would like to visually see when I need to shift employees to assist a line that may be falling short..


Thanks for your help.
 
Hi kmakifl,


Your question appears interesting and i am willing to help you any way i can. Please elaborate it further. How your data looks like and how do you want the report to be?


I worked out a similar problem here:

http://chandoo.org/forums/topic/highlight-the-cell-range-by-selecting-dropdown


..and this file might also interest you:

http://dl.dropbox.com/u/60644346/Atul%20Rajratna_ShiftQuery.xlsx


Regards,

Faseeh
 
Hi Faseeh, Thanks for sharing your file. Here is the basic information for my file, I made some comments within same. I hope I have explained sufficiently and that you can assist me. https://docs.google.com/open?id=0B5Vr4r9QZCxgSm9kd1loSVozVzg


Thank you.
 
Kmakifl


I would add a few helper columns to calculate


1. the Number of Units required for each day

2. the Number of People required for each day

3. Cummulative Production

4. Cummulative requirements


Then manually schedule the people (Green Column) accordingly

watching that you don't have too much excess or more than 9 days negative

Have a look here:

https://www.dropbox.com/s/ri7i6ygo6tjg762/Excel%20to%20Monitor%20Workflow_IH.xlsx
 
Hi kmakifl,


I think Hui's approach to the problem is just perfect. If there remains any need please let me know. and sorry for late reply. :)


Regards,

Faseeh
 
Hui - Thank you very much for your help - I believe it will work.


Faseeh - Thanks for the offer, and no worries on late reply.


I will post followup as soon as I update the data.
 
Kmakifl,


You don't need a Pivot table, just a Chart


Select whatever columns you want charted and Insert Chart
 
oakley flak jacket sunglasses are usually fantastic brand name sun shades, as oakley sun shades are manufactured having very best fabric forever top quality and cheap oakley sunglasses for china have got a lot of types and hues for every to decide on, no mater just what exactly color you want, an individual most discover having cheap oakley sunglasses onlin. Oakley sun shades is definitely available in this oakley sunglasses cheap usa, you'll be able to select any kind of inexpensive oakley sun shades having ushttp://www.icheapoakleysunglasses.org.
 
Back
Top