How to Develop a Profitable Merchandise Mix

Next, take the results of the catalog mailing, and for each product, indicate the following: gross demand items, orders and sales; gross margin; returns; and the advertising cost per square inch.

Add a column to calculate contribution by subtracting cost per square inch from gross margin per square inch. Sort the spreadsheet to rank products by contribution, price point, category, gross margin and catalog page.