This preview shows pages 1–3. Sign up to view the full content.
1) Write the formula that occurs in cell B6
=PMT (B3/12, B4, B2)
2) Write the formula that appears in B7
= (B6*B4) +F2
3) write the formula that appear in B2
=F1F2
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document A
B
C
D
E
1
Total
Features
3
Base
Hours
200
2
Hours
/Feature
40
Base
Cost/Hour
$25.00
3
Cost / Hour
F1
4
Cost
Multiplier
110%
5
Total Hours
F2
6
Total Cost
F3
For this problem you will use a spreadsheet to determine how many features to include in a piece
of software your company is developing.
You will need fields and labels for
Total Features
(a
number input),
Hours/Feature
(a number input),
Cost/Hour
( F1 ),
Base Hours
(a number
input),
Base Cost/Hour
(a currency input),
Total Hours( F2 )
and
Total Cost (F3).
You will
also need to have a
static
field labeled
Cost Multiplier
(a percentage input).
Fill in input fields
with your own values, they must be properly formatted.
Cost / Hour ( F1 )
is $60.00 if
Total Features
is 10 or more, $45.00 if
Total Features
is 5 or
more, otherwise it is $25.00
Total Hours (F2)
is
Hours/Features
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 12/28/2011 for the course 198 170 taught by Professor Kristianstout during the Spring '10 term at Rutgers.
 Spring '10
 KristianStout

Click to edit the document details