Overview:

The Cost Sheet is used to build up an aspect of the quote costs, for example 'Stage 1' of the quoted work. A quote may include multiple sheets as displayed on the Quote's Cost Sheets tab.

Screen Guide:

Main

Create or edit attributes for a Cost Sheet.

Sequence is a numeric used for the the list displayed on the Cost Sheets tab. This auto increments by 10 on a new cost sheet.
Cost Sheet is a name to identify this cost sheet.
Work Centre for the Cost Sheet. Leave blank unless you are equating a Work Centre with a whole cost sheet. This would only be the case if you were using Job Work Centres and were identifying the work from a chronological perspective. The Work Centre can be entered on the individual Cost Sheet transaction lines or will default from the Activity Code.
Price Code sets the default retail price code for all the Cost Transactions if you are pricing from the individual Cost Sheet transaction lines.
You can change the Price Code by entering a new code. The default is specified by the Quote Default Price Code control parameter.
Activity Group to be used in defaulting the cost line Work Centres.
Job for the Cost Sheet, a valid Job being the Header or SubJobs linked to the Quote Header.
Entered By is the person capturing the Cost Sheet.
Description in brief for this Cost Sheet.
Details allows for a more detailed narrative of the cost sheet if required, with basic formatting support.

Summary

Provides a summary aggregated by Cost Category. 'General' is the default cost category if not explicitly set up on the activity.

Cost aggregates the cost sheet line Total Cost values by cost category.
Sell aggregates the cost sheet line Total Selling values by cost category.
Margin is calculated as the Sell - Cost for the cost category.
Margin% is calculated as the (Sell - Cost)/Sell for the cost category.
Markup% is calculated as the (Sell - Cost)/Cost for the cost category.

Lines

The Lines tab support the breakdown of costs in 3 Input style, each supporting further levels of flexibility and sophistication. The Lines tab is only displayed after saving the Main tab.

Input style for this cost sheet.
- At Activity, Work Centre allows for a basic breakdown using activities only.
- At Cost Element allows for a breakdown by the standard types - Activity, Labour, Plant, Stock
- At Revenue & Cost Element allows for grouping the cost elements lines into a single revenue line

The input style is fixed after saving. The default style At Revenue & Cost Element is the most flexible.

Grid Sort specifies the row sort order, the default is Sequence No.
- Sequence No is the entered sequence
- Activity, Work Centre is a combined sort in this precedence
- Work Centre, Activity is a combined sort in this precedence

Expand

title	At Activity, Work Centre

Allows for a basic breakdown using activities only.

Details specifies information or specification about the line being quoted.
Line Code in this input style is equivalent to the Activity picker for those in the Activity Group specified on the Main tab.
Unit is the unit of measurement for this line.
Calculation allows to enter a mathematical expression that you can use to calculate the quantity value. If this is entered, the Qty column becomes read-only. Hidden by default in Grid Management. See valid expressions at the end of the page.
Qty is the quantity of units being quoted.
Cost Rate defaults based on the Activity selection but can be modified to what you believe is most accurate.
Total Cost is the Qty multiplied by the Cost Rate fields.
Markup% is the cost markup to be applied to sell, as displayed in Selling Rate.
Selling Rate is the result of the Markup% applied to the Total Cost.
Total Sell is the Qty multiplied by the Selling Rate field.
Margin% is calculated as (Selling Rate - Cost Rate) / Selling Rate
Activity availability depends on the Activities in the global list as well as the Activity Group selected for the Job in Job Maintenance.
Work Centre will need to be selected from the Work Centres available.
Description will default based on the Activity selection, but can be modified.

Expand

title	At Cost Element

Allows for a breakdown by the standard types - Activity, Labour, Plant, Stock.

Add Bill Of Materials allows selection of a defined Bill Of Materials (BOM) item, and the [+] button adds the constituent BOM lines into the cost lines.

The cost line fields specify the following.

Details specifies information or specification about the line being quoted.
Type of cost line being either Activity, Labour, Plant, Stock.
Line Code provides a line Type specific picker for the cost:
- Activity type has Activity picker for those in the Activity Group specified on the Main tab.
- Labour type has Employee Class picker
- Plant type has Plant picker
- Stock type has Stock Item picker
Plant Rate is only used for lines of Plant type, and lists the defined rates for the plant.
Unit is the unit of measurement for this line.
Calculation allows to enter a mathematical expression that you can use to calculate the quantity value. If this is entered, the Qty column becomes read-only. Hidden by default in Grid Management. See valid expressions at the end of the page.
Qty is the quantity of units being quoted.
Cost Rate defaults based on the Line Code selection but can be modified to what you believe is most accurate.
Total Cost is the Qty multiplied by the Cost Rate fields.
Markup% is the cost markup to be applied to sell, as displayed in Selling Rate.
Selling Rate is the result of the Markup% applied to the Total Cost.
Total Sell is the Qty multiplied by the Selling Rate field.
Margin% is calculated as (Selling Rate - Cost Rate) / Selling Rate.
Activity availability depends on the Activities in the global list as well as the Activity Group selected for the Job in Job Maintenance.
Work Centre will need to be selected from the Work Centres available.
Description will default based on the Activity selection, but can be modified.
Area, Weight and Volume, these fields can be enabled using Grid management. They are hidden by default and are only displayed on ‘At Cost Element’ Cost Sheets. The values are read only and will be populated for lines relating to stock items (if they have these values populated in the Stock Item), by multiplying the Weight, Area and Volume by the line Quantity.

Expand

title	At Revenue & Cost Element

Allows for revenue lines each with a breakdown by the standard types - Activity, Labour, Plant, Stock.

Add Bill Of Materials allows selection of a defined Bill Of Materials (BOM) item, and the [+] button adds the constituent BOM lines into the selected revenue cost lines.

The revenue line fields specify the following.

Sequence allows the revenue lines to be ordered.
Details specifies information or specification about the revenue line being quoted.
Line Code provides the reference for the revenue line
Unit is the unit of measurement for this line.
Calculation allows to enter a mathematical expression that you can use to calculate the quantity value. If this is entered, the Qty column becomes read-only. Hidden by default in Grid Management. See valid expressions at the end of the page.
Qty is the quantity of units being quoted to sell. Updating the Qty after cost lines have been defined will proportional increase the Qty on the sub-grid cost lines.
Cost Rate is a notional rate from the cost lines as revenue Total Cost / revenue Qty.
Total Cost is the calculated total of the cost Total Cost fields.
Markup% is the cost markup to be applied to sell, as displayed in Selling Rate.
Selling Rate is the result of the Markup% applied to the Total Cost.
Total Sell is the revenue Qty multiplied by the revenue Selling Rate field.
Margin% is calculated as (Selling Rate - Cost Rate) / Selling Rate.
Activity availability depends on the Activities in the global list as well as the Activity Group selected for the Job in Job Maintenance.
Work Centre will need to be selected from the Work Centres available.
Description will default based on the Activity selection, but can be modified.

The sub-grid cost line are the cost constituent of the revenue line and the fields specify the following.

Details specifies information or specification about the cost line being quoted.
Type of cost line being either Activity, Labour, Plant, Stock, and Catalogue.
Line Code provides a line Type specific picker for the cost:
- Activity type has Activity picker for those in the Activity Group specified on the Main tab.
- Labour type has Employee Class picker
- Plant type has Plant picker
- Stock type has Stock Item picker
- Catalogue type has Catalogue Line picker for Docket Cost Schedules, and Supplier Catalogues
Plant Rate is only used for cost lines of Plant type, and lists the defined rates for the plant.
Unit is the unit of measurement for this cost line.
Qty is the quantity of units of cost being quoted.
Cost Rate defaults based on the Line Code selection but can be modified to what you believe is most accurate.
Total Cost is the cost Qty multiplied by the Cost Rate fields.
Markup% is the cost markup to be applied to sell, as displayed in line Selling Rate
Selling Rate is the result of the Markup% applied to the Total Cost.
Total Sell is the cost Qty multiplied by the line Selling Rate field.
Margin% is calculated as (Selling Rate - Cost Rate) / Selling Rate.
Activity availability depends on the Activities in the global list as well as the Activity Group selected for the Job in Job Maintenance.
Work Centre will need to be selected from the Work Centres available.
Description will default based on the Activity selection, but can be modified.

When using At Revenue and Cost Element, on budget creation, Job Work Centres will be created or description updated with the description field on the Cost Sheet for each Revenue line. All cost lines in the Cost Sheet under the same Revenue line, will be created in the Budget under the same Revenue line (with same Job Work Centre).
If Job the Job already has Job Work Centres, the descriptions will be updated with the descriptions on the Revenue line; if Job Work Centres do not exist, they will be created with the Work Centres from the revenue lines.

Expand

title	Buttons

Import opens a list of supported imports, the default being wbImportCostSheetScheduleLinesWeb.
Save & Close will attempt to Save and close the popup if the save succeeded.
Save will attempt to commit all entered data to the system. If there are any errors, a red bar will display at the top of the screen with the error. You must fix these errors before the data will be committed to the system. A green bar will appear if the data has been saved.
Close will close the popup and revert to the underlying screen.

Expand

title	Calculation valid expressions

Below are the supported symbols to be used on a Calculation column.

Image Modified

Supported symbols

Symbol	Explanation
+	Addition Operator eg. 2+3 results 5
-	Subtraction Operator eg. 2-3 results -1
/	Division operator eg 3/2 results 1.5
*	Multiplication Operator eg. 2*3 results 6
Mod	Modulus Operator eg. 3 Mod 2 results 1
(	Opening Parenthesis
)	Closing Parenthesis
&	Bitwise AND eg. 3&1 results 1
Sigma	Summation eg. Sigma(1,100,n) results 5050
Pi	Product eg. Pi(1,10,n) results 3628800
n	Variable for Summation or Product
pi	Math constant pi returns 3.14
e	Math constant e returns 2.71
C	Combination operator eg. 4C2 returns 6
P	Permutation operator eg. 4P2 returns 12
!	factorial operator eg. 4! returns 24
log	logarithmic function with base 10 eg. log 1000 returns 3
ln	natural log function with base e eg. ln 2 returns .3010
pow	power function with two operator pow(2,3) returns 8
^	power operator eg. 2^3 returns 8
root	underroot function root 4 returns 2
sin	Sine function
cos	Cosine function
tan	Tangent function
asin	Inverse Sine function
acos	Inverse Cosine function
atan	Inverse Tangent function
sinh	Hyperbolic Sine function
cosh	Hyperbolic Cosine function
tanh	Hyperbolic Tangent function
asinh	Inverse Hyperbolic Sine function
acosh	Inverse Hyperbolic Cosine function
atanh	Inverse Hyperbolic Tangent function

Next Steps:

Related Pages:

Quotes

Bill of Materials

FAQs:

Filter by label (Content by label)

showLabels	false
showSpace	false
cql	label = "placeholder" and space = "KB"

Process Flow:

Versions Compared

Old Version 18

New Version 19

Key

Overview:

Screen Guide:

Main

Summary

Lines

Supported symbols

Next Steps:

Page Comparison

Versions Compared

Old Version 18

New Version 19

Key

Overview:

Screen Guide:

Main

Summary

Lines

Supported symbols

Next Steps: