We have developed several "quick & dirty" Excel programs which you may find helpful in your current endeavors (see below.) As we develop additional "quick and dirties" we will be glad to forward them to you.

WAREHOUSE LABOR STANDARDS
This "quick and dirty" program helps create labor standards for outbound and inbound pallet load shipments. It is based upon using a 3,000 to 6,000 propane or electric truck, with a clamp, fork or roll attachment and products stored three levels high. Paperwork requirements are minimal, just checking off a receiving or packing list. The variables are the number of stock keeping units (SKU's) the number of pallets, clamps or rolls, and the round-trip distance to be travelled. While this model is fairly generalized it can give you a benchmark. As with the 50% Dilemma, usually 50% of the people beat this standard, while 50% are below.

LABOR PRODUCTIVITY TRACKING
This "quick and dirty" program can be used to summarize your labor productivity. Inputs are date; start-time; end-time; individual; unit type; number of units; and task. The model calculates day-of-week, and productivity by individual task for each line of input. By depressing a "calculate productivity" button on the worksheet, the model will summarize productivity by individual and by task for the total period included on the worksheet. It can be used weekly or monthly. Tasks are user defined and unlimited.

THIRD PARTY WAREHOUSE RATE NEGOTIATIONS
If you are a third party warehouse provider, or a manufacturer using either public or contract warehousing this "quick and dirty" program can help you in evaluating your costs or charges. For storage charges the inputs are average inventory; monthly receipts; unit size; stacking height; honeycombing percentage; and cost of space in your locality. For handling charges required inputs are inbound and outbound productivity; and either the rate per piece; or the prevailing labor rates (plus benefits) for your geographic area. The model works for pallet loads as well as individual cases. Again, as with the 50% Dilemma, usually 50% of the people pay more than the rates indicated by this "Q & D", while 50% pay less than the rates indicated.

To get your free "Q & D" demos please indicate the following: