Class Project

Organization

It is essential that you get busy immediately, because you cannot plan realistically until you understand the work required. You should organize your group's resources quickly: database manipulation, CAD drawing, programming skills, report writing, presentation, etc. Make sure you can communicate with each other reliably and quickly.

Here is a calendar of milestones by which you can manage your work:

Do not contact the client directly. Instead, send any questions, etc. to me. I will collate them, forward them to the client and distribute the replies.

It is okay for one group to use the results or work of another, so long as the source is properly cited.

Expectations

Deliverables:

• Slides and a presentation to the client, me, and the class.

  Each group will make a 30-minute presentation, including questions, as scheduled. At the time of the presentation, you must submit four paper copies, in color, of your presentation slides. These should be printed 2 or 3 to a page, with space on which to take notes, and bound or stapled.

  Plan to talk for only 20 minutes and leave 10 minutes for questions. This means you should use no more than 10-15 slides. Use mostly slides with figures; if you use text, keep to fewer than about 6-8 lines of text per slide. I suggest that only one person be chosen from your group to present. Be sure to number your slides so that the client can easily refer back to specific slides.

  Note: This is the single most important deliverable. In particular, it is the only chance to engage your client directly. If you make a bad impression, it is almost impossible to recover. A large part of your project grade will depend on the quality of your presentation.

• Four copies of a bound or stapled executive summary, not to exceed 10 pages, written for the client.
• Four copies of a CD containing all your work, including the presentation, executive summary, appendices, figures, graphs, spreadsheets, databases, computer programs and source code, etc. - In short, everything necessary to follow every step of your work and to reconstruct your conclusions or extend your analysis. Include a copy of your final report in html format, with links to all supporting materials along with descriptions of what they are. The name of the main file should follow the convention main-YYYYMM-Group-N.html, where YYYYMM is the year and month of your presentation and N is your group number. Make sure the CD is in a protective case and that the case is labeled ISyE6202 YYYYMM Group N.

  If you write any computer program, queries, etc. for use in this project, include all source code. It will be assumed that your program will be freely available to all under the GNU General Public Licence. Please do not write or use software for which you are unwilling to do this. By releasing source code under the GPL the client and subsequent classes can build on your work, just as you will have built on the work of predecessors.

• Each group leader should also send me email listing the relative contributions of his/her group members: Rate each one as Extraordinary, Satisfactory, or Seriously Deficient. If other than Satisfactory, please support your rating with a detailed justification of at least 200 words.

You may need to bring more than four copies of each of the above, depending on how many representatives the client brings. This will be determined close to the time of presentation.

All of the deliverables are due at the time of presentation.

Each group will be graded on technical excellence, professionalism, and ability to work together. Group leaders will help me in evaluating the contributions of the group members. If you experience problems, contact me immediately. It is too late to do anything if I do not hear about the problem until the end of the project.

Note that all material is testable on the final exam. Each group member is expected to know about all aspects of the groups tools, techniques, and conclusions. For example, if the group wrote SQL queries to manipulate data then everyone in the group is responsible for understanding what was done and why.

Everyone is expected to attend each presentation, including those of other groups. Because presentation time will be short, please arrive promptly, take a seat, and remain quiet. If you have to leave the classroom for some reason, please do so as quietly and unobtrusively as possible.

The material displayed in the final presentations are part of the course material and may appear on Exam 3.

Suggested first steps

• In general, be aggressive about getting the data you need. Do you want to travel to see the client's facility? Write me a proposal: How many people? Who? When? What is your itinerary? How much is it expected to cost? What will you accomplish?
• Secure a computer with a database program and some general programming language. Recommendation: Java, because you cannot be sure of the computing resources of the client. If you choose some other language, be prepared to explain why, in terms of the client's requirements. “Because I already know language X” is not an adequate reason.
• Check out the software provided for the course. Some of it may be useful to you.
• Think about what data you would like from the client. Structure this in layers: What would you like to have ideally? What can you work with if the ideal is not available?
• As soon as you have data, generate some initial statistics to check for plausibility. For example: How many orders per day? How many lines per order? What are the ten most popular sku's? Ten least popular? What are the most/least popular vendors? You may find it easier to get started if you use only a portion of the order history at first (for example, data for one month). This will make it easier to debug your tools and get involved with the data. Afterwards you can run your tools on the complete data set.
• It is useless to report simply that there is missing or suspicious data. How big is the problem? If only ten of 10000 skus lack dimensions, ignore them; if 100 unpopular skus lack dimensions, ignore them too; if 500 popular skus lack dimensions, go measure them; if 5000 skus lack dimensions, then we need to discuss this with the client. If you are unable to proceed because of bad data, organize the questionable data and send it to me, along with an explanation of why you need to correct it.
• In the file of skus, break the storage addresses apart so that you have a separate field for each component (zone, aisle, section, shelf). This will allow you to locate sku's to any of several degrees of precision.

Advice on the presentation

You can waste a lot of good technical work with a poor presentation. Note the following.

• It is best to rely on a single person to present your work. The speaker should be able to explain anything appearing in your presentation.
• Face your audience, not the projection screen, when speaking.
• Leave time for questions and discussion.
• Talk about the client and his/her problems, not about yourselves and what you did.
• Do not use technical terminology that is unlikely to be familiar to your client.
• Use familiar units-of-measure. For example, use person-hours instead of person-seconds.
• Structure your report so that alternatives can easily be compared. This means that each alternative should be presented in the same units-of-measure, same scale, etc.
• Do not display any statistics that are obviously bogus; this just advertises that you did not resolve inconsistencies in the data or in your methodology.
• It is not enough simply to suggest changes. You must estimate the results of those changes, as well as the cost of implementing the changes. Cost can be in dollars or person-hours or whatever unit of measure seems most natural.
• In evaluating any suggested changes, be sure to discuss implications of the change on both upstream, downstream, and parallel processes.
• Use carefully-designed graphics to summarize your ideas for the client. In fact, try to speak only from figures and charts, without using bullet points.
• If you use a simulation, give the client some reason to trust the simulation. For example, benchmark it by comparing predictions with some verifiable statistics from the actual warehouse.
• Be suspicious of huge improvements. If there is an opportunity to improve by 40%, there is a good chance your client will have thought of this already, so you may have missed other issues involved. Find out what they are.
• Try to structure recommendations in layers, starting with simple, inexpensive improvements to current system and progressing to improvements that require more investment or return less value.
• Practice your talk in advance. Make sure in advance that the projection system works as you intend.