Final Examples

# Final Examples - 1 ) W ri te the formula that occurs in...

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*-1) 2) Write the formula that appears in B7 =(B6*B4)+F2 3) Write the formula that appear in B2 =F1-F2

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/Hou r \$25.00 3 Cost / Hour F1 4 Cost Multiplie r 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 times Total Features plus Base Hours
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 09/27/2011 for the course ECON 101 taught by Professor Gottlieb during the Spring '08 term at Rutgers.

### Page1 / 4

Final Examples - 1 ) W ri te the formula that occurs in...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online