Spreadsheet: 690122d1596882883-find-the-hourly-rate-for-each-role-estimations
Sheet: Sheet2

CNET IMPORT - Rebuild PHP - Retain mapping from Comwrap extension - Divide functionality into smaller pieces of module - Determine if Shared Catalog needs to be required | Document user stories, use cases | Requirements | BSA | 32
 | Create specification (includes review requirements) | Specification | [NAME] | 8
 | Create test cases (includes reviewing requirements) | Test cases | QA | 16
 | Develop | Customized feature | BE | 100
 | Conduct PHP code reviews (~10% of development time) |  | [NAME] | 12
 | Conduct QA (~30% of total development time) |  | QA | 30
 | Fix QA defects (~20% of development time) |  | BE | 20
SIX PAYMENT GATEWAY - Renalyze requirement - Install extension - Configure Six Payment Account - Enable, configure, test payment methods for purchase, return/credit memo flows - Integrate with SAP Business One flows  https://www.six-payment-services.com/en/home.html#country=ch | Document user stories, use cases | Requirements | BSA | 16 |  |  |  |  |  | 95
 | Create specification (includes review requirements) | Specification | [NAME] | 0 |  |  |  |  |  | 95
 | Create test cases (includes reviewing requirements) | Test cases | QA | 4 |  |  |  |  |  | 50
 | Develop | Customized feature | BE | 16 |  |  |  |  |  | 75
 | Conduct PHP code reviews (~10% of development time) |  | [NAME] | 4 |  |  |  |  |  | 95
 | Conduct QA (~30% of total development time) |  | QA | 6 |  |  |  |  |  | 50
 | Fix QA defects (~20% of development time) |  | BE | 4 |  |  |  |  |  | 75
RMA & RETURNS - Gather requirements - Analyze Returns and RMA flows - Integrate with SAP Business One flows - Understand full effects on Punchout Catalog and operation of 3rd party requisition systems. E.g. Do returns need to be appoved by manager as well??? | Document user stories, use cases | Requirements | BSA | 24 |  |  |  |  |  | 95
 | Create specification (includes review requirements) | Specification | [NAME] |  |  |  |  |  |  | 95
 | Create test cases (includes reviewing requirements) | Test cases | QA |  |  |  |  |  |  | 50
 | Develop | Customized feature | BE |  |  |  |  |  |  | 75
 | Conduct PHP code reviews (~10% of development time) |  | [NAME] |  |  |  |  |  |  | 95
 | Conduct QA (~30% of total development time) |  | QA |  |  |  |  |  |  | 50
 | Fix QA defects (~20% of development time) |  | BE |  |  |  |  |  |  | 75
B2B BASE TEMPLATE REDESIGN - Basic design easily revbrandable - Likely built on Luma - Minimal differences between new stores.  - Easy and fast to rebrand - Theme needs to be White Label | Document user stories, use cases | Requirements | BSA | 32 |  |  |  |  |  | 95
 | Create Wireframes | Specification | BSA | 16 |  |  |  |  |  | 95
 | Create test cases (includes reviewing requirements) | Test cases | QA |  |  |  |  |  |  | 50
 | Design |  | DESIGN |  |  |  |  |  |  | 75
 | Develop | Customized feature | BE |  |  |  |  |  |  | 95
 | Develop | Customized feature | FE |  |  |  |  |  |  | 50
 | Conduct PHP code reviews (~10% of development time) |  | [NAME] |  |  |  |  |  |  | 75
 | Conduct QA (~30% of total development time) |  | QA
 | Fix QA defects (~20% of development time) |  | BE
B2B PHILIP MORRIS [NAME] are only placeholders based on average time need to implement a reskin with no new BE functionality requirements | Document user stories, use cases | Requirements | BSA | 40 |  |  |  |  |  | 95
 | Create Wireframes | Specification | BSA | 16 |  |  |  |  |  | 95
 | Create test cases (includes reviewing requirements) | Test cases | QA |  |  |  |  |  |  | 50
 | Design |  | DESIGN |  |  |  |  |  |  | 75
 | Develop | Customized feature | BE |  |  |  |  |  |  | 95
 | Develop | Customized feature | FE |  |  |  |  |  |  | 50
 | Conduct PHP code reviews (~10% of development time) |  | [NAME] |  |  |  |  |  |  | 75
 | Conduct QA (~30% of total development time) |  | QA
 | Fix QA defects (~20% of development time) |  | BE
TEST RUN OF NEW STORE CREATION - Need to deternine rollout timeframes and costs for future stores - Need to understand level of SAP integration work and rieks involved, [NAME] | Create fictional new store to test integrations and deployment |  | DEVOPS | 40 |  |  |  |  |  | 80
 | Conduct QA (~30% of total development time) |  | QA | 12 |  |  |  |  |  | 50
 | Fix QA defects (~20% of development time) |  | DEVOPS | 8 |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  | 75
CONVERT CERN TO WHITE LABEL . Explain WL concept to client - Understand impact on current [NAME] configuration
 |  |  |  | 2 | 3 | 4 | 5 | 6
 |  |  |  |  | Meetings | DEV Hours | Rate | Revenue
TOTALS |  |  | BSA |  |  |  | 95
 |  |  | [NAME] |  |  |  | 95
 |  |  | QA |  |  |  | 50
 |  |  | DESIGN |  |  |  | 50
 |  |  | BE |  |  |  | 75
 |  |  | HTML |  |  |  | 75
 |  |  | DEVOPS |  |  |  | 85