PROGRAM DOC | CALC ADDENDUM MATERIAL HANDLING ACADEMY

All of the math under the hood, in one place. Every formula the Product Spec Calc r4.1 and the Calc Logic Guide use, laid out in sequence with the reason it is shaped the way it is.

How To Use This Addendum

This is the geeky companion for students who want the whole calculation stack in front of them at once. Each entry gives you what the formula computes, the math in readable form, one paragraph on why it is built that way, a worked example you can check by hand, and the lesson that teaches the underlying concept.

The primary authority is the Product Spec Calc r4.1 workbook. Where the workbook and the Calc Logic Guide differ, the workbook governs, and the notes say so. The live tools that run this math are the Product Spec Calc and the Payback and ROI Calc. The same functions power both pages and this addendum through one shared module.

Contents
  1. Section 1: Package Basics
  2. Section 2: Rate and Gap
  3. Section 3: Sorter
  4. Section 4: 90 Degree Transfer
  5. Section 5: Skew and Lookup Utilities
  6. Section 6: The Business Case

Section 1 Package Basics

These outputs characterize the mix. The minimum package drives roller centers and gap. The maximum package drives width and curve geometry. Run each against the worst-case carton, not the average.

Weight per Footr4.1 G15
FORMULAWT / (L / 12)
What it computes

The distributed load a carton puts on the conveyor, in pounds per running foot.

Why it is shaped this way

Roller and belt ratings are given per foot, so you convert the carton length from inches to feet and divide the weight across it. The heaviest carton at the shortest length is the worst case, because that packs the most weight into the least support. Checking the average would hide the carton that actually overloads a roller.

Worked example

Max carton 20 in long, 50 lbs. WT/FT = 50 / (20/12) = 50 / 1.667 = 30 lbs/ft.

Teaches: package analysis and the design envelope, Lesson 6, The MTBH and the Design Envelope.
Roller Centersthree-rollers rule
FORMULALeading Dimension / 3
What it computes

The maximum roller center spacing that still keeps at least three rollers under the product.

Why it is shaped this way

A minimum of three rollers must contact the product at any point along the run, or the carton teeters and dips between rollers. Divide the leading dimension by three and you get the widest spacing that guarantees that support. The minimum package sets it. After a 90 degree transfer the carton travels hard way, so the takeaway rollers must be sized to the hard way dimension, which is smaller, forcing tighter centers than the trunk line.

Worked example

Min carton leading dimension 9 in. Roller centers = 9 / 3 = 3 in maximum.

Teaches: roller support and hard way conveying, Lesson 11, How Conveyors Work and Lesson 15, Transfers and Merges.
Minimum Curve Between-Frame Widthr4.1 H15
FORMULASQRT((IR + W)^2 + (L/2)^2) - (IR - 2)
What it computes

The between-frame width a curve needs so the worst-case carton corner clears the outside rail.

Why it is shaped this way

In a curve the carton pivots and its outside corner swings toward the outer rail. Pythagoras on that corner, at the inside radius plus the carton width and half its length, gives the reach of the corner. Subtracting the inside frame position converts reach into required frame width. You round the result up to the next catalog width, never down, because rounding down puts the corner into the rail.

Worked example

IR 34.5 in, max W 15 in, max L 20 in. BF = SQRT((49.5)^2 + (10)^2) - 32.5 = SQRT(2550.25) - 32.5 = 50.5 - 32.5 = 18 in.

Tumble Angler4.1 I15
FORMULAATAN(L / (3 x H)) x 180 / PI
What it computes

The theoretical incline angle at which a carton tips forward over its front edge.

Why it is shaped this way

A carton tips when its center of gravity passes over its front bottom edge. Model the center of gravity at one third of the length and the arctangent of length over three times height gives the tipping angle, converted from radians to degrees. The short, tall carton has the smallest tumble angle and is the worst case, so design every incline to the minimum tumble angle in the mix with a safety margin, never to the theoretical limit.

Worked example

Min carton L 9 in, H 3 in. Tumble = ATAN(9 / 9) x 57.3 = ATAN(1) x 57.3 = 45 degrees.

Teaches: incline and elevation limits, Lesson 14, Changing Direction and Elevation.

Section 2 Rate and Gap

Gap and rate are two views of the same spacing. The min carton produces the smallest gap and is the binding case fed to the sorter. The max carton sets the design rate.

Gap Producedr4.1 C31
FORMULASpeedOut x (L / SpeedIn) - L + StartingGap
What it computes

The gap between cartons after a belt speed change.

Why it is shaped this way

When cartons move from a slow belt to a fast belt they spread apart, and the amount they spread depends on how long each carton spent on the slow belt. The term SpeedOut times L over SpeedIn is the distance the leading carton travels on the fast belt while the trailing carton finishes clearing at the slow speed. Accelerating grows the gap, decelerating shrinks it. The min carton produces the smallest gap, so the tool feeds that gap forward as the binding induction gap.

Worked example

SpeedIn 60, SpeedOut 120, StartingGap 24. Min carton L 9: gap = 120 x (9/60) - 9 + 24 = 18 - 9 + 24 = 33 in. Max carton L 20: gap = 40 - 20 + 24 = 44 in.

Teaches: rate, spacing, and bottlenecks, Lesson 10, Rate and Bottlenecks.
Theoretical Rater4.1 C32
FORMULASpeedIn / ((L + StartingGap) / 12)
What it computes

The maximum cartons per minute a belt can carry at a given speed and gap.

Why it is shaped this way

Pitch is length plus gap, the distance from one carton to the next. Dividing belt speed by pitch in feet gives cartons per minute. You use the max carton length for the design rate because the longest carton produces the fewest cartons per minute, the worst case. If the theoretical rate is below the required rate, raise belt speed or cut the gap, and never design to the minimum.

Worked example

SpeedIn 60 FPM, max L 20 in, StartingGap 24. Rate = 60 / ((20+24)/12) = 60 / 3.667 = 16.4 CPM.

Teaches: throughput math, Lesson 10, Rate and Bottlenecks.
Pitchr4.1 C33
FORMULAGap + L
What it computes

The center to center distance between cartons.

Why it is shaped this way

Everything about spacing derives from pitch, and pitch is simply the gap plus the carton length. If a pitch or a rate looks wrong, go back and check the gap first, because a bad gap propagates into every rate and sorter number downstream.

Worked example

Gap 44 in, L 20 in. Pitch = 64 in. One carton every 64 in of belt.

Teaches: spacing fundamentals, Lesson 10, Rate and Bottlenecks.

Section 3 Sorter

The sorter section runs in sequence, and each step feeds the next. It exists to answer one question: can this sorter run this mix at this rate without a gap failure. If the answer is no, the levers are rate, speed, or model.

CFPM, Minimum Conveyor Speedr4.1 Sorter C12
FORMULA(L x Rate CPM / 12) x Safety Factor
What it computes

The minimum belt speed needed to physically move enough cartons per minute to meet the rate.

Why it is shaped this way

Carton length times rate is the feet of product per minute the belt must carry, converted from inches by dividing by twelve. The 1.15 safety factor adds headroom for the losses the ideal formula ignores, such as slippage and imperfect presentation. CFPM is a floor, never the run speed, because the sorter has to run faster still once the speed gap ratio is applied.

Worked example

Rate 20 CPM, safety factor 1.15. Max carton L 20: CFPM = (20 x 20 / 12) x 1.15 = 33.3 x 1.15 = 38.3 FPM. Min carton L 9: 17.3 FPM.

Teaches: sortation speed, Lesson 16, Sortation.
SGR, Speed Gap Ratior4.1 Sorter C13
FORMULA(L + GapAtInduct) / L
What it computes

How much faster the sorter must run than the induction belt to hold the gap that already exists.

Why it is shaped this way

The ratio of pitch to carton length is the multiplier the sorter must apply to keep the same gap while the carton is short. A small carton carrying a large gap produces a high ratio and a high required speed, which is why the min carton is the binding case. The tool wires the induction gap to the min carton's gap produced, the smallest gap in the mix, so the ratio is computed against the worst case.

Worked example

Induction gap 33 in. Min carton L 9: SGR = (9+33)/9 = 4.67. Max carton L 20: SGR = (20+33)/20 = 2.65.

Required Sorter Speedr4.1 Sorter C14
FORMULASGR x CFPM
What it computes

The actual operating speed the sorter must run for a carton column.

Why it is shaped this way

Multiply the minimum conveyor speed by the speed gap ratio and you get the run speed that both moves enough product and holds the gap. The tool chains this at full precision from the raw inputs, so it reads lower than a hand example that first rounds CFPM. The max carton drives CFPM, the min carton drives SGR, and the column with the highest required speed governs. Round the governing speed up to the next practical belt speed.

Worked example

Max carton: SGR 2.65 x CFPM 38.3 = 101.6 FPM, the governing speed. Min carton: 4.67 x 17.25 = 80.5 FPM.

Teaches: sortation speed, Lesson 16, Sortation.
Gap Produced at Sorter Speedr4.1 Sorter C15
FORMULA(RequiredSpeed x 12 / Rate) - L
What it computes

The gap between cartons once the sorter is running at its operating speed.

Why it is shaped this way

Belt speed over rate gives the pitch the sorter is producing, and subtracting the carton length leaves the gap. This is informational in the r4.1 tool. The pass and fail checks compare the gap produced at induction, the smaller and more conservative number, not this larger gap the sorter opens up.

Worked example

Max carton, required speed 101.6 FPM, rate 20 CPM, L 20 in. Gap = (101.6 x 12 / 20) - 20 = 41.0 in.

Sorter Model Minimum Gapr4.1 Sorter C16
FORMULATable lookup by model and max carton width
What it computes

The minimum gap the selected sorter model needs to complete a divert before the trailing carton enters the zone.

Why it is shaped this way

Each sorter model has a physical divert mechanism with its own timing, and wider cartons need more gap to clear. The r4.1 workbook carries a lookup by model and by max carton width band, so the required gap comes from the manufacturer's own spec rather than a single rule of thumb. The values below are manufacturer-specific reference data, kept verbatim from the workbook.

ModelMinimum gap by max carton width (in)
ProSort SC12 for any width
ProSort 121under 8: 6. 8 to 16: 9. 16 to 24: 12. 24 and up: 15
ProSort 131under 6: 6. 6 to 12: 9. 12 to 18: 12. 18 and up: 15
ProSort 421under 13: 10. 13 to 26: 16. 26 and up: 20
ProSort 431under 10: 10. 10 to 20: 16. 20 to 30: 20. 30 and up: 26
QS-112 for any width
QS-218 for any width
Worked example

ProSort 121, max width 15 in. 15 falls in the 8 to 16 band, so the model minimum gap is 9 in.

Teaches: selecting a sorter, Lesson 16, Sortation.
Gap Required by Geometryr4.1 Sorter C17
FORMULA(MaxWidth x SIN(divert angle)) + 2
What it computes

The gap the widest carton needs to clear the divert without hitting the next carton.

Why it is shaped this way

As a carton turns onto the divert, its width projects along the line of travel by the width times the sine of the divert angle. That projection is the room the next carton must stay clear of. Two inches of margin are added on top. The gap check must satisfy both this geometric requirement and the model minimum, and whichever is larger governs.

Worked example

Max width 15 in, divert angle 30 degrees. Gap = (15 x 0.5) + 2 = 7.5 + 2 = 9.5 in. With the model minimum at 9 in, geometry governs at 9.5 in.

Takeaway Spur Speedr4.1 Sorter C18
FORMULASorterSpeed / COS(divert angle)
What it computes

The belt speed the takeaway spur must run.

Why it is shaped this way

The carton leaves the sorter at an angle, so only the cosine component of its velocity points down the spur. To keep the carton moving at the sorter's pace along the spur, the spur must run faster by one over the cosine of the divert angle. Specifying the spur at sorter speed is always wrong. At 30 degrees the spur runs about 15 percent faster, at 22 degrees about 8 percent faster.

Worked example

Required sorter speed 101.6 FPM, divert angle 30 degrees. Spur = 101.6 / 0.866 = 117.3 FPM.

Teaches: sortation and takeaway, Lesson 16, Sortation.

Section 4 90 Degree Transfer

A transfer lifts a carton off the trunk, moves it sideways, and lowers it, all while the trunk keeps running. Every transfer is a potential collision point, so the math confirms the trunk gap is large enough to finish the cycle first.

Lateral Travel Distancer4.1 Transfer C14
FORMULABF + ((OAW - BF) / 2)
What it computes

How far sideways the transfer must move the worst-case carton.

Why it is shaped this way

The carton can sit anywhere across the belt, and the worst case is the side opposite the divert direction. That worst-case offset is half of the difference between the overall width and the between-frame width, added to the frame width, which is the distance the mechanism must clear.

Worked example

BF 21 in, OAW 24 in. Lateral = 21 + ((24-21)/2) = 21 + 1.5 = 22.5 in.

Teaches: transfers, Lesson 15, Transfers and Merges.
Transfer Cycle Timer4.1 Transfer C15
FORMULALift + (LateralDist / 12) / (TransferSpeed / 60) + Lower
What it computes

The total time the transfer is busy, from the moment it lifts until it is back in the ready position.

Why it is shaped this way

The cycle is the lift time, plus the time to travel the lateral distance at the transfer speed, plus the lower time. The middle term converts the lateral distance to feet and divides by the speed in feet per second. During this whole window the trunk line cannot safely deliver the next carton, so this number sets the gap the trunk must hold.

Worked example

Lift 0.5 sec, lateral 22.5 in, transfer speed 30 FPM, lower 0.5 sec. Cycle = 0.5 + (22.5/12)/(30/60) + 0.5 = 0.5 + 3.75 + 0.5 = 4.75 sec.

Teaches: the gap check for transfers, Lesson 25, The Gap Check and Capacity Proof.
Minimum Gap Required on Trunk Liner4.1 Transfer C16
FORMULA(CycleTime x TrunkSpeed / 5) + 4
What it computes

The minimum gap the trunk line needs between cartons for the transfer to finish a full cycle in time.

Why it is shaped this way

Cycle time times trunk speed is the distance the trunk travels while the transfer is busy, and dividing by five converts feet per minute and seconds into the inches the trunk covers. Four inches of margin are added, and that four inches is a floor. On critical transfers add 8 to 10 inches more for product variation and belt slippage. If the available gap is short, the carton collides on every cycle, so reduce trunk speed, add gap upstream, or use a faster transfer.

Worked example

Cycle 4.75 sec, trunk speed 120 FPM. Min gap = (4.75 x 120 / 5) + 4 = 114 + 4 = 118 in. The min carton's 33 in gap is far short of this, so that transfer collides unless the trunk gap grows.

Teaches: the capacity proof, Lesson 25, The Gap Check and Capacity Proof.

Section 5 Skew and Lookup Utilities

Two supporting calculations. The skew length sizes an alignment section. The lookup time is the physical basis for any scan-to-divert distance check.

Skew Conveyor Required Lengthr4.1 C36
FORMULA((BF - MinW) x BF / RollerCenters + MaxL) / 12
What it computes

The minimum length of skewed roller conveyor needed to align the narrowest carton across the belt.

Why it is shaped this way

A skewed section walks a carton sideways a little with each roller until it rides against the guide. The narrowest carton has the farthest to travel, so the frame width minus the min width, scaled by how many rollers per length, gives the travel distance, and the max length is added so the longest carton is contained during the traverse. This is a minimum, so add length for connection to adjacent sections.

Worked example

BF 21 in, min W 6 in, roller centers 3 in, max L 20 in. Length = ((21-6) x 21/3 + 20) / 12 = (105 + 20) / 12 = 10.4 ft.

Teaches: alignment before merges, Lesson 15, Transfers and Merges.
Lookup Time, Time Between Pointsr4.1 C40
FORMULA(Distance / 12) / (Speed / 60)
What it computes

How many seconds a carton takes to travel a given distance at a given speed.

Why it is shaped this way

Convert distance to feet and speed to feet per second and divide, and you have the travel time. This is the response window between a scan point and a divert. If the controls need three seconds to return a sort decision and the travel time is five, there are two seconds of margin. If belt speed changes anywhere between the points, recalculate, and never estimate travel time from memory.

Worked example

Distance 120 in, speed 120 FPM. Time = (120/12) / (120/60) = 10 / 2 = 5.0 sec.

Teaches: sensing and scan timing, Lesson 19, Sensing and Identification.

Section 6 The Business Case

The money math is simple on purpose. What is hard is the honesty around it: confirm every input, build to the customer's own threshold, and never quote an industry-standard payback, because there is not one.

Annual Labor SavingsLesson 29 helper
FORMULAHeads x Loaded Rate x Hours
What it computes

The yearly labor cost the system removes or redeploys.

Why it is shaped this way

Positions times the fully loaded hourly rate times the hours that actually run gives the annual labor value. Fully loaded means wages plus the burden on top of them, not the offer-letter number. Confirm the headcount, the rate, and the hours with the customer in writing, because a payback built on a headcount nobody confirmed is a guess wearing a spreadsheet.

Worked example

Illustrative only. 5 positions at 30 dollars per hour across 2000 hours = 300,000 dollars per year.

Teaches: modeling savings, Lesson 29, The Business Case.
Annual SavingsLesson 29
FORMULALabor + Chargeback Reduction + Throughput
What it computes

The total yearly savings the system produces, modeled from three sources.

Why it is shaped this way

Annual savings is not one number the customer hands you. You build it from labor, from the chargebacks the system prevents by routing on confirmed scan data, and from throughput, but only where added capacity converts to revenue or avoided overtime. If the extra cartons per minute do not turn into money, they do not belong in the number.

Worked example

Illustrative only. 170,000 labor plus 40,000 chargeback reduction plus 15,000 avoided overtime = 225,000 dollars per year.

Teaches: the three savings sources, Lesson 29, The Business Case.
Simple PaybackLesson 29
FORMULATotal Investment / Annual Savings
What it computes

The number of years of savings it takes to recover the install cost.

Why it is shaped this way

Divide what the system costs by what it saves each year and you have the simple payback. It is deliberately simple, because the hard part is not the arithmetic, it is confirming the inputs. There is no industry-standard payback. The approval threshold is a number each company sets from its own cost of capital, so you find the customer's threshold and build to it.

Worked example

Illustrative only. 600,000 dollars over 225,000 dollars per year is about 2.7 years. Against a 3 year threshold, this clears with room. That 3 years is the customer's own hurdle, not the industry's.

Teaches: payback and the customer's threshold, Lesson 29, The Business Case.
Simple ROILesson 29
FORMULA(Annual Savings / Total Investment) x 100
What it computes

The simple annual return, the reciprocal of payback.

Why it is shaped this way

Savings over investment expresses the same relationship as payback from the other direction, as a percent return per year. It is a simple return, not a discounted cash flow or an internal rate of return, so use it alongside the payback and the customer's threshold, not instead of them.

Worked example

Illustrative only. 225,000 dollars over 600,000 dollars is 0.375, a 37.5 percent simple annual return.

Teaches: return framing, Lesson 29, The Business Case.
The number is the easy part. Knowing which carton binds, which requirement governs, and which input still has to be confirmed is the engineering. Run the math in the calculators, and come back here when you want to know why a formula is shaped the way it is.