|
|
|
Standard Cost Rollup
BOM Costing allows a user to carry out multi-level Cost Roll-up using the Standard Cost for Items, Descriptors and Labour plus Fixed and Variable Overheads related to Labour.
The Cost Roll up program goes through the following steps:-
|
• |
Sorts all parent Items in the BOM table into Low-Level Code descending sequence |
|
• |
Commencing with the first parent calculates the following from its components |
Set Up Cost
Items - Standard Cost * Usage Quantity / Setup Batch Size
Descriptors - Standard Cost * Usage Quantity / Setup Batch Size
Labour - Labour Code’s Labour Cost * Hours / Setup Batch Size
FOH - Labour Code’s FOH Cost * Hours / Setup Batch Size
VOH - Above Labour calculation * VOH recovery Rate
Process Cost
Items - Standard Cost * Usage Quantity
Descriptors - Standard Cost * Usage Quantity
Labour - Labour Code’s Labour Cost * Hours
FOH - Labour Code’s FOH Cost * Hours
VOH - Above Labour calculation * VOH recovery Rate
|
• |
Progressively repeats this process for all parent Items in the BOM |
|
• |
The results are displayed for assessment and selection |
|
• |
The select Items have their Standard Cost updated |
Opening Screen
Entry and Display fields
Create New or Open Previous: Only one Cost Rollup Run can exist at any time. Therefore the following scenarios can exist
|
• |
If the Cost Rollup has never been run before then you must generate ‘New’ |
|
• |
If the previous Cost Rollup has been ‘Updated’ then you must generate ‘New’ |
|
• |
If a previous run has not been ‘Updated’ then you have the option to open the current run details or run ‘New’. If you run ‘New’ then the old data is overwritten |
In the first two instances you have no choice but to run ‘New’, in which case the Cost Rollup will run after you click on the OK Button
Specific Site: If this is 'checked' then the Roll-up will be for the site selected in the next field and will use the Inventory Costs specified for this Site.
Site: This will become active if the previous filed is 'Checked'. Select the Specific Site from the drop-down list against which this Cost Roll-up will be carried out
Previous Standard Cost Rollup Run
Rollup Last Run Date: If a previous Rollup run exists then this will show the date when it was run. If no previous run has been done then this field will be blank
Status: If a previous Rollup run exists then this will be prefilled with the status ‘In Progress’. If no previous run has been done then this field will be blank.
Buttons
OK: If ‘Radio Button’ selection is:
|
• |
‘Create New Standard Cost Rollup’ then the Standard Cost Rollup routine will be carried out before displaying the results in the List screen |
|
• |
‘Open Previous Standard Cost Rollup’ then the program will go directly to the List screen and display the results of the previous Rollup |
Cancel: Will cancel and close this function
List Tab
This tab displays all the assemblies whose Cost has been rolled-up. You can select specific Items that you wish to update. These will then be updated with a single click of your mouse button.
Display fields
Select: ‘Check’ the checkbox where you want the Item’s revised Standard Cost to be updated. You have the option to click on the ‘Select All Items’ Button at the bottom of this panel to select all the records. You may also click on the ‘De-select All Items’ Button at the bottom of this panel to ‘un-select’ all the records
Item Code: Display only field showing the Item that has had its Standard Cost rolled up
Description: Display only field showing the description of the Item
Unit: Display only field showing the base Unit of Measure of the Item
Last Std Update: Display only field showing the Quantity required as amended in the Detail tab
Std Cost: Display only field showing the current Standard Cost of the Item
Rolled Up Cost: Display only field showing the calculated Standard cost evaluated during this Cost Rollup run
New Std Cost: Prefilled with the calculated Rolled Up Cost taken from the previous field. You can amend this value if you wish. The entry in this field is the value that updates the current Standard Cost against the Item
Item Cost Content: Display only field showing the calculated Material (Item) content evaluated during this Cost Rollup run
Descriptor Cost Content: Display only field showing the calculated Descriptor content evaluated during this Cost Rollup run
Labour Cost Content: Display only field showing the combined calculated Labour, Fixed Overhead and Variable Overhead content evaluated during this Cost Rollup run
Sourced By: Display only field showing the Source of the Item
Category: Display only field showing the Category currently held against the Item
Sub Category: Display only field showing the Sub Category currently held against the Item
Rolled Up From: This is normally from the BOM.
Data Display Options
Field Position - On the List screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.
Buttons
Select All Required: Clicking this Button will place a check-mark in the Select column against all displayed Items
De-select All Required: Clicking this Button will remove check-marks from the Select column against all displayed Items
Update Standard Cost for Selected Requirements: All Items that have been selected will be have their Standard Cost update with the above ‘New Std Cost’
Close: This will close the Cost Rollup screen. If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.
Save: If you have made any changes to the ‘New Std Cost’ in a record you can save that cost and remain in this screen by selecting this button.
Cancel: If you have made any changes to the ‘New Std Cost’ in a record you can ignore the change and revert to the pre-change condition by selecting this button.
Related: This will bring up a list of functions that are related to Cost Rollup. You may open and maintain information in those screens whilst still remaining in the Cost Rollup screen.
Reports: This will bring up a list of Reports that are related to Cost Rollup. You can immediately run the report whilst still remaining in the Cost Rollup screen.
Detail Tab
This tab displays the details that went into calculating the Standard Cost of the parent Item
Display fields
Item Code: Display only field showing the selected Item
Description: Display only field showing the description of the Item
Unit: Display only field showing the base Unit of Measure of the Item
Line Type: Display only field showing the type of line being displayed. The display options are:
|
• |
Item Code |
|
• |
Descriptor Code |
|
• |
Labour Code |
Code: Display only field showing the specific component code.
Qty Per: Display only field showing the usage quantity of this line in the parent assembly.
Std Cost: Display only field showing the Standard Cost of this line
Total Cost: Display only field showing the calculated (Qty per * Std Cost) extended Cost of this line.
Data Display Options
Field Position - On the List screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.
Buttons
Close: This will close the Cost Rollup screen. If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.
Related: This will bring up a list of functions that are related to Cost Rollup. You may open and maintain information in those screens whilst still remaining in the Cost Rollup screen.
Reports: This will bring up a list of Reports that are related to Cost Rollup. You can immediately run the report whilst still remaining in the Cost Rollup screen.