ElyxAI

Excel for brand managers: price, margin and range

A brand workbook in Excel is two sheets for the range you manage. The pricing grid is one row per SKU and channel: unit cost, shelf price, and the margin that price leaves. The margin sheet is the same SKU with selling price, unit cost, and the rate (price minus cost, divided by the price). Open the sheet that matches the question. A price change belongs on the grid. A profit question belongs on the margin sheet. A restaurant menu is a different set of pages. The links below open those two sheets. Elyx builds the columns in the file you already use. The trial lasts 7 days, with no card.

4 workflows

Frequently asked questions

What is on the pricing grid?

One row per SKU and channel, with the unit cost, the shelf price, and the margin that price leaves (price minus cost).

What is on the margin sheet?

One row per SKU: selling price, unit cost, margin in money, and the rate, that margin divided by the price.

Is this a restaurant menu?

No. Menu prices and dish margins are on the restaurant pages. These two sheets are the product range.

Essential
Popular