assignment 5 - $75.00 Regular Cost: $15,000.00 Over Time...

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

View Full Document Right Arrow Icon
Sales Dollars 83333.33 Bonus percentage 3% Bonus amount 2500
Background image of page 1

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

View Full DocumentRight Arrow Icon
Assumptions Customer Name MaryBeth Williams FICO Credit Rating 755 Purchase Price $21,000 Down Payment $3,000 Loan Term 3 (years) Application Date 1/14/2007 Outputs Payment: $557.85 per month Interest Rate: 7.25% per year Loan Term: 3 years Loan Amt. $18,000.00 Assessment $300.00 Today's Date: 6/1/11 300
Background image of page 2
pony lite Project Start Date: 01/01/08 Est. Duration (hours): 300 Completion Date: 08/01/08 Total Cost: $15,000.00 Number of Technicans: 1 Regular Hours: 300 OverTime Hours: 0 Contractor Surcharge: $200.00 Standard Per-Hour Rate: $50.00 Over Time Rate:
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $75.00 Regular Cost: $15,000.00 Over Time Cost: $- Total Hours Worked: 300 Scenario Summary Current Values: Scenario #3 Scenario #1 Changing Cells: $D$9 1 3 5 $D$10 300 150 10 $D$11 7 5 Result Cells: $D$7 $15,000.00 $24,475.00 $5,175.00 $D$12 $200.00 $200.00 $200.00 $D$15 $15,000.00 $22,500.00 $2,500.00 $D$16 $- $1,575.00 $1,875.00 $D$17 300 471 75 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray....
View Full Document

Page1 / 4

assignment 5 - $75.00 Regular Cost: $15,000.00 Over Time...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online