This case study is about a travel agency that specializes in booking spring break/reading week vacations for college/university students. The narrative deals with real time bookings, financial transactions, and confirmations to ensure that students are correctly booked for the resort, week, room, and groupings as reserved and paid for. These are the only aspects of the system that are under consideration. The current system is manual. RWM wants to fully automate the above aspects of the system due to the errors, problems, etc. with the current system. This narrative deals with real business processes which require detailed financial information which must be made on an accurate and timely basis. Buslness Summary Reading Week Madness Ltd. (RWM) is a travel service that specializes in vacations for college/university students during reading week/spring break at various Caribbean resorts. It deals with about 35 campuses across the province. Each college/university campus has a campus representative who interacts with the students at the campus. The campus reps are paid $20 /hour. Each campus has one rep. RWM has a general manager, Steve Berry, who deals with all the campus representatives. Each resort has a campus coordinator who deals with the RWM manager and the students once they arrive at the resort. During the fall semester, approximately 30 resorts submit availability information to RWM indicating specific weeks, rooms, room capacities and rates for each week of the spring break. Note that spring break weeks differ across colleges and universities, mainly over the months of February and March. Each resort offers bookings for various weeks. It takes about 75 hours, for the resort contact, at $35/ hour, to create these listings. The rates for the weeks and rooms differ depending on the week chosen. Usually, the resorts make available a variety of rooms with different capacities so students can book a room as a group. Rooms available are doubles for two, and group rooms for four. There are no other room capacities. Overbooking of rooms is not allowed. The RWM manager generates a list of resorts, available weeks, available rooms, and room rates that are distributed to the campus representatives. RWM creates this list based on the email conversations they have with each individual resort during the months of October and November. This can be a lengthy process and often requires multiple iterations to get the availability details right and documented. This can take 25 hours a week to complete over a 6week period. This does not include the time to make modifications. Students book their vacation by contacting the campus rep and providing details such as resort name, room type, student details together with names of students in their group for groups of 2 or 4 . A deposit cheque is required during this booking. It is cashed and payment noted on the student registration. Cashed cheques are totalled by campus and cross-referenced to each student and kept in a separate bank account. This activity can take about 21 hours a week over an 8-week period. These RWM activities occur in December and January in preparation for the reading weeks scheduled for the winter. Each college/university has a different cut-off date by which all bookings must be paid in full by means of a cheque for the total amount less the deposit. Once these cheques clear, they are organized by resort name and group names by the RWM manager. The amount totals are transferred by means of a banking transaction to the respective resorts. A 5% holdback is given to RWM Ltd. as payment for their services. The booking details are printed and faxed to each resort. Once each cheque clears, a confirmation of travel is created by the RWM manager and faxed to each campus rep who it turns distributes it to the students. All of this can take about 40 hours a week over a 6-week period. The manager makes $35/ hour. When a group of students submits a reservation request for a particular week at a particular resort, RWM rep assigns the students to a room, ensuring sufficient capacity and the campus rep gives each student a reservation notification. If a student has not fully paid for the trip by the cut-off date that student is removed from the room list; a non-payment notice is created by RWM manager and it and the deposit is returned to the student by the rep. Students on the waiting list are asked if they would like to occupy the available spot. Modifications such as these require extra time to process, adding another 8 hours of work each week for 8 weeks to the campus rep. If a student agrees to occupy the spot, that student must be accepted by the remaining students who are part of that group. The rep must notify each member of the group of the new student and ask if they accept that student. If all agree, the student is accepted, that new student is added to the group/room and a new added notice is given to each member of the group. If they do not agree, that student can ask to join a different group that has fewer than 4 students. So, the process repeats itself. Most of the time, it resolves itself. However, if a 4person room is finalized to have only 3 students in it, those 3 members must pay a higher rate to compensate for the rate loss of the missing student. When the cut-off date for a week arrives, RWM emails each resort a confirmed paper list of students booked by room for the week in question. RWM also transfers the funds to the resort. If a student does not arrive at the resort, they forsake all funds paid. No monies are returned at this point. INFO20172 Assignment Requirements Winter 2023 The current system is manual. The owner is looking for an in-house automated system. This narrative deals with real business processes which require detailed financial information which must be made on an accurate and timely basis. NOTE: You are responsible for this project. You will be leading this project. You will be determining the modules for this automated system. You will NOT be outsourcing this project to any third-party consultant and you will NOT be implementing a third party software application for this automated system (i.e. off the shelve software). The following are the assignment requirements: - Maximum 3 members to a group. - Submit ONE Word document to the SLATE assignment dropbox. The document must contain all sections as listed below. - Do not zip the document. Zipped documents will be treated as late documents and will be penalized 10% per day. After 3 days late, the grade is zero. - A document submitted in sections will be treated as a late document and will be penalized 10% per day. After 3 days late, the grade is zero. - A document named incorrectly will be treated as a late document and will be penalized 10% per day. After 3 days late, the grade is zero. - Faculty do not inform students if submissions are in improper format. - The word document must be named as follows asgn.classID. group\#. - The class id is the 5-digit number on SLATE I,e. 17970 Your submission must be based upon the details of narratiye. any thing else will earn a grade of: zero. Please note that if cheating is discovered in an individual/group assignment each member will be charged with a cheating offense regardiess of their minvoivenent in the offense. Fach member will receive the appropriate sanction based on their fidividual academic honesty history. The Word document will have the following sections: A titie page. The tttle page will list: - The assignment name - The class ID - The due date - The student(s) full name and student number - Student(s) signature(s) Objectives: An objective is a statement detailing something that must be achieved by a certain point in time. An objective is specitic, measurable, achievable, relevant and timely. Your objective may be to land a full-time job as an entry level programmer by Dec 312022 . That is specific, measurable and timely. By Dec 312022 you will see if you have attained your objective. SMART parameters are woven into the objective sentence itself. State 3 objectives for this new system automation. Objectives need to relate to the case study given. Justification: As part of any undertaking, there must be reasons for going ahead with this system automation. Without a justification given, undertaking the project becomes pointless. What is the justification for going ahead with the automation? This description MUST BE valid. applicable, and RELEVANT to the case study in question. Scope: What is the scope of this new system automation? Define and describe the processes, subsystems, etc. that will form the scope. The scope pertains to the whole narrative given and not just a section of it. This is not a repetition of the case study. Scope must support the justification of the project. The objective states what you want to achieve. The justification explains why you want to achieve it. The scope states what will be achieved. Stakeholder Responsibilitles Provide a table listing all the stakeholders. Include their names, roles and responsibilities throughout the entire project. Be clear in what each person is responsible for. You and your group members take on the role of the project manager and team members. Cost Beneft Analysls (CBA) Complete a cost benefit analysis for this case study. Why go ahead with the new system? What are the tangible benefits associated with this new system? What cost savings would occur with a new system compared to the old system? Tangible benefits look reductions in costs. Give a breakdown of these tangible benefits as they would apply to the various sections described in the case study. What are the development costs for creating the new system? Provide a breakdown of costs for hardwareetworking/coding/testing/etc for the new application software. Provide a breakdown of the types of operating costs for this new system. Create a cost benefit analysis spreadsheet and calculate the NPV, ROI and Payback ratios: Explain what these ratios mean to the client and what they suggest with respect to the new system. Assume the life of the new system is 5 years. Use a discount rate of 4% with factors of .9692.89.85.82 Work Breakdown Structure Chart Create a WBS in Word as below. Your WBS needs to show the steps necessary to create, undertake and complete the new automated system and manage its processes. It must. relate to the scope of the project. Your WBS is a planning document that GUIDES the execution of the project. It needs to relate to the 5 project management processes, with the MOST detailed one being Execution. Your WBS tasks will need to go down to a level 3. Your WBS must relate to your content in the previous sections AND to the case study details. The ppts for chapter 5 give examples of the required level of detail needed by the WBS. For each task on the WBS, give a description of what that level 3 task is about. For example, reservation could mean coding it, creating a screen for it, etc. Your mark will depend on the accuracy and comprehensiveness of the WBS as it relates to the case study. 1.0 Main category 1 1.1 Subcategory 1.1.1 Sub-subcategory - plus wbs dictionary item 1.1.2 Sub-subcategory - plus wbs dictionary item And so on 1.2 Subcategory 1.2.1 Sub-subcategory - plus wbs dictionary item 1.2.2 Sub-subcategory - plus wos dictionary item And so on 1.3 Subcategory 1.3.1 Sub-subcategory - plus wbs dictionary item 1.3.2 Sub-subcategory - plus wbs dictionary item And s0 on 1.4 Subcategory 1.4.1 Sub-subcategory - plus wibs dictionary item 1.4.2 Sub-subcategory - plus wbs dictionary item 2.0 Main category 2 2.1 Subcategory 2.1.1 Sub-subcategory - plus wbs dictionary item 2.1.2 Sub-subcategory - plus whs dictionary item And so on 2.2 Subcategory 2.2.1 Sub-subcategory - plus wbs dictionary item 2.2.2 Sub-subcategory - plus wbs dictionary item And so on 2.3 Subcategory 2.3.1 Sub-subcategory - plus wbs dictionary item 2.3.2 Sub-subcategory - plus wbs dictionary item And so on .... Continue with ALL the remaining categories needed to complete the system