As a culminating project, this assignment has two parts: a project plan created in either MS Project (PC) or Apple Merlin (MAC) due in Topic 7 and an executive summary due in Topic 8. Those experiencing problems with Project software may complete this portion of the assignment in Excel. Use prior course information and data gathered for your CLC Business Plan to complete this assignment.
Examine the business plan you created with your CLC group and determine the distinct goals, timelines, and resources necessary to put the plan into effect. The steps required for the implementation of the business plan are referred to as a project plan.
The business plan is a CHP for a mobile breast cancer screening station or Mammo-van.
Write a project plan in Microsoft Project or Apple Merlin. Excel may be substituted as needed. In your project plan:
- Identify the tasks needed to complete the project.
- Develop a completion schedule.
- Assign resources to project tasks. Be creative. For example: If your plan calls for three nurses, you will need to plan for hiring and training. Create realistic timelines for each activity. They could be very general (2 weeks to hire, 2 weeks to train) or they could dive much deeper (1 week to write hiring ad, 1 week to place the ad, 2 weeks to accept applications, 1 week to review, 3 weeks for interviews, 1 week for offer letters, 2 weeks to establish in the HR system, etc.).
Complete these steps for each major component of the business plan. Your project plan should be specific, detailed, and thorough.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.
ProjectSchedule
| Create a Project Schedule in this worksheet. Enter title of this project in cell B1. Information about how to use this worksheet, including instructions for screen readers and the author of this workbook is in the About worksheet. Continue navigating down column A to hear further instructions. | CLC Group 3 | SIMPLE GANTT CHART by Vertex42.com | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter Company Name in cell B2. | CHP MammoVan | https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell E3. Project Start: label is in cell C3. | Project Lead: Michael McDonald | Project Start: | Thu, 6/29/2023 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| The Display Week in cell E4 represents the starting week to display in the project schedule in cell I4. The project start date is considered Week 1. To change the display week, simply enter a new week number in cell E4. The starting date for each week, starting with the display week from cell E4, starts in cell I4 and is auto calculated. There are 8 weeks represented in this view from cell I4 through cell BF4. You should not modify these cells. Display Week: label is in cell C4. | Display Week: | 1 | Jun 26, 2023 | Jul 3, 2023 | Jul 10, 2023 | Jul 17, 2023 | Jul 24, 2023 | Jul 31, 2023 | Aug 7, 2023 | Aug 14, 2023 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cells I5 through BL5 contain the day number for the week represented in the cell block above each date cell and are auto calculated. You should not modify these cells. Today's date is outlined in Red (hex #AD3815) from today's date in row 5 through the entire date column to the end of the project schedule. | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | |||||||
| This row contains headers for the project schedule that follows below them. Navigate from B6 through BL 6 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell I6 and continues through cell BL6. All project timeline charting is auto generated based on the start and end dates entered, using conditional formats. Do not modify content in cells within columns after column I starting with cell I7. | TASK | ASSIGNED TO | PROGRESS | START | END | DAYS | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | |
| Do not delete this row. This row is hidden to preserve a formula that is used to highlight the current day within the project schedule. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cell B8 contains the Phase 1 sample title. Enter a new Title in cell B8. Enter a name to assign the phase to, if it applies for your project, in cell C8. Enter Progress for the entire phase, if it applies for your project, in cell D8. Enter the start and end dates for the entire phase, if it applies for your project, in cells E8 and F8. The Gantt chart will automatically fill in the appropriate dates and shade according to the progress entered. To delete the phase and work only from tasks, simply delete this row. | CLC Group Formation | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cell B9 contains the sample task "Task 1." Enter a new task name in cell B9. Enter a person to assign the task to in cell C9. Enter progress of the task in cell D9. A progress bar appears in the cell and is shaded according to the number in the cell. For example, 50 percent progress would shade half of the cell. Enter task start date in cell E9. Enter task end date in cell F9. A status bar shaded for the dates entered appears in blocks starting from cell I9 through BL9. | Create group | Dr. Kautzmann | 100% | 6/29/23 | 7/6/23 | 8 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rows 10 through 13 repeat the pattern from row 9. Repeat the instructions from cell A9 for all task rows in this worksheet. Overwrite any sample data. A sample of another phase starts in cell A14. Continue entering tasks in cells A10 through A13 or go to cell A14 to learn more. | Assign topic | Dr. Kautzmann | 100% | 6/29/23 | 7/6/23 | 8 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Initial group contact | Michael Mc Donald, Ceinna King, Rachel Cummings, Joshua Vela | 100% | 6/29/23 | 7/6/23 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Assign a project leader | All group members | 100% | 6/29/23 | 7/6/23 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Complete CLC Agreement | Michael McDonald | 100% | 6/29/23 | 7/12/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Group info session | All group members | 100% | 6/30/23 | 6/30/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Group info session | All group members | 100% | 7/7/23 | 7/7/23 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| The cell at right contains the Phase 2 sample title. You can create a new phase at any time within column B. This project schedule does not require phases. To remove the phase, simply delete the row. To create a new phase block in this row, enter a new Title in cell at right. To continue adding tasks to the phase above, enter a new row above this one and fill in the task data as in cell A9's instruction. Update the Phase details in cell at right based on cell A8's instruction. Continue navigating down column A cells to learn more. If you haven't added any new rows in this worksheet, you will find 2 additional sample phase blocks have been created for you in cells B20 and B26. Otherwise, navigate through column A cells to find the additional blocks. Repeat the instructions from cells A8 and A9 whenever you need to. | Plan Section Assignments | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Business Plan Model selection | All group members | 100% | 7/13/23 | 7/19/23 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Role assignments for each member | Michael McDonald | 100% | 7/13/23 | 7/19/23 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Plan for communication | All group members | 100% | 7/13/23 | 7/19/23 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Timeline for remaining tasks | Michael McDonald | 100% | 7/13/23 | 7/19/23 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Complete Business Plan Progress Report | Michael McDonald | 100% | 7/13/23 | 7/19/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Group info session | All group members | 100% | 7/14/23 | 7/14/23 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sample phase title block | Individual Section Assignments | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Market analysis, competitor analysis, strategic communications | Ceinna King | 100% | 7/20/23 | 7/30/23 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Resource & supply allocation, financial projections, funding estmates | Michael McDonald | 100% | 7/20/23 | 7/30/23 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Legal, regulations, permits, liabilties | Joshua Vela | 100% | 7/20/23 | 7/30/23 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Training, education, diversity, scheduling, staffing | Rachel Cummings | 100% | 7/20/23 | 7/30/23 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Group info session | All group members | 100% | 7/21/23 | 7/21/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Group info session | All group members | 100% | 7/28/23 | 7/28/23 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sample phase title block | Business Plan Finalization | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Assignfinal business plan sections | Michael McDonald | 100% | 7/29/23 | 8/13/23 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Introduction & Description of product/ service | Rachel Cummings | 50% | 7/29/23 | 8/13/23 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Business & industry profile | Ceinna King | 50% | 7/29/23 | 8/13/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Marketing components | Ceinna King | 50% | 7/29/23 | 8/13/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Financial information | Michae McDonald | 50% | 7/29/23 | 8/13/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Operational plan | Joshua Vela | 50% | 7/29/23 | 8/13/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| CLC Business Plan Update 2 | All group members | 50% | 8/3/23 | 8/9/23 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Submit CLC final business plan | Michael McDonald | 50% | 8/16/23 | 8/16/23 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Group info session | All group members | 100% | 8/4/23 | 8/4/23 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Group info session | All group members | 0% | 8/11/23 | 8/11/23 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| This is an empty row | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| This row marks the end of the Project Schedule. DO NOT enter anything in this row. Insert new rows ABOVE this one to continue building out your Project Schedule. | Insert new rows ABOVE this one | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html?utm_source=ms&utm_medium=file&utm_campaign=office&utm_content=url https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html?utm_source=ms&utm_medium=file&utm_campaign=office&utm_content=text
About
| SIMPLE GANTT CHART by Vertex42.com |
| https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html |
| About This Template |
| This template provides a simple way to create a Gantt chart to help visualize and track your project. Simply enter your tasks and start and end dates – no formulas required. The bars in the Gantt chart represent the duration of the task and are displayed using conditional formatting. Insert new tasks by inserting new rows. |
| Guide for Screen Readers |
| There are 2 worksheets in this workbook. TimeSheet About The instructions for each worksheet are in the A column starting in cell A1 of each worksheet. They are written with hidden text. Each step guides you through the information in that row. Each subsequent step continues in cell A2, A3, and so on, unless otherwise explicitly directed. For example, instruction text might say "continue to cell A6" for the next step. This hidden text will not print. To remove these instructions from the worksheet, simply delete column A. |
| Additional Help |
| Click on the link below to visit vertex42.com and learn more about how to use this template, such as how to calculate days and work days, create task dependencies, change the colors of the bars, add a scroll bar to make it easier to change the display week, extend the date range displayed in the chart, etc. |
| How to Use the Simple Gantt Chart |
| More Project Management Templates |
| Visit Vertex42.com to download other project management templates, including different types of project schedules, Gantt charts, tasks lists, etc. |
| Project Management Templates |
| About Vertex42 |
| Vertex42.com provides over 300 professionally designed spreadsheet templates for business, home, and education – most of which are free to download. Their collection includes a variety of calendars, planners, and schedules as well as personal finance spreadsheets for budgeting, debt reduction, and loan amortization. |
| Businesses will find invoices, time sheets, inventory trackers, financial statements, and project planning templates. Teachers and students will find resources such as class schedules, grade books, and attendance sheets. Organize your family life with meal planners, checklists, and exercise logs. Each template is thoroughly researched, refined, and improved over time through feedback from thousands of users. |
https://www.vertex42.com/ExcelTemplates/excel-project-management.html?utm_source=ms&utm_medium=file&utm_campaign=office&utm_content=text https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html?utm_source=ms&utm_medium=file&utm_campaign=office&utm_content=help https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html?utm_source=ms&utm_medium=file&utm_campaign=office&utm_content=url https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html?utm_source=ms&utm_medium=file&utm_campaign=office&utm_content=text