In this Article: ShowHide

Price Codes

Glass Pricer

New in FrameReady 11: Glass Pricer

Use this feature to help you to create a new Code Table or update an existing one to accurately price your glass.

• Price your glass by lite size, based on your wholesale cost times a markup plus a set price (Cost x Markup + Set Price). The wholesale cost is determined by the box Price divided by the number of lites per box.

How to Use the Glass  Pricer

• See also: Use the Glass Pricer

A Note on the Calculations Used

• The calculation for the Cost Per Square Inch is:  
  
  Cost Per Square Inch = (( Box Price  /  Lites Per Box ) / ( X  x  Y ))

• The calculation for Square Inches is:  
  
  Square Inches =  X  x  Y 

• The formula for the Retail Price is:  
  
  Retail Price =  Cost Per Square Inch  x  Square Inches  x  Markup  +  Set Price 

Glass Pricer Screen Explained

Width (X) Field

• The width of the lite.

Height (Y) Field

•  The height of the lite.

Box Price Field

• The cost for one box of glass in the size entered in Width and Height fields.

Qty Per Box Field

• The number of lites (full sheets of glass) in the box.

Tip: If you do not purchase glass by the box, then enter the per lite price in the box Price field and enter 1 in the Lites Per Box field.

Markup Field

• Must be entered as a number or decimal, e.g.  2.5  , and is the multiplier applied to the cost of the area of glass.

Set Price Field

• A dollar amount added per lite size.

Build New Table Button

• Creates a pricing chart for 21 common glass sizes based on the X and Y size, the Box Price, and the number of lites per box.

• The wholesale cost is broken down to a cost per square inch.

• The number of square inches for each glass size are multiplied by the Markup and a Set Price is added to determine a Retail Price for each size.

• If you change any of the fields at the top of the screen (in the pink area), then click the Build New Table button to recalculate the Retail Prices for all sizes. This also adds back any sizes you have previously removed. (TIP: Use the Restore Default For This Table button to recalculate any pricing changes in the top pink area without adding back in the sizes you previously removed in the lower portion of the screen.)

Recalculate Button

• Recalculates the prices using the amounts entered in the fields in the top pink area of the screen: X, Y, Box Price, Lites Per Box, Markup, and Set Price. It will not add back in any sizes which you may have deleted in the lower portion of the screen.

Line Items

Glass Pricer Line Items

• All fields can be clicked into and modified with the exception of: Cost Per Square and Square Inches (which are both calculated fields).

• The Delete (X) button removes the entire line item. This cannot be undone.

• To add a line item, click on Records in the menu bar and select New Record then enter the size. Or use the Build New Table button which will add all deleted sizes and put the pricing back to the calculations set at the top of the screen.

Restore Default Button  (in Glass Pricer Line Items)

• This button only appears when changes have been made to the: Box Price, Lites Per Box, Markup, or Set Price fields.

• Removes the change(s) made to the pricing of this one line and replace(s) it with the original calculation (as defined at the top of the screen in the pink section).

Bottom of Screen

Price Codes (Icon) Button

• Closes the window and returns to the glass record you were previously viewing in the Price Codes file.

Code Tables Button

• Open the Code Tables screen and shows the most recently viewed Code Table.

Update Code in Code Tables Button

• Replaces the existing Code Table (identified in the field below the button) with the sizes and retail prices shown in the current screen.

• A new Code Table can be added by typing the code name to be used into the field. Use the drop down list to ensure that the code name is not already is use. Pricing in this table can only be used when it has been converted into a Code Table.

Enter the glass area (in^2) and the glass cost per square inch ($/in^2) into the Glass Price Calculator. The calculator will evaluate the Glass Price. 

Glass Price Formula

The following two example problems outline the steps and information needed to calculate the Glass Price.

GP = GA * GCSI

Variables:

• GP is the Glass Price ($)
• GA is the glass area (in^2) 
• GCSI is the glass cost per square inch ($/in^2) 

To calculate glass price, multiply the glass cost per square inch by the glass area.

How to Calculate Glass Price?

The following steps outline how to calculate the Glass Price.

1. First, determine the glass area (in^2). 
2. Next, determine the glass cost per square inch ($/in^2). 
3. Next, gather the formula from above = GP = GA * GCSI.
4. Finally, calculate the Glass Price.
5. After inserting the variables and calculating the result, check your answer with the calculator above.

Example Problem : 

Use the following variables as an example problem to test your knowledge.

glass area (in^2) = 50

glass cost per square inch ($/in^2) = 12

GP = GA * GCSI = ?