Manufacturing > Sell price calculation for Sheet Materials (Plastic) used in Quotes and Client Orders

Overview:

For plastics fabrication companies, the selling price of sheet material can vary dependant on whether the sheet is sold as a full sheet or cut to size. The following options can be used to calculate the sell price in both Quotes and Client orders.

Option 1.

Variable material pricing automatically determined from cut size of material sheet. The following records need to be set as per figures below.

Click on ‘System Codes’ on the toolbar and select ‘System Parameters’ from the bottom of the drop-down list. Click on ‘Parameters – QUOTE’ to open the window, click on the tick boxes as shown below.

Create a material group for the plastic sheets and enter fields as shown below.

Note: The Factor for Plastic is used to create price points based on the portion of sheet being cut,

eg: the example shown will give 3 price breaks at 0 - .333 , .334 - .666 and .667 – 1.0 of a sheet. These factors will multiple the UOM2 SQM price. The more Factors loaded the greater sell price points created.

Create the Material Record and enter the UoM2 Price.

Calculating Sheet size and sell price for cut to size materials.

1.	Enter material code to be Sold/Quoted.

2.	Tick the ‘Use Size’ box and Dbl-click on the “@”column to display the Calculation window.

3.	Add the Length and Width as shown and press <TAB>. The appropriate sell price will be selected.

4.	Click on the Green update button to Update into Order/Quote.

Option 2

Sheet materials used in client orders or quotes can only be used as full sheets and the “Sell Price” from the material record will be applied.

Parameter setting as below.

Last Revised: 22/08/2011 SJ