FinalExamSpreadsheetExamples

FinalExamSpreadsheetExamples - 1) Write the formula that...

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) 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/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
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 12/28/2011 for the course 198 170 taught by Professor Kristianstout during the Spring '10 term at Rutgers.

Page1 / 3

FinalExamSpreadsheetExamples - 1) Write the formula that...

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