How much of the plan was made, and how far short it fell.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Achievement
—
Shortfall
—
Formula
Actual output ÷ planned output × 100; shortfall = planned − actual
=IFERROR(B2/C2,0)Excel: B2 actual good output; C2 planned output
Say whether achievement uses total output or good output, and use the same rule every day.
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.