Efficiency Formula: Help requested

[Monte Comeau]

Hi,

I need a formula that returns the efficiency of a machine based on certain
criteria.

This machine cuts logs. We have a goal set at 6000 per 8hr shift.

So if the machine processed 6000 logs with zero % downtime in 8 hrs it would
be running at 100% efficiency.

I need to create a worksheet that allows me to input

Number of logs
% downtime
Hrs of operation

And return a number in percent telling how efficient the machine is
operating. Something typical would be

5600 logs
20 % downtime
8.5 hours

Any help would be greatly appreciated.

 

[Harald Staff]

Hi

# of Logs in A1
Decimal time in B1
Percent downtime in C1
Formula in D1:
=IF(B1<>0,A1/(1-C1)/B1/750,"")

HTH. Best wishes Harald

 

[JE McGimpsey]

One way:

Assume,

A1: 6000 <== Goal per 8 hour shift

B1: 5600 <== Actual
B2: 8.5 <== Hours
B3: 20% <== Downtime

then efficiency is

C1: =(B1*8/B2/(1-B3))/A1 ==> 109.8%

when formatted as a percentage.

 

[Monte Comeau]

Thank you thank you thank you