CPM630 - WBS - Week 3 HW1

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 10

E-commerce Website and Costco Smart Application Project

Project Budget Project Info


Project Lead: Vishnu Gupta
Start Date: 9/8/2024

Labor Materials Fixed Cos


Tasks Resources Hrs Rate Units $/Unit Material

Planning, Analysis & Inception (Name, title, or other identifying factor)

Project Initiation Project Managers 12 $18.00 1

Stakeholder Meeting Project Managers 4 $30.00 4 $0.00 100.00

Task

Requirements Gathering Business Analyst 24 1

User Story Creation Business Analyst 16 $40.00 1

Sub Task

Product Backlog Creation Product Owner 12 $20.00 1 500.00

Sprint Planning Scrum Master 8 $35.00 1

Design /Sprint 1

UI/UX Design - Website Scrum Master 12 $35.00 2 100.00

UI/UX Design - Mobile App UI/UX Designer 12 $40.00 2

Database Schema Design UI/UX Designer 6 $40.00 1

API Design Database Architect 8 $30.00 2 100.00

DevOps / QA Backend Developer 12 $32.00 1 20.00

Development /Sprint 2

Frontend Development - Homepage Frontend Developer 16 $55.00 1 50.00

Frontend Development - Product Listing Frontend Developer 8 $55.00 2 50.00

Frontend Development - Product Details Frontend Developer 12 $45.00 1 60.00

https://www.vertex42.com/ExcelTemplates/project-budget.html Page 1 of 10 Project Budget Template © 2019 by Vertex42.com


Labor Materials Fixed Cos
Tasks Resources Hrs Rate Units $/Unit Material

Backend Development - User Authentication Backend Developer 12 $35.00 1

Backend Development - Product Management Backend Developer 8 $45.00 2

Database Implementation Database Administrator 12 $50.00 1

Development /Sprint 3

Frontend Development - Shopping Cart Frontend Developer 12 $45.00 2 50.00

Frontend Development - Checkout Frontend Developer 8 $40.00 1

Backend Development - Order Processing Backend Developer 12 $35.00 2

Backend Development - Payment Integration Backend Developer 8 $35.00 1


Development /Sprint 4

Mobile App Development - Offline Mode Mobile Developer 16 $30.00 2 50.00

Unit Testing - Frontend QA Engineer 8 $20.00 2

Unit Testing - Backend Mobile Developer 12 $30.00 1

Integration Testing QA Engineer 8 $20.00 1


Sprint 5

User Acceptance Testing QA Engineer 16 $30.00 2 50.00

Performance Testing Performance Engineer 8 $30.00 1

Security Audit Security Specialist 12 $30.00 2 50.00

Bug Fixing - Frontend Frontend Developer 8 $40.00 1

Bug Fixing - Backend Backend Developer 12 $35.00 1

Bug Fixing - Mobile App Mobile Developer 8 $35.00 1


Sprint 6

Documentation - API Technical Writer 12 $35.00 2 50.00

Documentation - User Manual Technical Writer 6 $30.00 1

Deployment Planning DevOps Engineer 8 $50.00 1


Sprint 7

Beta Testing QA Engineer 12 $35.00 1 50.00

User Feedback Collection Business Analyst 16 $35.00 2

https://www.vertex42.com/ExcelTemplates/project-budget.html Page 2 of 10 Project Budget Template © 2019 by Vertex42.com


Labor Materials Fixed Cos
Tasks Resources Hrs Rate Units $/Unit Material

Frontend Developer Frontend Developer 8 $50.00 1

Backend Developer Backend Developer 8 $45.00 1


Sprint 8

Final UI/UX Adjustments UI/UX Designer 12 $45.00 2 50.00

Content Creation Content Writer 8 $40.00 1 50.00

SEO Optimization SEO Specialist 8 $35.00 1

Load Testing Performance Engineer 12 $35.00 1

Disaster Recovery Planning DevOps Engineer 6 $30.00 1


Sprint 9

User Training Materials Technical Writer 8 $30.00 1 50.00

Staff Training Project Manager 12 $40.00 2

Marketing Campaign Planning Marketing Specialist 16 $30.00 1

Final Security Review Security Specialist 16 $50.00 1


Sprint 10

Go-Live Preparation DevOps Engineer 16 $90.00 2 50.00

Website and App Launch Project Manager 8 $85.00 1

Post-Launch Monitoring DevOps Engineer / QA Engineer 12 $100.00 1

https://www.vertex42.com/ExcelTemplates/project-budget.html Page 3 of 10 Project Budget Template © 2019 by Vertex42.com


Project Info Budget Summary
Vishnu Gupta [42]

Budget Actual Under(Over)


9/8/2024 $ 18,581 $ 24,470 $ (5,889)

Fixed Costs
Travel Other Budget Actual Under(Over)

$ 3,115 $ 2,396 $ 719

- 500.00 216.00 284.00

50.00 150.00 270.00 (120.00)

250.00 25.00 250.00 (225.00)

- -

1,400.00 640.00 760.00

- -

800.00 740.00 60.00

240.00 280.00 (40.00)

$ 1,010 $ 1,984 $ (974)

300.00 520.00 (220.00)

200.00 480.00 (280.00)

200.00 240.00 (40.00)

250.00 340.00 (90.00)

60.00 404.00 (344.00)

$ 1,680 $ 3,600 $ (1,920)

300.00 930.00 (630.00)

300.00 490.00 (190.00)

250.00 600.00 (350.00)

https://www.vertex42.com/ExcelTemplates/project-budget.html Page 4 of 10 Project Budget Template © 2019 by Vertex42.com


Fixed Costs
Travel Other Budget Actual Under(Over)

50.00 30.00 470.00 (440.00)

100.00 200.00 460.00 (260.00)

50.00 600.00 650.00 (50.00)

$ 1,250 $ 1,810 $ (560)

50.00 590.00 (540.00)

100.00 400.00 420.00 (20.00)

50.00 400.00 470.00 (70.00)

50.00 400.00 330.00 70.00


$ 126 $ 1,410 $ (1,284)
30.00 530.00 (500.00)
100.00 31.00 260.00 (229.00)
50.00 32.00 410.00 (378.00)
50.00 33.00 210.00 (177.00)
$ 2,400 $ 2,450 $ (50)
400.00 530.00 (130.00)
50.00 400.00 290.00 110.00
400.00 410.00 (10.00)
100.00 400.00 420.00 (20.00)
50.00 400.00 470.00 (70.00)
50.00 400.00 330.00 70.00
$ 600 $ 1,140 $ (540)
200.00 470.00 (270.00)
40.00 200.00 220.00 (20.00)
50.00 200.00 450.00 (250.00)
$ 1,200 $ 1,990 $ (790)
300.00 470.00 (170.00)
100.00 300.00 660.00 (360.00)

https://www.vertex42.com/ExcelTemplates/project-budget.html Page 5 of 10 Project Budget Template © 2019 by Vertex42.com


Fixed Costs
Travel Other Budget Actual Under(Over)

60.00 300.00 460.00 (160.00)


40.00 300.00 400.00 (100.00)
$ 1,500 $ 1,990 $ (490)
300.00 590.00 (290.00)
300.00 370.00 (70.00)
50.00 300.00 330.00 (30.00)
60.00 300.00 480.00 (180.00)
40.00 300.00 220.00 80.00
$ 1,200 $ 2,230 $ (1,030)
300.00 290.00 10.00
80.00 300.00 560.00 (260.00)
50.00 300.00 530.00 (230.00)
50.00 300.00 850.00 (550.00)
$ 4,500 $ 3,470 $ 1,030
1,500.00 1,490.00 10.00
50.00 1,500.00 730.00 770.00
50.00 1,500.00 1,250.00 250.00

https://www.vertex42.com/ExcelTemplates/project-budget.html Page 6 of 10 Project Budget Template © 2019 by Vertex42.com


Template Help
Visit the Project Budget Template Page >

About This Template


This version of the project budget template was designed with a new look and it provides
multiple columns for fixed costs. Also, instead of using the Labor, Materials, and Fixed
Costs columns to calculate the Budgeted amount, these columns are used to calculate the
Actual amount.

Entering Budget and Actual Amounts


In this worksheet, the Actual amount is calculated from the Labor, Materials, and Fixed
Costs columns. This means that you manually enter the Budget value and you use the
Labor, Materials, and Fixed Costs columns to enter actual spent amounts.

When Adding New Rows


The Phase/Category Title rows contain SUBTOTAL(9,...) formulas in the Budget and
Actual columns that should be verified for accuracy after inserting new rows. Check these
formulas to ensure that they reference the correct range of cells.

Note: The SUBTOTAL(9,…) function is the same as the SUM(…) function except that
using SUBTOTAL() ignores cells containing other SUBTOTAL() formulas. This allows the
grand-total at the top to sum all budget values while ignoring the subtotals.

Cell containing "#####"


If you see "#####" in a cell, it means you need to widen the column to see the value, or
reduce the font size for that cell.
Project Budget Template

By Vertex42.com
https://www.vertex42.com/ExcelTemplates/project-budget.html

© 2019 Vertex42 LLC

This spreadsheet, including all worksheets and associated content is a copyrighted


work under the United States and other copyright laws.

Do not submit copies or modifications of this template to any website or online


template gallery.

Please review the following license agreement to learn how you may or may not use
this template. Thank you.

License Agreement
https://www.vertex42.com/licensing/EULA_privateuse.html

Do not delete this worksheet.

You might also like