HUST Project Cost Allocations Initial Investment & Reocurring Costs Excel Worksheet Background: XYZ Company is an international manufacture of farm equipme
HUST Project Cost Allocations Initial Investment & Reocurring Costs Excel Worksheet Background: XYZ Company is an international manufacture of farm equipment.They have hired your team to develop some core components of a project plan for providing an enterprise-wide CRM Relationship Management (CRM) solution.Some other details for consideration:The company executives and CIO have determined the best approach for this solution is to use their internal IT staff to deliver a custom software development CRMIT staff will also be supplemented by external professional services and subject matter experts (where required)Phase 1 of the initiative will be to roll the solution within the United States and Phase 2 will then extend the deployment to their three international facilities (China, Germany, and South America)Hardware and software components will need to be procured for all company locations (e.g., desktop, server, firewall, network, etc.) to support development, training, and production environments.There will be integration points with the company’s existing MRP, financial, sales & marketing, and distribution systems.Internal staff matrix and hourly rates will be providedThe team will use a traditional Water-Fall software development methodology, and structure the WBS tasks to align with this methodology Harrisburg University
XYZ Company CRM Project WBS & Summary
ISEM 500
Group Exercise: Company XYZ Software Development Project (Begin by forming a group of 4 to 6 Students)
1.
Background: XYZ Company is an international manufacture of farm equipment. They have hired your team to develop some core components of a project plan
for providing an enterprise-wide CRM Relationship Management (CRM) solution. Some other details for consideration:
a. The company executives and CIO have determined the best approach for this solution is to use their internal IT staff to deliver a custom software
development CRM
b. IT staff will also be supplemented by external professional services and subject matter experts (where required)
c. Phase 1 of the initiative will be to roll the solution within the United States and Phase 2 will then extend the deployment to their three international
facilities (China, Germany, and South America)
d. Hardware and software components will need to be procured for all company locations (e.g., desktop, server, firewall, network, etc.) to support
development, training, and production environments.
e. There will be integration points with the company’s existing MRP, financial, sales & marketing, and distribution systems.
f. Internal staff matrix and hourly rates will be provided
g. The team will use a traditional Water-Fall software development methodology, and structure the WBS tasks to align with this methodology
2.
Getting Started:
a. Download the Group Exercise 03 – Project WBS-Cost Summary workbook; enter group participant name on student tab.
b. Develop a work breakdown structure, high level project schedule outline, phase roll-up, and project summary with total cost estimates and duration for
Phase 1.
c. Follow the guideline/instruction below!
d. Answer all the question outlined on the Analysis tab after the other workbook tabs have been completed.
3.
Guideline/Instructions
a. Start with the WBS worksheet first! This is the foundation and required for successfully completing all the other worksheets.
b. For each WBS phase you will:
i. Define the level 3 tasks and associated dependencies in each predefined phase. Do not add or delete any phase task rows in the WBS
worksheet. In addition, leave unused phase tasks lines blank and corresponding entries 0.0; if not used/required.
ii. Allocate hours to predefined staff resources for each phase task and determine/enter the number of FTEs required to support the project
(Cells: D68-AN68)
iii. Identify the software, hardware, and services that are required to complete the tasks in the phase; you will reference this later when filling
out the corresponding Systems Costs and Lifecycle Management (LCM) worksheets. Note: Do not fiddle with any of the precalculated fields
in the WBS worksheet (i.e., Phase Staff Subtotals, Totals (Column AO), Task Allocation (Column AP), Project Staff Total Hours (Cells: D67AO67), or FTE totals (Cell AO68).
1
Harrisburg University
XYZ Company CRM Project WBS & Summary
ISEM 500
iv. Staff & Labor worksheet will self-populate based on the entries made in the WBS worksheet. This worksheet contains key reference tables
that are used to provide information about staffing job classifications, consultants, labor/bill rates, total number of FTEs, and total labor
costs.
v. Systems Costs worksheet will need to be completed since you are building the CRM solution in-house (i.e., enterprise data center facility);
you will need to determine the types, numbers and costs of software and hardware required to design, build, test/validate, implement and
continue to maintain the finished in-house custom CRM solution. In addition, identify the project phase in which this cost will occur using the
drop down selection ( F-Feasibility; R-Requirements; D-Design; B-Build; T-Test/Validate; & I-Implementation. Then enter the hours required
to procure and deliver these items to your facility; which will be factored into the total project phase duration estimate.
vi. The Phases worksheet will self-populate upon completion of the WBS, Staff Labor, and Systems Costs worksheets. You will need to enter in
the Planned Start Date, Target Completion Date, and deliverables for each phase; all other fields are calculated field and will self-populate
based on other worksheet entries. Note: Be sure to align total hours in each phase from WBS and additional procurements and delivery
hours. Do not fiddle with the reference tables contained in Cells: N26-AB54!
vii. Complete the Life Cycle Management (LCM) worksheet. You will need to estimate what the annual reoccurring costs are for each of the
predefined line items in the table for year 1, Year 2,Year 3, Year 4, and Year 5. Note: Initial Investment Cost filed is automatically populated
(Cell B2). Also, consider doing a technology platform refresh in Year 4 or year 5 timeframe.
viii. Financial worksheet, you will only make entries in the following cells:
• Cell B3-Initial Investment Costs (must be negative number); Hint: Use total Phase cost data to obtain the initial investment cost
number.
• Cells C3, D3, E3, F3 & G3; you will need to determine the yearly net income (i.e., tangible benefits, cost savings and/or after tax
revenues generated less (minus) the annual reoccurring costs from LCM worksheet).
• Cell K3 -Weighted Average Cost of Capitol (WACC): leave at 10% and Cell L3 -Risk Free Rate (RFR): Leave at 2%
• All the other cells in this financial table will self-populate based on the above entries; these figures will link to the workbook
Summary worksheet.
• Reference the notes on this worksheet for information and better understanding
IX. Reference worksheet, do nothing!
X. Summary worksheet summary table and pie chart will self-populate based on the completion of the other tabs in the workbook.
XI. Analysis worksheet; review the project workbook tabs, evaluate results, and answers the questions outlined in this worksheet.
2
No.
1
2
3
4
5
6
Student Name
Enter all students participating in your group for this exercise (your initials should be on this worksheet and in-class attendanc
Student ID Number
et and in-class attendance sheet to get credit).
No.
Questions
1
Based on the NPV, IRR, MIRR is this project viable? Explain
why it is or would not be viable. Secondly, how can the
finacial assessments be useful in managing the IT project
portfolio?
2
Which phase of the project has the highest cost? Which phase of
the project has the longest duration? Explain why a particular
phase of the project has the highest costs and/or duration.
3
Which three staff positions had the highest hours contributed to
this project? Who (of all the staffing resouces) do you believe are
most critical to ensuring the success of this project?
4
Which element of the project had the highest percentage of the
total cost of the project (i.e., Labor, Software, Hardware)? What
recommendations you could make to the CIO on how to lower the
project costs for labor, software, and hardware?
5
Why is it important to to complete a WBS and summary roll-up by
phase of the project?
6
Did you find this group exercise useful and why or why not?
7
Is the WBS-Cost Summary Workbook a valuable tool and why?
Answer
Project Summary
Project Cost Allocations
$0.00
$0.00
$0.00
Labor
Hardware
Software
Total Project Costs:
$0.00
Initial Investment & Reocurng Costs
Feasibility & Analysis
Solution Requirements
Solution Design
Solution Build
Test & Validation
Solution Implemetation
Initial Investment Costs
Average Annual Reocuring Costs
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Financial/Economic Sumary
Net Prsent Value (NPV)
Internal Rate of Return (IRR)
Modified Internal Rate of Return (MIRR)
$0.00
No Data
No Data
Project Task/Duration Summary
Number of Tasks Indentified
FTEs required to complete Tasks
Total Hours Estimated
Total Days Estimated
Total Project Duration in Months
Total Project Duration in Years
57
13
0.0
0.0
0.0
0.0
Project Phase Hour Allocations
Phase
Feasibility
Requirements
Design
Build
Test
Implementation
Allocations
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
Implementation
Test
Build
Design
Requirements
Feasibility
Feasibility
0.00%
CRM Project Cost Allcations
0%
Labor
Hardware
Software
Project Phase Allocations
10.00%
20.00%
30.00%
40.00%
50.00%
60.00%
70.00%
80.00%
90.00%
100.00%
Level
1.0
1.1
1.2
1.3
1.4
1.5
1.6
1.7
Feasibility Phase Staff Hours Sub Totals:
2.0
2.1
2.2
2.3
2.4
2.5
2.6
2.7
2.8
Requirements Phase Staff Hours Sub Totals:
3.0
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
3.10
Design Phase Staff Hours Sub Totals:
4.0
4.1
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.9
4.10
4.11
Build Phase Staff Hours Sub Totals:
5.0
5.1
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
5.10
Test Phase Staff Hours Sub Totals:
6.0
6.1
6.2
6.3
6.4
6.5
6.6
6.7
6.8
6.9
6.10
6.11
Implementation Phase Staff Hours Sub Totals:
Project Staff Total Hours
Enter Required Full Time Equivilents (FTEs)
Notes:
1
2
3
Tasks
Fesibility & Analysis Phase
Approved Business Case & Project Charter
Project Initiation & Planning (Iterative Refinement Approach)
Evaluate Solution Approach & Methodologies Alternatives
Recommend Solution Approach & Methodologies
Evaluate & Recommend Technologies
Evaluate capabilities, resource, and capacities
Business Solution Approach Summary Document*
Feasibility Phase Staff Hours Sub Totals:
Requirements Phase
Define Functional Requirments
Define non-functional Requirements
Verify & Validate Requirements
Categorize and prioritize Requirements
Create Requirements Traceability Matrix*
Create Requirements Document*
Business Solution Architecture Review Committee reveview and approvals – Change Mgt & Governance
Solution Archtecture Reevalautions, Redesign, & Rework
Requirements Phase Staff Hours Sub Totals:
Design Phase
Architecture Evaluation (Current & Future State based on requirements translation & clarification)
Solution Conceptual Design Design Document & EA Transition Roadmaps (BRM, ARM,DRM, TRM, SRM, C&P)*
Soulution Architecture Review (i.e., App, Data, Technology, Infrastructure, Security, Compute, Storage, etc.)
Detailed Design Document & Executable EA Transition Roadmaps (Blueprints)*
Enterprise Architecture Review Committee Review & Approval
Update Requrements Traceabiity Matrix*
EA Transition Roadmaps alignment with Project Plan, Procurements, Resources, Services Contracts, & Funding
Solution Archtecture Reevalautions, Redesign, & Rework
Enterprise Architecture Review Committee Reviews & Approvals – Change Mgt & Goverenance
Solution Architect & DEV/OPS team alignment, resource acquisitions & procurements
Design Phase Staff Hours Sub Totals:
Build Phase
Establish, Install, & Configure Development, Test, Training, & Production Environments
Application Architecture frameworks based on approved DDD & EA-ARM, DRM, SRM, TRM Roadmaps
GUI -Wireframes, Mockups & Customer Reviews
Software Units & Modules (Functions & Features) Coding, Compiling, & Desktop/Pier Reviews
Module & Systems lntegrations Check systems and module dependancies/integrations & Initial Testing
Database/Warehouse Build (i.e., Tables, Queries, Stored Prod, Data Dictionary, Data Marts, ETL, Views, DBMS, Repsitory, etc.
Systems Interfaces & Data Exchanges (i.e., source & target schemas, APIs, orchestration, data validation, etc.)
Software Builds, Source Code Mgt, Systems Documentation, & Release Planning & Management*
Integrated Software Quality Assurance Reviews, Evaluations, Reporting
Solution Archtecture Reevalautions, Recoding, & Rework
Update Requrements Traceabiity Matrix*
Build Phase Staff Hours Sub Totals:
Test Phase
Create User Test Cases
Test Plan Creation, Appovals, & Execution (i.e.,Test Coverage and Effectiveness; Resource Req, Criteria pass/fail, cycles, etc)
Unit & Module Testing, Evaluation, & Reporting
Full Systems Integration Testing, Evaluation, & reporting (i.e., End-to-End, UI, App, Middleware, Database, Data Exchanges, et
User Acceptance Testing, Evaluation, Reporting & Sign-Off
Defect Management (i.e., Indetification, evaluation, resolution, & reporting, etc.)
Test Results Review & Approvals (i.e., Alignment and compliance with Functional & Nonfunctional Requirements)
Regression testing, Evaluations, Change Mgt, & Rework
Software Quality Assurance Reviews, Evaluations, Reporting
Update Requrements Traceabiity Matrix*
Test Phase Staff Hours Sub Totals:
Implementation Phase
Business Process & Governance Reengineering *i.e., SOP, Staffing, Administrative, Technical, & Physical Controls, etc.)
Business & IT Training Plan Creation & Approvals
Business & IT Training Plan Execution, Evaluations, Retraining, & Reporting
Business Readiness Assessment & Sign-Off
Technical Readiness Asssessment & Signoff
Define Product/Soulution Deployment Strategy & Implementation Playbook (Go & No-Go Criteria & Checlists)
Enterprise Architecture Review Committee Review & Approval
Execute Solution Implemetation Playbook (i.e, Monitoring, Risk/Impact Assessment, Status Reporting, & Change-Mgt, etc.)
Software Quality Assurance Implementation & Readiness Reviews, Results Evaluations, Coorective actions, Change-Mgt, & R
Enterpise Architecture Review Committee GO or No-Go Decision (Business & Technical Representatives)
Project Closeout (Lessons Learned, stakeholder assessments, and Corrective Actions, Process Improvement, CSI, Change-Mgt
Implementation Phase Staff Hours Sub Totals:
Project Staff Total Hours
Enter Required Full Time Equivilents (FTEs)
An FTE is considered to be 2,080 hours; which is calculated as: 8 hours per day x 5 work days per week x 52 weeks per year
Enter the hours required by each FTE to complete the a task (example: if one FTE requires 500 hours to compltete task; then
* Deliverables; theses are core products or tangibles produced
Business
Analyst
Application
Developers
Database
Architect
Application
Architect
Security
Architect
Network
Engineer
Dependancies
1.1
Dependancies
1.7
2.6
Dependancies
2.5, 2.6
3.1
3.2
3.4
Dependancies
3.2
3.4. 3.6
s, DBMS, Repsitory, etc.)
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
4.8
Dependancies
4.11
5.1
ase, Data Exchanges, etc.)
quirements)
5.7, 5.8
5.7, 5.8, 5.9
Dependancies
al Controls, etc.)
6.4, 6.5, 6.6
& Change-Mgt, etc.)
tions, Change-Mgt, & Reporting
6.9
ement, CSI, Change-Mgt)
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
k x 52 weeks per year
to compltete task; then 2 FTEs would require 250 hours to complete the same task)
0.0
0.0
0.0
0.0
0.0
0.0
Systems
Analyst
Data
Analyst
Business
Managers
IS/IT
Directors/
Managers
Solutions
Architect
Quality
Assurance
Manager
Quality
Assurance
Analysts
Server
Admins
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
Staff Resources
Database Network Computer
Admins Admins Specialists
Help Desk
Technicians
Customer
Service
Managers
Customer
Service
Reps
Project
Manager
Test
Trainers Manager
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0…
Purchase answer to see full
attachment
