PowerApps Development for BOM Estimations and Management
Budget: $30 – $250 AUD
Project: Development of a PowerApps application for the management of estimations and Bill of Materials
Total Budget: TBD
Delivery Time: 5 days
Unfortunately I'm very limited on budget for this project but am hoping as i have completed the detail in excel this could be a relatively quick job for someone skilled or perhaps a growth opportunity for a junior to mid experienced person. I had also built this fully to be used in Excel but have been reading that perhaps PowerApps is a better option!
Perhaps even getting the structure in place and then allowing me to finish it off could reduce costs?
Project Description:
This PowerApp will be driving the creation of an Estimation process for the Project Management of various Services and Products. As I require the ability for a user to edit records I believe this will need to be built with Sharepoint in the backend.
This should be built for laptop use, not mobile or tablet.
The high level overview of the application is -
PAGE LAYOUT
- Left Hand Navigation Bar consisting of shortcuts to:
i) Sites
ii) Project BOM
iii) Services BOM
iv) Product BOM
v) Master BOM
vi) Resource Catalogue
vii) Project Catalogue
viii) Services Catalogue
ix) Product Catalogue
ENGAGEMENT DETAILS
Ability to capture:
- Project Name
- Quotation Title
- Date Issued
- Engagement Type
- Account Executive
- Project Manager
CATALOGUE MASTERS
- Resource Catalogue
- Project Catalogue
- Services Catalogue
- Product Catalogue
NB:
Each catalogue requires the ability to Add / Edit / Remove / Filter and Search
Some fields will be rules driven by lookup conditions held in the Setup document
Requires the ability to highlight fields that are missing as part of a catalogue item entry
SETUP
- This drives as a reference sheet to all default lookup values, lists or lookup data
- Drives multi-dependant lookups filters
- Requires the ability to Add / Edit / remove / Filter and Search
SITE DATA
- Requires the ability to Add / Edit / Remove / Filter and Search
BILL OF MATERIALS
- Project BOM
- Services BOM
- Product BOM
NB:
- Requires the ability to Add / Edit / Remove / Filter and Search
- Requires ability to lookup against the Setup conditions
- Requires the ability to lookup against the relevant BOM Catalogue
- Fields will be a mixture of Lookup conditions and manual data entry, these will be defined by colour coding of the columns
- Empty fields should be highlighted to show they require entry
MASTER BOM
- Consolidation of all individual BOMs to a single MASTER BOM view
- Status field for approvals
- Ability to Sort / Filter by key fields (default sort based on 2 specific fields)
- Ability to see Total Costs at a BOM Level
- Ability to apply a % discount at a BOM Level
- Ability to apply a Project Contingency % to the ENTIRE Project
- Ability to see Pre Discount Price / Post Discount Price / Discount Value at BOM level
- Ability to apply an Item Level Contingency %
- Ability to see Item Contingency Value at Item Level
- Ability to see Project Contingency at Item level
- Ability to see Final Cost projection at Item level (Item Value + Item Contingency + Project Contingency)
- Validation conditions to ensure all individual BOM items have populated MASTER BOM
- Ability to extract in excel format (specific fields will be required only TBD)
REPORTING
- I would love the ability of creating various dashboards etc based on the final MASTER BOM but this could likely come at a later date
EXPORTS / INTEGRATIONS
- Ability to extract in excel format (specific fields will be required only TBD)
NB: I already have all of the above in an excel document available broken out by the specific entry points as shown above.
Potential opportunity if this works for additional integration options in an extended phase.
Total Budget: TBD
Delivery Time: 5 days
Unfortunately I'm very limited on budget for this project but am hoping as i have completed the detail in excel this could be a relatively quick job for someone skilled or perhaps a growth opportunity for a junior to mid experienced person. I had also built this fully to be used in Excel but have been reading that perhaps PowerApps is a better option!
Perhaps even getting the structure in place and then allowing me to finish it off could reduce costs?
Project Description:
This PowerApp will be driving the creation of an Estimation process for the Project Management of various Services and Products. As I require the ability for a user to edit records I believe this will need to be built with Sharepoint in the backend.
This should be built for laptop use, not mobile or tablet.
The high level overview of the application is -
PAGE LAYOUT
- Left Hand Navigation Bar consisting of shortcuts to:
i) Sites
ii) Project BOM
iii) Services BOM
iv) Product BOM
v) Master BOM
vi) Resource Catalogue
vii) Project Catalogue
viii) Services Catalogue
ix) Product Catalogue
ENGAGEMENT DETAILS
Ability to capture:
- Project Name
- Quotation Title
- Date Issued
- Engagement Type
- Account Executive
- Project Manager
CATALOGUE MASTERS
- Resource Catalogue
- Project Catalogue
- Services Catalogue
- Product Catalogue
NB:
Each catalogue requires the ability to Add / Edit / Remove / Filter and Search
Some fields will be rules driven by lookup conditions held in the Setup document
Requires the ability to highlight fields that are missing as part of a catalogue item entry
SETUP
- This drives as a reference sheet to all default lookup values, lists or lookup data
- Drives multi-dependant lookups filters
- Requires the ability to Add / Edit / remove / Filter and Search
SITE DATA
- Requires the ability to Add / Edit / Remove / Filter and Search
BILL OF MATERIALS
- Project BOM
- Services BOM
- Product BOM
NB:
- Requires the ability to Add / Edit / Remove / Filter and Search
- Requires ability to lookup against the Setup conditions
- Requires the ability to lookup against the relevant BOM Catalogue
- Fields will be a mixture of Lookup conditions and manual data entry, these will be defined by colour coding of the columns
- Empty fields should be highlighted to show they require entry
MASTER BOM
- Consolidation of all individual BOMs to a single MASTER BOM view
- Status field for approvals
- Ability to Sort / Filter by key fields (default sort based on 2 specific fields)
- Ability to see Total Costs at a BOM Level
- Ability to apply a % discount at a BOM Level
- Ability to apply a Project Contingency % to the ENTIRE Project
- Ability to see Pre Discount Price / Post Discount Price / Discount Value at BOM level
- Ability to apply an Item Level Contingency %
- Ability to see Item Contingency Value at Item Level
- Ability to see Project Contingency at Item level
- Ability to see Final Cost projection at Item level (Item Value + Item Contingency + Project Contingency)
- Validation conditions to ensure all individual BOM items have populated MASTER BOM
- Ability to extract in excel format (specific fields will be required only TBD)
REPORTING
- I would love the ability of creating various dashboards etc based on the final MASTER BOM but this could likely come at a later date
EXPORTS / INTEGRATIONS
- Ability to extract in excel format (specific fields will be required only TBD)
NB: I already have all of the above in an excel document available broken out by the specific entry points as shown above.
Potential opportunity if this works for additional integration options in an extended phase.