Case Study: Harbor Printing Database Project

M2-Case Study Activity

From this module, you start to review the Case Study Main Document and familiarize yourself with its contents. In future modules, you keep adding more contents to your work. All module case study activities are your personal learning notes, that will draw from the course reading and all other activities. Save this case study, and use it for the rest of the term.

For this first module, you need to
• Create an APA-style compliant document that contains all sections listed in the ‘Case-Study Main Document.’
• Make sure to include automated Table of Contents.

If you are not familiar with the APA style document, you may want to review the following web page
https://apastyle.apa.org/learn/index

If you need help with inserting automated table of contents, look at the following YouTube clip:

General Instructions for This Activity

Work on this activity as your personal learning notes, and add more contents throughout the term, but you don’t need to submit anything.

Note, this is an ongoing project as learning note or journal for your own benefit. Your current work is the initial word document that includes Cover Page, Table of Contents and all headings for all sections and proper page numbers.

See the following table for expected status of your project work in yellow:

Case-Study Learning Notes for Module 2
Section Pinto’s Textbook Pages Covered in Module Activity in Module

1. Cover page
M2

2. Table of contents
M2

3. Executive Summary
M8

4. Introduction
Chapter 2 – Page 76 (Integrated Project Section) for guidance M2 M3

5. Project charter
Chapter 5 – Page 164 (The Project Charter) M3 M3

6. Project scope
Chapter 5 – Page 164 (The Scope Statement) M3 M3

7. Project Work Breakdown Structure (WBS)
Chapter 5 – Page 165 (The Work Breakdown Structure) M3 M4

8. Project time schedule including Gantt and network diagrams
Chapter 9 – Page 313 (Project Scheduling) M5 M5

9. Project costs
Chapter 8 – Page 274 (Cost Estimation and Budgeting) M4 M6

10. Project quality
Research Topic M6

11. Project procurement
Research Topic M7

12. Project human resources requirement
Chapter 12 – Page 420 (Resource Management) M7 M7

13. Project communications including outline for monthly progress reports
Research Topic M8

14. Project risks
Chapter 7 – Page 241 (Risk Management) M3 M7

15. Project stakeholder management
Chapter 2 – Page 43 (Stakeholder Management) M2 M4

16. Conclusion
M8

17. References
M8

Case-Study Assignment Main Document
Case Study Overview
In this case study you will essentially go through the stages of project management and knowledge areas (i.e. the project management in integration, scope, time, cost, quality, human resource, communications, risk, procurement, and stakeholder) for a case study given to you. You will be using the Microsoft Project management system for portions of this course. Your case study grade will be based on your analysis and quality of the final report.

Case Study: Harbor Printing Database Project
Harbor Printing, impressed with your DBMS knowledge and skills, has decided to hire you as a project manager to direct this project. They want you to design and build a database system to keep track of the information about their printing products.
You met with their CEO and here are your interview notes:
Harbor Printing is a specialty printing company. We print the foil lids for yogurt, jams, and other food products. Our industry has many regulations and standards that require diligence and care in the type of ink, handling, and packaging of the food products. Harbor Printing prints the food package and then ships the product to the food manufacturer. We do not package the food.
We want to create a project to establish a database of customer’s electronic artwork, previous print jobs, and statistics on each print job they ran. The goal of the database project is to allow the company to electronically retrieve a customer’s artwork to make revisions, offer new prices, and to electronically archive the artwork for future business. The project deliverable should allow Harbor Printing to offer faster turnaround times on orders.
Jan Elbert, a program manager, worked with the project stakeholders to determine the project objectives and then prioritize the project requirements. You later met her — She told you that the project was scheduled to finish in 3 months and had a budget of $100,000. You also learned from the sales manager, Tom Whitson that he wanted the database to provide more sales automation for repeat customers while Gary Yung, the manager of prepress wanted his designers to be able to retrieve artwork for fast development.
Harbor Printing management would not allow the project to launch until the project integration management plan developed. This requires you to present this plan extensively to the project stakeholders.
As the project manager to direct this project, you need prepare a detail report, as outlined below, and submit for grading. (Your submission should include an electronic copy all files from MS Project and a Word document for your final report). Throughout the semester, you will be given instructions on what to do for every module and at the end of semester you will submit a final report as outlined below. Each module submission will be awarded a maximum of 10% of the case study grade. You will receive feedback 2019f or each one of the first six submissions, and then the remaining 40% of the grade is reserved for the final revised submission of the report.