JOOUST SYSTEM DESIGN AND ANALYSIS

calleb anyona 0 Reputation points
2026-11-11T04:36:12.9+00:00

Project duration Development and rollout as per your schedule, then 5 years of

operation

Discount rate 12% per year

Currency Kenya Shillings (KES)

Initial investment (Year 0) KES 45,000,000 (hardware and AR devices, licences, development,

training)

Annual operating and

maintenance cost

KES 6,000,000 (Years 1 to 5)

Working calendar Monday to Friday, 8 hours a day; Kenyan public holidays observed

Project team (planned resources) 1 project manager, 2 analysts, 3 developers, 1 UI/UX designer, 1 AI

engineer, 1 AR developer, 1 tester

Revenue gains (fee collection,

asset utilisation)

Total benefits

1 5,000,000 3,000,000 8,000,000

2 10,000,000 8,000,000 18,000,000

3 14,000,000 12,000,000 26,000,000

4 16,000,000 15,000,000 31,000,000

5 17,000,000 17,000,000 34,000,000

Using an Excel workbook with live formulas, calculate:

  1. Net cash flow for each year (benefits minus operating cost, with the Year 0 investment).
  2. The simple payback period and the discounted payback period.
  3. ROI (total and annualised) and the benefit-cost ratio.
  4. Net Present Value (NPV) at 12%, with a manual calculation shown for at least two years.
  5. Sensitivity analysis: recompute NPV if benefits fall by 20%, and if the discount rate rises to

15%.

  1. A clear investment recommendation, discussing tangible and intangible benefits.

Task 6: Gantt Chart in MS Project Professional (15 marks)

  1. A full WBS with summary tasks (phases) and milestones.
  2. Correct predecessor links (FS, plus at least one SS or FF with lag or lead where justified).
  3. A resource sheet with the team, standard rates and resource assignments.
  4. The critical path highlighted, a saved baseline and a project start date of your choice.
  5. Screenshots of the Gantt Chart, Network Diagram and Resource Usage views.
  6. A statement confirming whether MS Project's critical path matches your manual analysis in

Task 5, with an explanation of any differences.

Submit the .mpp file

Microsoft 365 and Office | Project | For education | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Teddie Dang 2,155 Reputation points Independent Advisor
    2026-11-11T04:59:13.35+00:00

    Hi @calleb anyona

    It sounds like this is an academic assignment, and I would encourage you to work through it yourself, using AI tools and other resources as learning aids where appropriate.

    This community is primarily a user-to-user support forum, usually focused on helping people troubleshoot and resolve specific issues they encounter while using Microsoft products. We are happy to explain features, troubleshoot problems, and guide you through specific steps, but completing the entire assignment on your behalf is outside the scope of this forum.

    My recommendation is to work through the tasks step by step. If you become stuck on a particular calculation, formula, scheduling concept, or Microsoft Project feature, feel free to create a new thread with your specific question. Community members can then help explain the concept and guide you in the right direction.

    I would also encourage you not to skip the practical steps just to obtain the final files. Working through the process yourself will give you a much better understanding of Excel and Microsoft Project, which will be more valuable for your learning, future coursework, and professional projects.

    Best of luck with your assignment!

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.