Offer Page Analysis Report (OPAR)

This report can be run only for a single offer, and is sorted by page and item within page. Subtotals and final totals are provided by page.

How to print: Use the Print Offer Page Analysis (OPAR) menu option.

CWDirect Offer Page Analysis Mail Order Company Offer 1 OFFER INITIALIZED Units Profit Page Contrib Item Description Offer Space Squ ------------------------------- $ Ordered ------------------------------------- ------------ Price Cost In Ordered Sold Out Returns Exchange Gross Net Square In Index gp% Sales% Page # 27 4659 LACE SLIPPERS .00 .00 0 36 0 150 0 1415.00 1415.00 1415.00 .00 .00 100.00 100.00 Page 27 totals: .00 0 36 0 150 0 1415.00 1415.00 1415.00 .00 .00 Page # 99999 PSG SOLDOUT PSG SOLD OUT ITEM 10.00 .00 0 2 2 0 0 2.00 .00 .00 .00 .00 .00 .02 SHIPALONE SHIP ALONE ITEM 9.00 .00 0 15 0 0 0 30.00 30.00 30.00 .00 .00 .33 .33 1511 WASH CLOTH .00 .00 0 1 0 0 0 3.00 3.00 3.00 .00 .00 .03 .03 2222 NIGHTSHIRT .00 .00 0 8 0 0 0 14.00 14.00 14.00 .00 .00 . 15 .15 4659 LACE SLIPPERS .00 .00 0 25 0 0 0 1150.00 1150.00 1150.00 .00 .00 12.78 12.77 4824 EARRINGS .00 .00 0 0 0 138 0 .00 .00 .00 .00 .00 . 00 .00 6006 SPOOL BED .00 .00 0 6 0 0 0 7800.00 7800.00 7800.00 .00 .00 86.69 86.67 Page 99999 totals: .00 0 57 2 138 0 8999.00 8997.00 8997.00 .00 .00 Offer 1 totals: .00 0 93 2 288 0 10414.00 10412.00 10412.00 .00 .00

Contents:

• Offer code

• Offer description

• Item number: the base item number

• Item description

• Offer price: the price at which the item is advertised in this offer

• Space cost: the cost of the item on this page, calculated by:

 

(Square inch per item in Item Offer Page / Square inch per page in Offer) * Page cost in Offer = Space cost

 

• Square inches: the square inches for the item, as defined in Item/Offer

• Units ordered: the net number of units ordered for this item in this offer. This is the sum of Units Ordered CTD in the SKU Offer Page file for all SKUs.

• Units sold out: the number of units of the item identified as soldout on this page. This is the sum of Units Sold Out CTD in the SKU Offer Page file for all SKUs.

• Units returned: the number of units returned for this page. This is the sum of Units Returned CTD in the SKU Offer Page file for all SKUs.

• Units exchanged: the number of units exchanged, captured in the Exchange Reason/Offer file.

• $ ordered: the total dollars ordered for the item for this page. This is the sum of Dollars Ordered CTD in the Offer Page file for all SKUs

Note: The sum of all Gross $ Ordered for all items on a page is "Gross $ Ordered Per Page."

• Gross profit: the gross profit for this item on this page, calculated by:

 

Gross $ ordered - Total item cost

 

Total item cost = Units ordered * item cost

 

Note: The sum of all Gross $ Ordered for all items on a page is "Gross $ Ordered Per Page."

• Net profit: the net profitability of the item, including the space cost, calculated by:

 

(Gross profit - Space cost)

 

• Profit/Square inch: the profit per square inch, calculated by:

 

(Gross profit / Square inch per item

 

• Profit index: a measure of net profitability, in which the break even equals 1 when the net profit covers the allocated cost, calculated by:

 

(Gross profit / Space cost)

 

• GP% Contribution to the Page: the total gross profit contributed to the page by this item, calculated by:

 

Gross profit / Gross profit per page

 

• Sales % Contribution to the Page: the percentage of sales contributed by this item, calculated by:

 

Gross $ ordered / Gross $ per page

 

• Page totals

• Offer totals