Case03_Belen_2

Case03_Belen_2 - Salesperson Qtr 1 Qtr 2 Qtr 3 Qtr 4 Jim H....

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

View Full Document Right Arrow Icon
CaseGrader 2007 Case 03 - Working with Formulas and Functions Author Belen Cardenas Date 16-Nov-11 25-Dec-08 -1056.3387615741
Background image of page 1

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

View Full DocumentRight Arrow Icon
Ultra Premium Paper A bright, glossy paper that offers superior quality and reliability 2010 QUARTERLY SALES DATA, REAMS SOLD Salesperson Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total Minimum Maximum Average Grade Jim H. 7428 7846 7842 7280 30396 $7,280.00 $7,846.00 $7,599.00 Poor Phyllis V. 7940 8184 7720 7552 31396 $7,552.00 $8,184.00 $7,849.00 Poor Stanley H. 8022 9186 9352 8801 35361 $8,022.00 $9,352.00 $8,840.25 Outstanding Ryan H. 7960 7135 7739 7428 30262 $7,135.00 $7,960.00 $7,565.50 Poor Karen F. 8486 8143 8574 8497 33700 $8,143.00 $8,574.00 $8,425.00 Poor Dwight S. 8794 9085 8324 8762 34965 $8,324.00 $9,085.00 $8,741.25 Outstanding Michael S. 10574 10297 9248 10648 40767 $9,248.00 $10,648.00 $10,191.75 Outstanding 2010 Qtr Average (Overall) $8,458.82 Projected Increase 8% 2011 QUARTERLY SALES DATA, REAMS SOLD (PROJECTED)
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Salesperson Qtr 1 Qtr 2 Qtr 3 Qtr 4 Jim H. 8022.24 8473.68 8469.36 7862.4 Phyllis V. 8575.2 8838.72 8337.6 8156.16 Stanley H. 8663.76 9920.88 10100.16 9505.08 Ryan H. 8596.8 7705.8 8358.12 8022.24 Karen F. 9164.88 8794.44 9259.92 9176.76 Dwight S. 9497.52 9811.8 8989.92 9462.96 Michael S. 11419.92 11120.76 9987.84 11499.84 Total 63940.32 64666.08 63502.92 63685.44 NewLeaf Paper The Value of Time Minute 0.01 Hour 0.6 Day 14.4 Month 437.76 Number of Years 5 Number of Periods 60 Annual Percentage Rate 0% 2% 4% 6% 8% 10% 12% 14% Periods Per Year 12 Interest Rate Per Period 0.0000% 0.1667% 0.3333% 0.5000% 0.6667% 0.8333% 1.0000% 1.1667% Future Value $26,265.60 $27,599.61 $29,023.04 $30,542.53 $32,165.23 $33,898.85 $35,751.71 $37,732.78...
View Full Document

Page1 / 3

Case03_Belen_2 - Salesperson Qtr 1 Qtr 2 Qtr 3 Qtr 4 Jim H....

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