Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer all questions below in an Excel spreadsheet. Put each task on a separate worksheet. In cells that contain calculated values, use Excel's formulas and/or

image text in transcribed
image text in transcribed
Answer all questions below in an Excel spreadsheet. Put each task on a separate worksheet. In cells that contain calculated values, use Excel's formulas and/or functions so I can see how you came up with your results. Be sure to complete all three tasks. Task 1 The diagram below is a partial WBS for a tablet computer project with costs apportioned by percent. Given that the total project cost is estimated to be $1,000,000, provide the estimated costs for each item. E-Slim Tablet Cost: $1,000,000 CPU Hardware 40% 60% Cameras Antenna Frame 10% Speakers 10% Flash ROM 10% Power Supply 20% 10% 1/0 Controller 25% 15% Format your worksheet like this (use a formula to calculate the estimated cost in column B): Estimated cost Deliverable Hardware Frame Cameras Speakers Antenna CPU Power Supply Flash ROM 1/ Controller Task 2 Using the "complexity weighting" scheme shown in Table 5.2 (p. 138) and the function point complexity weighted table shown below, estimate the total function point count for this project. Assume historical data suggests that seven function points equal one personi a month and five people can work on the project. Your table should look similar to the bottom part of Table 5.3 (p. 139). Where possible, be sure to use formulas. Underneath your table, respond to the following questions: a. What is the estimated project duration? b. If 9 people are available for the project, what is the estimated project duration to the nearest tenth)? c. If the project must be completed in 6 months, how many people are needed for the project to the nearest tenth)? 20 Complexity Weight Table Number of inputs Number of outputs Number of inquiries Number of files Number of interfaces 10 15 20 10 Rated complexity average Rated complexity high Rated complexity low Rated complexity average Rated complexity high

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Payroll Accounting 2021

Authors: Bernard J. Bieg, Judith A. Toland

31st Edition

0357358287, 9780357358283

More Books

Students also viewed these Accounting questions