Please use Microsoft Project, and follow the rubric
PART 1 Frankie & Co to Open a New Bakery Frankie and Charlie recently a completed a degree in Culinary Arts, with a specialty in baking. They decide to start a business, Frankie & Charlie Bakes (F&CB) to make their own baked goods. They decide to differentiate themselves from the competition by producing sustainably sourced ingredients, using environmentally conscious manufacturing techniques. After conducting a series of market research studies, they decide to introduce a line of products that are based on flavours from around the world. The taste, branding and name of the products will be based on specific regions in the world that they have visited over the years. Your team has been hired to assist them in setting-up the new bakery. They need your help to build a plan to start the bakery. Your team has completed the WBS, Precedence Table and identified the Critical Path with the Network Diagram. Your team met with Frankie and Charlie to review the work and get agreement to move to the next step in the engagement – preparing the project schedule. Frankie and Charlie have also provided your team with the following information: · They want to start this project on January 09, 2023 with a maximum budget of $250,000 (CAD) and needs to be completed within 4-months. · January 12 to 13 will be an offsite meeting that you and all other resources need to attend, so no work will take place during these days · No work on the weekends · Frankie and Charlie have asked you to include all the project management work required to complete the project in the schedule and identify the related costs i.e., WBS, Precedence Table and Network Diagram. Deliverables: Due April 11, 2023 (5:00 PM EST) You need to prepare a project schedule to track and manage the work. The project schedule will be used to determine the costs and report on the progress. The project schedule needs to include the following components: · Summary level information of the work · Task level information of the work SCHEDULE & COST MANAGEMENT: Assignment 2 · Start & Finish dates for each task PAGE 2 MGMT 4085 · The amount of time required to complete each task (duration) · Include predecessors and milestones · Identification of the critical activities illustrated in the GANTT chart and schedule · Assign resources and costs for all activities · Set Project Baseline Grading: · Grading of the Assignment will be based on the following criteria for a total of 15 points. Criteria Points · Identification of Summary Tasks (Level 2) · Identification of Task Level work (Level 3, 4 etc.) · Duration of the Tasks · Accuracy of the Start & Finish dates based on · Project Start Date · Non-Working Time · Holidays · Identification of milestones · Identification of predecessors (dependencies) · Identification of the critical activities · Identification of costs · Alignment budget · Consistency of project schedule with the Network Diagram 15 -Manual scheduling of tasks -5 -Not showing Entire Project with Gantt chart -5 PART 2 Frankie & Co to Open a New Bakery Frankie and Charlie recently a completed a degree in Culinary Arts, with a specialty in baking. They decide to start a business, Frankie & Charlie Bakes (F&CB) to make their own baked goods. They decide to differentiate themselves from the competition by producing sustainably sourced ingredients, using environmentally conscious manufacturing techniques. After conducting a series of market research studies, they decide to introduce a line of products that are based on flavours from around the world. The taste, branding and name of the products will be based on specific regions in the world that they have visited over the years. Your team has been hired to assist them in setting-up the new bakery. They need your help to build a plan to start the bakery. Your team has completed the WBS, Precedence Table and identified the Critical Path with the Network Diagram. Your team had a meeting with Frankie and Charlie to review the work when they advised you of the budget, timelines and details regarding working time. Frankie and Charlie set a maximum budget of $250,000 (CAD) and a timeline of 4-months to complete the project. Based on information provided in the meeting your team prepared a project schedule (using MS Project). Since completing the project schedule, 2-months have passed, and Frankie and Charlie have contacted you with an update. They advise you that there are potential investors in their bakery. This is good news for Frankie and Charlie. Before the investors commit funding, they need to receive an update on the project. The investors are also interested in adding a new line of products to the baked goods. 2- Month Update* a) Set-up of the location (online or physical) is complete, however, total amount of time required 5-additional days. b) Product Testing is taking longer than expected, since it’s difficult to get the appropriate sample size of customers. Testing of the product is now 7-days behind schedule. c) Development of the marketing tactics are now 75% complete. d) Selection of the Equipment is complete, however, delivery and installation is 7- days delayed e) People work package was completed earlier than planned, with all tasks completed 5-days ahead of plan * Ensure the Baseline is set before making any updates to the project New Product Line The new product line will introduce premium goods that will be sold for a higher margin compared to other goods. These goods will require specialized equipment and ingredients. · A baker with specialized knowledge will be needed to prepare the new goods. The cost for this baker is expected to be 10% more than the salary of the ‘regular’ baker, however, this baker is only needed 25% of the time. · The new equipment cost an additional $5,000 and ingredients costs an additional $1,000 · Testing of the new product line will require a separate series of testing and take 7-days to be completed. This additional round of testing needs to be complete before all products can be commercialized. · No other impacts to the business are expected based on the new product line Deliverables: April 13, 2023 (5:00 PM EST) The following is needed to prepare for the meeting with the new investor 1. Updated MS Project Schedule includes 2-Month Updates and The New Product Line 2. Prepare a PowerPoint Presentation with the following information: Part 1: 2-Month Update (2-3 slides) a. Update on the current status of the project schedule and budget illustrating plan vs. actual, including update on the Critical Path and Tracking Gantt (refer to Project Statistics), including sections of the project that are either late b. Update on Project Milestones Part 2: New Product Line (2-3 slides) a. Assessment of the impact to the project (schedule and budget) due to New Product Line, including update on the Critical Path and Tracking Gantt b. Update on Project Milestones Grading: · Grading of the Assignment will be based on the following criteria for a total of 15 points. Criteria Points Updated Project Schedule which includes: · Finalized Baseline · Progress based on 2-month update · New Product Line changes 10 · Include any leads or lags (at least 1 of each) · Includes at least 1 constraint/deadline (needs to be logical) · Include at least 1 recurring task PowerPoint Presentation including: · Part 1 – 2-month status update 2.5 · Part 2 – New Product Line assessment 2.5 Total 15 Deductions · Manual scheduling of tasks -2.5 · Not showing Entire Project with Gantt Chart -2.5 · Status Update line not showing -2.5 · Overallocations -2.5 Up to -5 marks for each of the previous criteria from Assignment 2 that is not included · Identification of Milestones · Identification of predecessors (dependencies) · Identification of critical activities · Identification of costs Assignment 2 Precedence Table Rawand Task IDWSB #Task NamePredecessorDuration (Days)ResourceCostMilestone (Y/N) Sales & distribution A1.1Research online optionsNone5 B1.2Research store front optionsNone5 C1.3Evaluate pros and cons of each options1,22 D1.4Make final decision32 People E2.1Hire planning43 F2.2Hire initiation54 G2.3Hire execution620 Procurement H3.1Planning43 I3.2Intiating84 J3.3Puchasing99 Product development K4.1Create prototypeNone6 L4.2Test product1110 M4.3Commercialize product126 Marketing N5.1Identify customer segments and target audience135 O5.2Determine marketing tactics147 P5.3Develop branding1516 Part 2 - Precedence table Precedence Table Task IDWSB #Task NamePredecessorDuration (Days) Sales & distribution A1.1Research online optionsNone5 B1.2Research store front optionsNone5 C1.3Evaluate pros and cons of each options1,22 D1.4Make final decision32 People E2.1Hire planning43 F2.2Hire initiation54 G2.3Hire execution620 Procurement H3.1Planning43 I3.2Intiating84 J3.3Puchasing99 Product development K4.1Create prototypeNone6 L4.2Test product1110 M4.3Commercialize product126 Marketing N5.1Identify customer segments and target audience135 O5.2Determine marketing tactics147 P5.3Develop branding1516 Part 2 - Network Diagram 0A55C77D99E1212F1616G36 141414141414141414141414 1451919221212232332626430302050 0B59H1212I1616J25 START1414252525252525FINISH 14519343373744141950 0K66L1616M2222N2727O3434P50 000000000000 Late finish = 5006661016166222252727734341650 Critical Path The critical Path in this case is K -L - M- N - O - P because it will take the longest amount of time to complete. It will take 50 days to be completed. Slack We can see that task K,L,M,N,O and P have no slack because they are on the critical path. They must be completed on time or it will delay the project. Task A, B, C, D, E , F , G, H, I and J have some slack meaning the project can be delayed without disrupting the overall project. Part 1 - WBS Final Frankie & Co to Open a New Bakery Schedule & Cost Management: Assignment 1 Project Deliverables (WBS) 1 Sales & distribution 1.1 Research online options 1.2 Research store front options 1.3 Evaluate pros and cons of each options 1.4 Make final decision 2 People 2.1 Hire planning 2.1.1 Determine positions to be hired 2.1.2 Determine number of positions to be filled 2.2 Hire initiation 2.2.1 Write job descriptions for each position needed 2.2.2 Determine qualifications needed 2.2.3 Create/post a job announcement 2.3 Hire execution 2.3.1 Screen resumes 2.3.2 Book interviews 2.3.3 Choose the best candidate 2.3.4 Send job offer 2.3.5 Onboard employees 3 Procurement 3.1 Planning 3.1.1 Determine equipment/materials needs 3.1.2 Determine equipment/materials requirements 3.1.3 Search for suppliers 3.2 Intiating 3.2.1 Request quotes for purchasing/leasing 3.2.2 Evaluate purchasing option 3.2.3 Evaluate leasing option 3.3 Puchasing 3.3.1 Decide on the option/supplier 3.3.2 Sign purchase/lease agreement 3.3.3 Provide deposit if needed 3.3.4 Get items delivered 4 Product development 4.1 Create prototype 4.2 Test product 4.3 Commercialize product 5 Marketing 5.1 Identify customer segments and target audience 5.2 Determine marketing tactics 5.3 Develop branding