Planning

3.0 Planning

The Planning menu in the home page of the cuteQM app is mainly used to search for the piping feasibility of the projects and to assign priority. This menu also helps to add the bill of materials and material request.

Here, you can manage the material reservation, material substitution, offcut inventory, material requisition, and material issuance.

Once you click the Planning menu, the following tabs open,

       

3.1 Bill of Material (BOM)

The BOM tab in the Planning menu used to add a BOM including quantity of items needed for the piping fabrication from the overall quantity in the inventory. To add BOM,

1. Click BOM in the Planning

The Bill of Material page opens.

      

                                                          Figure 3.1: Bill of Material page

3.1.1 Add a BOM

If you want to add a BOM,

1. Click (ADD button) in the Bill of Material See Fig 3.1.

The page opens a new window to add the details of BOM.

       

       Note: The field notified with a symbol (*) is mandatory. You must enter the relevant details in that fields before saving.

2. In the ISO Drawing box, select an ISO drawing from a drop-down list.

3. In the Sum of Qty box, enter the BOM quantity you want to take from the inventory.

4. In the NS1and NS2 boxes, enter the NS1 and NS2 information.

5. In the Ident Code box, enter the code of item you want take from the inventory.

6. In the Item Type box, enter the item type.

7. In the Tag Number box, enter the tag number.

8. In the Item Code box, enter the client item code.

9. In the UOM box, enter the unit of measurement.

10. In the Description box, enter the description.

11. In the Long Description box, enter the long description.

12. In the Category box, enter the item category whether Fab or Erection.

13. In the PT No box, enter the PT number.

14. In the Client Rev No box, enter the client revision number.

15. In the Rev No box, enter the revision number.

16. In the Transmittal Ref No box, enter the transmittal reference number.

17. In the Date Received box, choose the received date.

18. In the Week No box, enter the week number.

19. Click Save.

The BOM including the item quantity is successfully added and listed in the Bill of Material page.

3.1.2 Edit a BOM

1. If you want to edit any existing BOM in the Bill of Material page, do the following,

Click  (Edit icon) in the Edit column for the respective BOM. See Fig 3.1.

The page shows the details of the selected BOM.

2. Click any box where you want to edit the details, and then edit the details in the respective box.

3. Click Save.

3.1.3 Delete a BOM

If you want to delete any existing BOM in the Bill of Material page, you can use  (Delete icon) provided in the Bill of Material page.

3.1.4 Export BOM List

You can export a list of BOMs added in the Bill of Material page in both the pdf and excel formats.

        1. If you want to export the BOM list in the pdf format, click (PDF button).

            a. The BOM list will be downloaded as a pdf file.

       2. If you want to export the BOM list in the excel format, click (Excel button).

            b. The BOM list will be downloaded as an excel file.

3.1.5 Filter a BOM 

If you want to filter any BOM from the list of BOMs in the Bill of Material page, do the following,

1. Click (FILTER button) located on the Bill of Material  See Fig 3.1.

Once you clicked the Filter button, the filter box opens in each column of the Bill of Material page. 

       

2. Enter relevant detail in the respective column’s filter box to filter a BOM you want.

3.1.6 Import Multiple BOMs

If you want to import multiple BOM together, do the following,

1. Click (IMPORT button). See Fig 3.1.

The Excel Import page opens.

             

2. Click (TEMPLATE button).

3. An excel worksheet will be downloaded with a predefined template to enter the details of BOM.

4. Enter the required BOM details in the respective columns of the excel worksheet.

5. Once you have added the BOM details in the excel worksheet, save the excel worksheet on your computer.

6. Click (Browse button) to select the excel worksheet to be uploaded.  

7. Select the excel worksheet you want to upload from your computer.

8. Click (Upload button) to export the BOM details that are included in the excel worksheet.

9. The columns added in the excel worksheet will be listed in the Excel Column

          

 Note:  Make sure that the Excel Column field must have all the columns as in the System Column field.

10. To map the columns in the System Column and Excel Column fields, do one of the following,
11. If you want to map the columns automatically, click (AutoMap button).                                                                                          a. The columns will be mapped automatically and displayed in the Mapped Columns
12. If you want to map each column manually, select the respective columns in both the System Column and Excel Column fields and then click   (Map button).                                                                                                                                  a. The selected columns will be mapped and displayed in the Mapped Columns Field.                                                        b.   
13. To un-map the columns in the Mapped Columns field, select the respective column and then click  (UnMap button).

       Note: In the Total Rows field, the range for uploading the data from the excel worksheet will be updated automatically.

14. Click  (Populate Values button).
15. The data are populated.
16. Click  (Process button).
17. The system processes all the uploaded data and shows if any error with the uploaded data. You can download the error details in the excel worksheet by clicking  (Export to Excel button).  Note:  Different color code explains the different type of errors.
18. Once you have rectified the identified error in the excel worksheet, follow the above procedures to upload the worksheet.
19. Click (Import button) to import the uploaded data.
20. The data will be successfully imported.

3.2 Assign Priority

The Assign Priority tab in the Planning menu helps to assign the priority for KPW, Offcut, and FIM warehouses. Likewise, you can assign priority for Module, Test Pack, System, Line, and ISO. For example, once you have assigned the high priority for any warehouse, the materials from the high priority warehouse will be taken initially for performing piping feasibility.

To assign priority,

1. Click Assign Priority in the Planning

The Assign Priority page opens.

   

                                                   Figure 3.2: Assign Priority page

Note: You can assign the priority by giving the numbers from 1 to 99.

2. If you want to assign priority for warehouses,

       a. Select the Warehouse

The added warehouses will be listed.

    

     b. In the Priority column, enter the priority numbers for the respective warehouse.

     c. Click Save Changes.

3. If you want to assign priority for project modules,

       a. Select the Module

      The added project modules will be listed.

     

     b. In the Priority column, enter the priority numbers for the respective module.

     c. Click Save Changes.

4. If you want to assign priority for test packs,

    a. Select the Test Pack

The added test packs will be listed.

       

  b. In the Priority column, enter the priority numbers for the respective test pack.

  c. Click Save Changes.

      Once you have set the priority for a particular test pack, the piping feasibility will be loaded based on a list of spools included          in the test pack.

5. If you want to assign priority for systems,

     a. Select the System

         The added systems will be listed.

       

    b. In the Priority column, enter the priority numbers for the respective system.

    c. Click Save Changes.

6. If you want to assign priority for lines,

    a. Select the Line

        The added lines will be listed.

    

     a. In the Priority column, enter the priority numbers for the respective line.

     c. Click Save Changes.

7. If you want to assign priority for ISO,

    a. Select the ISO

       The added ISO will be listed.

    

  b. In the Priority column, enter the priority numbers for the respective ISO.

  c. Click Save Changes.

3.2.1 Export Assigned Priority List

You can export the assigned priority list in the Assign Priority page in the pdf and excel formats by using   (PDF button) and (Excel button). To know how to export, see the topic, “Export BOM List”.

2.3 Reserve Material

The Reserve Material tab in the Planning menu helps to reserve the material from the inventory quantity. To reserve the material,

1. Click Reserve Material in the Planning

    The Reserve Material page opens. 

                                                Figure 2.3: Reserve Material page

2.3.1 Reserve a Material

If you want to reserve a material,

1. In the ISO Number box, select an ISO number from a drop-down list. See Fig 5.3.

   The page shows a list of BOM item codes including the BOM quantity and inventory stock quantity for this corresponding ISO         number.

     Note: The quantity you want to reserve should be less than the BOM quantity.

2. In the Reserved Qty column, enter the number of quantity of items you want to reserve.

3. Once you have entered the reserve quantity, select the respective checkbox in the Reserve?

4. Click Save changes.

The entered material quantity will be reserved. While feasibility reserved quantity used against the reserved ISO.

    Note: If you want to unreserve all the reserved material quantity, click  (Unreserve All button).

3.4 Revision Comparison

In BOM, when you subsequently revise the quantity of items added against the ISO number, the revision number will be changed. The revision history will be maintained in the back end.

The Revision Comparison tab in the Planning menu helps you to view the revision history of items added in the BOM.

1. Click Revision Comparison in the Planning

    The Revision Comparison page opens.

      

                                                      Figure 3.4: Revision Comparison page

     Note: The field notified with a symbol (*) is mandatory. You must enter the relevant details.

2. In the Module box, select a module from a drop-down list.

3. In the System box, select a system from a drop-down list.

4. In the ISO / Drawing Number box, select an ISO number from a drop-down list.

5. In the Week No From and Week No To boxes, select the week numbers.

    a. In the Comparison Type box, select one of the following,

    b. If you want to view the revision history for all items, select

    c. If you want to view the revision history for added items, select

    d. If you want to view the revision history for removed items, select

6. If you want to view the difference in comparison, select Difference Only.

7. In the Revision From and Revision To boxes, select the revision numbers.

8. Click Get Difference.

    The revision history opens based on the given criteria. The revision history shows the total quantity and difference quantity after      completing the revision.  

      

3.4.1 Export Revision Comparison Detail

You can export the revision detail generated in the Revision Comparison page in the pdf and excel formats by using  (PDF button) and  (Excel button). To know how to export, see the topic, “Export BOM List”.

3.5 Material Substitution

The Material Substitution tab in the Planning menu helps to do substitute one item for another item. To perform the material substitution,

1. Click Material Substitution in the Planning

The Material Substitution page opens.

    

                                           Figure 3.5: Material Substitution

3.5.1 Add Material Substitution

If you want to do material substitution,

1. Click (ADD button) in the Material Substitution See Fig 3.5.

The page opens a new window to add the details of material substitution.

         

      Note: The field notified with a symbol (*) is mandatory. You must enter the relevant details in that fields before saving.

2. In the Item Code box, select an item code from a drop-down list.

      Note: In the Item Code box, a list of item codes added in the BOM will be listed.

3. In the Substitute Item Code box, select a substitute item code from a drop-down list.

      Note: In the Substitute Item Code box, a list of item codes added in the inventory will be listed.

4. In the Quantity box, select the quantity of items you want to substitute.

5. Click Save.

The entered quantity of items will be substituted successfully. After completing the material substitution, you can do the feasibility search to check the feasibility percentage of the substituted materials.  

3.5.2 Export Material Substitution List

You can export a list of material substitutions added in the Material Substitution page in the pdf and excel formats by using   (PDF button) and  (Excel button). To know how to export, see the topic, “Export BOM List”.

3.5.3 Filter a Material Substitution 

If you want to filter any material substitution from the list of material substitutions in the Material Substitution page, you can use   (FILTER button). To know how to filter, see the topic, “Filter a BOM”.

3.6 Component Requirement

The Component Requirement tab in the Planning menu help to add the components required for the feasibility search. To add the component requirement,

1. Click Component Requirement in the Planning

The Component Requirement page opens with a list of components.

         

                                           Figure 3.6: Component Requirement page

2. Select the module whether Piping

3. Select the checkbox of the component you require.

4. Click Save changes.

3.7 Offcut Inventory

When a material issuance has been created with the Offcut material, we need to add the offcut material details in the Offcut inventory. To add the offcut material details,

1. Click Offcut Inventory in the Planning

The Offcut Inventory page opens.

                                         Figure 3.7: Offcut Inventory page

3.7.1 Add Offcut Material Detail

To add the offcut material detail,

1. Click (ADD button) in the Offcut Inventory See Fig 3.7.

A new window opens to add the details of offcut material.

     

2. In the Material Request box, select a material request from a drop-down list.

The cut length for the selected material request opens.

     

3. In the Cut Length column, change the cut length of the offcut item if you want.

    Note: The cut length should not be exceeded the material issuance quantity.

4. In the Received Date box, choose the date when the offcut material received in the Offcut inventory.

5. Click Save changes.

The offcut material is added.

3.7.2 Adjust Cut Length Quantity

To adjust the cut length quantity,

1. Click (Add icon) in the Adjustment

The Adjustment window opens.

          

2. Click (ADD button) in the Adjustment

         

3. In the Adjustment Qty box, enter the adjustment cut length quantity.

4. In the Remarks box, enter your remarks if any.

5. Click Save.

The adjusted cut length quantity will be updated.

       

3.7.3 Export Offcut Inventory List

You can export a list of offcut materials added in the Offcut Inventory page in the pdf and excel formats by using  (PDF button) and  (Excel button). To know how to export, see 1the topic, “Export BOM List”.

3.7.4 Filter an Offcut Material 

If you want to filter any offcut material from the list of offcut materials in the Offcut Inventory page, you can use (FILTER button). To know how to filter, see the topic, “Filter a BOM”.

3.8 Feasibility

The Feasibility tab in the Planning menu helps to search the feasibility percentage of items available in the warehouses. Based on the feasibility search percentage, the inspectors will move furtherly for material requisition and material issuance.

To navigate into the Feasibility page,

1. Click Feasibility in the Planning

           

                                                               Figure 3.8: Feasibility page

    Note: The feasibility result displayed in different color explains that status of ISO feasibility.

• The feasibility result displayed in Red color shows that the ISO has reserved items.
• The feasibility result displayed in Green color shows that the ISO has 100 percentage feasibility.
• The feasibility result displayed in Blue color shows that the ISO has less than 100 percentage feasibility.

3.8.1 To do Feasibility Search

To search the feasibility percentage, do the following steps in the Feasibility page,

1. In the Module box, select the modules you want.   

  Note: According to the selection of modules, the system list will be updated in the System box.

2. In the System box, select the systems you want.  

  Note: According to the selection of systems, the line list will be updated in the Line box.

3. In the Line Number box, select the line numbers you want.

4. In the Feasibility box, enter the feasibility percentage.

  Tip: If you enter 100, the items which have the feasibility percentage of 100 will be listed. If you enter 10, the items which have the feasibility percentage above 10 will be listed.

5. Select the checkbox of Reserve Material option if you want to filter the reserve material items.

    The page shows the feasibility of the reserved materials.

      

Select the checkbox of Material Substitution option if you want to filter the material substitution items.

6. If you want to see the feasibility percentage for any particular warehouse, select the warehouse listed in the Warehouse

      a. If you want to view the feasibility percentage for the items in the KPW warehouse, select the checkbox of KPW.

      b. If you want to view the feasibility percentage for the items in the Offcut warehouse, select the checkbox of Offcut.

     c. If you want to view the feasibility percentage for the items in the FIM warehouse, select the checkbox of FIM.

7. In the Category field, select the category whether Shop or Field.

   Note: If you want clear the given input data, click (CLEAR button).

8. Click FEASIBILTY SEARCH.

The feasibility result opens based on the given feasibility percentage.

         

9. Click (Expand icon) of the respective module to view the items included in the module or click  (Expand All button) to view the items included in each module .A new window opens and shows a list of items included in the module.

          

• BOM Qty – shows the item’s quantity added in the BOM.
• Required Qty – shows the required quantity of item.
• Stock Qty – shows the overall quantity of stock available in all the inventory.
• Available Qty – shows the available quantity of item. The available quantity will be changed based on the reserve quantity. Once you reserve any quantity, the same will be reduced from the available quantity.
• Reserve/Release Qty – shows the reserve/release quantity of item.

You can reserve the item here while doing feasibility itself by entering the reserve quantity in the respective field.

Make sure that the reserve quantity should not be exceeded the BOM quantity.

To reserve the items,

1. Select the checkbox of item for which you want to reserve the quantity.
2. Enter the reserve quantity in the Reserve/Release Qty
3. Click (RESERVE MATERIAL button).

The added quantity will be reserved and updated in the Reserve Material page.

• MR Qty– shows the quantity of item for which the material requests has added.
• MI Qty– shows the quantity of item for which the material issuance has done.
• The feasibility percentage is calculated based on the available quantity. For example, in the below figure, the given BOM quantity is higher than the available quantity, so the feasibility percentage will be less than 100.

         

10. If you want to give purchase order details, enter in the PODetails

11. Click Save changes.

3.8.2 Clear Feasibility Search Data

If you want to clear the data of feasibility search done by any of the user, you can use this clear feasibility search data functionality.

Users assign with Admin role only have access to view the Clear Feasibility Search Data tab in the Planning menu.

To clear the feasibility search data,

1. Click Clear Feasibility Search Data in the Planning

The Feasibility Search Clear page opens.

         

                                      Figure 3.8.2: Feasibility Search Clear page

The page shows the feasibility search data of all the users.

2. Click  (Clear icon) of the respective user to clear the feasibility search data.

The feasibility search data of the selected user will be cleared.

6.9 Material Request

The Material Request tab in the Planning menu helps to manage the material requests added in the Feasibility page.

6.9.1 Add a Material Request

If you want to create a material request, do the following steps,

1. Navigate to the generated feasibility results in the Feasibility.                                                                                             

       

2. Select the checkbox of the project for which you want to add the material requests.

3. Click (ADD MATERIAL REQUEST button).

The Subcon Details window opens.

   

4. In the Sub Contractor Name box, select a sub-contractor.

5. In the Request Date & Timebox, choose the request date and time.

6. In the Location box, select a location.

7. Click SAVE.

The material request will be added in the Material Request page.

     Note: For each item code included in the project, one material request will be created individually.

For example, The BOM quantity is 18 and you set the high priority for KPW and the least priority for Offcut. A material request will be created with the KPW inventory if the KPW has the same quantity of 18. If the KPW is available with quantity of 10, then two material requests will be created separately for quantity of 10 in KPW and quantity of 8 in Offcut.

8. Click Material Request in the Planning

The Material Request page opens and shows the list of created material requests.

                                       Figure 3.9.1: Material Request page

   Note: The material request displayed in different color explains the status of the request.

• The material request displayed in Black color indicates a new material request. The Status column shows Waiting for MR confirmation.
• If the Status column shows Fully Issued, which means that the item’s quantity is issued fully.
• If the Status column shows Partially Issued, which means that the item’s quantity is issued partially.
• The material request displayed in Green color indicates the completed material request.

9. If you want to view the material details, click (Expand icon) of the respective request.

The Material Details window opens and shows the material details including their issuance status.

         

3.9.2 Approve a Material Request

Once you have added the material request, the Request Status column in the Material Request page is appeared with  (Submit and Reject icons).

1. If you want to approve the material request, click (Approve icon) in the Request Status Otherwise click (Reject icon) to reject the request.

The approved material request will be moved for Material issuance. The Status column shows MR confirm.

3.9.3 Cancel a Material Issuance

If you want to cancel the material issuance,

     Note: If the material’s quantity is fully issued, the (Cancel icon) will not be displayed in the Issuance Status column for the  respective report number. Partially

1. Click (Cancel icon) provided in the Issuance Status

Once you have cancelled the issuance, the Status column shows Cancel.

3.9.4 View a Material Request Report

If you want to view a material request report, click  (Report icon) provided in the Report column of the Material Request page.

3.9.5 Export Material Request List

You can export a list of material requests added in the Material Request page in the pdf and excel formats by using (PDF button) and (Excel button). To know how to export, see the topic, “Export BOM List”.

3.9.6 Export Material Request List

If you want to filter any material request from the list of material requests in the Material Request page, you can use (FILTER button). To know how to filter, see the topic, “Filter a BOM”.

3.10  Material Issuance

When a material request has been created, we need to issue materials from the inventory for the created request.

The Material Issuance tab in the Planning menu helps to issue the materials from the inventory based on the added material request.

1. Click Material Issuance in the Planning

The Material Issuance page opens.

          

                                                                 Figure 3.10: Material Issuance

3.10.1 Add a Material Issuance Report

If you want to add a material issuance report,

1. Click (ADD button) in the Material Issuance See Fig 3.10.

The Add MR details window opens.

                 

       Note: The field notified with a symbol (*) is mandatory. You must enter the relevant details in that fields before saving.

2. In the Material Request Number box, select a material request number from a drop-down list.

3. In the Heat Number box, enter the heat number.

4. In the Issued Date box, choose the issued date.

5. Click (Add button).

The material issuance request will be added.

          

The Add MR Details window shows the total and balance quantity of the item.

6. In the Issued Qty column, enter the issued quantity detail.

      Note: The issued quantity can be higher than the total quantity.

The material issuance report is added.

3.10.2 Approve a Material Issuance

Once you have added the material issuance, the Issue Status column in the Material Issuance page is appeared with  (Submit and Reject icons).

1.  If you want to approve the material issuance, click (Approve icon) in the Issue Status Otherwise click  (Reject icon) to reject the request.

After Material Issuance, Heat number can be used in Fit up.

3.10.3 View a Material Issuance Report

If you want to view a material issuance report, click (Report icon) provided in the Report column of the Material Issuance page.

3.10.4 Export Material Issuance List

You can export a list of material issuances added in the Material Issuance page in the pdf and excel formats by using

 (PDF button) and (Excel button). To know how to export, see the topic, “Export BOM List”.

3.10.5 Filter a Material Issuance 

If you want to filter any material issuance from the list of material issuances in the Material Issuance page, you can use

 (FILTER button). To know how to filter, see the topic, “Filter a BOM”.

3.11  BOM Status by ISO

The BOM Status by ISO tab in the Planning menu helps to view the BOM status added against the ISO number. To view the BOM status,

1. Click BOM Status by ISO in the Planning

The BOM Status by ISO page opens and shows a list of modules with their ISO numbers.

         

                                                        Figure 3.11: BOM Status by ISO page

2. Click (Expand icon) in the Details

The page shows the items included in the respective module including the BOM quantity, material request quantity, material issued quantity, and offcut material quantity.      

   

3.11.1 Export BOM Status

You can export the BOM generated in the BOM Status by ISO page in an excel format by using  (Excel button). To know how to export, see the topic, “Export BOM List”.

3.12 BOM Details

The BOM Details tab in the Planning menu helps to view the added BOM details. To view the BOM details,

1. Click BOM Details in the Planning

The BOM Details page opens.

     

                                                 Figure 3.12: BOM Details page

2. If you want to view any particular BOM details, you can use the filter options (Explained below) given in the page,  

• If you want to view the BOM details of any sub-contractor, select a sub-contractor in the Sub Contractor Name  
• If you want to view the BOM details of any module, select a module in the Module
• If you want to view the BOM details against an ISO number, select an ISO number in the ISO Number
• If you want to view the BOM details for any item code, select an item code in the Item Code
• If you want to view the BOM details against a MR number, select a MR number in the MR Number
• The Option 1, Option 2, Option 3, and Option 4boxes are provided to filter the BOM details by giving the BOM description.

3. Click Search.

The BOM will be displayed based on the given data in the filter boxes.

3.12.1 Export BOM Details

You can export the BOM details generated in the BOM Details page in an excel format by using (Excel button). To know how to export, see the topic, “Export BOM List”.