Ask Experts Questions for FREE Help !
Ask
    dominicdiaz8's Avatar
    dominicdiaz8 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 24, 2011, 08:33 AM
    Combined Efficiency
    I have two product lines that run at different efficiencies and I need a weighted combined efficiency based on amount run.

    Example:

    Line 1 ran 37,456 cases in 157 hours @ 75.74%. Efficiency goal is 65% of 315 cases per hour
    Line 2 ran 3,554 cases in 28 hours @ 21.51%. Efficiency goal is 40% of 590 cases per hour

    This is going to go into a conditional format for a digital dashboard that I am working on in Excel
    gmandelbraat's Avatar
    gmandelbraat Posts: 8, Reputation: 2
    New Member
    		  
    #2

    Jun 27, 2011, 07:37 AM
    Why your goal is stated as "40% of 590"? Why not just say 216?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

10 Tables combined [ 6 Answers ]

I have 10 tables that all have the same columns with the same names. I have created a new table that has all those same field names. I want the rows in all 10 tables to pull into one table or query. Would prefer a table. I would just combine all the tables but they're linked from other...

Combined inequalities [ 1 Answers ]

1)d - 1 > -3 and d + 2 < 5 2) -3k + 7 > -5 and -7k + 5 < -2 3) -5 < 2y - 3 < 23 4) x - 4 < 5 or x + 2 > 15 5) 5x - 4 > 6 or -4x + 5 > 1

Combined medicine [ 1 Answers ]

Can you take Sudafed PE and Motrin together?

Combined inequalities [ 1 Answers ]

1. 2x > -6 and x -4 _<_to 3

View more questions Search