Here are a series of formulas used by sign and printing companies. It is common for sign-makers (particularly) to use simple formulas that approximate the material use. In this case, you must ensure you allow for the waste by adding additional markup.
Selecting a Material Formula
The formulas for a material are set in the master material list. (1) is a drop-down list where you select the default material that you apply to this material. The selection here determines the calculation that will be applied.
Understanding the Price Method
The price method box (2) contains a limited list of price methods associated with the formula. The price method box allows you to convert the calculation and its prices to a more user-friendly format.
For instance, the selection above of roll/lineal metre first calculates the roll percentage required for the job. The price method converts this to lineal metres and also the cost to a lineal metres prices.
Over-riding a Material Formula in a Job/Quote
It is important to remember that you can override the default formula within a recipe. For instance, even if the material is defined as a length, you can assign 'perimeter metres' to its use within a recipe.
Formulas That Approximate Material Usage
The following are formulas that approximate the material requirements and do not allow for waste
Square Metres
The square meter formula calculates the area of the finished size of the item. For instance, the area of 2 x 900W x 600H panels is 1.08 sqm.
The formula uses the finished size of the item, and the price per sqm is calculated using the value in the material master list. If you have determined a set selling price for the sqm then enter this in the 'sell price' box for the material. If the sell price is empty, the sqm price will be calculated using the sqm size of the material, divided by the buy price
Simple Lineal Metre
The simple lineal meter formula is used for materials like rope, sail track, Kedar where you have already factored the waste into the markup or sell price.
The system uses the 'longest side' of the sizes into the material grid
Cost per Worksheet
This formula is used for calculating the number of impressions or 'clicks' for machinery such as digital printing presses that are sold by the printing impression
Flat Rate - Square Metres
This formula is used to calculate a cost for materials that are used in the setup of a process and are not affected by order quantity. An example would be positive films for screen printing - the cost of the film might be costed in square metres based on the number of colours printed
Formulas that Calculate Actual Material Use
The following formulas will calculate the actual material requirements by working out the best fit of the product size into the material size. You can show the result as lineal meters, square metres or a count.
Sheet
The sheet formula is used for materials like aluminium composite panels, acrylic and aluminium. When a material is defined as a sheet, the system will calculate how many finished panels fit into the sheet and will calculate the remainder as a percentage of the sheet.
You can set the system to round up to the next full sheet after the calculation
If the product size is larger than the sheet, the system will attempt to cover the area with even-sized panels.
Example:
A 900 x 600 panel is cut from a 2400 x 1200 sheet of ACM which costs 85.90
Sheet Formula | No Price Method - 0.19 sheets @ 85.90 per sheet
Sheet Formula | SQM Price Method - 0.54 sm @29.83 per sqm.
Roll
A roll is used for materials such as printed self-adhesive vinyl. The system will fit the finished item size across the roll, then down the roll and work out the percentage of the roll required. It is more intuitive to show usage in lineal metres.
If the item size is larger than the sheet, then the system will calculate even-sized drops.
Components
The component formula is used for items like eyelets, screws and fittings. It works off a count of the items. You can manually enter the number of items per finished item or assign a formula that derives the count from the outside dimensions.
Length
The length formula is used for material items like aluminium extrusions that have a defined length, which we consider in the calculation, but the width is not considered. The length formula rounds up to the next full unit. The length required for a job will depend on the shape of the finished part. Here are some formulas that you can apply as overrides within a recipe.
Perimeter Meters
Use the Perimeter Meters formula to calculate the outside dimension of a part in meters. You will use this formula in conjunction with a material sold by the lineal metre.
Top and Bottom
This formula calculates the length in meters for the X-Dimension for the top and bottom - ie 2 X the X-Dimension
Top or Bottom
This formula calculates the length in metres for the X-Dimension for either the top or bottom - ie the X-Dimension
Left and Right
This formula calculates the length in metres for the Y-Dimension for the left and right- ie 2 X the Y-Dimension
Left or Right
This formula calculates the length in metres for the Y-Dimension for the left or right- ie 1X the Y-Dimension
Flat Rate
The flat rate formula is used for fixed-cost items that don't vary with the quantity of the job. An example would be machine hire, engineering costs, and traffic control costs.
Garment
The garment formula is used for apparel decoration. It uses the same calculation as a component; however, when you define a material as a garment, it allows us to group decoration costs around the garment and recognise that there are children 'sizes' we can consider.
Comments
0 comments
Please sign in to leave a comment.