COIT12208 Assessment item 2 — Individual case studyIntroduction and Student Guide
This assessment item is to be completed individually.
The case study simulates a project management scenario where the student takes on the role of project manager. The case information is not complete so where necessary students will have to argue the pros and cons of any assumptions they make. If necessary, students are expected to find relevant information in the academic literature to justify their answers and provide appropriate references.
The following information is provided to assist students to develop their assessment solution:
Important notes regarding assignment submission
Preparation for the assignment
You are required to take your Microsoft Project practical’s and this assignment to your tutorial/practical classes from week 3 onwards. The course is scheduled to commence the practical’s in week 3 and you are expected to start work on this assignment in week 6 (or earlier).
The Mo Mo Factory Outlet Case Description
The last four years had been a roller coaster ride for the companies three founders Raju, Vaneet and Dipesh. The readymade Nepalese’s dumpling (Mo Mo) business had exploded before their eyes. Their choice of street front premises had proved very successful. As the business expanded they were able to grow with the acquisition of a warehouse at the rear of the property from which they were able to manufacture and dispatch there product to restaurants and supermarkets across Sydney and with the capacity to produce product for the whole of Australia and beyond.
The next stage of growth comes with some substantial constraints which will direct the nature of future projects. The easiest thing to do, is more of the same but that requires extending the geographic reach of its distribution which in turn, pushes up costs. The last few months have shown that the wholesales customer base would not tolerate the required price increase. Forays into the Brisbane and Melbourne markets have cost the company dearly and left the company strapped for cash. The only positive outcome from these trials, was the knowledge gained to structure air flight delivery to those capitals.
To revitalise the company’s fortunes and to pay for the up keep of the company yacht, Rakshya, Aashish and Dipesh have put together a plan to grow the business and change the business model and revenue stream of the company.
The Mo Mo Factory are to risk cannibalising there exiting business and to start selling directly to the general public. The project will involve setting up retail outlets in 10 shopping centre food court in each of the three eastern seaboard capitals. 30 shops in all.
Project work has been divided into 7 sections from which you the Project manager will create the WBS for the project | ||
1.0 | Fund Raising | |
2.0 | Securing retail spaces | |
3.0 | Retail Spaces Fit out | |
4.0 | Systems Development | |
5.0 | Hardware Acquisition | |
6.0 | Staff Acquisition and training | |
7.0 | Marketing and promotion |
As old Alumni’s of CQU Rakshya, Aashish and Dipesh had come to the college and requested your help to turn their plan into a set of MS project worksheets. You will carry out this work individually with the assistance of your tutor.
You have responsibility for scheduling the work of a team of 16 professionals and will need to manage their labour, accommodation and air travel costs. Other transport and material costs will be incorporated into the Mo Mo Factory’s operational cost centre and will not be included in your MS Project plan. You also do not need to include your our own labour cost/resources and that of Rakshya, Aashish and Dipesh in the MS project files.
Rakshya, Aashish and Dipesh have left some notes that formed the basis of the plan and your structure for your WBS in your Ms Project in this table below.
<
WBS | Task Name | Comments/task sequence | Effort and Resources | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.0 | Fund Raising | Project start date 10th June 2019 | 3 weeks Rakshya, Aashish and Dipesh. (Don’t show these resources in the project plan ) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.0 | Securing retail spaces | Start after fund raising | A region manager will be recruited at each site. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.1 | Determine locations | Work can be done simultaneously in each region | 2 weeks simultaneous work by each of the three RM’s | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.2 | Negotiate rental contract | After Determining Location 2.2 | 4 weeks of 3 RM’s | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.3 | Review and Sign Contracts | After Review and Sign Contracts | 2 weeks 1 RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.0 | Retail Spaces Fit out | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.1 | Carpentry | After the Review & Sign Contract. 5.1.4 carpentry work can commence. | Three days each shopping centre | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.1.1 | Sydney | 30days of 2 SF and 10% of RM | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.1.2 | Melbourne | Start After Sydney | 30days of 2 SF and 10% of RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.1.3 | Brisbane | Start after Sydney | 30days of 2 SF and 10% of RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.2 | Electrics | One days each shopping centre | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.2.1 | Sydney | Start once Carpentry in Sydney is complete 2.1.1 | 10days of 2 SF and 10% of RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.2.2 | Melbourne | Start once Carpentry in Melbourne is complete 2.1.2 | 10days of 2 SF and 10% of RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.2.3 | Brisbane | Start once Carpentry in Brisbane is complete 2.1.3 | 10days of 2 SF and 10% of RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.3 | Plumbing | Work can be done at each site at the same time | Two shopping centres each day | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.3.1 | Sydney | Start once Electrics in Sydney is complete 2.2.1 | 5 days of 2 SF and 10% of RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.3.2 | Melbourne | Start once Electrics in Melbourne is complete 2.2.2 | 5 days of 2 SF and 10% of RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3.3.3 | Brisbane | Start once Electrics Brisbane is complete 2.2.3 | 5 days of 2 SF and 10% of RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.0 | Systems Development | The Mo Mo factory did not set out to replace information systems for this project , but it soon became clear that sound financial control and accurate demand pull, product delivery were essential. | Each module has multiple tasks Each task requires multiple resources (these are summary headings and we never assign resources to summary headings) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.1 | Manufacturing Resource Processing | The BA later explained first module 4.1 was in fact 5 tasks shown in the next 5 rows. Details of the other modules: 4.2,4.3,4.4,4.5 were later forwarded in an e-mail in table form ( below ) as the associated tasks were similar. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.1.1 | Inventory control | After IB Acceptance 1.1. | 2 wks of Business Analysts (BA) ,Software Engineer (SE) and Production Specialist (PS) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.1.2 | Modelling production lines | After inventory control 5.1.1 | 2 wks of Business Analysts (BA) ,Software Engineer (SE) and Production Specialist (PS) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.1.3 | Capacity planning | After inventory control 5.1.1 | 1 wks Software Engineer (SE) and Production Specialist (PS) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.1.4 | Live production reporting | After Modelling production Lines 5.1.2 and Capacity Planning 5.1.3 | 3 Days Business Analysts (BA) Software Engineer (SE) and Production Specialist (PS) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4.1.5 | Integrations | After Activity learning 5.1.2 | 2 Day of Business Analysts (BA) , Software Engineer (SE) and Production Specialist (PS) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The other software modules all have similar tasks so have been arranged in this table below | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5 | Hardware | To fit out at each of the 30 locations Micro Wave Point of Sale equipment LCD Screens Warmer cabinets Bins . | Don’t need to include these capital resources in the plan. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.1 | Hardware Order | The day after the IB Acceptance 1.0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.1.1 | Develop Tender Document | After IB acceptance | 6 days work for BA, RM, PS, EM & CH | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.1.2 | Open Tender | After Develop Tender Document 5.1.1 | 2 weeks no resources | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.1.3 | Award Tender | After Open tender 5.1.2 | 1 day BA & RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.1.4 | Review & Sign Contract | After Award tender 5.1.3 | 1 day BA &RM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.2.1 | Hardware Shipping | After Sign review Contract 5.1.4. All equipment is delivered to Burwood NSW | 2 weeks, no resources | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.2.2 | Hardware received and checked | 4 Day PS,SF and EM | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.3 | Food court outlet configuration | Staff from Sydney will be used for these tasks. One SE / EM will travel in a hired van to each city meaning we can do only one region at a time in addition accommodation and van rental will need to be calculated for these tasks |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.3.1 | Warmer Cabinet assembly | On arrival of the Hardware 5.2. 1 days each site. Start or Finish in Sydney to avoid paying for weekend accommodation. | 2 weeks of SF and EM and RM 10% per region plus travel time Van Hire are $50 per unit/day. (remember to add these in MS project as materials not work) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.3.2 | Servers/network | ½ days each site. Start or Finish in Sydney to avoid paying for weekend accommodation. Requires the network (5.3.1) to be in place. | 6 days of SE. Should be done in conjunction with Network. Server will be delivered with Warmer Cabinets. SE can travel with the van or Fly down | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.3.3 | POS Assembly | On arrival of the Hardware 5.2. 2 days each site. Start or Finish in Sydney to avoid paying for weekend accommodation. Requires the Servers (4.1) to be in place. | 4 weeks of EM, SE and RM 10%. Per region plus travel time. Separate van trip delivering POS and LED Screens. Require accommodation while away from Sydney. Van Hire and accommodation for EM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5.3.4 | LED Screen installation | After 5.3.2 and 5.3.3 | 6 days of both CH & SE and RM 10%. Will require flights for the CH and accommodation | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sections 5.3.1 to 5.3.5 will need subtasks for the different location to provision the differing resource requirements The relevant team members will need to fly from the factory in Sydney to the other capitals to complete the work for each of these tasks. While others will travel by van. It will be necessary to make 2 van trips to each location one for Cabinets and server the other for POS and led’s as they won’t all fit in the first trip.These tasks will consume flight resources and Accommodation resources but only for the time away from Sydney. All of them will need van resources | Accommodation is $100 per unit Flights are $200 per unit. Van Hire $50 per unit (remember to add these in MS project as materials not work) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
6.0 | Staff Acquisition and training | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
6.1 |
Resource Name | Type | Std. Rate |
Accommodation Cost Warmer Cabinet Assembly | Material | $5,000.00 |
Accommodation cost of SE | Material | $1,500.00 |
Flight and Accommodation for CH | Material | $2,000.00 |
POS Assembly Accommodation and Travel | Material | $3,000.00 |
MMFO_PartAQ2.mpp: This file presents the levelling of resources as done from previous file. As per requirement, the levelling options used are:
The change in project can be shown as follows:
MMFO_PartAQ1.mpp | MMFO_PartAQ2.mpp | ||
Total Duration | Total Cost | Total Duration | Total Cost |
129 days | $828,675.60 | 277 days | $828,675.60 |
The increased duration indicates the impact of levelling whereby the time taken has increased.
The increase is very high as levelling was done with the requirement that no additional resources will be hired and they cannot be split. This is the reason that project cost remains same and only time increased.
Further, there is no change in ordering or sequence of tasks as the predecessor task as set in initial file have been kept same for this file also.
MEMO
To: The Founding Members, The MoMo Factory
From: Project Manager, XXX
Subject: Plan for Setting up Retail Outlets
Date: 24th May, 2019
The memo provides estimated plan for setting up of The MoMo Factory retail outlets in Sydney, Brisbane and Melbourne. Assuming that the project start date is 10th June, 2019, the estimated duration of the project is 277 days with the completion date being 22nd July, 2020. The total project cost is estimated at $828,675.60.
The initial project duration was estimated at 129 days but due to constraint of resource availability, the resources were levelled which increased the duration to 277 days. Most of the tasks are sequential in nature such that a task cannot begin simultaneously with previous tasks. However, the duration can be reduced by allocating more resources to tackle over-allocation aspect.
The direct cost has been estimated as:
Resource Name | Cost ($) |
Regional Managers (RM) | 1,97,785.60 |
Business Analysts (BA) | 1,14,240.00 |
Production Specialist (PS) | 61,560.00 |
Software Engineers (SE) | 1,56,640.00 |
Catering and Hygiene Analyst (CH) | 44,160.00 |
Shop Fitter (SF) | 1,18,400.00 |
Electrical and Mechanical Engineer (EM) | 78,400.00 |
Marketing Analyst (MA) | 46,080.00 |
Total direct labour costs: | $8,17,265.60 |
Accommodation Cost Warmer Cabinet Assembly | 5,000.00 |
Accommodation cost of SE | 1,500.00 |
Flight and Accommodation for CH | 2,000.00 |
POS Assembly Accommodation and Travel Cost | 3,000.00 |
TOTAL COST | $8,28,765.60 |
Thank You,
XXX
Attachments: MMFO_PartAQ2
MMFO_PartAQ3.mpp: A copy of MMFO_PartAQ1 was created to see the over allocation of resources:
It can be seen that all the resources are over allocated but we have an option of increasing one resource only. Hence, the next step is to identify critical path through network diagram and see resource allocation for those resources. The identified resources on critical path are Regional Manager (RM) and Marketing Analyst (MA) but we have a constraint of increasing one resource from 100% to 200%. Hence, in this section, resource allocation has been increased for Marketing Analyst from 100% to 200%. This has been done by adding a resource called Additional Marketing Analyst at the same rate as MA and this has been allocated to WBS 7.1 to 7.4. The change is as follows:
MMFO_PartAQ1.mpp | MMFO_PartAQ3.mpp | ||
Total Duration | Total Cost | Total Duration | Total Cost |
129 days | $828,675.60 | 125.67 days | $831,985.60 |
It can be seen that duration has reduced by around 4 days at an additional cost of around $3,300 which is the cost of additional MA.
MMFO_PartAQ4.mpp: A copy of MMFO_PartAQ3 was created to see the over allocation of resources and level resources to tackle the issue:
The change is as follows:
MMFO_PartAQ1.mpp | MMFO_PartAQ3.mpp | MMFO_PartAQ4.mpp | |||
Total Duration | Total Cost | Total Duration | Total Cost | Total Duration | Total Cost |
129 days | $828,675.60 | 125.67 days | $831,985.60 | 253.17 days | $831,985.60 |
It can be seen that after levelling, cost has remained same but impact is fully taken on duration as no additional resources have been hired. The total duration is now 253.17 days with a total cost of $831,985.60. The estimated project end date is 19th June, 2020.
All the resources were over allocated in initial file as seen above. Hence, it may be possible to reduce the duration by adding more resources as done for Marketing Analyst in initial stage.
Part A Q5: The quality issues that can hamper the project include:
The tasks that can be added are related to checking quality in first outlet before launching more outlets and another can be documenting the found results for perusal in further opening of new outlets:
WBS Number | Task Name | Predecessor’s | Duration | Resource |
8.0 | Testing results from First Outlet | M5 | 15 days | Regional Managers |
9.0 | Quality Testing & Reports | 8.0 | 15 days | Regional Managers |
Part A Q6: As discussed above, project monitoring is a critical aspect for success of any project. Hence, this must be included at various steps so as to ensure that project remains on track in terms of cost as well as duration. This also helps to rectify deviations in a timely manner. For example, if a resource is in shortage, a call can be taken whether to hire additional resource or analyse effectiveness of current resource.
Additionally, risk management should also be an integral part of any project so as to handle any risk arising in an effective manner.
Part B Q1: The Sprint has replaced the traditional module method under Point of Sales, leading to an increased overall duration of project from 277 days to 293 days and project ends on 13th August, 2020. This is due to predecessors for various tasks being changed to later tasks.
For example, earlier, none of the Point of Sales tasks were critical to completion due to presence of slack period. Now, after Sprint method, Sprint 1 and Sprint 2 have become critical tasks as all slack has been utilized due to change of predecessor activity constraints.
Part B Q2: Earlier, none of the Point of Sales tasks were critical to completion due to presence of slack period. Now, after Sprint method, Sprint 1 and Sprint 2 have become critical tasks as all slack has been utilized due to change of predecessor activity constraints.
Change | Impact on project duration (longer, shorter or no impact) | Explanation ( which resources and task clashes were the cause) |
Removal of POS module | Longer duration | Due to dependence on various tasks or changing of predecessors. |
Addition 5.2.1 Sprint 1 | None | The task is a critical task now due to utilization of all the slack present earlier. There is over allocation of resources. |
Addition 5.2.2 Sprint 2 | None | The task is a critical task now due to utilization of all the slack present earlier. |
Addition 5.2.3 Sprint 3 | None | There is over allocation of resources. |
Addition 5.2.4 Sprint 4 | None | None |
Part B Q3:
Change | Impact on project Cost (greater ) | Explanation ( which additional resources were the cause) |
Removal of POS Module | Greater at $263,400 | Addition of resources BA, RM, SE, EM, MA, if missing |
Addition 5.2.1 Sprint 1 | Greater at $76,800 | Addition of resources BA, RM, SE, EM, MA, if missing |
Addition 5.2.2 Sprint 2 | Greater at $55,200 | Addition of resources BA, RM, SE, EM, MA, if missing |
Addition 5.2.3 Sprint 3 | Greater at $76,200 | Addition of resources BA, RM, SE, EM, MA, if missing |
Addition 5.2.4 Sprint 4 | Greater at $55,200 | Addition of resources BA, RM, SE, EM, MA, if missing |
Part B Q4:
A sprint methodology involves frequent meetings where a ScrumMaster or leader takes status update from team members and works towards removing obstacles in achieving goals so that the project stays on time. The methodology is collaborative in nature and hence, lines of communication need to be kept open. Further, it is necessary to hold frequent meetings so as to stay on set targets in the timeframe decided.
Hence, project manager needs to ensure clear communication about the timeframe and deadlines for smaller tasks involved in a stage so that team members use all their efforts to complete the task. Further, regular monitoring and meetings are necessary to identify roadblocks so that the project manager can clear the same and target can be met.