Sales, Inventory, Profitability Analysis

This screen allows you to run a profitability report for a product or a set of products by analyzing the gross profits from sales, the volume of sales, and the average value of your inventory plus other assets.

To access this report generation screen, navigate as follows:

* From the Main Navigation screen,
* Click: Financials Icon > Reports Tab
* In the Inventory section,
* Click: Sales, Inventory Profitability Analysis -- link to report page.

Then, fill in the form:

* Enter the Product ID, or the first part of the ID for a set of products, to be analyzed.  If you
    leave this blank the analysis is performed for all products that were sold in the period.
* Enter a specified date range or a pre-configured fiscal time period.  You may
    manually enter the "From" and "Thru" dates or search for the dates using the 
    calendar widget, or you may also use a fiscal time period by selecting it from
    the drop down menu.  
* Select the Fiscal Type (for example, "Actual" or "Budgeted") from the drop down
    menu, to run the profitability analysis for actual results or for the budgets and
    forecasts.  
* Click: [Run] button -- to run the profitability analysis for return on equity (ROE)  

Clicking the [Return to Reports] button will take you back to the Reports Main Screen.

The report table that is produced includes these data items for each product in the report:

• Product ID
• Sales Volume -- the revenue from sales
• COGS -- cost of goods sold
• Gross Profit -- revenue minus COGS
• Beginning Inventory
• Ending Inventory
• Average Inventory -- part of the assets
• Turnover -- Sales divided by Assets
• Annualized Turnover
• Profitability Ratio -- profit margin divided by equity

This report is based on The Du Pont formula of profitability analysis.