Tasks:
1. Copy the entire data from the “Raw-Data” worksheet into a new worksheet
called “Equipment-Rental” .
2. Convert the Flat Table (range A1:F30) to an Excel Table.
3. Use the Quick Sort & Filter column dropdowns to perform the following:
a. Sort by Checked Out Date in descending order from latest date (recent) to
earliest date (oldest).
b. Filter the Excel Table to only show the Laptop category.
Take a screenshot of the result of applying the filter, and paste this into a
new worksheet called “Screenshot-1”.
You can take a screenshot by using the Alt+Printscreen combination
on your keyboard.
c. Remove the filter from the previous step.
d. Use a Text Filter to show entries related to Camera equipment. To do this,
Use a custom filter to search for entries in the Detail column
containing the text “Cam”.
Take a screenshot of the result of applying the filter, and paste this into a
new worksheet called “Screenshot-2”.
e. Remove the filter from the previous step.
4. Copy the entire table from the “Equipment-Rental” worksheet into a new
worksheet called “Report-1” . In the “Report-1” worksheet,
convert the Excel Table back into a Flat Table (range).
5. In the “Report-1” worksheet, Use the Sort controls in the Data tab to perform a
multi-level custom sort such that entries are first ordered by equipment type,
and within each type, items are ordered by their checkout dates (latest to
earliest).
6. In the “Report-1” worksheet, add a new column called “Number of Days” .
This column should contain the number of working days between the checkout
and the checkin dates.
Use the “NetWorkDays” function to calculate the value for the first row in the
table and use Auto-Fill to copy the formula to the rows below.
7. Create a new worksheet called “Report-2”.
8. In the “Report-2” worksheet, in Cell A1, enter the text “Report Highlights”.
Merge and Center cells A1, B1 and C1, and make the text bold.
9. In Cell A3 enter the text “Average Rent Duration:” and make it bold and right
aligned. In Cell B3, use an Excel function to calculate the average of the
“Number of Days” column from the “Report-1” worksheet.
Reformat the number to be 1 decimal place only.
10. In cell A5, enter the text “Max Rent Duration” and make it bold and right
aligned. In Cell B5, use an Excel function to calculate the maximum of the
“Number of Days” column from the “Report-1” worksheet.
11. Go back to the “Report-1” worksheet and apply a custom filter to the
“Number of Days” column to only show records with more than 7 days of
equipment rentals.
For the records shown after applying the filter, ONLY copy the “Type” ,
“Equipment Detail”, “By Whom”, and “Number of Days” columns (including
headers) and paste this copied data in the “Report-2” worksheet
starting at cell A7.
12. Remove the Filter from “Report-1”. 13. Format the “Report-2” worksheet to be aesthetically pleasing, including section titles, column headers, column widths etc.
| ID # | Type | Equipment Detail | Checked Out | Checked In | By Whom |
| 1011 | Laptop | 10″ Saris Netbook Pro | October 4, 2010 | October 8, 2010 | Jay Peralta |
| 1012 | Laptop | 10″ Saris Netbook Pro | September 29, 2010 | October 6, 2010 | August Zorn |
| 1021 | Laptop | 15″ EDI SmartPad L200-3 | September 15, 2010 | October 1, 2010 | Sofie Ragnar |
| 1022 | Laptop | 15″ EDI SmartPad L200-3 | August 14, 2010 | August 16, 2010 | Hank Sorenson |
| 1023 | Laptop | 15″ EDI SmartPad L200-3 | August 8, 2010 | August 15, 2010 | Jennifer Weiss |
| 1025 | Laptop | 15″ EDI SmartPad L200-4X | September 26, 2010 | October 4, 2010 | Min Seung |
| 1031 | Laptop | 17″ Saris X-10 Laptop | October 4, 2010 | October 14, 2010 | Nick Ortiz |
| 1032 | Laptop | 17″ Saris X-10 Laptop | September 19, 2010 | September 24, 2010 | Stanley Geyer |
| 1033 | Laptop | 17″ Saris X-10 Laptop | September 24, 2010 | September 26, 2010 | George D’Agosta |
| 1034 | Laptop | 17″ Saris X-10 Laptop | August 25, 2010 | August 27, 2010 | Jay Peralta |
| 2050 | Other | EDI SmartBoard L500-1 | October 5, 2010 | October 6, 2010 | Anthony Liddell |
| 2051 | Other | EDI SmartBoard L500-1 | October 1, 2010 | October 5, 2010 | Sofie Ragnar |
| 3000 | Other | Saris Lumina Digital Camera | May 12, 2010 | May 15, 2010 | Shannon Nguyen |
| 3005 | Other | Saris Zoom Z-60 Digital Camera | July 27, 2010 | August 6, 2010 | Sela Shepard |
| 3070 | Other | Omega PixL Digital Camcorder | October 6, 2010 | October 9, 2010 | Min Seung |
| 3800 | Other | U-Go Saris DigiCam Printer II | August 4, 2010 | August 5, 2010 | Hank Sorenson |
| 3900 | Other | U-Go Saris Label Maker | June 13, 2010 | June 20, 2010 | Clint Gosse |
| 4800 | Other | 7N Deluxe Camera Travel Bag | July 27, 2010 | August 6, 2010 | Sela Shepard |
| 4900 | Other | 7N Light Rolling Laptop Case | October 4, 2010 | October 7, 2010 | Jay Peralta |
| 4905 | Other | 7N Heavy Rolling Laptop Case | October 4, 2010 | October 8, 2010 | Nick Ortiz |
| 5020 | TV | 32″ Paragon 440 Plasma TV | August 11, 2010 | August 13, 2010 | Marta Lao |
| 5022 | TV | 32″ Paragon 440 Plasma TV | July 17, 2010 | July 17, 2010 | Carl Langer |
| 5023 | TV | 50″ Paragon 490L LCD TV | October 1, 2010 | October 1, 2010 | Margaret Lisbon |
| 6100 | Projector | Omega VisX 1.0 | September 28, 2010 | October 1, 2010 | Win Armitage |
| 6101 | Projector | Omega VisX 1.0 | September 26, 2010 | September 27, 2010 | Michael Earley |
| 6102 | Projector | Omega VisX 1.0 | August 22, 2010 | August 23, 2010 | Jamila Kyle |
| 6200 | Projector | Saris Lux T-80 | September 1, 2010 | September 4, 2010 | Jolie Chaturvedi |
| 6301 | Projector | Saris Lux T-81 Lite | September 10, 2010 | September 14, 2010 | Marques Herndon |
| 6302 | Projector | Saris Lux T-81 Lite | September 8, 2010 | September 15, 2010 | Dean Sorenson |
| ID # | Type | Equipment Detail | Checked Out | Checked In | By Whom |
| 3070 | Other | Omega PixL Digital Camcorder | October 6, 2010 | October 9, 2010 | Min Seung |
| 2050 | Other | EDI SmartBoard L500-1 | October 5, 2010 | October 6, 2010 | Anthony Liddell |
| 1011 | Laptop | 10″ Saris Netbook Pro | October 4, 2010 | October 8, 2010 | Jay Peralta |
| 1031 | Laptop | 17″ Saris X-10 Laptop | October 4, 2010 | October 14, 2010 | Nick Ortiz |
| 4900 | Other | 7N Light Rolling Laptop Case | October 4, 2010 | October 7, 2010 | Jay Peralta |
| 4905 | Other | 7N Heavy Rolling Laptop Case | October 4, 2010 | October 8, 2010 | Nick Ortiz |
| 2051 | Other | EDI SmartBoard L500-1 | October 1, 2010 | October 5, 2010 | Sofie Ragnar |
| 5023 | TV | 50″ Paragon 490L LCD TV | October 1, 2010 | October 1, 2010 | Margaret Lisbon |
| 1012 | Laptop | 10″ Saris Netbook Pro | September 29, 2010 | October 6, 2010 | August Zorn |
| 6100 | Projector | Omega VisX 1.0 | September 28, 2010 | October 1, 2010 | Win Armitage |
| 1025 | Laptop | 15″ EDI SmartPad L200-4X | September 26, 2010 | October 4, 2010 | Min Seung |
| 6101 | Projector | Omega VisX 1.0 | September 26, 2010 | September 27, 2010 | Michael Earley |
| 1033 | Laptop | 17″ Saris X-10 Laptop | September 24, 2010 | September 26, 2010 | George D’Agosta |
| 1032 | Laptop | 17″ Saris X-10 Laptop | September 19, 2010 | September 24, 2010 | Stanley Geyer |
| 1021 | Laptop | 15″ EDI SmartPad L200-3 | September 15, 2010 | October 1, 2010 | Sofie Ragnar |
| 6301 | Projector | Saris Lux T-81 Lite | September 10, 2010 | September 14, 2010 | Marques Herndon |
| 6302 | Projector | Saris Lux T-81 Lite | September 8, 2010 | September 15, 2010 | Dean Sorenson |
| 6200 | Projector | Saris Lux T-80 | September 1, 2010 | September 4, 2010 | Jolie Chaturvedi |
| 1034 | Laptop | 17″ Saris X-10 Laptop | August 25, 2010 | August 27, 2010 | Jay Peralta |
| 6102 | Projector | Omega VisX 1.0 | August 22, 2010 | August 23, 2010 | Jamila Kyle |
| 1022 | Laptop | 15″ EDI SmartPad L200-3 | August 14, 2010 | August 16, 2010 | Hank Sorenson |
| 5020 | TV | 32″ Paragon 440 Plasma TV | August 11, 2010 | August 13, 2010 | Marta Lao |
| 1023 | Laptop | 15″ EDI SmartPad L200-3 | August 8, 2010 | August 15, 2010 | Jennifer Weiss |
| 3800 | Other | U-Go Saris DigiCam Printer II | August 4, 2010 | August 5, 2010 | Hank Sorenson |
| 3005 | Other | Saris Zoom Z-60 Digital Camera | July 27, 2010 | August 6, 2010 | Sela Shepard |
| 4800 | Other | 7N Deluxe Camera Travel Bag | July 27, 2010 | August 6, 2010 | Sela Shepard |
| 5022 | TV | 32″ Paragon 440 Plasma TV | July 17, 2010 | July 17, 2010 | Carl Langer |
| 3900 | Other | U-Go Saris Label Maker | June 13, 2010 | June 20, 2010 | Clint Gosse |
| 3000 | Other | Saris Lumina Digital Camera | May 12, 2010 | May 15, 2010 | Shannon Nguyen |
| ID # | Type | Equipment Detail | Checked Out | Checked In | By Whom | Number of Days |
| 1011 | Laptop | 10″ Saris Netbook Pro | October 4, 2010 | October 8, 2010 | Jay Peralta | 5 |
| 1031 | Laptop | 17″ Saris X-10 Laptop | October 4, 2010 | October 14, 2010 | Nick Ortiz | 9 |
| 1012 | Laptop | 10″ Saris Netbook Pro | September 29, 2010 | October 6, 2010 | August Zorn | 6 |
| 1025 | Laptop | 15″ EDI SmartPad L200-4X | September 26, 2010 | October 4, 2010 | Min Seung | 6 |
| 1033 | Laptop | 17″ Saris X-10 Laptop | September 24, 2010 | September 26, 2010 | George D’Agosta | 1 |
| 1032 | Laptop | 17″ Saris X-10 Laptop | September 19, 2010 | September 24, 2010 | Stanley Geyer | 5 |
| 1021 | Laptop | 15″ EDI SmartPad L200-3 | September 15, 2010 | October 1, 2010 | Sofie Ragnar | 13 |
| 1034 | Laptop | 17″ Saris X-10 Laptop | August 25, 2010 | August 27, 2010 | Jay Peralta | 3 |
| 1022 | Laptop | 15″ EDI SmartPad L200-3 | August 14, 2010 | August 16, 2010 | Hank Sorenson | 1 |
| 1023 | Laptop | 15″ EDI SmartPad L200-3 | August 8, 2010 | August 15, 2010 | Jennifer Weiss | 5 |
| 3070 | Other | Omega PixL Digital Camcorder | October 6, 2010 | October 9, 2010 | Min Seung | 3 |
| 2050 | Other | EDI SmartBoard L500-1 | October 5, 2010 | October 6, 2010 | Anthony Liddell | 2 |
| 4900 | Other | 7N Light Rolling Laptop Case | October 4, 2010 | October 7, 2010 | Jay Peralta | 4 |
| 4905 | Other | 7N Heavy Rolling Laptop Case | October 4, 2010 | October 8, 2010 | Nick Ortiz | 5 |
| 2051 | Other | EDI SmartBoard L500-1 | October 1, 2010 | October 5, 2010 | Sofie Ragnar | 3 |
| 3800 | Other | U-Go Saris DigiCam Printer II | August 4, 2010 | August 5, 2010 | Hank Sorenson | 2 |
| 3005 | Other | Saris Zoom Z-60 Digital Camera | July 27, 2010 | August 6, 2010 | Sela Shepard | 9 |
| 4800 | Other | 7N Deluxe Camera Travel Bag | July 27, 2010 | August 6, 2010 | Sela Shepard | 9 |
| 3900 | Other | U-Go Saris Label Maker | June 13, 2010 | June 20, 2010 | Clint Gosse | 5 |
| 3000 | Other | Saris Lumina Digital Camera | May 12, 2010 | May 15, 2010 | Shannon Nguyen | 3 |
| 6100 | Projector | Omega VisX 1.0 | September 28, 2010 | October 1, 2010 | Win Armitage | 4 |
| 6101 | Projector | Omega VisX 1.0 | September 26, 2010 | September 27, 2010 | Michael Earley | 1 |
| 6301 | Projector | Saris Lux T-81 Lite | September 10, 2010 | September 14, 2010 | Marques Herndon | 3 |
| 6302 | Projector | Saris Lux T-81 Lite | September 8, 2010 | September 15, 2010 | Dean Sorenson | 6 |
| 6200 | Projector | Saris Lux T-80 | September 1, 2010 | September 4, 2010 | Jolie Chaturvedi | 3 |
| 6102 | Projector | Omega VisX 1.0 | August 22, 2010 | August 23, 2010 | Jamila Kyle | 1 |
| 5023 | TV | 50″ Paragon 490L LCD TV | October 1, 2010 | October 1, 2010 | Margaret Lisbon | 1 |
| 5020 | TV | 32″ Paragon 440 Plasma TV | August 11, 2010 | August 13, 2010 | Marta Lao | 3 |
| 5022 | TV | 32″ Paragon 440 Plasma TV | July 17, 2010 | July 17, 2010 | Carl Langer | 0 |
<!–table {mso-displayed-decimal-separator:”\.”; mso-displayed-thousand-separator:”\,”;} @page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl65 {font-weight:700;} .xl66 {text-align:left;} .xl67 {color:#3F3F3F; font-weight:700; border-top:.5pt solid #3F3F3F; border-right:.5pt solid #3F3F3F; border-bottom:.5pt solid #3F3F3F; border-left:1.0pt solid windowtext; background:#F2F2F2; mso-pattern:black none;} .xl68 {color:#3F3F3F; font-weight:700; border:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl69 {color:#3F3F3F; font-weight:700; mso-number-format:”\[ENG\]\[$-409\]mmmm\\ d\\\,\\ yyyy\;\@”; border:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl70 {color:#3F3F3F; font-weight:700; border-top:.5pt solid #3F3F3F; border-right:1.0pt solid windowtext; border-bottom:.5pt solid #3F3F3F; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl71 {color:#3F3F3F; font-weight:700; border-top:.5pt solid #3F3F3F; border-right:.5pt solid #3F3F3F; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:#F2F2F2; mso-pattern:black none;} .xl72 {color:#3F3F3F; font-weight:700; border-top:.5pt solid #3F3F3F; border-right:.5pt solid #3F3F3F; border-bottom:1.0pt solid windowtext; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl73 {color:#3F3F3F; font-weight:700; mso-number-format:”\[ENG\]\[$-409\]mmmm\\ d\\\,\\ yyyy\;\@”; border-top:.5pt solid #3F3F3F; border-right:.5pt solid #3F3F3F; border-bottom:1.0pt solid windowtext; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl74 {color:#3F3F3F; font-weight:700; border-top:.5pt solid #3F3F3F; border-right:1.0pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl75 {color:#3F3F3F; font-weight:700; border-top:none; border-right:.5pt solid #3F3F3F; border-bottom:.5pt solid #3F3F3F; border-left:1.0pt solid windowtext; background:#F2F2F2; mso-pattern:black none;} .xl76 {color:#3F3F3F; font-weight:700; border-top:none; border-right:.5pt solid #3F3F3F; border-bottom:.5pt solid #3F3F3F; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl77 {color:#3F3F3F; font-weight:700; mso-number-format:”\[ENG\]\[$-409\]mmmm\\ d\\\,\\ yyyy\;\@”; border-top:none; border-right:.5pt solid #3F3F3F; border-bottom:.5pt solid #3F3F3F; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl78 {color:#3F3F3F; font-weight:700; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid #3F3F3F; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl79 {color:#1F497D; font-weight:700; text-align:left; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext;} .xl80 {color:#1F497D; font-weight:700; text-align:left; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;} .xl81 {color:#1F497D; font-weight:700; text-align:left; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none;} .xl82 {color:#3F3F3F; font-weight:700; text-align:right; border-top:1.0pt solid windowtext; border-right:.5pt solid #3F3F3F; border-bottom:.5pt solid #3F3F3F; border-left:1.0pt solid windowtext; background:#F2F2F2; mso-pattern:black none;} .xl83 {color:#3F3F3F; font-weight:700; mso-number-format:”0\.0″; text-align:right; border-top:1.0pt solid windowtext; border-right:.5pt solid #3F3F3F; border-bottom:.5pt solid #3F3F3F; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl84 {color:#3F3F3F; font-weight:700; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid #3F3F3F; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl85 {color:#3F3F3F; font-weight:700; text-align:right; border-top:.5pt solid #3F3F3F; border-right:.5pt solid #3F3F3F; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:#F2F2F2; mso-pattern:black none;} .xl86 {color:#3F3F3F; font-weight:700; text-align:right; border-top:.5pt solid #3F3F3F; border-right:.5pt solid #3F3F3F; border-bottom:1.0pt solid windowtext; border-left:.5pt solid #3F3F3F; background:#F2F2F2; mso-pattern:black none;} .xl87 {color:#1F497D; font-size:15.0pt; font-weight:700; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext;} .xl88 {color:#1F497D; font-size:15.0pt; font-weight:700; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;} .xl89 {color:#1F497D; font-size:15.0pt; font-weight:700; text-align:center; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none;} –>
Report Highlights
Average Rent Duration
4.2
Max Rent Duration
13
Type
Equipment Detail
Checked Out
Checked In
By Whom
Number of Days
Laptop
17″ Saris X-10 Laptop
October 4, 2010
October 14, 2010
Nick Ortiz
9
Laptop
15″ EDI SmartPad L200-3
September 15, 2010
October 1, 2010
Sofie Ragnar
13
Other
Saris Zoom Z-60 Digital Camera
July 27, 2010
August 6, 2010
Sela Shepard
9
Other
7N Deluxe Camera Travel Bag
July 27, 2010
August 6, 2010
Sela Shepard
9
| Products | Price per Unit | Cost per Unit | Unit Sales |
| Product1 | $15 | $8 | 200 |
| Product2 | $18 | $12 | 225 |
| Product3 | $20 | $14 | 175 |
| Product4 | $20 | $12 | 215 |
| Product5 | $22 | $15 | 235 |
| Total Revenue | $20,020.00 | ||
| Total Cost of Goods Sold | $12,855.00 | ||
| Profit | $7,165.00 |
1. Calculate the Total Revenue using ONE single function or formula (without intermediate steps)
2. Calculate the Total Cost using ONE single function or formula (without intermediate steps)
3. Calculate the Profit using a formula that uses the revenue and cost as inputs.
4. Format all the output cells as currency values with two decimals.
| LOOKUP FORM | Information Table | ||||||||||
| Stationery Items | Product Code | Price | |||||||||
| Enter Stationery Item Here: | Product Code Is: | Product Package Price Is: | Pencils | A12 | 10 | ||||||
| Markers | C55 | 15 | Pens | A44 | 20 | ||||||
| Erasers | G14 | 10 | |||||||||
| Laser Paper | P12 | 15 | |||||||||
| Highlighters | C12 | 18 | |||||||||
| Markers | C55 | 15 | |||||||||
| Inkjet Paper | P33 | 10 | |||||||||
Tasks:
In the Decision-Heuristics -Model -1 worksheet:
1. Calculate the Max, Min, and Average payoffs for each decision alternative and fill cells F5 to H7 appropriately.
2. Use the Max function in F8, G8, H8 to calculate the values of the heuristics.
3. Format the cells in the model as Currency cells.
4. For row 9, make a note (manually enter) of the alternatives that correspond to the heuristics values calculated in row 8.
In the Decision-Heuristics-Model -2 worksheet:
1. Calculate the EMV (Expected Monetary Value) for each decision alternative and fill cells G6, G7, G8 appropriately.
2. Use the Max function in G9 to calculate the final value of the EMV heuristic.
3. Format the cells in the model as Currency cells.
4. For row 10, make a note (manually enter) of the alternative that corresponds to the best EMV value calculated in row 9.
| Data | Model with Three Different Heuristics | ||||||
| Payoffs based on Max, Min, Average Heuristics | |||||||
| States of Nature & Payoffs | Maximax Heuristic | Maximin Heuristic | Equally Likely Heuristic | ||||
| Decision Alternatives | Favourable Market | Unfavourable Market | Decision Alternatives | Max | Min | Average | |
| Large Plant | $200,000 | -$180,000 | Large Plant | $200,000.00 | -$180,000.00 | $10,000.00 | |
| Small Plant | $100,000 | -$20,000 | Small Plant | $100,000.00 | -$20,000.00 | $40,000.00 | |
| No Plant | $0 | $0 | No Plant | $0.00 | $0.00 | $0.00 | |
| Max | $200,000 | $0 | $40,000 | ||||
| Best Alternative (based on Heuristic) | $200,000 | $0 | $40,000 |
| Data | Model | ||||||
| States of Nature | Payoffs based on EMV Heuristic | ||||||
| Favourable Market | Unfavourable Market | EMV Heuristic | |||||
| Probabilities | 0.6 | 0.4 | Decision Alternatives | EMV | |||
| Decision Alternatives | Large Plant | 48000 | |||||
| Large Plant | $200,000 | -$180,000 | Small Plant | 52000 | |||
| Small Plant | $100,000 | -$20,000 | No Plant | 0 | |||
| No Plant | $0 | $0 | Max | 52000 | |||
| Best Alternative (based on EMV) | 52000 |
Tasks:
In the Sales-Data worksheet:
1. Break the data in the Salesperson column into two columns: First Name and Last Name. (Use the Text to Columns feature in the Data tab). Make sure that you also type the column labels First Name and Last Name.
2. Add a validation to the country column so the only valid entries include England, France or Germany.
The following criteria should be considered while applying the validation rule:
a) Apply the validation rule to the entire column (original values in the column should be preserved).
b) Add a user-friendly Error Alert (notifying users in case they try to enter an invalid value for country).
c) Add an input message to inform users which countries are valid.
3. Format the worksheet to make it aesthetically pleasing and include measurement units (e.g. $)
4. Sort the data by country and by last name of salesperson within each country.
5. Create subtotals by Country showing:
a) Totals for Salary and Sales
b) Averages for Salary and Sales 6. Label the subtotals appropriately (if needed).
| Annual Sales – 2012 | ||||
| Firstname | Lastname | Country | Salary | Sales |
| Gordon | Banks | England | $85,000 | 700,950 |
| David | Beckham | England | $39,000 | 766,277 |
| Bobby | Charlton | England | $34,000 | 844,935 |
| Kevin | Keegan | England | $83,000 | 334,433 |
| Gary | Lineker | England | $23,000 | 330,707 |
| Michael | Owen | England | $40,000 | 190,508 |
| Alan | Shearer | England | $60,000 | 489,817 |
| Eric | Cantona | France | $30,000 | 419,128 |
| Marcel | Desailly | France | $42,000 | 643,445 |
| Didier | Deschamps | France | $78,000 | 232,273 |
| Just | Fontaine | France | $63,000 | 567,230 |
| Thierry | Henry | France | $61,000 | 622,240 |
| Raymond | Kopa | France | $76,000 | 822,211 |
| Jean-Pierre | Papin | France | $22,000 | 775,294 |
| Robert | Pires | France | $80,000 | 304,211 |
| Michel | Platini | France | $79,000 | 602,645 |
| Lilian | Thuram | France | $78,000 | 371,064 |
| Marius | Tresor | France | $54,000 | 590,275 |
| David | Trezeguet | France | $34,000 | 461,193 |
| Patrick | Vieira | France | $37,000 | 738,052 |
| Zinedine | Zidane | France | $33,000 | 190,037 |
| Michael | Ballack | Germany | $39,000 | 180,504 |
| Franz | Beckenbauer | Germany | $66,000 | 314,437 |
| Paul | Breitner | Germany | $20,000 | 869,937 |
| Oliver | Kahn | Germany | $56,000 | 640,261 |
| Jurgen | Klinsmann | Germany | $74,000 | 391,346 |
| Sepp | Maier | Germany | $59,000 | 256,754 |
| Lothar | Matthaeus | Germany | $71,000 | 374,572 |
| Gerd | Mueller | Germany | $71,000 | 854,398 |
| Karl-Heinz | Rummenigge | Germany | $67,000 | 626,119 |
| Uwe | Seeler | Germany | $54,000 | 665,744 |
| Customer Name | Years Purchasing | Last Year Spend | Months Since Last Purchase | Customer Reward (% Off) |
| Kate Austen | 3 | 500 | 4 | 40% |
| Juliet Burke | 1 | 1200 | 2 | 40% |
| Michael Dawson | 2 | 200 | 16 | 25% |
| Daniel Faraday | 0.5 | 0 | 3 | 10% |
| James Ford | 2 | 400 | 1 | 10% |
| Desmond Hume | 7 | 1400 | 5 | 40% |
| Sayid Jarrah | 0.25 | 0 | 2 | 10% |
| Jin-Soo Kwon | 3 | 125 | 6 | 40% |
| Sun-Hwa Kwon | 4 | 1200 | 2 | 40% |
| Frank Lapidus | 8 | 450 | 7 | 40% |
| Benjamin Linus | 2 | 200 | 9 | 10% |
| Ethan Rom | 7 | 0 | 24 | 40% |
| Claire Littleton | 9 | 1100 | 2 | 40% |
| John Locke | 3 | 275 | 6 | 40% |
| Charlie Pace | 1 | 0 | 14 | 25% |
| Shannon Rutherford | 4 | 300 | 14 | 40% |
| Jack Shephard | 3 | 150 | 11 | 40% |
| Libby Smith | 2 | 600 | 8 | 10% |
| Miles Straume | 1 | 300 | 15 | 25% |
| Hugo Reyes | 0.75 | 150 | 19 | 25% |
| Ilana Verdansky | 1 | 1200 | 4 | 40% |
| Richard Alpert | 2 | 600 | 22 | 25% |
| Ana Lucia Cortez | 4 | 250 | 5 | 40% |
| Charlotte Lewis | 2.5 | 540 | 4 | 40% |
| Alexandra Rousseau | 6 | 1050 | 11 | 40% |
| Region | Sales Rep | Customer | Product | Cost of Goods Sold | Sales |
| NorthEast | Rhonda | Sherman Williams | MKO Item | $1,885.71 | $4,190.46 |
| North | Luke | SoftwareFun | MME Item | $1,281.18 | $3,462.65 |
| SouthEast | Steven | Sherman Williams | OQM Item | $6,515.34 | $8,687.12 |
| MidWest | Troung | Costco | WIL Item | $815.21 | $1,381.71 |
| NorthEast | Luke | Office Depot | BJH Item | $3,387.08 | $7,526.85 |
| MidWest | Luke | Sherman Williams | ZEI Item | $1,370.55 | $2,491.91 |
| North | Steven | Yahoo | HPF Item | $87.25 | $193.88 |
| NorthEast | Jeri | Nature Company | NEE Item | $2,790.65 | $4,811.47 |
| SouthEast | Luke | Costco | CLN Item | $612.13 | $1,360.28 |
| North | Jon | The Economist | ZJS Item | $5,002.53 | $6,670.04 |
| MidWest | Rhonda | Peet’s Coffee | JYF Item | $3,931.98 | $6,779.28 |
| SouthEast | Jeri | SoftwareFun | ZLA Item | $1,101.14 | $2,976.06 |
| MidWest | Jeri | Costco | CLS Item | $6,662.83 | $7,126.02 |
| West | Rhonda | Nature Company | WHF Item | $5,162.85 | $5,521.76 |
| NorthEast | Steven | McLendon’s Hardware | VDD Item | $3,729.20 | $4,972.27 |
| MidWest | Sheliadawn | The Economist | WEW Item | $5,349.44 | $7,866.83 |
| NorthEast | Jeri | Yahoo | ICX Item | $4,085.49 | $9,078.87 |
| North | Steven | Sherman Williams | QIL Item | $2,952.36 | $3,354.96 |
| NorthEast | Rhonda | MHX Item | $2,075.59 | $3,773.80 | |
| NorthEast | Chin | Nature Company | HLL Item | $4,007.99 | $4,554.53 |
| West | Jon | Peet’s Coffee | YGP Item | $6,835.97 | $7,768.15 |
| SouthEast | Troung | Nature Company | EIS Item | $5,338.44 | $7,117.92 |
| North | Chin | Yahoo | WKL Item | $8,597.46 | $9,195.14 |
| NorthEast | Steven | Whole Foods | FZS Item | $359.26 | $619.42 |
| MidWest | Jeri | Amazon.com | LII Item | $7,221.70 | $8,206.48 |
| SouthEast | Rhonda | Peet’s Coffee | TIH Item | $4,846.16 | $5,507.00 |
| MidWest | Chin | Sherman Williams | BPZ Item | $3,148.53 | $3,577.87 |
| NorthEast | Steven | Yahoo | DKM Item | $5,385.81 | $7,181.08 |
| West | Jeri | The Economist | CDR Item | $2,335.03 | $5,430.30 |
| SouthEast | Rhonda | Office Depot | XMY Item | $2,395.25 | $6,473.64 |
| NorthEast | Steven | Yahoo | LGZ Item | $4,064.72 | $7,390.40 |
| West | Jon | The Economist | PTH Item | $1,449.15 | $2,634.81 |
| NorthEast | Steven | Whole Foods | BAN Item | $2,881.43 | $6,700.99 |
| NorthEast | Jeri | Costco | AKY Item | $1,193.47 | $1,591.29 |
| North | Troung | Costco | TTK Item | $2,963.68 | $5,023.18 |
| SouthEast | Jon | Costco | IQG Item | $116.92 | $171.94 |
| MidWest | Jon | Solar and Wind Inc. | VMC Item | $4,705.07 | $6,273.43 |
| North | Sheliadawn | Home Depot | XOU Item | $3,636.08 | $6,269.11 |
| NorthEast | Luke | Nature Company | ZMF Item | $3,251.36 | $4,335.15 |
| West | Jon | Yahoo | SHA Item | $1,934.53 | $2,198.33 |
| SouthEast | Troung | Sherman Williams | UBW Item | $1,186.64 | $2,759.63 |
| NorthEast | Sheliadawn | McLendon’s Hardware | QHO Item | $1,641.61 | $1,865.47 |
| NorthEast | Steven | Sherman Williams | OCL Item | $3,308.41 | $8,941.64 |
| North | Luke | Office Depot | VRK Item | $4,155.90 | $6,111.62 |
| MidWest | Chin | Nature Company | CSJ Item | $731.82 | $1,977.89 |
| NorthEast | Jeri | Home Depot | WPD Item | $3,140.58 | $5,414.79 |
| NorthEast | Jon | Solar and Wind Inc. | LOI Item | $2,356.68 | $4,284.88 |
| NorthEast | Sheliadawn | SoftwareFun | AIQ Item | $4,257.44 | $6,260.94 |
| MidWest | Steven | The Economist | MTL Item | $3,730.96 | $3,990.33 |
| NorthEast | Chin | Home Depot | AUW Item | $2,741.96 | $6,093.24 |
| North | Jeri | Peet’s Coffee | GHF Item | $1,575.67 | $2,864.86 |
| NorthEast | Steven | Solar and Wind Inc. | SMX Item | $4,035.88 | $6,958.42 |
| NorthEast | Rhonda | Solar and Wind Inc. | NZX Item | $725.55 | $1,229.75 |
| NorthEast | Chin | Amazon.com | KEI Item | $3,491.87 | $8,120.63 |
| North | Troung | Solar and Wind Inc. | GMO Item | $5,590.28 | $7,453.70 |
| SouthEast | Steven | Home Depot | DRK Item | $2,266.80 | $5,271.62 |
| NorthEast | Sheliadawn | Sherman Williams | ONY Item | $272.13 | $604.74 |
| West | Jon | Office Depot | XOU Item | $5,848.91 | $7,798.55 |
| NorthEast | Troung | Yahoo | XLN Item | $1,155.08 | $3,121.84 |
| NorthEast | Rhonda | Office Depot | XZI Item | $4,217.72 | $9,808.64 |
| NorthEast | Sheliadawn | Costco | RGS Item | $1,365.32 | $1,551.50 |
| SouthEast | Jon | Nature Company | BYE Item | $4,482.80 | $6,592.35 |
| MidWest | Chin | Whole Foods | FKD Item | $2,924.24 | $6,800.55 |
| NorthEast | Rhonda | The Economist | DIO Item | $4,246.57 | $4,541.79 |
| NorthEast | Luke | Solar and Wind Inc. | MQW Item | $92.28 | $135.70 |
| West | Rhonda | Amazon.com | PEN Item | $1,701.14 | $3,780.32 |
| MidWest | Jeri | PNA Item | $2,070.56 | $5,596.10 | |
| MidWest | Chin | SoftwareFun | MWN Item | $6,305.00 | $9,272.06 |
| NorthEast | Troung | Home Depot | BSV Item | $5,085.13 | $8,618.86 |
| NorthEast | Jeri | Yahoo | KDX Item | $1,231.80 | $2,737.33 |
| West | Sheliadawn | Whole Foods | MFB Item | $1,174.98 | $2,611.06 |
| NorthEast | Jon | Office Depot | JYF Item | $1,210.34 | $1,613.79 |
| North | Sheliadawn | IAF Item | $1,908.55 | $2,544.73 | |
| NorthEast | Jon | Sherman Williams | OYO Item | $836.18 | $1,520.32 |
| SouthEast | Steven | Costco | XLF Item | $1,798.34 | $2,043.57 |
| West | Chin | Yahoo | HAI Item | $2,640.13 | $4,800.24 |
| NorthEast | Troung | Office Depot | IKV Item | $4,949.54 | $6,599.38 |
| NorthEast | Steven | The Economist | III Item | $5,843.45 | $6,249.68 |
| North | Steven | FPO Item | $1,518.20 | $2,024.27 | |
| North | Troung | PXE Item | $7,327.08 | $9,769.44 | |
| North | Rhonda | Home Depot | KFE Item | $1,297.01 | $2,236.23 |
| NorthEast | Troung | KKL Item | $1,775.08 | $4,797.50 | |
| North | Luke | Home Depot | LFD Item | $3,413.63 | $9,226.02 |
| MidWest | Troung | McLendon’s Hardware | RRT Item | $2,442.52 | $6,601.40 |
| NorthEast | Jon | Amazon.com | YQS Item | $1,479.24 | $3,287.19 |
| North | Chin | WPF Item | $2,401.73 | $6,491.17 | |
| SouthEast | Troung | Whole Foods | ZMY Item | $3,234.28 | $8,741.30 |
| North | Jeri | SoftwareFun | KPY Item | $8,446.46 | $9,598.25 |
| North | Rhonda | Solar and Wind Inc. | XFU Item | $969.04 | $2,253.57 |
| NorthEast | Sheliadawn | Sherman Williams | SBX Item | $3,281.54 | $3,729.02 |
| MidWest | Steven | McLendon’s Hardware | LXS Item | $6,385.73 | $6,829.66 |
| NorthEast | Luke | The Economist | JTV Item | $1,731.35 | $2,985.09 |
| SouthEast | Jeri | Solar and Wind Inc. | RCE Item | $3,730.50 | $6,431.90 |
| SouthEast | Rhonda | Nature Company | XWP Item | $3,154.71 | $5,346.96 |
| NorthEast | Steven | Yahoo | WPE Item | $5,394.15 | $9,300.25 |
| MidWest | Jon | SoftwareFun | NBK Item | $167.96 | $390.61 |
| SouthEast | Jon | Solar and Wind Inc. | VIN Item | $5,876.59 | $9,960.33 |
| SouthEast | Jon | Whole Foods | MSH Item | $6,820.56 | $9,094.08 |
| NorthEast | Sheliadawn | Sherman Williams | JZO Item | $6,575.61 | $8,767.48 |
| NorthEast | Troung | SoftwareFun | YTX Item | $4,906.63 | $8,921.14 |
| North | Chin | Home Depot | FEK Item | $1,531.21 | $3,560.96 |
| North | Chin | Sherman Williams | XNB Item | $3,464.64 | $6,299.34 |
| NorthEast | Chin | Costco | YWP Item | $558.25 | $1,298.25 |
| NorthEast | Jeri | Costco | FSJ Item | $4,647.29 | $8,449.61 |
| West | Jon | NWT Item | $1,768.95 | $3,049.92 | |
| NorthEast | Luke | Yahoo | MOQ Item | $4,595.21 | $8,354.92 |
| North | Rhonda | Nature Company | OAP Item | $2,666.14 | $7,205.78 |
| West | Chin | Amazon.com | LOP Item | $266.30 | $451.36 |
| SouthEast | Chin | Peet’s Coffee | UXD Item | $2,647.43 | $4,564.54 |
| West | Jon | Nature Company | EWM Item | $1,805.73 | $4,880.35 |
| NorthEast | Chin | Costco | TGL Item | $58.76 | $158.81 |
| North | Chin | Yahoo | RCA Item | $1,904.67 | $3,228.26 |
| SouthEast | Sheliadawn | The Economist | CRF Item | $5,399.02 | $9,308.65 |
| NorthEast | Jeri | SoftwareFun | NCN Item | $1,522.32 | $3,382.93 |
| West | Rhonda | Sherman Williams | THO Item | $4,832.69 | $8,786.70 |
| West | Jeri | Whole Foods | FXL Item | $677.31 | $1,167.78 |
| NorthEast | Luke | TTM Item | $203.69 | $271.58 | |
| West | Jeri | Costco | KVL Item | $627.28 | $1,393.96 |
| North | Steven | SoftwareFun | MGO Item | $2,464.91 | $4,481.65 |
| North | Steven | The Economist | RDD Item | $1,980.14 | $2,640.18 |
| North | Chin | Yahoo | AIL Item | $1,142.98 | $2,658.10 |
| NorthEast | Chin | Amazon.com | SVF Item | $947.64 | $2,203.81 |
| NorthEast | Steven | Costco | RGD Item | $4,276.92 | $9,946.32 |
| North | Jeri | The Economist | KWJ Item | $5,832.41 | $7,776.55 |
| NorthEast | Rhonda | The Economist | FFT Item | $7,012.77 | $7,500.29 |
| West | Jon | Office Depot | UBV Item | $18.07 | $31.16 |
| MidWest | Luke | Whole Foods | NSN Item | $8,615.62 | $9,790.48 |
| West | Luke | Costco | JUE Item | $1,117.50 | $1,894.07 |
| NorthEast | Troung | Office Depot | CMU Item | $5,412.79 | $7,959.98 |
| NorthEast | Steven | Amazon.com | GYH Item | $2,280.17 | $3,353.19 |
| NorthEast | Sheliadawn | Yahoo | SCW Item | $2,237.46 | $3,792.31 |
| West | Jeri | Office Depot | RTF Item | $1,259.07 | $2,928.08 |
| NorthEast | Luke | The Economist | XZF Item | $1,950.30 | $4,334.01 |
| NorthEast | Sheliadawn | Peet’s Coffee | GLG Item | $3,446.42 | $8,014.94 |
| North | Jon | Costco | MYE Item | $3,330.01 | $7,400.03 |
| MidWest | Troung | McLendon’s Hardware | EVO Item | $9,189.78 | $9,828.64 |
| MidWest | Luke | Home Depot | YHI Item | $3,418.54 | $6,215.52 |
| North | Steven | Office Depot | HKD Item | $4,911.25 | $5,252.67 |
| NorthEast | Steven | Nature Company | GYK Item | $1,864.67 | $2,742.16 |
| West | Troung | Solar and Wind Inc. | PUA Item | $2,050.45 | $3,535.25 |
| West | Sheliadawn | McLendon’s Hardware | NGZ Item | $644.47 | $1,092.32 |
| NorthEast | Troung | McLendon’s Hardware | BJI Item | $105.40 | $284.87 |
| MidWest | Jeri | Solar and Wind Inc. | HGT Item | $3,639.02 | $4,852.02 |
| MidWest | Sheliadawn | Nature Company | KKF Item | $3,344.00 | $7,431.10 |
| West | Rhonda | Whole Foods | EFD Item | $45.01 | $81.83 |
| SouthEast | Steven | Home Depot | UPA Item | $7,054.78 | $8,016.79 |
| NorthEast | Jeri | Whole Foods | FPN Item | $1,855.42 | $5,014.65 |
| North | Rhonda | Solar and Wind Inc. | SNK Item | $2,173.22 | $3,683.42 |
| NorthEast | Jeri | Office Depot | HOQ Item | $5,300.66 | $5,669.16 |
| SouthEast | Jon | Nature Company | KHA Item | $1,191.24 | $2,053.87 |
| NorthEast | Troung | Office Depot | FZY Item | $331.15 | $895.01 |
| North | Luke | Whole Foods | SRN Item | $4,662.30 | $6,856.33 |
| West | Troung | SoftwareFun | AEW Item | $4,760.79 | $8,208.26 |
| MidWest | Chin | Solar and Wind Inc. | PET Item | $3,504.65 | $8,150.36 |
| NorthEast | Troung | The Economist | EYP Item | $2,705.44 | $4,664.56 |
| West | Sheliadawn | Solar and Wind Inc. | PKE Item | $7,137.56 | $9,516.74 |
| West | Luke | Solar and Wind Inc. | CCV Item | $1,205.93 | $1,773.42 |
| MidWest | Luke | Whole Foods | YNQ Item | $3,185.71 | $8,610.02 |
| North | Jeri | Sherman Williams | KGM Item | $4,699.11 | $5,339.90 |
| NorthEast | Sheliadawn | Sherman Williams | HMW Item | $5,011.17 | $7,369.37 |
| West | Jon | The Economist | TGO Item | $2,674.61 | $4,533.23 |
| MidWest | Troung | Costco | KXJ Item | $4,501.76 | $6,002.34 |
| West | Rhonda | Costco | FSD Item | $3,806.21 | $8,851.64 |
| NorthEast | Jeri | Sherman Williams | SSU Item | $1,323.12 | $2,242.57 |
| North | Troung | Costco | NFU Item | $234.09 | $266.01 |
| West | Rhonda | Peet’s Coffee | UMN Item | $1,724.03 | $2,972.47 |
| NorthEast | Chin | McLendon’s Hardware | TMF Item | $1,660.48 | $4,487.79 |
| SouthEast | Chin | Sherman Williams | YVD Item | $3,605.87 | $6,111.65 |
| SouthEast | Jeri | Sherman Williams | MJG Item | $2,704.59 | $3,073.40 |
| West | Sheliadawn | The Economist | KQN Item | $1,622.29 | $4,384.57 |
| North | Rhonda | McLendon’s Hardware | WBN Item | $892.65 | $1,312.72 |
| West | Chin | Costco | CNG Item | $1,735.73 | $1,856.40 |
| West | Troung | Amazon.com | YHA Item | $114.45 | $254.34 |
| NorthEast | Jeri | Yahoo | HVH Item | $1,264.48 | $2,143.19 |
| MidWest | Jon | Whole Foods | ILP Item | $2,982.53 | $5,422.79 |
| West | Jon | Solar and Wind Inc. | HGQ Item | $249.38 | $366.74 |
| North | Sheliadawn | Home Depot | BPJ Item | $730.54 | $1,238.20 |
| NorthEast | Sheliadawn | Yahoo | ONK Item | $2,647.84 | $5,884.09 |
| West | Jeri | Costco | UYR Item | $3,188.92 | $7,416.09 |
| NorthEast | Jon | Nature Company | EZU Item | $607.65 | $1,047.67 |
| West | Jeri | Office Depot | MEL Item | $8,814.57 | $9,427.35 |
| West | Luke | Yahoo | UCA Item | $1,267.40 | $2,304.36 |
| SouthEast | Sheliadawn | Whole Foods | NEE Item | $4,351.80 | $7,375.94 |
| NorthEast | Sheliadawn | Whole Foods | KNX Item | $4,231.46 | $7,693.57 |
| NorthEast | Sheliadawn | Nature Company | PBH Item | $5,217.19 | $5,928.62 |
| MidWest | Chin | Yahoo | CVY Item | $4,445.83 | $7,665.23 |
| NorthEast | Sheliadawn | Peet’s Coffee | QGM Item | $5,643.75 | $9,565.67 |
| North | Jeri | Nature Company | ILH Item | $4,854.34 | $7,138.73 |
| MidWest | Steven | Solar and Wind Inc. | QPM Item | $2,645.06 | $5,877.92 |
| West | Luke | ETU Item | $4,341.18 | $7,357.93 | |
| NorthEast | Troung | Amazon.com | CNH Item | $4,467.84 | $6,570.35 |
| NorthEast | Jon | SoftwareFun | YIP Item | $4,494.45 | $9,987.66 |
| MidWest | Luke | Office Depot | WVS Item | $1,455.00 | $2,645.45 |
| NorthEast | Jon | Office Depot | EIE Item | $2,212.82 | $5,146.10 |
| SouthEast | Luke | Amazon.com | AIM Item | $3,641.63 | $6,278.68 |
| NorthEast | Luke | SoftwareFun | HAK Item | $640.66 | $1,085.87 |
| NorthEast | Luke | Nature Company | BCD Item | $563.56 | $1,024.66 |
| North | Sheliadawn | Nature Company | NCH Item | $5,047.35 | $5,398.23 |
| NorthEast | Jeri | Yahoo | JKT Item | $1,559.50 | $3,626.74 |
| NorthEast | Rhonda | Costco | IWN Item | $5,331.83 | $5,702.49 |
| West | Chin | The Economist | KYW Item | $3,119.56 | $7,254.79 |
| MidWest | Rhonda | Peet’s Coffee | ITT Item | $2,317.30 | $3,407.80 |
| SouthEast | Jeri | Home Depot | JHF Item | $15.06 | $22.15 |
| NorthEast | Luke | Yahoo | CNN Item | $4,357.25 | $5,809.66 |
| MidWest | Rhonda | Costco | MKA Item | $944.41 | $2,552.46 |
| MidWest | Troung | The Economist | KFB Item | $4,976.28 | $8,434.37 |
| North | Steven | The Economist | XIM Item | $2,510.19 | $5,837.66 |
| MidWest | Sheliadawn | Yahoo | VGE Item | $844.62 | $903.34 |
| MidWest | Jon | WWB Item | $1,936.76 | $2,582.35 | |
| West | Chin | SoftwareFun | RHM Item | $890.87 | $2,071.80 |
| SouthEast | Troung | ZQH Item | $2,637.42 | $2,820.77 | |
| West | Troung | McLendon’s Hardware | EUH Item | $196.46 | $456.88 |
| North | Chin | SoftwareFun | FMP Item | $2,672.18 | $4,858.51 |
| NorthEast | Rhonda | Peet’s Coffee | LVG Item | $3,671.58 | $6,330.31 |
| West | Jeri | Costco | WKC Item | $1,721.55 | $4,003.61 |
| West | Steven | Home Depot | EAP Item | $3,695.77 | $9,988.56 |
| NorthEast | Luke | Yahoo | LVD Item | $241.66 | $322.21 |
| MidWest | Rhonda | The Economist | QSA Item | $6,032.36 | $6,451.72 |
| West | Chin | Whole Foods | JLK Item | $5,224.19 | $5,587.37 |
| West | Troung | SoftwareFun | XBY Item | $2,350.46 | $4,052.52 |
| NorthEast | Troung | The Economist | GAK Item | $345.52 | $585.62 |
| NorthEast | Troung | Yahoo | SQZ Item | $5,717.91 | $9,691.38 |
| SouthEast | Steven | UWT Item | $246.18 | $572.52 | |
| NorthEast | Jeri | McLendon’s Hardware | POX Item | $4,025.11 | $4,573.99 |
| NorthEast | Jon | Solar and Wind Inc. | JZS Item | $2,764.40 | $4,766.20 |
| SouthEast | Steven | Amazon.com | MPS Item | $6,892.16 | $9,189.55 |
| MidWest | Rhonda | The Economist | EYG Item | $3,918.36 | $4,452.68 |
| SouthEast | Steven | McLendon’s Hardware | ACF Item | $3,479.96 | $3,954.50 |
| MidWest | Luke | Solar and Wind Inc. | XVI Item | $4,250.16 | $7,327.87 |
| NorthEast | Steven | Whole Foods | ZCL Item | $4,549.04 | $7,710.23 |
| West | Jeri | Yahoo | UAD Item | $758.70 | $1,115.73 |
| SouthEast | Jon | PQT Item | $1,707.81 | $4,615.71 | |
| NorthEast | Chin | Yahoo | JXK Item | $3,621.75 | $9,788.51 |
| NorthEast | Rhonda | Costco | VCN Item | $2,991.77 | $3,989.02 |
| NorthEast | Jeri | McLendon’s Hardware | EQL Item | $1,385.90 | $3,079.77 |
| West | Troung | SoftwareFun | KPO Item | $426.48 | $991.81 |
| SouthEast | Jon | The Economist | XHR Item | $4,271.12 | $7,364.00 |
| West | Sheliadawn | McLendon’s Hardware | JGS Item | $3,107.28 | $7,226.23 |
| MidWest | Luke | Solar and Wind Inc. | ZFB Item | $3,396.25 | $9,179.05 |
| MidWest | Sheliadawn | Costco | TBQ Item | $3,970.29 | $9,233.24 |
| MidWest | Jon | Yahoo | IAG Item | $5,988.93 | $7,985.24 |
| SouthEast | Jon | Costco | UGN Item | $1,503.71 | $2,004.95 |
| SouthEast | Steven | SoftwareFun | AWF Item | $6,417.66 | $9,437.74 |
| NorthEast | Chin | Nature Company | WLY Item | $819.24 | $1,204.76 |
| West | Chin | Sherman Williams | BNH Item | $3,978.63 | $5,850.92 |
| North | Steven | Whole Foods | TYZ Item | $2,542.44 | $5,912.65 |
| MidWest | Chin | Whole Foods | STR Item | $4,421.19 | $7,493.55 |
| NorthEast | Chin | Solar and Wind Inc. | KST Item | $1,232.27 | $1,643.02 |
| NorthEast | Chin | The Economist | VBF Item | $1,441.14 | $2,442.61 |
| West | Jeri | The Economist | HEB Item | $4,592.57 | $6,123.43 |
| MidWest | Jon | Yahoo | FLS Item | $3,664.68 | $8,143.73 |
| West | Rhonda | Costco | JUV Item | $2,790.27 | $6,200.59 |
| MidWest | Jon | Peet’s Coffee | LRH Item | $500.89 | $1,353.75 |
| MidWest | Chin | Costco | VYV Item | $3,545.62 | $3,792.11 |
| NorthEast | Sheliadawn | Costco | WWD Item | $1,528.84 | $2,779.70 |
| West | Chin | Sherman Williams | OLN Item | $666.74 | $1,149.56 |
| North | Jeri | Amazon.com | BZE Item | $3,249.56 | $3,475.47 |
| NorthEast | Troung | Whole Foods | EHO Item | $1,251.69 | $2,121.50 |
| SouthEast | Troung | Sherman Williams | GPQ Item | $6,549.87 | $7,005.21 |
| West | Chin | Solar and Wind Inc. | VPY Item | $712.93 | $1,296.23 |
| North | Steven | Nature Company | OGH Item | $2,116.40 | $4,921.86 |
| West | Luke | Solar and Wind Inc. | VDA Item | $2,944.10 | $4,990.00 |
| West | Chin | Peet’s Coffee | EYP Item | $4,665.41 | $4,989.74 |
| MidWest | Jeri | Nature Company | XKR Item | $3,708.54 | $4,944.72 |
| West | Chin | The Economist | AYF Item | $3,119.09 | $3,335.92 |
| North | Sheliadawn | Nature Company | HQT Item | $4,756.44 | $6,994.77 |
| North | Chin | Yahoo | VNQ Item | $969.23 | $1,762.24 |
| NorthEast | Jeri | WBL Item | $4,714.63 | $7,990.90 | |
| NorthEast | Rhonda | Sherman Williams | SWQ Item | $4,295.72 | $9,990.04 |
| MidWest | Rhonda | Yahoo | FZK Item | $4,145.58 | $7,026.41 |
| North | Sheliadawn | Solar and Wind Inc. | PUD Item | $3,827.04 | $8,504.53 |
| North | Jeri | Nature Company | YIV Item | $916.59 | $1,222.12 |
| West | Sheliadawn | Nature Company | IYT Item | $1,390.59 | $1,487.26 |
| SouthEast | Luke | Home Depot | KBY Item | $2,935.04 | $4,316.23 |
| NorthEast | Steven | Whole Foods | VYM Item | $2,420.96 | $6,543.14 |
| NorthEast | Troung | DVC Item | $3,411.56 | $3,648.73 | |
| MidWest | Jon | Nature Company | QDA Item | $5,395.13 | $9,809.32 |
| NorthEast | Jon | Home Depot | MQP Item | $4,296.41 | $7,407.61 |
| MidWest | Jeri | Solar and Wind Inc. | GLY Item | $5,352.97 | $6,082.92 |
| North | Troung | Amazon.com | PJA Item | $682.21 | $1,240.38 |
| SouthEast | Jeri | McLendon’s Hardware | OGB Item | $450.47 | $763.51 |
| SouthEast | Sheliadawn | QBL Item | $862.86 | $2,006.65 | |
| NorthEast | Jon | Costco | ATV Item | $2,880.90 | $3,273.75 |
| NorthEast | Chin | Sherman Williams | LEO Item | $3,132.68 | $7,285.31 |
| NorthEast | Sheliadawn | SoftwareFun | JFF Item | $3,565.93 | $8,292.86 |
| NorthEast | Luke | Solar and Wind Inc. | ULJ Item | $3,442.43 | $5,834.62 |
| NorthEast | Troung | Costco | WCX Item | $1,182.05 | $3,194.72 |
| NorthEast | Jon | Costco | UZP Item | $526.08 | $891.66 |
| MidWest | Jon | Solar and Wind Inc. | UDH Item | $6,619.97 | $9,735.25 |
| MidWest | Steven | Yahoo | WIP Item | $3,075.82 | $5,592.40 |
| NorthEast | Jon | QJV Item | $1,835.90 | $3,165.34 | |
| SouthEast | Chin | Office Depot | ICN Item | $605.97 | $1,101.77 |
| West | Troung | SoftwareFun | YGD Item | $2,226.95 | $2,530.62 |
| MidWest | Sheliadawn | SoftwareFun | LCU Item | $3,976.60 | $4,518.86 |
| SouthEast | Chin | Costco | LFI Item | $3,410.24 | $7,578.32 |
| West | Rhonda | Office Depot | BUZ Item | $4,355.79 | $7,382.70 |
| MidWest | Rhonda | Office Depot | FPF Item | $3,381.07 | $9,138.04 |
| West | Troung | ZAW Item | $2,878.68 | $6,397.07 | |
| West | Jeri | Nature Company | GVD Item | $1,854.61 | $4,313.04 |
| SouthEast | Luke | Peet’s Coffee | ENW Item | $3,438.09 | $5,927.74 |
| NorthEast | Jon | Nature Company | KVA Item | $1,070.95 | $1,815.17 |
| SouthEast | Rhonda | Solar and Wind Inc. | UVO Item | $3,345.55 | $4,919.93 |
| West | Rhonda | UNH Item | $2,727.48 | $3,636.64 | |
| NorthEast | Jeri | Yahoo | VTW Item | $2,204.46 | $4,898.81 |
| NorthEast | Rhonda | Whole Foods | UDS Item | $3,354.58 | $3,812.02 |
| West | Steven | McLendon’s Hardware | WMW Item | $4,341.22 | $7,484.87 |
| West | Rhonda | Yahoo | QTS Item | $3,138.51 | $7,298.86 |
| West | Rhonda | Yahoo | CJK Item | $4,675.34 | $8,500.61 |
| West | Rhonda | Home Depot | WWU Item | $3,043.75 | $3,255.35 |
| North | Troung | SoftwareFun | WJP Item | $2,596.21 | $5,769.35 |
| NorthEast | Rhonda | McLendon’s Hardware | IZV Item | $6,050.41 | $8,897.66 |
| North | Luke | Solar and Wind Inc. | EXM Item | $5,754.94 | $9,754.13 |
| West | Steven | Yahoo | MQT Item | $3,266.35 | $3,711.76 |
| NorthEast | Sheliadawn | Home Depot | XYL Item | $4,638.92 | $6,821.94 |
| SouthEast | Jeri | Sherman Williams | QGI Item | $4,345.09 | $7,491.54 |
| MidWest | Steven | Sherman Williams | ILS Item | $1,461.23 | $3,949.28 |
| MidWest | Jeri | Home Depot | GPH Item | $4,442.32 | $5,923.09 |
| North | Steven | XXH Item | $610.90 | $898.38 | |
| MidWest | Rhonda | The Economist | DNA Item | $6,349.59 | $7,215.44 |
| SouthEast | Troung | Office Depot | YIT Item | $3,219.61 | $8,701.64 |
| SouthEast | Jeri | The Economist | MKP Item | $447.89 | $658.66 |
| NorthEast | Steven | Peet’s Coffee | BTJ Item | $4,431.12 | $7,639.86 |
| MidWest | Chin | Amazon.com | WXR Item | $2,714.01 | $4,600.01 |
| NorthEast | Jeri | Solar and Wind Inc. | LII Item | $2,339.48 | $2,658.50 |
| MidWest | Rhonda | Home Depot | RFR Item | $1,074.69 | $2,904.57 |
| NorthEast | Rhonda | Home Depot | EAR Item | $4,384.42 | $9,743.15 |
| SouthEast | Troung | Costco | KJV Item | $9,318.96 | $9,966.80 |
| NorthEast | Chin | Yahoo | PUJ Item | $3,407.48 | $6,195.41 |
| MidWest | Sheliadawn | McLendon’s Hardware | NIV Item | $5,180.14 | $7,617.85 |
| NorthEast | Jeri | Amazon.com | AIZ Item | $627.94 | $923.44 |
| MidWest | Luke | Costco | QDR Item | $3,978.19 | $6,858.94 |
| NorthEast | Jeri | Amazon.com | AHN Item | $5,927.72 | $6,736.05 |
| West | Jeri | SoftwareFun | AIU Item | $3,845.55 | $6,991.91 |
| MidWest | Chin | Costco | QRV Item | $2,674.67 | $4,863.04 |
| West | Jeri | Solar and Wind Inc. | FVF Item | $782.59 | $1,739.09 |
| NorthEast | Sheliadawn | McLendon’s Hardware | HUO Item | $2,306.57 | $6,233.97 |
| NorthEast | Rhonda | SoftwareFun | ZAH Item | $5,841.59 | $6,638.17 |
| MidWest | Steven | Home Depot | SXT Item | $7,371.44 | $9,828.59 |
| NorthEast | Steven | Home Depot | DRO Item | $4,764.98 | $8,215.49 |
| NorthEast | Rhonda | Nature Company | ESJ Item | $5,269.95 | $9,581.72 |
| MidWest | Luke | SoftwareFun | YAK Item | $5,245.71 | $5,610.38 |
| North | Luke | Sherman Williams | RYV Item | $6,159.04 | $9,057.41 |
| NorthEast | Troung | Office Depot | PAY Item | $3,795.61 | $6,433.23 |
| North | Troung | SoftwareFun | GHH Item | $7,657.57 | $8,701.78 |
| North | Jon | The Economist | TLQ Item | $2,084.69 | $5,634.31 |
| NorthEast | Troung | Office Depot | TUL Item | $2,918.63 | $6,485.84 |
| North | Jeri | Home Depot | NJY Item | $54.29 | $126.25 |
| NorthEast | Jeri | Peet’s Coffee | QLL Item | $1,319.85 | $2,399.72 |
| NorthEast | Jeri | The Economist | KSG Item | $649.50 | $1,180.91 |
| Date | Region | Sales Rep | Customer | Product | Cost of Goods Sold | Sales |
| 3/1/2006 | NorthEast | Rhonda | Sherman Williams | MKO Item | $1,885.71 | $4,190.46 |
| 8/3/2004 | North | Luke | SoftwareFun | MME Item | $1,281.18 | $3,462.65 |
| 5/24/2005 | SouthEast | Steven | Sherman Williams | OQM Item | $6,515.34 | $8,687.12 |
| 10/15/2005 | MidWest | Troung | Costco | WIL Item | $815.21 | $1,381.71 |
| 6/7/2005 | NorthEast | Luke | Office Depot | BJH Item | $3,387.08 | $7,526.85 |
| 8/9/2004 | MidWest | Luke | Sherman Williams | ZEI Item | $1,370.55 | $2,491.91 |
| 5/27/2006 | North | Steven | Yahoo | HPF Item | $87.25 | $193.88 |
| 1/20/2006 | NorthEast | Jeri | Nature Company | NEE Item | $2,790.65 | $4,811.47 |
| 10/20/2005 | SouthEast | Luke | Costco | CLN Item | $612.13 | $1,360.28 |
| 1/25/2005 | North | Jon | The Economist | ZJS Item | $5,002.53 | $6,670.04 |
| 8/30/2004 | MidWest | Rhonda | Peet’s Coffee | JYF Item | $3,931.98 | $6,779.28 |
| 9/21/2004 | SouthEast | Jeri | SoftwareFun | ZLA Item | $1,101.14 | $2,976.06 |
| 10/2/2004 | MidWest | Jeri | Costco | CLS Item | $6,662.83 | $7,126.02 |
| 2/3/2005 | West | Rhonda | Nature Company | WHF Item | $5,162.85 | $5,521.76 |
| 8/29/2004 | NorthEast | Steven | McLendon’s Hardware | VDD Item | $3,729.20 | $4,972.27 |
| 8/28/2005 | MidWest | Sheliadawn | The Economist | WEW Item | $5,349.44 | $7,866.83 |
| 12/17/2004 | NorthEast | Jeri | Yahoo | ICX Item | $4,085.49 | $9,078.87 |
| 5/1/2005 | North | Steven | Sherman Williams | QIL Item | $2,952.36 | $3,354.96 |
| 5/3/2006 | NorthEast | Rhonda | MHX Item | $2,075.59 | $3,773.80 | |
| 4/5/2005 | NorthEast | Chin | Nature Company | HLL Item | $4,007.99 | $4,554.53 |
| 12/2/2004 | West | Jon | Peet’s Coffee | YGP Item | $6,835.97 | $7,768.15 |
| 12/30/2005 | SouthEast | Troung | Nature Company | EIS Item | $5,338.44 | $7,117.92 |
| 10/21/2005 | North | Chin | Yahoo | WKL Item | $8,597.46 | $9,195.14 |
| 12/29/2005 | NorthEast | Steven | Whole Foods | FZS Item | $359.26 | $619.42 |
| 12/16/2004 | MidWest | Jeri | Amazon.com | LII Item | $7,221.70 | $8,206.48 |
| 3/14/2006 | SouthEast | Rhonda | Peet’s Coffee | TIH Item | $4,846.16 | $5,507.00 |
| 1/25/2005 | MidWest | Chin | Sherman Williams | BPZ Item | $3,148.53 | $3,577.87 |
| 10/9/2004 | NorthEast | Steven | Yahoo | DKM Item | $5,385.81 | $7,181.08 |
| 12/16/2004 | West | Jeri | The Economist | CDR Item | $2,335.03 | $5,430.30 |
| 10/13/2005 | SouthEast | Rhonda | Office Depot | XMY Item | $2,395.25 | $6,473.64 |
| 12/23/2004 | NorthEast | Steven | Yahoo | LGZ Item | $4,064.72 | $7,390.40 |
| 1/1/2005 | West | Jon | The Economist | PTH Item | $1,449.15 | $2,634.81 |
| 8/4/2005 | NorthEast | Steven | Whole Foods | BAN Item | $2,881.43 | $6,700.99 |
| 11/19/2005 | NorthEast | Jeri | Costco | AKY Item | $1,193.47 | $1,591.29 |
| 12/31/2005 | North | Troung | Costco | TTK Item | $2,963.68 | $5,023.18 |
| 2/19/2005 | SouthEast | Jon | Costco | IQG Item | $116.92 | $171.94 |
| 10/28/2005 | MidWest | Jon | Solar and Wind Inc. | VMC Item | $4,705.07 | $6,273.43 |
| 5/20/2005 | North | Sheliadawn | Home Depot | XOU Item | $3,636.08 | $6,269.11 |
| 9/15/2005 | NorthEast | Luke | Nature Company | ZMF Item | $3,251.36 | $4,335.15 |
| 4/6/2006 | West | Jon | Yahoo | SHA Item | $1,934.53 | $2,198.33 |
| 4/27/2006 | SouthEast | Troung | Sherman Williams | UBW Item | $1,186.64 | $2,759.63 |
| 7/21/2005 | NorthEast | Sheliadawn | McLendon’s Hardware | QHO Item | $1,641.61 | $1,865.47 |
| 3/17/2006 | NorthEast | Steven | Sherman Williams | OCL Item | $3,308.41 | $8,941.64 |
| 4/7/2005 | North | Luke | Office Depot | VRK Item | $4,155.90 | $6,111.62 |
| 4/21/2005 | MidWest | Chin | Nature Company | CSJ Item | $731.82 | $1,977.89 |
| 12/11/2005 | NorthEast | Jeri | Home Depot | WPD Item | $3,140.58 | $5,414.79 |
| 3/6/2006 | NorthEast | Jon | Solar and Wind Inc. | LOI Item | $2,356.68 | $4,284.88 |
| 12/7/2005 | NorthEast | Sheliadawn | SoftwareFun | AIQ Item | $4,257.44 | $6,260.94 |
| 7/9/2005 | MidWest | Steven | The Economist | MTL Item | $3,730.96 | $3,990.33 |
| 3/1/2005 | NorthEast | Chin | Home Depot | AUW Item | $2,741.96 | $6,093.24 |
| 9/17/2005 | North | Jeri | Peet’s Coffee | GHF Item | $1,575.67 | $2,864.86 |
| 1/28/2005 | NorthEast | Steven | Solar and Wind Inc. | SMX Item | $4,035.88 | $6,958.42 |
| 1/9/2006 | NorthEast | Rhonda | Solar and Wind Inc. | NZX Item | $725.55 | $1,229.75 |
| 3/15/2005 | NorthEast | Chin | Amazon.com | KEI Item | $3,491.87 | $8,120.63 |
| 9/26/2005 | North | Troung | Solar and Wind Inc. | GMO Item | $5,590.28 | $7,453.70 |
| 2/17/2005 | SouthEast | Steven | Home Depot | DRK Item | $2,266.80 | $5,271.62 |
| 5/16/2006 | NorthEast | Sheliadawn | Sherman Williams | ONY Item | $272.13 | $604.74 |
| 12/19/2005 | West | Jon | Office Depot | XOU Item | $5,848.91 | $7,798.55 |
| 10/7/2004 | NorthEast | Troung | Yahoo | XLN Item | $1,155.08 | $3,121.84 |
| 8/19/2005 | NorthEast | Rhonda | Office Depot | XZI Item | $4,217.72 | $9,808.64 |
| 10/5/2005 | NorthEast | Sheliadawn | Costco | RGS Item | $1,365.32 | $1,551.50 |
| 8/30/2004 | SouthEast | Jon | Nature Company | BYE Item | $4,482.80 | $6,592.35 |
| 2/18/2005 | MidWest | Chin | Whole Foods | FKD Item | $2,924.24 | $6,800.55 |
| 5/18/2006 | NorthEast | Rhonda | The Economist | DIO Item | $4,246.57 | $4,541.79 |
| 12/12/2005 | NorthEast | Luke | Solar and Wind Inc. | MQW Item | $92.28 | $135.70 |
| 3/8/2006 | West | Rhonda | Amazon.com | PEN Item | $1,701.14 | $3,780.32 |
| 1/9/2006 | MidWest | Jeri | PNA Item | $2,070.56 | $5,596.10 | |
| 6/17/2004 | MidWest | Chin | SoftwareFun | MWN Item | $6,305.00 | $9,272.06 |
| 2/16/2005 | NorthEast | Troung | Home Depot | BSV Item | $5,085.13 | $8,618.86 |
| 4/4/2006 | NorthEast | Jeri | Yahoo | KDX Item | $1,231.80 | $2,737.33 |
| 4/3/2005 | West | Sheliadawn | Whole Foods | MFB Item | $1,174.98 | $2,611.06 |
| 7/17/2004 | NorthEast | Jon | Office Depot | JYF Item | $1,210.34 | $1,613.79 |
| 7/15/2005 | North | Sheliadawn | IAF Item | $1,908.55 | $2,544.73 | |
| 7/2/2004 | NorthEast | Jon | Sherman Williams | OYO Item | $836.18 | $1,520.32 |
| 10/24/2005 | SouthEast | Steven | Costco | XLF Item | $1,798.34 | $2,043.57 |
| 12/5/2004 | West | Chin | Yahoo | HAI Item | $2,640.13 | $4,800.24 |
| 6/16/2005 | NorthEast | Troung | Office Depot | IKV Item | $4,949.54 | $6,599.38 |
| 8/27/2005 | NorthEast | Steven | The Economist | III Item | $5,843.45 | $6,249.68 |
| 12/6/2005 | North | Steven | FPO Item | $1,518.20 | $2,024.27 | |
| 9/1/2005 | North | Troung | PXE Item | $7,327.08 | $9,769.44 | |
| 2/6/2006 | North | Rhonda | Home Depot | KFE Item | $1,297.01 | $2,236.23 |
| 5/2/2006 | NorthEast | Troung | KKL Item | $1,775.08 | $4,797.50 | |
| 12/11/2004 | North | Luke | Home Depot | LFD Item | $3,413.63 | $9,226.02 |
| 5/18/2006 | MidWest | Troung | McLendon’s Hardware | RRT Item | $2,442.52 | $6,601.40 |
| 12/9/2005 | NorthEast | Jon | Amazon.com | YQS Item | $1,479.24 | $3,287.19 |
| 4/30/2005 | North | Chin | WPF Item | $2,401.73 | $6,491.17 | |
| 7/24/2005 | SouthEast | Troung | Whole Foods | ZMY Item | $3,234.28 | $8,741.30 |
| 8/13/2004 | North | Jeri | SoftwareFun | KPY Item | $8,446.46 | $9,598.25 |
| 1/29/2005 | North | Rhonda | Solar and Wind Inc. | XFU Item | $969.04 | $2,253.57 |
| 6/19/2005 | NorthEast | Sheliadawn | Sherman Williams | SBX Item | $3,281.54 | $3,729.02 |
| 1/14/2005 | MidWest | Steven | McLendon’s Hardware | LXS Item | $6,385.73 | $6,829.66 |
| 9/26/2005 | NorthEast | Luke | The Economist | JTV Item | $1,731.35 | $2,985.09 |
| 3/30/2005 | SouthEast | Jeri | Solar and Wind Inc. | RCE Item | $3,730.50 | $6,431.90 |
| 3/6/2005 | SouthEast | Rhonda | Nature Company | XWP Item | $3,154.71 | $5,346.96 |
| 12/31/2004 | NorthEast | Steven | Yahoo | WPE Item | $5,394.15 | $9,300.25 |
| 10/2/2005 | MidWest | Jon | SoftwareFun | NBK Item | $167.96 | $390.61 |
| 12/20/2004 | SouthEast | Jon | Solar and Wind Inc. | VIN Item | $5,876.59 | $9,960.33 |
| 5/1/2005 | SouthEast | Jon | Whole Foods | MSH Item | $6,820.56 | $9,094.08 |
| 2/16/2005 | NorthEast | Sheliadawn | Sherman Williams | JZO Item | $6,575.61 | $8,767.48 |
| 8/23/2005 | NorthEast | Troung | SoftwareFun | YTX Item | $4,906.63 | $8,921.14 |
| 11/20/2005 | North | Chin | Home Depot | FEK Item | $1,531.21 | $3,560.96 |
| 10/7/2005 | North | Chin | Sherman Williams | XNB Item | $3,464.64 | $6,299.34 |
| 3/17/2005 | NorthEast | Chin | Costco | YWP Item | $558.25 | $1,298.25 |
| 4/5/2006 | NorthEast | Jeri | Costco | FSJ Item | $4,647.29 | $8,449.61 |
| 11/21/2005 | West | Jon | NWT Item | $1,768.95 | $3,049.92 | |
| 8/1/2004 | NorthEast | Luke | Yahoo | MOQ Item | $4,595.21 | $8,354.92 |
| 5/13/2006 | North | Rhonda | Nature Company | OAP Item | $2,666.14 | $7,205.78 |
| 9/16/2005 | West | Chin | Amazon.com | LOP Item | $266.30 | $451.36 |
| 4/9/2006 | SouthEast | Chin | Peet’s Coffee | UXD Item | $2,647.43 | $4,564.54 |
| 9/16/2005 | West | Jon | Nature Company | EWM Item | $1,805.73 | $4,880.35 |
| 2/15/2006 | NorthEast | Chin | Costco | TGL Item | $58.76 | $158.81 |
| 7/10/2004 | North | Chin | Yahoo | RCA Item | $1,904.67 | $3,228.26 |
| 11/16/2004 | SouthEast | Sheliadawn | The Economist | CRF Item | $5,399.02 | $9,308.65 |
| 6/26/2005 | NorthEast | Jeri | SoftwareFun | NCN Item | $1,522.32 | $3,382.93 |
| 8/27/2004 | West | Rhonda | Sherman Williams | THO Item | $4,832.69 | $8,786.70 |
| 8/31/2005 | West | Jeri | Whole Foods | FXL Item | $677.31 | $1,167.78 |
| 11/9/2005 | NorthEast | Luke | TTM Item | $203.69 | $271.58 | |
| 12/9/2004 | West | Jeri | Costco | KVL Item | $627.28 | $1,393.96 |
| 3/21/2006 | North | Steven | SoftwareFun | MGO Item | $2,464.91 | $4,481.65 |
| 12/4/2004 | North | Steven | The Economist | RDD Item | $1,980.14 | $2,640.18 |
| 2/4/2006 | North | Chin | Yahoo | AIL Item | $1,142.98 | $2,658.10 |
| 12/14/2005 | NorthEast | Chin | Amazon.com | SVF Item | $947.64 | $2,203.81 |
| 11/17/2005 | NorthEast | Steven | Costco | RGD Item | $4,276.92 | $9,946.32 |
| 12/27/2004 | North | Jeri | The Economist | KWJ Item | $5,832.41 | $7,776.55 |
| 11/22/2004 | NorthEast | Rhonda | The Economist | FFT Item | $7,012.77 | $7,500.29 |
| 10/13/2005 | West | Jon | Office Depot | UBV Item | $18.07 | $31.16 |
| 1/21/2005 | MidWest | Luke | Whole Foods | NSN Item | $8,615.62 | $9,790.48 |
| 5/30/2006 | West | Luke | Costco | JUE Item | $1,117.50 | $1,894.07 |
| 7/1/2005 | NorthEast | Troung | Office Depot | CMU Item | $5,412.79 | $7,959.98 |
| 9/23/2005 | NorthEast | Steven | Amazon.com | GYH Item | $2,280.17 | $3,353.19 |
| 8/8/2005 | NorthEast | Sheliadawn | Yahoo | SCW Item | $2,237.46 | $3,792.31 |
| 5/25/2006 | West | Jeri | Office Depot | RTF Item | $1,259.07 | $2,928.08 |
| 11/20/2005 | NorthEast | Luke | The Economist | XZF Item | $1,950.30 | $4,334.01 |
| 2/6/2006 | NorthEast | Sheliadawn | Peet’s Coffee | GLG Item | $3,446.42 | $8,014.94 |
| 1/9/2005 | North | Jon | Costco | MYE Item | $3,330.01 | $7,400.03 |
| 10/3/2005 | MidWest | Troung | McLendon’s Hardware | EVO Item | $9,189.78 | $9,828.64 |
| 8/17/2004 | MidWest | Luke | Home Depot | YHI Item | $3,418.54 | $6,215.52 |
| 8/4/2005 | North | Steven | Office Depot | HKD Item | $4,911.25 | $5,252.67 |
| 9/7/2004 | NorthEast | Steven | Nature Company | GYK Item | $1,864.67 | $2,742.16 |
| 8/25/2005 | West | Troung | Solar and Wind Inc. | PUA Item | $2,050.45 | $3,535.25 |
| 1/5/2005 | West | Sheliadawn | McLendon’s Hardware | NGZ Item | $644.47 | $1,092.32 |
| 7/1/2004 | NorthEast | Troung | McLendon’s Hardware | BJI Item | $105.40 | $284.87 |
| 2/11/2005 | MidWest | Jeri | Solar and Wind Inc. | HGT Item | $3,639.02 | $4,852.02 |
| 12/25/2004 | MidWest | Sheliadawn | Nature Company | KKF Item | $3,344.00 | $7,431.10 |
| 4/18/2005 | West | Rhonda | Whole Foods | EFD Item | $45.01 | $81.83 |
| 4/26/2006 | SouthEast | Steven | Home Depot | UPA Item | $7,054.78 | $8,016.79 |
| 5/10/2006 | NorthEast | Jeri | Whole Foods | FPN Item | $1,855.42 | $5,014.65 |
| 1/8/2006 | North | Rhonda | Solar and Wind Inc. | SNK Item | $2,173.22 | $3,683.42 |
| 12/14/2004 | NorthEast | Jeri | Office Depot | HOQ Item | $5,300.66 | $5,669.16 |
| 12/13/2005 | SouthEast | Jon | Nature Company | KHA Item | $1,191.24 | $2,053.87 |
| 1/24/2005 | NorthEast | Troung | Office Depot | FZY Item | $331.15 | $895.01 |
| 4/25/2005 | North | Luke | Whole Foods | SRN Item | $4,662.30 | $6,856.33 |
| 11/30/2004 | West | Troung | SoftwareFun | AEW Item | $4,760.79 | $8,208.26 |
| 11/12/2004 | MidWest | Chin | Solar and Wind Inc. | PET Item | $3,504.65 | $8,150.36 |
| 1/20/2006 | NorthEast | Troung | The Economist | EYP Item | $2,705.44 | $4,664.56 |
| 10/24/2005 | West | Sheliadawn | Solar and Wind Inc. | PKE Item | $7,137.56 | $9,516.74 |
| 6/1/2005 | West | Luke | Solar and Wind Inc. | CCV Item | $1,205.93 | $1,773.42 |
| 3/1/2006 | MidWest | Luke | Whole Foods | YNQ Item | $3,185.71 | $8,610.02 |
| 11/23/2004 | North | Jeri | Sherman Williams | KGM Item | $4,699.11 | $5,339.90 |
| 10/24/2004 | NorthEast | Sheliadawn | Sherman Williams | HMW Item | $5,011.17 | $7,369.37 |
| 11/29/2004 | West | Jon | The Economist | TGO Item | $2,674.61 | $4,533.23 |
| 4/20/2005 | MidWest | Troung | Costco | KXJ Item | $4,501.76 | $6,002.34 |
| 2/10/2005 | West | Rhonda | Costco | FSD Item | $3,806.21 | $8,851.64 |
| 12/5/2005 | NorthEast | Jeri | Sherman Williams | SSU Item | $1,323.12 | $2,242.57 |
| 8/10/2004 | North | Troung | Costco | NFU Item | $234.09 | $266.01 |
| 9/9/2004 | West | Rhonda | Peet’s Coffee | UMN Item | $1,724.03 | $2,972.47 |
| 9/17/2005 | NorthEast | Chin | McLendon’s Hardware | TMF Item | $1,660.48 | $4,487.79 |
| 8/22/2004 | SouthEast | Chin | Sherman Williams | YVD Item | $3,605.87 | $6,111.65 |
| 10/13/2005 | SouthEast | Jeri | Sherman Williams | MJG Item | $2,704.59 | $3,073.40 |
| 9/19/2005 | West | Sheliadawn | The Economist | KQN Item | $1,622.29 | $4,384.57 |
| 3/31/2006 | North | Rhonda | McLendon’s Hardware | WBN Item | $892.65 | $1,312.72 |
| 1/22/2005 | West | Chin | Costco | CNG Item | $1,735.73 | $1,856.40 |
| 12/18/2004 | West | Troung | Amazon.com | YHA Item | $114.45 | $254.34 |
| 6/24/2005 | NorthEast | Jeri | Yahoo | HVH Item | $1,264.48 | $2,143.19 |
| 9/24/2004 | MidWest | Jon | Whole Foods | ILP Item | $2,982.53 | $5,422.79 |
| 3/18/2005 | West | Jon | Solar and Wind Inc. | HGQ Item | $249.38 | $366.74 |
| 12/1/2004 | North | Sheliadawn | Home Depot | BPJ Item | $730.54 | $1,238.20 |
| 1/12/2005 | NorthEast | Sheliadawn | Yahoo | ONK Item | $2,647.84 | $5,884.09 |
| 10/26/2004 | West | Jeri | Costco | UYR Item | $3,188.92 | $7,416.09 |
| 8/6/2005 | NorthEast | Jon | Nature Company | EZU Item | $607.65 | $1,047.67 |
| 8/3/2005 | West | Jeri | Office Depot | MEL Item | $8,814.57 | $9,427.35 |
| 9/24/2004 | West | Luke | Yahoo | UCA Item | $1,267.40 | $2,304.36 |
| 3/19/2005 | SouthEast | Sheliadawn | Whole Foods | NEE Item | $4,351.80 | $7,375.94 |
| 11/13/2005 | NorthEast | Sheliadawn | Whole Foods | KNX Item | $4,231.46 | $7,693.57 |
| 1/11/2005 | NorthEast | Sheliadawn | Nature Company | PBH Item | $5,217.19 | $5,928.62 |
| 7/18/2005 | MidWest | Chin | Yahoo | CVY Item | $4,445.83 | $7,665.23 |
| 6/13/2005 | NorthEast | Sheliadawn | Peet’s Coffee | QGM Item | $5,643.75 | $9,565.67 |
| 11/15/2005 | North | Jeri | Nature Company | ILH Item | $4,854.34 | $7,138.73 |
| 8/13/2005 | MidWest | Steven | Solar and Wind Inc. | QPM Item | $2,645.06 | $5,877.92 |
| 1/1/2006 | West | Luke | ETU Item | $4,341.18 | $7,357.93 | |
| 3/11/2005 | NorthEast | Troung | Amazon.com | CNH Item | $4,467.84 | $6,570.35 |
| 5/31/2006 | NorthEast | Jon | SoftwareFun | YIP Item | $4,494.45 | $9,987.66 |
| 4/4/2005 | MidWest | Luke | Office Depot | WVS Item | $1,455.00 | $2,645.45 |
| 12/20/2005 | NorthEast | Jon | Office Depot | EIE Item | $2,212.82 | $5,146.10 |
| 10/7/2005 | SouthEast | Luke | Amazon.com | AIM Item | $3,641.63 | $6,278.68 |
| 4/20/2005 | NorthEast | Luke | SoftwareFun | HAK Item | $640.66 | $1,085.87 |
| 11/6/2004 | NorthEast | Luke | Nature Company | BCD Item | $563.56 | $1,024.66 |
| 9/7/2004 | North | Sheliadawn | Nature Company | NCH Item | $5,047.35 | $5,398.23 |
| 9/23/2004 | NorthEast | Jeri | Yahoo | JKT Item | $1,559.50 | $3,626.74 |
| 6/10/2005 | NorthEast | Rhonda | Costco | IWN Item | $5,331.83 | $5,702.49 |
| 7/21/2004 | West | Chin | The Economist | KYW Item | $3,119.56 | $7,254.79 |
| 10/14/2004 | MidWest | Rhonda | Peet’s Coffee | ITT Item | $2,317.30 | $3,407.80 |
| 2/26/2006 | SouthEast | Jeri | Home Depot | JHF Item | $15.06 | $22.15 |
| 9/2/2005 | NorthEast | Luke | Yahoo | CNN Item | $4,357.25 | $5,809.66 |
| 3/23/2005 | MidWest | Rhonda | Costco | MKA Item | $944.41 | $2,552.46 |
| 3/19/2006 | MidWest | Troung | The Economist | KFB Item | $4,976.28 | $8,434.37 |
| 11/5/2005 | North | Steven | The Economist | XIM Item | $2,510.19 | $5,837.66 |
| 6/28/2004 | MidWest | Sheliadawn | Yahoo | VGE Item | $844.62 | $903.34 |
| 2/8/2005 | MidWest | Jon | WWB Item | $1,936.76 | $2,582.35 | |
| 9/8/2005 | West | Chin | SoftwareFun | RHM Item | $890.87 | $2,071.80 |
| 8/25/2004 | SouthEast | Troung | ZQH Item | $2,637.42 | $2,820.77 | |
| 8/20/2005 | West | Troung | McLendon’s Hardware | EUH Item | $196.46 | $456.88 |
| 3/7/2006 | North | Chin | SoftwareFun | FMP Item | $2,672.18 | $4,858.51 |
| 10/6/2004 | NorthEast | Rhonda | Peet’s Coffee | LVG Item | $3,671.58 | $6,330.31 |
| 10/22/2004 | West | Jeri | Costco | WKC Item | $1,721.55 | $4,003.61 |
| 8/2/2005 | West | Steven | Home Depot | EAP Item | $3,695.77 | $9,988.56 |
| 1/5/2006 | NorthEast | Luke | Yahoo | LVD Item | $241.66 | $322.21 |
| 4/1/2005 | MidWest | Rhonda | The Economist | QSA Item | $6,032.36 | $6,451.72 |
| 5/30/2006 | West | Chin | Whole Foods | JLK Item | $5,224.19 | $5,587.37 |
| 4/16/2006 | West | Troung | SoftwareFun | XBY Item | $2,350.46 | $4,052.52 |
| 1/17/2006 | NorthEast | Troung | The Economist | GAK Item | $345.52 | $585.62 |
| 4/20/2006 | NorthEast | Troung | Yahoo | SQZ Item | $5,717.91 | $9,691.38 |
| 6/5/2005 | SouthEast | Steven | UWT Item | $246.18 | $572.52 | |
| 8/18/2005 | NorthEast | Jeri | McLendon’s Hardware | POX Item | $4,025.11 | $4,573.99 |
| 5/17/2006 | NorthEast | Jon | Solar and Wind Inc. | JZS Item | $2,764.40 | $4,766.20 |
| 6/22/2005 | SouthEast | Steven | Amazon.com | MPS Item | $6,892.16 | $9,189.55 |
| 4/4/2005 | MidWest | Rhonda | The Economist | EYG Item | $3,918.36 | $4,452.68 |
| 1/28/2006 | SouthEast | Steven | McLendon’s Hardware | ACF Item | $3,479.96 | $3,954.50 |
| 10/16/2004 | MidWest | Luke | Solar and Wind Inc. | XVI Item | $4,250.16 | $7,327.87 |
| 10/31/2004 | NorthEast | Steven | Whole Foods | ZCL Item | $4,549.04 | $7,710.23 |
| 12/17/2004 | West | Jeri | Yahoo | UAD Item | $758.70 | $1,115.73 |
| 6/23/2004 | SouthEast | Jon | PQT Item | $1,707.81 | $4,615.71 | |
| 12/28/2004 | NorthEast | Chin | Yahoo | JXK Item | $3,621.75 | $9,788.51 |
| 8/18/2004 | NorthEast | Rhonda | Costco | VCN Item | $2,991.77 | $3,989.02 |
| 1/22/2006 | NorthEast | Jeri | McLendon’s Hardware | EQL Item | $1,385.90 | $3,079.77 |
| 3/3/2006 | West | Troung | SoftwareFun | KPO Item | $426.48 | $991.81 |
| 2/16/2005 | SouthEast | Jon | The Economist | XHR Item | $4,271.12 | $7,364.00 |
| 7/11/2005 | West | Sheliadawn | McLendon’s Hardware | JGS Item | $3,107.28 | $7,226.23 |
| 12/27/2004 | MidWest | Luke | Solar and Wind Inc. | ZFB Item | $3,396.25 | $9,179.05 |
| 4/20/2005 | MidWest | Sheliadawn | Costco | TBQ Item | $3,970.29 | $9,233.24 |
| 9/4/2004 | MidWest | Jon | Yahoo | IAG Item | $5,988.93 | $7,985.24 |
| 9/25/2005 | SouthEast | Jon | Costco | UGN Item | $1,503.71 | $2,004.95 |
| 10/10/2004 | SouthEast | Steven | SoftwareFun | AWF Item | $6,417.66 | $9,437.74 |
| 10/22/2005 | NorthEast | Chin | Nature Company | WLY Item | $819.24 | $1,204.76 |
| 9/2/2004 | West | Chin | Sherman Williams | BNH Item | $3,978.63 | $5,850.92 |
| 2/10/2006 | North | Steven | Whole Foods | TYZ Item | $2,542.44 | $5,912.65 |
| 3/1/2006 | MidWest | Chin | Whole Foods | STR Item | $4,421.19 | $7,493.55 |
| 12/16/2004 | NorthEast | Chin | Solar and Wind Inc. | KST Item | $1,232.27 | $1,643.02 |
| 8/27/2004 | NorthEast | Chin | The Economist | VBF Item | $1,441.14 | $2,442.61 |
| 9/6/2005 | West | Jeri | The Economist | HEB Item | $4,592.57 | $6,123.43 |
| 12/25/2004 | MidWest | Jon | Yahoo | FLS Item | $3,664.68 | $8,143.73 |
| 2/27/2005 | West | Rhonda | Costco | JUV Item | $2,790.27 | $6,200.59 |
| 9/30/2004 | MidWest | Jon | Peet’s Coffee | LRH Item | $500.89 | $1,353.75 |
| 5/11/2006 | MidWest | Chin | Costco | VYV Item | $3,545.62 | $3,792.11 |
| 12/17/2005 | NorthEast | Sheliadawn | Costco | WWD Item | $1,528.84 | $2,779.70 |
| 8/25/2004 | West | Chin | Sherman Williams | OLN Item | $666.74 | $1,149.56 |
| 1/11/2006 | North | Jeri | Amazon.com | BZE Item | $3,249.56 | $3,475.47 |
| 1/1/2006 | NorthEast | Troung | Whole Foods | EHO Item | $1,251.69 | $2,121.50 |
| 8/7/2005 | SouthEast | Troung | Sherman Williams | GPQ Item | $6,549.87 | $7,005.21 |
| 4/7/2006 | West | Chin | Solar and Wind Inc. | VPY Item | $712.93 | $1,296.23 |
| 5/27/2005 | North | Steven | Nature Company | OGH Item | $2,116.40 | $4,921.86 |
| 3/31/2005 | West | Luke | Solar and Wind Inc. | VDA Item | $2,944.10 | $4,990.00 |
| 9/9/2004 | West | Chin | Peet’s Coffee | EYP Item | $4,665.41 | $4,989.74 |
| 7/8/2004 | MidWest | Jeri | Nature Company | XKR Item | $3,708.54 | $4,944.72 |
| 1/17/2005 | West | Chin | The Economist | AYF Item | $3,119.09 | $3,335.92 |
| 11/29/2004 | North | Sheliadawn | Nature Company | HQT Item | $4,756.44 | $6,994.77 |
| 8/23/2004 | North | Chin | Yahoo | VNQ Item | $969.23 | $1,762.24 |
| 4/17/2005 | NorthEast | Jeri | WBL Item | $4,714.63 | $7,990.90 | |
| 6/8/2006 | NorthEast | Rhonda | Sherman Williams | SWQ Item | $4,295.72 | $9,990.04 |
| 12/16/2004 | MidWest | Rhonda | Yahoo | FZK Item | $4,145.58 | $7,026.41 |
| 3/2/2006 | North | Sheliadawn | Solar and Wind Inc. | PUD Item | $3,827.04 | $8,504.53 |
| 1/26/2005 | North | Jeri | Nature Company | YIV Item | $916.59 | $1,222.12 |
| 12/27/2005 | West | Sheliadawn | Nature Company | IYT Item | $1,390.59 | $1,487.26 |
| 12/9/2004 | SouthEast | Luke | Home Depot | KBY Item | $2,935.04 | $4,316.23 |
| 8/18/2004 | NorthEast | Steven | Whole Foods | VYM Item | $2,420.96 | $6,543.14 |
| 6/10/2006 | NorthEast | Troung | DVC Item | $3,411.56 | $3,648.73 | |
| 6/7/2006 | MidWest | Jon | Nature Company | QDA Item | $5,395.13 | $9,809.32 |
| 4/12/2005 | NorthEast | Jon | Home Depot | MQP Item | $4,296.41 | $7,407.61 |
| 7/27/2005 | MidWest | Jeri | Solar and Wind Inc. | GLY Item | $5,352.97 | $6,082.92 |
| 11/23/2004 | North | Troung | Amazon.com | PJA Item | $682.21 | $1,240.38 |
| 10/24/2004 | SouthEast | Jeri | McLendon’s Hardware | OGB Item | $450.47 | $763.51 |
| 2/3/2005 | SouthEast | Sheliadawn | QBL Item | $862.86 | $2,006.65 | |
| 7/12/2005 | NorthEast | Jon | Costco | ATV Item | $2,880.90 | $3,273.75 |
| 12/29/2005 | NorthEast | Chin | Sherman Williams | LEO Item | $3,132.68 | $7,285.31 |
| 8/1/2004 | NorthEast | Sheliadawn | SoftwareFun | JFF Item | $3,565.93 | $8,292.86 |
| 7/4/2005 | NorthEast | Luke | Solar and Wind Inc. | ULJ Item | $3,442.43 | $5,834.62 |
| 4/15/2006 | NorthEast | Troung | Costco | WCX Item | $1,182.05 | $3,194.72 |
| 8/10/2005 | NorthEast | Jon | Costco | UZP Item | $526.08 | $891.66 |
| 1/12/2005 | MidWest | Jon | Solar and Wind Inc. | UDH Item | $6,619.97 | $9,735.25 |
| 12/17/2004 | MidWest | Steven | Yahoo | WIP Item | $3,075.82 | $5,592.40 |
| 6/16/2006 | NorthEast | Jon | QJV Item | $1,835.90 | $3,165.34 | |
| 3/16/2005 | SouthEast | Chin | Office Depot | ICN Item | $605.97 | $1,101.77 |
| 12/6/2004 | West | Troung | SoftwareFun | YGD Item | $2,226.95 | $2,530.62 |
| 6/27/2005 | MidWest | Sheliadawn | SoftwareFun | LCU Item | $3,976.60 | $4,518.86 |
| 7/24/2004 | SouthEast | Chin | Costco | LFI Item | $3,410.24 | $7,578.32 |
| 8/25/2005 | West | Rhonda | Office Depot | BUZ Item | $4,355.79 | $7,382.70 |
| 7/10/2005 | MidWest | Rhonda | Office Depot | FPF Item | $3,381.07 | $9,138.04 |
| 11/4/2005 | West | Troung | ZAW Item | $2,878.68 | $6,397.07 | |
| 5/19/2006 | West | Jeri | Nature Company | GVD Item | $1,854.61 | $4,313.04 |
| 6/12/2005 | SouthEast | Luke | Peet’s Coffee | ENW Item | $3,438.09 | $5,927.74 |
| 4/4/2006 | NorthEast | Jon | Nature Company | KVA Item | $1,070.95 | $1,815.17 |
| 1/19/2006 | SouthEast | Rhonda | Solar and Wind Inc. | UVO Item | $3,345.55 | $4,919.93 |
| 7/2/2005 | West | Rhonda | UNH Item | $2,727.48 | $3,636.64 | |
| 6/11/2005 | NorthEast | Jeri | Yahoo | VTW Item | $2,204.46 | $4,898.81 |
| 6/28/2005 | NorthEast | Rhonda | Whole Foods | UDS Item | $3,354.58 | $3,812.02 |
| 3/28/2005 | West | Steven | McLendon’s Hardware | WMW Item | $4,341.22 | $7,484.87 |
| 2/6/2006 | West | Rhonda | Yahoo | QTS Item | $3,138.51 | $7,298.86 |
| 7/29/2004 | West | Rhonda | Yahoo | CJK Item | $4,675.34 | $8,500.61 |
| 12/10/2004 | West | Rhonda | Home Depot | WWU Item | $3,043.75 | $3,255.35 |
| 8/25/2005 | North | Troung | SoftwareFun | WJP Item | $2,596.21 | $5,769.35 |
| 7/26/2005 | NorthEast | Rhonda | McLendon’s Hardware | IZV Item | $6,050.41 | $8,897.66 |
| 5/5/2005 | North | Luke | Solar and Wind Inc. | EXM Item | $5,754.94 | $9,754.13 |
| 5/20/2005 | West | Steven | Yahoo | MQT Item | $3,266.35 | $3,711.76 |
| 12/27/2004 | NorthEast | Sheliadawn | Home Depot | XYL Item | $4,638.92 | $6,821.94 |
| 3/29/2005 | SouthEast | Jeri | Sherman Williams | QGI Item | $4,345.09 | $7,491.54 |
| 10/3/2005 | MidWest | Steven | Sherman Williams | ILS Item | $1,461.23 | $3,949.28 |
| 8/22/2005 | MidWest | Jeri | Home Depot | GPH Item | $4,442.32 | $5,923.09 |
| 9/30/2005 | North | Steven | XXH Item | $610.90 | $898.38 | |
| 10/27/2005 | MidWest | Rhonda | The Economist | DNA Item | $6,349.59 | $7,215.44 |
| 10/15/2005 | SouthEast | Troung | Office Depot | YIT Item | $3,219.61 | $8,701.64 |
| 9/18/2005 | SouthEast | Jeri | The Economist | MKP Item | $447.89 | $658.66 |
| 5/13/2005 | NorthEast | Steven | Peet’s Coffee | BTJ Item | $4,431.12 | $7,639.86 |
| 10/28/2005 | MidWest | Chin | Amazon.com | WXR Item | $2,714.01 | $4,600.01 |
| 5/4/2005 | NorthEast | Jeri | Solar and Wind Inc. | LII Item | $2,339.48 | $2,658.50 |
| 6/27/2005 | MidWest | Rhonda | Home Depot | RFR Item | $1,074.69 | $2,904.57 |
| 5/2/2005 | NorthEast | Rhonda | Home Depot | EAR Item | $4,384.42 | $9,743.15 |
| 2/1/2005 | SouthEast | Troung | Costco | KJV Item | $9,318.96 | $9,966.80 |
| 11/7/2004 | NorthEast | Chin | Yahoo | PUJ Item | $3,407.48 | $6,195.41 |
| 11/2/2005 | MidWest | Sheliadawn | McLendon’s Hardware | NIV Item | $5,180.14 | $7,617.85 |
| 9/30/2005 | NorthEast | Jeri | Amazon.com | AIZ Item | $627.94 | $923.44 |
| 12/16/2005 | MidWest | Luke | Costco | QDR Item | $3,978.19 | $6,858.94 |
| 6/26/2004 | NorthEast | Jeri | Amazon.com | AHN Item | $5,927.72 | $6,736.05 |
| 12/7/2004 | West | Jeri | SoftwareFun | AIU Item | $3,845.55 | $6,991.91 |
| 1/14/2005 | MidWest | Chin | Costco | QRV Item | $2,674.67 | $4,863.04 |
| 8/23/2004 | West | Jeri | Solar and Wind Inc. | FVF Item | $782.59 | $1,739.09 |
| 9/13/2005 | NorthEast | Sheliadawn | McLendon’s Hardware | HUO Item | $2,306.57 | $6,233.97 |
| 10/26/2004 | NorthEast | Rhonda | SoftwareFun | ZAH Item | $5,841.59 | $6,638.17 |
| 1/29/2005 | MidWest | Steven | Home Depot | SXT Item | $7,371.44 | $9,828.59 |
| 5/12/2006 | NorthEast | Steven | Home Depot | DRO Item | $4,764.98 | $8,215.49 |
| 7/16/2004 | NorthEast | Rhonda | Nature Company | ESJ Item | $5,269.95 | $9,581.72 |
| 3/4/2005 | MidWest | Luke | SoftwareFun | YAK Item | $5,245.71 | $5,610.38 |
| 9/24/2004 | North | Luke | Sherman Williams | RYV Item | $6,159.04 | $9,057.41 |
| 5/18/2005 | NorthEast | Troung | Office Depot | PAY Item | $3,795.61 | $6,433.23 |
| 2/19/2006 | North | Troung | SoftwareFun | GHH Item | $7,657.57 | $8,701.78 |
| 2/6/2005 | North | Jon | The Economist | TLQ Item | $2,084.69 | $5,634.31 |
| 9/17/2005 | NorthEast | Troung | Office Depot | TUL Item | $2,918.63 | $6,485.84 |
| 12/6/2004 | North | Jeri | Home Depot | NJY Item | $54.29 | $126.25 |
| 5/19/2005 | NorthEast | Jeri | Peet’s Coffee | QLL Item | $1,319.85 | $2,399.72 |
| 7/22/2004 | NorthEast | Jeri | The Economist | KSG Item | $649.50 | $1,180.91 |
allocating resources.xlsx
| Toys | Red Paint | Blue Paint | White Paint | Plastic | Wood |
| Toy A | 0 | 3 | 2 | 1 | 3 |
| Toy B | 1 | 1 | 1 | 5 | 0 |
| Toy C | 0 | 0 | 2 | 2 | 3 |
| Toy D | 1 | 1 | 0 | 2 | 5 |
| Toy E | 3 | 0 | 2 | 1 | 5 |
| Toys | Profit Per Unit | Unit | |||
| Toy A | $15 | 54.05405405 | |||
| Toy B | $30 | 108.1081081 | |||
| Toy C | $20 | 72.07207207 | |||
| Toy D | $25 | 90.09009009 | |||
| Toy E | $25 | 90.09009009 | |||
| Total | $10,000 | ||||
| Manufacturing Material | Quantity (Units) Available | ||||
| Red Paint | 625 | ||||
| Blue Paint | 640 | ||||
| White Paint | 1,100 | ||||
| Plastic | 875 | ||||
| Wood | 2,200 | ||||
| Glue | 1,500 |
