Menu Path: Executive Information Systems Performance Metrics Turns and Earns Analysis
Display profitability and velocity metrics such as Turns, Turn and Earn and GMROI (Gross Margin Return on Investment) by shipping location, supplier, category, subcategory, and product.
Compare two different period ranges.
Use Turns and Earns Analysis to view profitability and velocity metrics for a specific date or two ranges of dates.
Note Turns and Earns Analysis only functions if you are performing a periodic update of product history statistics in Turns and Earns Daily Update. This update can be run daily, weekly, or as often as required for your analytical needs. The more often it is run, the better the resulting analytical information.
To analyze profitability and velocity:
Enter a range of dates for which you want to display data in the range 1 From Date and To Date fields.
If you want to compare data from the first range to another range of dates, select the Range 2 check box, and then enter a range of dates in the range 2 From Date and To Date fields.
If you want to display data for a single shipping location, clear the All Shipping Locations check box, and enter a shipping location in the Location field.
If you want to display data for a single supplier, clear the All Suppliers check box, and enter a supplier in the Supplier Code field.
If you want to display data for a single category, clear the All Categories check box, and enter a category in the Category field. If you enter a category and want to display data for a single subcategory, clear the All Subcategories check box, and enter a subcategory in the Subcategory field.
Define the display method by selecting the Category, Subcategory, Product, or Supplier radio buttons. You can drill down to the subcategory, product, or supplier level if you select the Category radio button. You can drill down to the product or supplier level if you select the Subcategory radio button. You can drill down to the category, subcategory, product, or customer level if you select the Supplier radio button.
Select a drill down option. The available options depend on the display option you selected in step 6.
Select whether to use sales or accounting cost.
If you want to display data in a currency other than the default currency, click the Lookup button to the right of the Currency field, and select a valid currency.
If you want to display cost of products that have been returned but not restocked, select the Include Cost of Products Returned and Not Restocked check box.
Click the Show Data button in the ribbon to display data on the Results tab. The Totals section displays total sales, margin, and margin percentage for the data.
Select a method for sorting the data.
If you want to position the results in the Results grid to a specific record, enter it in the Position field. Enter data corresponding to the sort option you selected in step 12.
Button |
Description |
Exit |
Click this button to close the Turns and Earns Analysis window. |
Show Data |
Click this button to display category, subcategory, product, or supplier data on the Results tab, based on the selected criteria. |
Inventory Matrix |
Click this button to display Inventory Matrix Inquiry, which allows you to view inventory and transaction information for the product selected in the Results grid. |
Field or Button |
Description |
Enter the first date in a range of dates for which to display data, or click the drop-down arrow to select a date. |
|
Enter the last date in a range of dates for which to display data, or click the drop-down arrow to select a date. |
|
Select this check box if you want to compare data for two ranges of dates. This check box is cleared by default. |
|
Enter the first date in a second range of dates for which to display data, or click the drop-down arrow to select a date. This field is only enabled if you select the Range 2 check box. |
|
Enter the last date in a second range of dates for which to display data, or click the drop-down arrow to select a date. This field is only enabled if you select the Range 2 check box. |
|
Select this check box to display data for all shipping locations. This check box is selected by default. |
|
Enter a location prefix or name to display data only for goods shipped from this location, or click the Lookup buttons to select a shipping location prefix or name. These fields are only enabled if you clear the All Shipping Locations check box. |
|
Select this check box to display data for all suppliers. This check box is selected by default. |
|
Enter a supplier code or name to display data only for this supplier, or click the Lookup button to select a supplier code or name. These fields are only enabled if you clear the All Suppliers check box. |
|
Select this check box to display data for all product categories. This check box is selected by default. |
|
Enter a product category for which to display data, or click the Lookup button to select a product category. This field is only enabled if you clear the All Categories check box. |
|
Select this check box to display data for all product subcategories. This check box is selected by default, and is only enabled if you enter a category in the Category field. |
|
Enter a product subcategory for which to display data, or click the Lookup button to select a product subcategory. This field is only enabled if you clear the All Subcategories check box. |
|
Select the data displayed on the Results tab. Select one of the following options:
Category is selected by default. |
|
Select the information to display if you drill down on data displayed on the Results tab. This field is only enabled if you select the Category, Subcategory, or Supplier radio button. |
|
Select whether to use the sales or accounting cost type. Sales is selected by default. |
|
Click the Lookup button to select a currency to use for all data displayed on the Results tab. |
|
Select this check box to include cost for products that were returned but not restocked. |
Field or Button |
Description |
This grid displays category, subcategory, product, or supplier data based on the criteria selected on the Select tab. Values in this grid are calculated as follows:
Double-click a line to drill down to more detailed data. The window that appears when you drill down is based on your selection in the Drill Down field on the Select tab, as follows:
NOTE For partial months, the following formulas are used: Monthly.avg-cost = SUM(daily.avg-cost* daily.qoh)/ SUM(daily.qoh) and Monthly.qoh = SUM(daily.qoh)/COUNT(daily). If there are missing daily records in the selected partial month (because one record may not be created every day even if you run Turns and Earns Daily Update every day), the software creates temporary daily records, and then calculates the partial monthly data based on these records. If the selected date range contains a full month and a partial months (e.g., 10/6/2020 – 11/30/2020), the software will first pick up the monthly data for the full month, and then add up the partial month data using the following formula: ASSIGN prod-summary.avg-cost = ((EntireMonth.avg-cost * EntireMonth.avg-qoh * EntireMonthTotalDays) + PartialMonthTotalCost) / (EntireMonth.avg-qoh * EntireMonthTotalDays + PartialMonthTotalQOH). ASSIGN prod-summary.avg-qoh = (EntireMonth.avg-qoh * EntireMonthTotalDays + PartialMonthTotalQOH)/ (EntireMonthTotalDays + PartialMonthTotalDays) If the selected date range contains a full month and two partial months (e.g., 10/6/2020 – 12/6/2020), the software will first pick up the monthly data for the full month, and then add up the two partial month data using the following formula (it will be run twice as there are two partial months): ASSIGN prod-summary.avg-cost = ((prod-summary.avg-cost * prod-summary.avg-qoh * prod-summary.r1-num-days) + temp-avg-cost-total) / (prod-summary.avg-qoh * prod-summary.r1-num-days + temp-qoh-total). ASSIGN prod-summary.avg-qoh = (prod-summary.avg-qoh * prod-summary.r1-num-days + temp-qoh-total) / (prod-summary.r1-num-days + curr-mth-days |
|
Select a method for sorting data in the Results grid. The available options depend on the selected display option. |
|
Enter the record to display at the top of the Results grid. The entry in this field is based on the selected Sort by option. |
|
This field displays range 1 total sales for the data displayed in the Results grid. |
|
This field displays range 1 margin for the data displayed in the Results grid. |
|
This field displays range 1 margin percentage for the data displayed in the Results grid. |
|
This field displays range 2 total sales for the data displayed in the Results grid. |
|
This field displays range 2 margin for the data displayed in the Results grid. |
|
This field displays range 2 margin percentage for the data displayed in the Results grid. |