Business Analysis Report

Summary

The business analysis report is a general-purpose analysis report used for assessing the general business state of a particular store. The sections and fields in this report include:

Report Breakdown

Sales Analysis On Placed Orders

First Time Placed Orders: The percentage of orders (by sales volume) that were first time orders for those accounts in the report period. (= Sales Subtotal from First Time Orders / Sales Subtotal from All Orders.)
Note: Adjustments to orders placed before the report period are NOT included in this calculation.
Converted Prospects: The number of first-time customers in this report period that were initially entered as prospects (i.e., not entered with a new order).
Average Order Amount: The average sales sub-total for orders placed during the period. (= Sum (Sales Sub-Total) / Total Number of Orders.)
Note: Adjustments to orders placed before the report period are NOT included in this calculation.

Estimate Analysis

Note: Deleting an estimate removes it from this count, so it is not recommended that estimates be deleted/purged until after this report is printed.

Number of Converted Estimates:

The number of estimates converted to orders during the report period.Total Converted Estimates: The sales subtotal of all orders that were converted from estimates during the report period.
Average Converted Estimates: The average sales subtotal of all converted orders for the period. (= Number of Converted Estimates / Total Converted Estimates.)
Average Outstanding Estimates: The average sales subtotal of all estimates created in the report period that were not converted to orders.
Average Outstanding Estimates Age: The average age (in number of days) for all estimates created in the report period (based on the original estimate creation date). Note: Only estimates created in the report period are considered in this calculation. It is not an average age for all estimates in the system.
Percent Converted: This is determined using the following formula "Number Converted" / ("Number of Estimates" + "Number Converted")
Quick Conversion: This is determined using the following formula "((OrderDate - EstimateDate) < (1/96)) or Conversion from an Estimate to an Order is under 15 minutes.

Ratio Analysis On Sales

Ratio Analyses are grouped by calendar month (not closeout months). Additionally, if any part of the report period falls within a month, that entire month is included not just the portion of the month in the report period.
Note: Adjustments to orders placed before the report period are NOT included in these calculation.

Month:

The month and year for the analysis.Sales Subtotal: The sales subtotal for the report period. (Subtotal is before taxes, shipping, finance charges, and write-offs.)
Deposit Ratio: The percentage (by dollar) of deposits taken for orders picked-up in this month. (A deposit is considered any payment taken more than 2 hours before the order was picked-up.)
Price Modifier Ratio: The ratio of Modifier Sales to Base Sales (by dollar) for orders picked-up during the month.
Discount Ratio: The ratio of Order Discounts to Base Sales (by dollar) for orders picked-up during the month.
Percentage of Overrides: The percentage (by dollar) of orders picked-up during the month that had one or more overridden line items.

Receivable Analysis

This section provides information on how old ("aged") the orders in accounts receivable are. Note: The A/R breakout is always based on the current (printed) date, regardless of the report period.
Total Row The total row shows the dollar total of A/Rs in the given category.
Count Row The count row shows the number of A/Rs in the given category.
Average Row The average row shows the dollar average of A/Rs in the given category.

Total: Includes all A/Rs.

Within Grace Period: Includes all A/Rs within the payment terms specified for the customer. (For instance, this will include any receivable less than 30 days old for a customer with Net30 payment terms.)
0-30 Days: Includes all A/Rs not within their grace period that are 30 or fewer days old.
31-60 Days: Includes all A/Rs not within their grace period that are between 31 and 60 days old, inclusive.
61-90 Days: Includes all A/Rs not within their grace period that are between 61 and 90 days old, inclusive.
Over 90 Days: Includes all A/Rs not within their grace period that are over 90 days old.
Average Receivable Age: The average age of all A/Rs. (= sum(Days Outstanding) / Number of A/Rs)
Total Balance Past Grace Period: The balance of A/Rs older than their grace period. (= Total 0-30 + Total 31-60 + Total 61-90 + Total 90+)
Number Past Grace Period: The number (count) of A/Rs older than their grace period. (= Total 0-30 + Total 31-60 + Total 61-90 + Total 90+)
Days Receivable: The number of days of sales represented by the current A/Rs total. (= Total A/R Balance / average sales per day. )
(Note: The average sales per day is calculated as the monthly sales goal / 30).


Error: Blank Values on Business Analysis Report

This section details how to fix the problem with blank values being generated for the Business Analysis Report. You may find that when you attempt to run the Business Analysis Report that the report displays blank values for all fields regardless of the date range set for the report, this is likely caused by missing Sales Goals that need to be set in the system. You can create Sales Goals by going to MGMT > Set-up > Set Sales Goals. You will need to set Sales Goals pre-dating the current year by 3 years (i.e. if it's 2017 create Sales Goals dating back to 2014), and to create the Sales Goals for the following year. Once you have entered the Sales Goals try running the report again.



See Also