Lynn Sau X MAN assignment (1) - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do _ AutoSum & Cut AYO Calibri - 12 - A A" = ab Wrap Text General Fill EB Copy Conditional Format as Cell Insert Delete Format Sort & Find & Paste A Merge & Center $~ % " Formatting " Table * Styles ~ Clear Filter ~ Select Format Painter BIUS Alignment Number Styles Cells Editing Clipboard Font A72 X fx G B C D Non-Labour Cost (per Total Non-Labour Co: Total Cost Column1 WBS # Deliverable/Work Packag Duration Preceding Activity Labour Cost (per day - Total Labour cost day) 3 Content Management 2500 3500 3.1 Records Retention Policy 5 200 1000 500 6000 8400 3.2 Old Content Archive 12 3.1 200 240 500 3.3 New Design Content 21 3.2 300 6300 500 10500 16800 New Photography 500 5500 600 6600 12100 4.1 Photoshoots 11 600 1800 3000 4.2 Photo edits 3 4 .2 400 1200 600 600 750 4.3 inal selections 1 4 3 150 150 600 8400 12600 4.4 4200 Image replacements 14 300 Search Engine Optimization 5 .1 Search effectiveness 150 600 400 1600 2200 assessment Future state search 5.2 3.3 300 800 1100 parameters 150 400 400 2800 3850 5.3 Meta data tagging 3.3, 4.4 150 1050 6 Launch 6.1 200 500 1400 Rollout strategy 5.3 400 1000 500 2500 3500 6.2 1000 Testing N H UT N 5 .3 200 200 500 500 700 6 .3 Cutover 6 .2 200 6.4 Employee training 6 .1 100 200 500 1000 1200 46,600.00 Total cost 24,500.00 71,100.00 (excluding contingency) $7,110 contingency (10%) $78,210 (including contingency) Total budget STEP 1 STEP 2 Explanation: Non-Labour Cost for WBS 3,3.1, 3.2, 3.3 - The Non-Labour cost is $500 per day, which includes the laptop/computers and softwares to be used for the archive. Non-Labour Cost for WBS 4,4.1, 4.2, 4.3, 4.4 - The non-labour cost is $600 per day, which includes equipment that can be borrowed for a day, such as a computer/laptop, camera, lighting, Non-Labour Cost for WBS 5,5.1, 5.2, 5.3- The non-labour cost is $400 per day, which includes the laptop/computers and softwares to be used for the search engines. Non-Labour Cost for WBS 6, 6.1, 6.2, 6.3, 6.4 - The Non-Labour cost is $500 per day, which includes the laptop/computers and softwares to be used for rollouts and trainings, 34 Sheet1 + 70% Ready Accessibility: Investigate ON D O MX ENG 6:34 PM Search GFX WMAN assignment (1) - Excel Lynn Sau X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Cut Calibri - 12 - A A" = ab Wrap Text General _ AutoSum AYO EB Copy Fill Paste BIU Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting " Table * Styles ~ Clear Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing A72 X B C D G The total non-labour cost of the project is $46600. The total cost (without considering the contingency) is: labour cost + non-labour cost labour cost 24,500.00 non-labour cost 46,600.00 total cost of the project 1,100.00 (excluding contingency) contingency (10%) 7,110.00 total cost of the project 8,210.00 (including contingency) Assuming a reasonable contingency of 10% of the total budget, we will add $7110 as a contingency amount. The total budget with contingency will be: Total Budget (including contingency): $78210 Reasons of contingency Unexpected expenses including additional material, extra labor, equipment repair There can be several unexpected expenses that may arise during the process of redesigning a company website. Some examples include: 1 Change in scope: This could lead to additional costs for revising the design, integrating new features, or accommodating new content. 2 Technical challenges: Unforeseen technical difficulties may arise unexpected expenses including compatibility issues with certain browsers or devices, integration problems with third-party systems, or the need for additional software or tools to overcome technical limitations. 3 Content migration and data conversion: If the website redesign involves migrating content from the old website to the new one, unexpected complexities may arise. This could include the need for manual content cleanup or reformatting, data transformation, or dealing with content that is incompatible with the new system. Such challenges may require additional resources or tools to address effectively. 4 Accessibility compliance: Ensuring the website is accessible to individuals with disabilities may require modifications to the design, coding, or content structure, which could lead to unexpected expenses. 5 Security enhancements: As part of the website redesign, security vulnerabilities may be identified, necessitating the implementation of additional security measures. This could include adding SSL certificates, enhancing user authentication processes, or implementing security monitoring tools. 6 License or subscription fees: The website redesign may require the use of new software, plugins, or content management systems that involve licensing or subscription fees. These costs may not have been initially accounted for in the budget and can be unexpected expenses. 7 Training and support: Once the revamped website go live, there may be a need for training employees on how to use the new system or providing ongoing support. These training and support costs may not have been anticipated initially and can be an unexpected expense. 70 STEP 4 72 73 74 79 Sheet1 + Ready Accessibility: Investigate 70% Search 8 0 0 4X ENG 6:34 PM