The Frame Markup screen allows you to specify the formulas used to calculate the retail price of frames being added into your frame inventory. During this process, you can manually override the retail price calculated by the system (based on these formulas) for any given frame. Frame markup formulas calculate the retail price for a frame by multiplying its group cost, adding a fixed amount to it or both.

If you are importing frames from the SPEX UPC CD, the group cost field is automatically imported from the CD into My Vision Express and, if a markup formula applies to them, the retail price is calculated automatically. To import frames from the SPEX UPC CD, go to File > Inventory > Transactions > FRAMES Data import from the main application menu. Refer to the Frames Data  subsection under the Inventory Setup and Maintenance section further down this chapter for additional information.

You can access the Frame Markup screen by going to File > Setup > Frame Markup. Here you can Add new markup formulas, select one and Delete it, or apply one to your frame inventory by selecting it and clicking

Update Pricing…. You can also change a formula by selecting its record and editing the fields in the ‘Frame Markup Details’ group box.

The frames that a formula applies to could be narrowed down by ‘Collection’ and group cost. For a formula to apply, a frame’s group cost must fall within the range specified by the ‘Start Group Cost’ and ‘End Group Cost’ fields. The ‘Collection’ could be left blank if the formula was to apply to any frame collection in inventory.

Formulas are applied as follows:

§ When ‘Ceiling’ is set to “Down”:

§ When ‘Ceiling’ is set to “Up”:

In other words, if the ‘Ceiling’ is “Down”, the result of‘Ends With’ amount will be added to the retail price. If the ‘Ceiling’ is “Up”, the result of‘Ends With’ amount will be added to the retail price.

As an example, you can have a frame markup formula like the one selected on Fig. 20 with a ‘Multiplier’ of 2.0, an ‘Amount’ of 50.00, an ‘Ends With’ of 0.99 and the ‘Ceiling’ set to “Down”. Note that this formula will apply to frames on any collection with a group cost in the range between $1 and $500. Suppose that there is a frame with a group cost of $30.25 which is within that range. The retail price for that frame would be:

In a similar case, with the ‘Ceiling’ set to “Up” instead, the retail price for the frame would be:

Finally, the ‘Nearest Tenth’ checkbox will round the price up to the next multiple of 10. Thus, checking this box would cause the two examples above to round up to $120.

Click Save and Close on the main application toolbar when you are finished making changes to this screen.