Open topic with navigation

Set a Min/Max Value

Use the following controls, features, and techniques to set min and max values as desired:

Set a Min/Max Value for an Individual Item

1. Log in to the IMS application and select Data > Item from the menu bar to display the Item window.
2. Click the desired item in the list to select it.
3. Click the Modify button to display the Edit Item window.
4. Click the Setup tab to display it.
5. Modify the values in the Min Qty and Max Qty fields as desired.
6. Click the OK button to close the window.

Set a Min/Max Value for Multiple Items

1. Log in to the IMS application and select Data > Item from the menu bar to display the Item window.
2. If desired, drag the Min Qty and Max Qty columns to a location (e.g., beside the QoH column) where they can be easily viewed. (To save this arrangement, select Edit > Save Grid Preferences from the menu bar.)
3. Use the Filter function to display only the items to be modified in the list.
4. Right-click the desired column name (Min Qty or Max Qty) to display a menu of options.
5. Select Edit from the menu to highlight the column name.
6. Enter the desired value(s) in the column cells. (To save the value in a cell, move the cursor to another cell.)
7. Right-click the column name and select Edit from the menu to remove the highlight from the column name.

Generate and Apply Suggested Min/Max Values

1. Log in to the IMS application and select Data > Item from the menu bar to display the Item window.

2. Click the Min/Max tab to display it.

   Note: The Min/Max tab allows the user to calculate suggested minimum and maximum values for items and apply these suggestions as desired. Calculations are based on the most recent 12 weeks of sales data (obtained from the Sales Transaction History) and are weighted by department. (Refer to Department Screen for more information.) This tab is accessible at the store level but is not yet available for corporate systems.

3. If desired, drag the Min Qty, Sugg Min, Sugg Min (with buttons), Max Qty, Sugg Max, and Sugg Min (with buttons) columns to a location (e.g., beside the QoH column) where they can be easily viewed. (To save this arrangement, select Edit > Save Grid Preferences from the menu bar.)

4. Click the Calculate Suggested Min/Max button to calculate values for and populate the Sugg. Min and Sugg. Max columns.

   Note: This calculation process may utilize a good deal of system resources, so click the button only when necessary.

5. When the Sugg. Min and Sugg. Max columns have been populated, complete the following procedures as desired:

   Note: The buttons noted below are available only after the Sugg. Min and Sugg. Max columns have been populated.

   • Click an item's Use Sugg. Min button to update its Min Qty value to match its Sugg Min value.
   • Click an item's Use Sugg. Max button to update its Max Qty value to match its Sugg Max value.
   • Click the Replace All Min and Max with Suggested Values button to update all Min Qty and Max Qty values to match their corresponding Sugg Min and Sugg Max values. (If the list is filtered, only displayed items are modified.)

Set Weekly Weights for a Department

1. Log in to the IMS application and select Data > Department from the menu bar to display the Department window.

2. Click the Min/Max Weights tab to display it.

   Note: The Min/Max Weights tab allows the user to set percentage weights for each of 12 weeks used to calculate suggested min/max values. Weights can be assigned as needed.

3. Click the desired department in the list to select it.
4. Complete the following procedures as needed:

   • Enter weight (%) values in each of the department's week weight columns ( (Wk 1 Weight %, Wk 2 Weight %, ... Wk 12 Weight %) so they total 100%.

     Note: The Weight Totals column displays the total combined value of a department’s 12 week weight values. If these values do not add up to 100%, the Weight Totals field displays red highlighting.

   • Click a department's Reset to Default button to return all its week weight columns to their default values.

Use the Min/Max Import/Export Utility

The AcuSport Min/Max Import/Export Utility allows the user to export min/max data to a specially formatted Excel file, modify the data in the file (outside of RTG software), and import the adjusted data back into the system to update the database. Refer to Use the AcuSport Min/Max Import/Export Utility for more information.