Detailed Estimation of Project
After getting administrative approval on a pre-estimation of project cost a detailed estimate is prepared. It helps to capture the measurement of works in details estimate the cost accurately in terms of predicting the cost, material, labour, and machinery required to complete the work. It is also used for tendering and contracting the work.
Estimate preparation for a work, by the Estimate Creator and then its verification and approval by other users (actors) in the workflow. Hence no change in existing approach.
There is no change from existing actors.
#
Role (Actors)
Actions
User Persona
1
ESTIMATE_CREATOR
Create
Submit
Search
View
Edit/ Re-submit
Junior Engineer/ Assistant Engineer/ MUKTA Implementation Expert
2
ESTIMATE_VERIFIER
Search
View
Verify and Forward
Send Back
Executive Engineer
3
TECHNICAL_SANCTIONER
Search
View
Technical Sanction
Send Back
Send Back To Originator
Reject
Municipal Engineer
4
ESTIMATE_ APPROVER
Search
View
Approve
Send Back
Send Back To Originator
Reject
Executive Officer/ Municipal Commissioner
5
ESTIMATE_VIEWER
Search
View
MUKTA Program Coordinator
There is minor change in the workflow.
The option to save the estimate as draft to be provided at first before submitting it to verifier and the same is reflected in the below table.
#
Action
Role
From State
To State
Status
1
Save as Draft
Estimate Creator
Saved as draft
Drafted
2
Submit
Estimate Creator
Saved as draft
Pending for verification
Submitted
3
Verify and Forward
Estimate Verifier
Pending for verification
Pending for technical sanction
Verified
4
Technical Sanction
Technical Sanctioner
Pending for technical sanction
Pending for approval
Technically Sanctioned
5
Send Back
Estimate Verifier
Pending for verification
Pending for correction
Sent Back
6
Send Back
Technical Sanctioner
Pending for technical sanction
Pending for verification
Sent Back
7
Send Back
Estimate Approver
Pending for approval
Pending for technical sanction
Sent Back
8
Send Back To Originator
<roles having access>
<Current Status>
Pending for correction
Sent Back
9
Edit/ Re-submit
Estimate Creator
Pending for correction
Pending for verification
Re-submitted
10
Approve
Estimate Approver
Pending for approval
Approved
Approved
11
Reject
<any roles having access>
<Current Status>
Rejected
Rejected
No change. In the UI, the workflow will start displaying from Submitted state.
Roles are created as given provided.
Actions are configured based on role - action mapping.
Workflow states are defined as provided and the state transition done accordingly by updating the status appropriately.
View Detailed Estimate
Search Estimate → View Estimate.
No change.
There is no change in existing search estimate.
Changes are for the attributes added newly.
Estimate Number
Estimate Type
Project ID
Project Sanction Date
Project Name
Project Description
Project Details [*The project details is shown as view project detail in a separate TAB*]
Estimation Details
SORs - Below information is displayed in the grid.
Type
Code
Description
UOM
Rate
Quantity
Amount
Measurements
Type
Description
Numbers
Length
Breath
Height/ Depth
Quantity
Total
Not applicable.
Not applicable.
For In Workflow Estimates, actions in Action Menu, workflow actions based on the role of logged-in user.
Save as Draft
Verify and Forward,
Technical Sanction
Approve
Send Back
Send Back To Originator
Edit Estimate
Reject
Not applicable.
Same as create estimate in real only mode.
Estimate details is displayed as described in the story.
Actions are enabled as per the estimate workflow state and role logged-in user has.
There is no change in the role-action and edit process.
Edit screen will get changed based on changes to have detailed estimate.
Not applicable.
On Save, Changes in the detail estimate are saved and no workflow changes done, fresh analysis is generated.
On submit, based on logged-in user role, workflow pop-up window is displayed.
Role
Workflow Window
Estimate Creator
Submit pop-up window, estimate gets forwarded to verifier with changes saved and fresh analysis generated.
Estimate Verifier
Verify and Forward pop-up window, estimate gets forwarded to technical sanctioner with changes saved and fresh analysis generated.
Technical Sanctioner
Technical Sanction pop-up window, estimate gets forwarded to approver with changes saved and fresh analysis generated.
Approver
Approval pop-up window, estimate gets approved with changes saved and fresh analysis generated.
Same as created detailed estimate screen with additional estimate number displayed on top.
Role based access based on configuration.
The estimates which are in workflow can only be edited.
Estimate is opened in editable mode.
The details given in table can be edited by user.
Create Detailed Estimate
Home > Estimates > Estimate Inbox > Create Estimate
ULB: Estimate Creator (Same as existing)
A detailed estimate creation screen to be provided.
The attributes defining detailed estimate are given in below table.
#
Field Name
Data Type
Is Mandatory?
Description
1
Estimate Type
Display
Yes
Estimate type, Original.
2
Project ID
Display
Yes
Project ID
3
Project Sanction Date
Display
Yes
Project sanction date
4
Project Name
Display
Yes
Project name
5
Project Description
Display
Yes
Project description
Search SOR
It provides the option to search a SOR and add to estimate.
SORs
1
Code
Display
Yes
SOR code, unique identifier for each SOR.
2
SOR Description
Display
Yes
SOR description from the SOR master for the selected SOR.
3
Unit
Display
Yes
Unit of measurement
4
Rate
Display
Yes
The rate defined and effective currently.
5
Quantity
Display
Yes
Calculated value out of measurements.
6
Amount
Display
Yes
Calculated value and equal to Qty*Amount.
Measurements
A table to capture the measurement details and calculate the quantity using it.
1.1
Sr. No.
Display
Auto
Measurement serial number.
1.2
Type
Drop-down
Yes
Plus/ Minus measurements.
1.3
Name
Alphanumeric
(32 Chars)
Yes
The name of the measurement.
1.4
Number (Nos)
Numeric
(6,4)
Yes
No. of items.
1.5
Length (L)
Numeric
(6,4)
Yes
Length measured. Allowed up-to 4 places of decimal.
1.6
Breadth (B)
Numeric
(6,4)
Yes
Width measured. Allowed up-to 4 places of decimal.
1.7
Height/ Depth
Numeric
(6,4)
Yes
Depth measured. Allowed up-to 4 places of decimal.
1.8
Quantity
Display
Yes
Qty = N* L*B*D; rounded up-to 4 places of decimal.
1.9
Total
Display
Yes
Grid total for the quantities of measurements. rounded up-to 4 places of decimal.
Non SORs
2
SOR Description
Alphanumeric
(2048 Chars)
Yes
SOR description from the SOR master for the selected SOR.
3
Unit
Drop-down
Yes
Unit of measurement
4
Rate
Numeric
(6,2)
Yes
The rate defined and effective currently.
5
Quantity
Display
Yes
Calculated value out of measurements.
6
Amount
Display
Yes
Calculated value and equal to Qty*Amount.
Measurements
The table is same as described under SOR.
Other Charges
It is going to be same as provided in the existing estimate screen as overhead.
7
View Analysis Statements
Link
Yes
It will take the user to analysis page. It gets enabled once the analysis is generated.
Actions
1
Save as Draft
Button
Yes
Save the estimate as a draft.
2
Generate Analysis
Button
Yes
Generates the analysis and populates the figures.
3
Submit
Button
Yes
Submit the estimate for verification.
Note: Attachment section to be changed to remove detailed estimate as attachment.
Save as Draft - It is to save the details captured for detailed estimate and keeping it with creator.
Generate Analysis - Generate the analysis statement out of saved detailed estimate details.
Submit - It is the same as per existing estimate, allow the user to forward the estimate for verification.
View Analysis Statements - It will take the user to view analysis statement HTML page.
Estimate is created with the details provided.
If it is first time, estimate no. is generated as per the format provided.
Success toast message is displayed and page is loaded again in editable mode with the details saved.
Estimate gets assigned to the creator and made available in his/her inbox with the WF state Drafted.
On open from inbox, its get opened in editable mode same as edit estimate.
This action is enabled for saved estimate only.
The estimate details are saved.
Analysis statements are revised.
Estimate is forwarded to verifier.
Success page is displayed with success message.
First time, this action is enabled for saved estimate only.
The analysis is generated and Success toast message is displayed.
View Analysis Statements link is enabled.
Analysis statements are generated successfully.
Analysis statements generation failed.
Only active SORs and active and effective rates are displayed on search SOR.
All the intermediate figures are rounded up-to 2 decimal places.
Prerequisite
SOR Rate Master
Not applicable
The given additional features are incorporated.
The workflow is changed to have the option to save the details as draft.
The drafted estimate is assigned to the creator of estimate and can be searched using search estimate.
Estimate is made available to the inbox of estimate creator as well.