| |
Total Hours Per Day |
Average Hourly Wage |
Total Daily Cost |
Annualized Cost |
|
| 1.Material Handlers, Daily Hours Spent by Materials - Personnel involved in picking, issues, receiving, stocking material, traveling to sites such as sales reps |
|
$
|
$
|
$
|
Personnel involved in picking, receiving, putaway of inventory. Average hourly wage paid to these people - This category also applies to Sales and Support Personnel who are charged with the replenishment of Inventory at Customers or Vendors. [In a Vendor Managed Inventory Setting for example] |
| 2.Warehouse Material Handling Daily Hours - Personnel involved in Packing and Shipping The Product |
|
$
|
$
|
$
|
Personnel involved in picking, packing and shipping the inventory. Average hourly wage paid to these people. |
| 3.Daily Data Entry Clerical Hours - Hours spent entering inventory transactions |
|
$
|
$
|
$
|
Daily data entry hours spent on transactions. Average hourly wage paid to these people. |
| 4.Cycle Counting, Daily Hours Spent in Cycle Counting. |
|
$
|
$
|
$
|
Total daily hours spent in cycle counting activities. Average hourly wage paid to these people. |
| 5.Data Entry Clerical, Daily Hours Spent correcting Data Entry Errors - Time spent in correcting errors |
|
$
|
$
|
$
|
Total time spent correcting data entry errors. Average hourly wage paid to these people. |
| 6.Daily Hours spent in Management Functions - Time Spent by Mangement to Ensure Proper Planning and Control of Inventory |
|
$
|
$
|
$
|
Total daily hours spent in the management of these functions. Average hourly wage paid to these people. |
| 7.Burden Factor - The percentage of dollars spent above the hourly wage for factors such as benfits and overhead |
% |
|
|
|
This represents the percentage of dollars spent above the hourly wage for factors such as social security, benefits, etc. |
| 8.Material Handlers Inventory Labor Time Saved |
% |
|
$
|
$
|
Enter a percentage of inventory labor time that you can expect to save. (Refer to item no.1) |
| 9.Warehouse Labor Time Saved |
% |
|
$
|
$
|
Enter a percentage of warehouse labor time that you can expect to save.(Refer to item no. 2) |
| 10.Inventory Counting time Saved |
% |
|
$
|
$
|
Enter a percentage of cycle count time or Physical Inventory time that you can expect to save. (Refer to item no.3) |
| 11.Data Entry time saved by VI-Data Collection Activites |
% |
|
$
|
$
|
Enter a percentage of data entry time that you can expect to save. (Refer to item no. 4) |
| 12.Error Decrease after VI-Data Collection Activities |
% |
|
$
|
$
|
Enter a percentage of data entry error time that you can expect to change. (Refer to item no. 5) |
| 13.Daily Hours Saved by Planning and Control |
% |
|
$
|
$
|
Enter a percentage of managements time that you can expect to save. (Refer to Item no. 6) |
| 14.Current Value of Inventory in Dollars - expected to be placed in iBins, Ishelves, etc |
$
|
|
|
|
Value of inventory that will be placed in iBins - annualized. |
| 15.Inventory Reduction due to more accurate information, reduces safety stock |
% |
|
$
|
$
|
Carrying costs include warehousing, racking, interest costs, etc. A reduction in inventory can apply 10% directly to the bottom line. |
| 16.Carrying Costs |
% |
|
|
|
Carrying costs include warehousing, racking, interest costs, risk costs etc. |
| 17.Current Value of Inventory - Average |
$
|
|
|
|
Value of average Inventory on Hand. |
| 18.Current Annual Cost of Goods Sold |
$
|
|
|
|
Annual Cost of Goods Sold. |
| Current Inventory Turns |
|
|
|
|
Annual Cost of Goods Sold. |
| Current Inventory Carrying Cost |
$
|
|
|
|
Inventory carry cost = average inventory value times the carry cost percentage. |
| 19.Estimated Inventory Turns with Real time Inventory Visibility |
|
|
|
|
Increased inventory turns expected. |
| 20.Estimated Inventory Savings due to Inventory Reductions |
$
|
|
|
|
Inventory carry cost savings due to increased inventory turns. |
| 21. Estimated Miscellaneous Savings |
|
|
|
$
|
Total estimated savings such as reduction in expediting cost. |
| 21.Total Cost Of VI Product - Sensors and SuppliLink Software |
|
|
|
$
|
Enter the total cost of all sensors and user licenses for SuppliLink. |
| 22.Estimated Cost of Implementaion - Include Installation, Training, Project Management |
|
|
|
$
|
Enter the estimated cost for implementation. Include all miscellaneous costs that could be associated with the project, Project Managers cost for example. |
| 23.Miscellaneous Costs |
|
|
|
$
|
Enter any miscellanous costs that will be associated with the project, a new computer for example. |
