Source Code Analysis Report (RSCA)

How to print: Use the Source Code Analysis Screen (RSCA).

For more information: See the sample report in PDF format.

Note: This report is also available as a .csv (comma-separated value) file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in CSV (Spreadsheet) Format for more information.

Contents:

• Offer: Offer code and description

• Source:

• Ty: Type; the analysis type (defined in the source code), which is used for determining total sales for all or selected source codes. There are 3 types:

• K = Known source

• U = Unknown source

• N = Do not analyze source

The system performs a calculation to determine the percent that each known source code represents of the total known source code sales. The dollars from the unknown sources are proportionately redistributed to each known source code. See Type from Working with Source Codes (WSRC).

• Ct: Category code; a code used to group source codes for reporting and forecasting purposes

• Dr: Drop; a code representing a mailing

• Cv: Cover code; a code for the catalog cover mailed to the source code

• BC: Business/Consumer code; this value indicates whether the source includes businesses or consumers

• H: you can use this value to indicate whether the mailing segment associated with the source code was derived from a house list or a non-house (rented) list.

• Mail date: the date the offer was mailed

• DFO: the date of the first order for this source, as updated by the system

• Net circ: the number of pieces mailed

• WTD ord: the number of orders booked week-to-date (except returns)

• Orders: the number of orders booked offer-to-date

• $ orders: the dollar amount booked in orders

• Avg order: the average dollar value of an order, calculated by dividing the number of orders by the dollar/orders

• Brkevn %: the percentage of orders needed to cover the cost of producing the offer, calculated by:

 

Break-even Amount * Net Circulation / Average Dollars per Order

 

• Brkevn: the dollar value of orders needed to cover the cost of producing the offer

 

Break-even Amount / Average Order

 

• Wgt Ord $: the projected weighted sales per book

 

(Sale/Book/Proj) * (Total Circ) / Running total cir. + Prev. wgt. proj.

 

• Rsp %: the actual response percentage to date for the offers shipped

 

# Orders / Net Circulation * 100

 

• % Comp: the cumulative percent complete for the list based on the curve being used. The source code projection will use the default curve unless the curve for a particular source code was overridden when the forecast was built. All percentage complete factors will be the same, except for an item override curve.

• Actual $: the dollar value of orders divided by the # books circulated

• Weighted: the weighted order dollars divided by the # books circulated

• Proj: total projected dollars / # books circulated (total projected = actual order dollars / percent complete)

• Wgt Prj: weighted projected dollars / # books circulated (weighted projected dollars = weighted dollars / % complete)

• Order $/1000 Books: number of orders / # books circulated * 1000