Calculate the schedule performance index spi
Solved Step by step with explanation of implement a smart ordering system for Grilloo
Question
INF3708-23-Y-ASSESSMENT 3 1 CASE Grilloo is a successful restaurant in Cape Town CBD that specialises in flamed grilled meals. The owner of Grilloo recently hired a software development company – Designor – to design and install a smart ordering system for patrons. Designor formulate Project X and Project Y to help the successful design and implementation of the ordering system. Each respective project offers different strategic planning approaches, funding models and physical resources. Project X specifies an ordering system whereby a tablet is physically installed into tables, allowing clients to access the digital menu. Upon selection of meals and beverages, the order is sent to the kitchen. When the meal preparation is complete, the cook or chef will deliver the food to the table. Project Y found that tablets may not be a viable strategy due to wear-and-tear expected from a high frequency of use – this implies a hike in maintenance cost. In response, it has been suggested that the customer bring their own device and download a Grilloo app (to be created) to order meals. You are a graduate with a Bachelor of Science in Information Systems from the University of South Africa. You have been hired by Designor to become part of the project management team who will design and create the smart ordering system for Grilloo. INF3708-23-Y-ASSESSMENT 3 2
Question 1 [60] You’ve been instructed by the project manager to draft the business case for Project X. The project manager will review your assertions, inferences, and suggestions.
1.5. The Analysis and Options and Recommendations section is followed by Information Systems Requirements. Describe at least three actions/functions that the ordering system must execute. (6)
1.6. The section on Information Systems requirements is followed by Budget and Financial Analysis. You are instructed to calculate the estimated net present value (NPV) and return of investment (ROI) of both Project X and Project Y based on the cash flows in Table 1. Table 1: Project X and Project Y cash flow Year Project X Project Y 0 -R165 000,00 -R60 000,00 1 R92 000,00 R58 000,00 2 R85 500,00 R59 000,00 3 R61 000,00 R61 000,00 4 R78 300,00 R61 000,00 INF3708-23-Y-ASSESSMENT 3 3
1.6.5. Calculate the total discounted benefits of Project X. (1)
1.6.6. Calculate the NPV of Project X. (1)
1.6.11. Calculate the NPV of Project Y. (1)
1.6.12. Calculate the ROI (multiyear projects formula) of Project X (round the ROI off to 1 decimal place). (2)
2.1.2. Indicate the activity which has free slack and number of days the activity can be delayed before a subsequent task. (2)
2.2. Grilloo and Designor took the joint decision to outsource the physical installation of the tablets to Zoomatics. Zoomatics specialises in home and office automation. The purchase and installation of 12 tablets (12 tables in restaurant) is scheduled to take two weeks. The planned value (PV) for the complete installation is R55 000,00. During the first week, the installation cost incurred, amounted to R22 590,00. Also, during the first week, 34% of the installation process has been completed.
2.2.5. What does the SV value calculated in question 2.2.4 indicate about the time it took to perform the work? (1)
2.2.6. Calculate the cost performance index (CPI) (2)
Answer
Solved Step by step with explanation of implement a smart ordering system for Grilloo
1.1. Introduction:
Project X aims to design and implement a smart ordering system for Grilloo, a successful restaurant in Cape Town CBD that specializes in flamed grilled meals. The project involves the physical installation of tablets on each table, allowing patrons to access the digital menu, place their orders, and have them sent directly to the kitchen for preparation. The goal of Project X is to enhance the dining experience for customers, streamline the ordering process, and improve overall operational efficiency for Grilloo.
Enhance data collection and analysis capabilities to gain insights into customer preferences, popular menu items, and order patterns, enabling Grilloo to make data-driven decisions for menu planning, inventory management, and marketing strategies.
Differentiate Grilloo from competitors by adopting innovative technology solutions that align with the restaurant's modern and sophisticated brand image.
The kitchen staff will seamlessly integrate the new system into their workflow and adapt to the changes.
Sufficient training and support will be provided to both customers and staff to ensure a smooth transition.
Initial investment costs for the tablets and system implementation may exceed the projected budget.
The need for continuous updates and upgrades to keep up with evolving technology trends.
Conduct thorough testing and quality assurance to ensure the tablets can withstand the demands of a restaurant environment.
Option 2: Provide customers with the option to bring their own devices and download the Grilloo app.
Implement QR codes on tables that customers can scan using their smartphones to access the digital menu and place orders.
Install interactive kiosks at strategic locations within the restaurant, allowing customers to place orders independently.
Order Transmission: Send the order details to the kitchen staff, including special instructions or dietary requirements.
1.6. Budget and Financial Analysis:
Year 3: 0.79
Year 4: 0.74
Year 3: R61,000.00 * 0.79 = R48,190.00
Year 4: R78,300.00 * 0.74 = R57,822.00
Year 2: R85,500.00 * 0.86 = R73,410.00
Year 3: R61,000.00 * 0.79 = R48,190.00
NPV = Total discounted benefits - Total discounted cost
NPV = R264,982.00 - R429,982.00 = -R165,000.00
Year 3: R61,000.00 * 0.79 = R48,190.00
Year 4: R61,000.00 * 0.74 = R45,140.00
Year 2: R59,000.00 * 0.86 = R50,740.00
Year 3: R61,000.00 * 0.79 = R48,190.00
NPV = Total discounted benefits - Total discounted cost
NPV = R198,010.00 - R257,010.00 = -R59,000.00
ROI = (NPV / Initial Investment) * 100
ROI = (-R59,000.00 / R60,000.00) * 100 = -98.33%
A → B → D → G → H → I → J (duration: 2 + 6 + 4 + 1 + 2 + 3 + 2 = 20)
A → B → D → G → I → J (duration: 2 + 6 + 4 + 1 + 3 + 2 = 18)
Planned Value (PV) for the complete installation: R55,000.00
Percentage completion after the first week: 34%
CV = EV - AC
CV = R18,700.00 - R22,590.00 = -R3,890.00
Earned Value (EV) after the first week: R18,700.00
SV = EV - PV
CPI = EV / AC
CPI = R18,700.00 / R22,590.00 ≈ 0.827
SPI = R18,700.00 / R55,000.00 ≈ 0.339
2.2.9. Schedule Performance Index Interpretation:


