A1 Student Example 1
A1 Student Example 1
A1 Student Example 1
Project Proposal
Euclid Avenue Dental
Prepared by:
Student | s0001001
1
Table of Contents
1. System Vision Document ............................................................................................................... 3
1.1 Identify the Problem ............................................................................................................ 3
1.1.1 Problem Description........................................................................................................ 3
1.1.2 Systems Capabilities ........................................................................................................ 3
1.1.3 Business Benefits ............................................................................................................. 3
2. Quantifying Project Approval Factors ............................................................................................ 4
2.1.1 Estimated Time for Project Completion ......................................................................... 4
2.1.2 Development Costs of Project ........................................................................................ 4
2.1.3 Estimated Annual Operating Costs of Project ................................................................ 6
2.2 Cost/Benefit Analysis ........................................................................................................... 6
2.2.1 Anticipated Benefits of the Proposed System ................................................................ 6
2.2.2 Estimated Annual Benefits of Project ............................................................................. 7
3. Risk & Feasibility Analysis .............................................................................................................. 9
3.1.1 Organisational Risk & Feasibility .................................................................................... 9
3.1.2 Technological Risk & Feasibility .................................................................................... 10
3.1.3 Resource Risk & Feasibility ........................................................................................... 10
3.1.4 Schedule Risk & Feasibility ............................................................................................ 11
4. Establish the Project Environment .............................................................................................. 11
4.1 Project Tools & Software .................................................................................................... 11
4.2 Project Work Environment ................................................................................................. 12
4.2.1 Hardware/Software ...................................................................................................... 12
4.2.2 Physical Environment .................................................................................................... 13
4.2.3 Support Staff ................................................................................................................. 13
4.3 Project Processes & Procedures ......................................................................................... 13
4.3.1 Reporting & Documentation ......................................................................................... 13
4.3.2 Programming ................................................................................................................. 13
4.3.3 Testing ........................................................................................................................... 14
4.3.4 Deliverables ................................................................................................................... 14
4.3.5 Code & Version Control ................................................................................................. 14
5. Schedule the Work ...................................................................................................................... 14
5.1.1 Project Work Breakdown Structure .............................................................................. 14
5.1.2 Gantt Chart .................................................................................................................... 16
References ........................................................................................................................................... 16
2
1. System Vision Document
1.1 Identify the Problem
1.1.1 Problem Description
Business success depends on a range of elements, including the implementation and use of
effective systems, marketing strategies and online presence of the business. However, the
current system used in Euclid Avenue Dental, a small suburban dental practice, is inefficient
and possesses some deficiencies. Further, the online presence of Euclid Avenue Dental is
currently minimal. Improvements to the current system’s efficiency, including relevant
additions to the system, and an improved website, will increase the quality-of-service Euclid
Avenue Dental has to offer to its employees and patients. These improvements will also
enhance communication between the employees and patients of the dental practice.
Moreover, the advances a proposed system will bring will increase the success and survival
of Euclid Avenue Dental.
3
2. Quantifying Project Approval Factors
2.1.1 Estimated Time for Project Completion
Table 1 outlines the development of the subsystems and estimates a total of 20 weeks for
the project to reach completion. There are nine subsystems involved in this project, as listed
below. The accounts, dental charting and treatment planning, website, written records and
x-ray and photographs subsystems will require improvement on the existing system. The
remaining subsystems will need to be created and developed from the beginning. As a
result, some subsystems will require more or less time to develop, depending on whether it
will be based on the existing subsystem. Moreover, the complexity of each subsystem will
also factor into the development time.
4
Summary of Development Costs for Euclid Avenue Dental
Expense Category Amount (AUD)
Wages:
1
Project Manager (x1) $16,707
2
Business Analyst (x1) $20,290
3
Programmer/Developer (x1) $20,224
4
Systems Analyst (x1) $17,830
5
Support Technician (x1) $15,102
6
Facilities $8,000
7
Hosting $115
8
Equipment and Miscellaneous $1,732
Total $100,000.00
Table 2: Estimated Project Development Costs
1
Average Project Manager wage is $52.21 per hour. The Project Manager will be responsible
for planning the project, as well as managing and following up with employee progress.
(PayScale Inc., 2021). The Project Manager will work a total of approximately 16 hours a
week, for 20 weeks.
$52.21/hr * 16 hours * 20 weeks = $16,707 (AUD)
2
Average Business Analyst wage is $42.27 per hour. The Business Analyst will be responsible
for analysing the subsystems, particularly the accounts and inventory, in addition to
reporting to the Project Manager (PayScale Inc., 2021). The Business Analyst will work a
total of approximately 26 hours a week, for 20 weeks.
$42.27/hr * 24 hours * 20 weeks = $20,290 (AUD)
3
Average Programmer/Developer wage is $31.60 per hour. The role will include designing,
developing, and programming the subsystems (PayScale Inc., 2021). The
Programmer/Developer will work approximately 32 hours a week, for 20 weeks.
$31.60/hr * 32 hours * 20 weeks = $20,224.00 (AUD)
4
Average Systems Analyst wage is $27.86 per hour. The Systems Analyst will work in
developing, analysing, and testing the subsystems (PayScale Inc., 2021). The Systems Analyst
will work a total of approximately 32 hours a week, for 20 weeks.
$27.86/hr * 32 hours * 20 weeks = $17,830 (AUD)
5
Average Support Technician wage is $25.17 per hour. The Support Technician will be
responsible for supporting other project members and keeping track of the performance of
the system and its subsystems (PayScale Inc., 2021). The Support Technician will work a
total of approximately 30 hours a week, for 20 weeks.
$25.17/hr * 30 hours * 20 weeks = $15,102 (AUD)
6
The approximate cost of facilities is $400 per week (AUD) with a person’s capacity between
5 and 7 (REA Group Ltd., n.d.). As the estimated project time is 20 weeks, the total amount
of rent for facilities is approximately $8,000.00 (AUD).
5
7
The hosting services required for the project will cost approximately $22.90 a month (AUD)
(Digital Pacific, 2021). The project is estimated at 20 weeks, which is approximately 5
months. Therefore, hosting services will cost approximately $115 (AUD) for the total time of
the project.
8
The equipment required for the project will include an iPad mini. The cost of purchase for
the iPad mini is $599.00 (AUD) (Apple Inc., 2021). It will be used to help develop a digitalised
patient medical form, in addition to other relevant patient forms. A total of $133.00 (AUD)
will be awarded to miscellaneous items. Additionally, $1000 will be awarded to necessary
employee training, as the project is for a dental practice and more specialised information
will be required. This expense will total to $1,133 (AUD).
6
Tangible Benefits
§ Increasing the revenue of the business:
o Easily tracking and following up on outstanding patient accounts.
o Reducing cost of inventory by eliminating amount of excess stock ordered each
month through the inventory subsystem, which allows for more efficient tracking
on items.
§ Decreasing stationery and printing costs:
o Electronic payment, billing and ordering will significantly reduce the requirement
of paper and stationary.
o Electronic storage of patient records will significantly reduce the requirement of
paper and stationary.
§ Reducing employee wages:
o The cost of employee labour when ordering stock for the practice will be lowered
with the new inventory subsystem.
o Reduced employee labour from increase of system efficiency and electronic
patient files.
Intangible Benefits
§ Increasing patient experience of the practice.
o Patient wait time for payment and billing will be reduced.
o Increasing patient referral of family and friends of existing patients.
§ Increasing the reputation of the practice.
o Positive patient and employee interactions due to effective notes on patient files.
o Attracting potential patients and maintaining existing patients through positive
experience on website and online booking option.
§ Increasing employee satisfaction.
o Increasing productivity of employees through digital subsystems.
o Increasing employee work-life balance.
o Increasing morale of employees.
§ Increasing communication between practitioners, employees, and patients.
o Enhancing the quality and types of appointment notes for patients.
o Improving the quality and detail of patient dental charting and treatment
planning.
o Increased organisation of patient files and notes.
7
Estimated Annual Benefits of Euclid Avenue Dental
Benefit/Cost Saving Amount (AUD)
1
Increase of Busines Revenue $243,000
2
Decreased Stationary Costs $3,798
3
Reduced Employee Wages $11,433
Total $258,231
Table 4: Estimated Annual Benefits
1
Increase of Busines Revenue. The estimated revenue for the practice is $2,500,000 (AUD)
(Australian Dental Industry Association (ADIA), 2020). It is estimated that approximately
0.18% of accounts are considered outstanding and that the system can lower this to 0.09%.
Additionally, it is estimated that approximately $1,500 (AUD) of excess stock is ordered for
the practice each month. Therefore, it is estimated that the total gain would be $243,000
(AUD).
$2,500,000 * 0.09% = $225,000 (AUD)
$1,500 * 12 months = $18,000 (AUD)
2
Decreased Stationary Costs. The estimated average cost of stationary for the practice is
$92 (AUD) per month (Hearst, 2019), and a 0.57% reduction of stationary used, and printing
required per year.
($92 * 12 months * 8 employees) * -0.57% = -$5,034.24 (AUD)
($92 * 12 months * 8 employees) * 0.43% = $3,797.76 (AUD)
3
Reduced Employee Wages. It is estimated that employees will spend less time on tasks
after the introduction of the new subsystems by approximately 2.25 hours a week. The
average wage of a dental assistant is $24.21 (AUD), and the average wage of a dental
receptionist is $25.09 (AUD) (PayScale Inc., 2021). Given there are three dental assistants
and one receptionist, this will reduce the amount spent on wages by approximately
$11,433.24 (AUD).
($24.21 * 2.25 * 52 * 3) + ($25.09 * 2.25 * 52) = $11,433.24 (AUD)
8
Category Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
1 Value of Benefits $258,231 $258,231 $258,231 $258,231 $258,231
2 Development Costs -$100,000
3 Annual Expenses -$2,627 -$2,627 -$2,627 -$2,627 -$2,627
4 Net Benefit/Costs -$100,000 $255,604 $255,604 $255,604 $255,604 $255,604
5 Discount Factor (6%) 1.0000 0.9434 0.8900 0.8396 0.7921 0.7050
6 Net Present Value -$100,000 $241,136 $227,487 $214,610 $202,462 $180,191
7 Cumulative NPV -$100,000 $141,136 $468,622 $442,097 $417,072 $382,653
8 Payback Period 0.41 151.37 151 days
Table 5: Cost/Benefit Analysis
9
§ Change in practice procedures and protocols.
Some practice procedures and protocols will change with the implementation of the
proposed system. Employees may resist or fear this change, as the current procedures are
more well-known and trusted. Offering transparency of the proposed system to the
employees can aid in the transition and minimise any fear in the procedure and protocol
change.
10
3.1.4 Schedule Risk & Feasibility
§ Unable to meet fixed deadline or critical points of project on-time.
The total estimated time of the project is 20 weeks. To ensure the commitment to the
deadline, both the Project Manager and Business Analyst will be involved in planning and
conformation of the project. Additionally, frequent communication between staff and the
Project Manager will assist the team in keeping all tasks on schedule.
Most of the electronic tools that will be used throughout the project are available for free
and are often used in these types of projects. All project members will already own and
have access to the remaining software that will be used for the project, namely Microsoft
(MS) software.
11
Analysts, Programmer, Support
Errors and Outstanding (update).
MS Excel, Dropbox, Trello.
Problems Project Manager, Business
Analyst (view).
Project Schedule GanttProject. All project members view.
Progress Tracking Trello, GanttProject. All project members view.
Project Manager, Business
Team Coordination
Trello, Zoom. Analyst (update).
Meetings
All project members view.
Design Diagrams and
Web Design Tools, Git. Analysts, Programmer (update).
Wireframes
Analysts, Programmer (update).
Program Code Git.
Website Code Web Design Tools, Git. Programmer (update).
Team Communication All project members update and
MS Outlook, Trello.
and Dashboard view.
Table 6: Information Captured
4.2.1 Hardware/Software
The project team will use their personal computers, in addition to an iPad mini that will be
purchased as a part of the project. This will allow the budget to be reduced on expensive
hardware items, such as computers and laptops.
The software to be used will be free, or existing on the project team’s hardware (Table 6).
The free software will include Trello, Git, Zoom, GanttProject, DropBox and open-source
web design tools. Most of the code and other information that is directly related to creating
the system will be stored on Git (Git, n.d.). As for the progress and daily team
communication, this will be centred around Trello (Atlassian, 2021). Additionally, MS
Outlook and Zoom will be used for more formal communication and team meetings. The
limiting, but varied options of communication, will facilitate the project team to be able to
communicate as best as possible.
Open-source web design tools will be used to develop diagrams and wireframes. DropBox,
Trello and Git will be used to deliver, communicate, and store this information, respectively.
GanttProject will be used to create and track the project. Trello will also be used to help
track the progress of the project in a more informal manner, while also facilitating
communication on the progress of the project between team members. This will encourage
the team’s awareness on the project’s critical points, milestones, and deadlines.
Additional software, existing on the staff’s computers, will include MS Word and MS Excel.
MS Word will be used for recording written documents of the project, user, and client. This
12
is a simple and common method to store these types of documents and can be easily
communicated to individuals. MS Excel will be used to record and track outstanding
problems and errors the project team may encounter. Using MS Excel will ensure a
centralised and organised method for recording and attending to problems throughout the
project.
The Business Analyst will be responsible for documenting the iteration progress reports and
project schedule tracking. This information will be documented using MS Word and
GanttProject. The Business Analyst will also record important informal communication using
MS Word.
4.3.2 Programming
The Project Manager and Business Analyst will assign positions to the programming
component of the project. The programming will be completed in pairs, with the
Programmer/Developer and Systems Analyst working together. For the development of the
website, the Programmer/Developer will be the leader of the pair. This will be driven by the
experience the Programmer/Developer has on building websites. As for the remaining
subsystems, the Systems Analyst will be the leader, given the experience and existing
knowledge base.
13
4.3.3 Testing
The Programmer/Developer will be responsible for testing the website and the Systems
Analyst will be responsible for testing the remaining subsystems. All tests will be in-house
programmer tests. However, additional user tests will be completed for the accounts, forms
and medical information, x-ray and photographs, as well as dental charting and treatment
planning subsystems. Items will be marked ready for testing on a centralised Excel
document and be communicated formally in team meetings and via email. This Excel
document will also facilitate the follow-up of bugs as well as troubleshooting information for
the project. The communication of issues in meetings and emails will also provide reminders
and reinforce required follow-ups for the Programmer/Developer and Systems Analyst.
4.3.4 Deliverables
The deliverables will be tested by the Programmer/Developer and the Systems Analyst.
The deliverables of the project are as follows:
o A website with online bookings.
o Digitalised patient accounts and payments.
o Digitalised appointment bookings.
o Digitalised patient forms and medical information.
o Digitalised written records, including appointment notes.
o Storage of digitalised patient x-rays and photographs.
o Recorded digital dental charting and treatment planning.
o Digital record of equipment and maintenance log.
o Digital and customisable inventory system.
The Project Manager will receive the deliverables after testing, ready for approval. Once
they have been approved by the Project Manager, they will be brought to the client for
approval. Upon the client’s approval, they will receive the deliverables through a handover
process, which will involve the installation of the system. The website will not be a part of
the installation process, and instead be handed over through confirmation and activation.
The project planning will primarily involve the Project Manager and Business Analyst. The
remaining tasks will involve the Programmer/Developer and Systems Analysts, to greater or
lesser degrees in each separate task section.
14
There is a total of 88.5 hours in this iteration. The work breakdown structure involves some
predecessors; however, many tasks can be completed simultaneously with other tasks.
Moreover, both the Programmer/Developer and Systems Analyst will be working together,
which will reduce the overall amount of time spent in this iteration.
15
5.1.2 Gantt Chart
Table 8 demonstrates the above work breakdown structure (Table 7) as a Gantt chart. The
Gantt chart outlines 30 tasks, in the form of ID’s, with the five section headings of the tasks
as their own separate tasks, giving a total of 35 tasks in the chart. The chart also specifies
the start date, end date, duration, and predecessors.
The resources involved in each task are listed on the right-hand side of the chart,
underneath each calendar bar. All meetings with project staff will require all staff to be
present. For client meetings, only the Project Manager will be present for the meeting itself,
however the Business Analyst will be briefed of the information in detail for staff meetings.
The duration of each task is measured in days, which is not particularly accurate for some
tasks as they will take a shorter amount of time. It should be noted that the software used
to create the Gantt chart does not allow for the duration measurement to be customised
into hours. However, based on the Gantt chart, the total time for the equipment
maintenance subsystem, iteration 3, to be completed will be approximately four weeks.
Although, Table 7 indicates the most accurate duration for the iteration, approximately 5
days, and the time spent on each individual task.
Based on the Gantt chart, the project planning stage will take a maximum of four days,
following which the analysis component will take a total of three days. This analysis stage
will primarily involve the Systems Analyst and Programmer/Developer, as well as the
Business Analyst. The following stage, designing, will take approximately four days. This
stage will involve the Systems Analyst and Programmer/Developer, working mostly in
collaboration on the tasks. The next stage is to build the equipment maintenance
subsystem, which will take approximately six days. Again, this stage involves the Systems
Analyst and Programmer/Developer to work in collaboration on the tasks. Some simple test
tasks will be involved in the build stage for practicality. Finally, the last stage of the iteration
will test the created subsystem. This will mostly involve the Systems Analyst and
Programmer/Developer, but the Business Analyst and Project Manager will also be present
on certain tasks. This section will also contain the client follow-up approval meeting and
team retrospection on this iteration of the project.
Each task has at least one predecessor listed, as shown in Table 8. This also assists in the
critical path outlined in the calendar section of the chart. The critical path is shown in the
black diagonal stripes of the blue bars, in addition the red highlights on the ‘Test Tasks’
duration bar. If any of these tasks are delayed, it will extend the estimated time of
completion for this iteration, as well as subsequent iterations.
16
Table 8: Gantt Chart
References
Apple Inc.. (2021). Buy iPad mini.
Retrieved from https://www.apple.com/au/shop/buy-ipad/ipad-mini/64gb-space-
grey-wifi
Aston, B. (2021, January 15). Ultimate Guide To Project Budgets [With Template &
Examples] [Blog post]. Retrieved from
https://thedigitalprojectmanager.com/project-budget-cost-estimation-guide/
Australian Dental Industry Association (ADIA). (2020). Australian Dental Industry Association
Limited Annual Report 2020 [pdf]. Retrieved from
https://assets.cdn.thewebconsole.com/S3WEB9942/images/1-6-10-2020-ADIA-
Annual-Report-Final.pdf?m=212713da6ae7bf23201cc8add20d73e9
Erickson, B. (2019, March 5). How long does it take to build a website? [Blog post].
Retrieved from https://www.billerickson.net/how-long-does-it-take-to-build-a-
website/
Hearst. (2019, March 8). The Average Cost Per Month for Office Supplies [Blog post].
Retrieved from https://smallbusiness.chron.com/average-cost-per-month-office-
supplies-12771.html
PayScale Inc.. (2021). Average Project Manager, Information Technology (IT) Salary in
Australia. Retrieved from
https://www.payscale.com/research/AU/Job=Project_Manager%2C_Information_Te
chnology_(IT)/Salary
PayScale Inc.. (2021). Average Support Technician, Information Technology (IT) Salary in
Australia.
Retrieved from
https://www.payscale.com/research/AU/Job=Support_Technician%2C_Information_
Technology_(IT)/Salary
REA Group Ltd.. (n.d.). Office space in Brisbane City, QLD 4000.
Retrieved from https://www.realcommercial.com.au/short-term-workspace/office-
space/brisbane-city-qld-
4000/?pricing[min]=100&pricing[max]=750&pricing[unit]=week&capacity[min]=7&c
apacity[max]=10&sort=price-lowest
17