K3S_2040 Supplier Order Cycle Analysis - Screen 2 of 3


 Summary

A way to narrow down the best order cycle taking into account the many different variables involved. F20 allows toggling between page 2 and 3 since page 1 is a setup screen.

For definitions of the top portion, see screen definitions for Supplier Order Cycle Analysis Screen 1 of 3. The top portion is the same for all 3 pages. (Except for Active and Used which is described here)

If the order cycle is updated, you must recalculate the supplier's order to see the results or wait for a night job to run.

One way to get here:

4. Suggested Orders - Selected from the main menu
Opt1-Select - From K3S_1010 Orders - Supplier Summary screen
F19=Order cycle analysis - Gets you to the first screen
Enter - To get to screen below

 User Sub Pages

K3S_2040 Supplier Order Cycle Analysis - Screen 1 of 3

K3S_2040 Supplier Order Cycle Analysis - Screen 3 of 3


 Function Key options:

F5=Update Order Cycle

F9=Notes

F11=Product Maintenance

F12=Previous

F20=Toggle






Display Field Descriptions

For definitions of the top portion, see screen definitions for Supplier Order Cycle Analysis Screen 1 of 3.
The top portion is the same for all 3 pages. (Except for Active and Used which is described here)


Active                  Display only

The number of products currently available to order from.


Used                    Display only

The number of products actively being ordered. If a product is in delete mode it is not being used and would not be counted here.


Unit values/order

Here the cost of each scenario is shown in detail. In our example, a 7 day cycle will have a cost of $2,537, weight of 1,313 pounds and a total cost of $134,282. The total can be compared to other cycles to find the most cost efficient cycle.


dollars          

The cost associated with the cycle days chosen.

weight           

The weight that will be produced given the amount of cycle days chosen. Remember, there may be weight restrictions so this field may be valuable in determining which cycle is best.

volume

The volume associated with the cycle days chosen.

  purch increment   (purchase increment)         

The amount of product that will be purchased if the associated cycle days is chosen.

Other      

The user can set up an Other category such as Gallons. If this was done, Gallons would show here instead of Other and the amount of Gallons needed for the associated order cycle would be displayed after it.

 

Disc earned by %        (Discount earned by %)       

If a discount can be applied, this will show the discount as a percentage.

 

Disc earned by $        (Discount earned by $)       

If a discount can be applied, this will show the discount as a dollar amount.

 

Annual net cost        

The total annual net cost associated with the cycle days chosen. To see how this total was computed, toggle to page 3 of this screen display.

 

Note:  The most optimal order frequency is the one with the lowest Annual Net Cost, which will be identified in the color white (in our example, it is a light gray).

 Also, use different sets of Order Cycle values to help zero in on the correct answer for this supplier.

 

Disc level met          (Discount levels met)  

This shows how many Discount Bracket Levels have been met with the associated cycle days chosen. Remember, the bracket levels must be correct in order for this to work properly.

 

Note       

An area for notes. A note entered here will be saved with the supplier information.



Function Key Descriptions

F5=Update Order Cycle     (New feature)

Will automatically take the lowest Annual Net Cost answer and display it in a pop up window. The buyer is then given the option to use the Order Cycle supplied or insert another. 


F9=Notes

Transfers the user to the Notes Maintenance screen.


 F11=Product maintenance

Transfers the user to the Product Maintenance screen.


 F12=Previous

To get to the previous screen selected.

 
F20=Toggle

Transfer the user back and forth from/to pages 2 and 3.