Final Examples

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

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
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
Background image of page 2
Image of page 3
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 Right Arrow Icon
Ask a homework question - tutors are online