Need help using Excel, IT project management.

Sigchi4life
Category:
Computer Science
Price: $10 USD

Question description

Dear,

I have WBS ready but I don't know how to finish this part of the homework. can anyone help me please?

6. . In assignment 4 & 5 you developed the scope and schedule for a new Self-checkout Point of Sale

(cash register) system in TU’s University Store. That project required at least 4 summary tasks and 12 primary tasks. Using the Excel template (attached in BB) create a Project Cost Estimate (like the sample below) for your Self-checkout project. Be sure to include the cost for each primary task. Provide summary task totals and percentage of total project cost.

You must copy and paste the Project Cost Estimate worksheet into your word document (make sure itfits page and is readable) and answer the questions below:

Note below is a sample Cost Estimate. Yours should include your WBS items not what is on this sample.

Be sure to include contingency/reserve funds!

Sample Project Cost Estimate

# Units/Hrs

Cost Per

Subtotal

Summary Task

% of

Task / WBS Items

Unit ($)

($)

Total ($)

Total

Automated Software System Project

1. Prime Mission Product

70,250

37%

1.1 Subsystem 1 (Specify name)

30

300

9,000

1.2 MAP Application Software

500

50

25,000

1.3 PMP System Software

725

50

36,250

2. Platform Integration

400

120

4,800

4,800

2.5%

3. Systems Eng/Program Mgt

200

75

15,000

15,000

8%

4. System Test & Evaluation

80

30

2,400

2,400

1.5%

5. Training

45,250

22.5%

5.1 Equipment

16

1,500

24,000

5.2 Services

65

250

16,250

5.3 Facilities

2

2,500

5,000

6. Data

100

105

10,500

10,500

5.5%

7. Peculiar Support Equip

3

3,000

9,000

9,000

5%

8. Common Support Equip

4,800

2.5%

8.1 Test & Measure Equipment

80

40

3,200

8.2 Support & Handling Equipment

40

40

1,600

9. Contingency / Reserve funds

27,000

15%

Total Project Cost

189,000

a.  What is the total cost of the project?

b.  What is the cost of each summary task (level 1 of your WBS - 1., 2., 3., etc. )?

c.  What summary task for the project is the most costly?

Here is the WBS that I used in previous HW:

WBS.docx 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Duke University
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors