Understanding the Default Pricing for Moulding
FrameReady can be set to begin with Length, Chop or Join prices as the default Retail Price Per Foot. If those are unavailable, then FrameReady looks to the next available price.
Default Pricing Based on Length
-
If you set FrameReady to order your moulding by Length, then FrameReady first looks in the Cost field ("Cost" is the actual name of the database field that FrameReady uses for Length pricing. This is important for setting up a pricing Formula).
-
If FrameReady does not find a wholesale Cost in that field, then FrameReady looks in the Chop field.
-
If that too is blank, then FrameReady bases your Retail Price Per Foot on the amount in the Join field.
-
The following chart shows a sliding scale formula for moulding based on the Cost (length) field to determine which Markup to use.
FrameReady's Markup Table for Length Pricing
Cost Type |
If Cost is Less Than |
Use a Markup of |
Cost |
<2.50 |
5.0; |
Cost |
<3.75 |
4.9; |
Cost |
<5.00 |
4.8; |
Cost |
<6.25 |
4.7; |
Cost |
<7.50 |
4.6; |
Cost |
<8.75 |
4.5; |
Cost |
<10.00 |
4.4; |
Cost |
<11.25 |
4.3; |
Cost |
<12.50 |
4.2; |
Cost |
<13.75 |
4.1; |
Cost |
<15.00 |
4.0; |
Cost |
<16.25 |
3.9; |
Cost |
<17.50 |
3.8; |
Cost |
<18.75 |
3.7; |
Cost |
<20.00 |
3.6; |
Cost |
all others |
3.5 |
See also: Pricing by the Linear Foot and Pricing by United Inch/Centimetre
Default Pricing Based on Chop
-
If you selected to order your moulding by Chop, then FrameReady looks first in the Chop field.
-
If the Chop field is blank, then FrameReady looks in the Join field.
-
If it too is blank, then FrameReady will base your Retail Price Per Foot on the amount in the Cost field.
-
If you selected to price (and order) your moulding by Chop, then FrameReady applies the appropriate Markup based on the corresponding Cost:
FrameReady's Markup Table for Chop Pricing
Cost Type |
Less Than |
Markup |
Chop |
<5 |
2.85; |
Chop |
<10 |
2.80; |
Chop |
<15 |
2.75; |
Chop |
<20 |
2.70; |
Chop |
<25 |
2.65; |
Chop |
all others |
2.6 |
Default Pricing Based on Join
-
If you selected to order your moulding by Join, then FrameReady looks first in the Join field.
-
If the Join field is blank, then FrameReady looks in the Chop field.
-
If it too is blank, then FrameReady will base your retail price on the amount in the Cost field.
Note: Although suppliers may have an option for you to order their moulding as Chop and Join, they may not have provided Adatasol Inc with the wholesale costs for Chop and Join.
This often happens when the wholesale cost of the moulding varies with the size of the frame you order. E.g. 8×10 frame is $5.00 per foot while a 34×40 frame is 4.10 per foot. This is a common practise for Canadian vendors.
-
If you selected to price (and order) your moulding by Join, then FrameReady applies the default Markup (pre-entered into FrameReady as: Join wholesale cost multiplied by two).
FrameReady's Markup Table for Join Pricing
Cost Type |
All |
Markup |
Join |
all |
2 |
Working with Default Markups
-
The default Markups in FrameReady can easily be modified by clicking on the number and changing it.
-
You can always revert back to the FrameReady defaults by clicking on the Install Program Defaults button. This allows you to install the default formula to just the current record or to all moulding records.
-
In addition to the Markups, all woods, liners, and extenders have an additional $5.00 added to the final price of the frame and all Fillets have $7.50 added to the final Retail Price. These amounts are stored in the Set Price tab, like so:
Case(
Group = "Fillet"; 7.5;
5)
The 5 in the above Case statement is at the end of the list. This position is reserved for a default result; if none of the expressions in the Case statement are true, then the default result is used. In this case, 5.
Set Up Your Own Moulding Formulas
© 2023 Adatasol, Inc.