Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Determine a detailed budget from the given information below: Software & Database Development cost : $12,000 - $20,000 (this includes the software development, testing, and

Determine a detailed budget from the given information below:

Software & Database Development cost: $12,000 - $20,000 (this includes the software development, testing, and deployment costs)

Hardware and infrastructure costs: $7,000 - $9,000 (this includes the cost of servers, data storage, and other network components)

Training costs: $2,000 - $4,000 (mainly the training for customer service agents and some data analysts)

Maintenance and support costs: $3,000 - $5,000 (based on annual upkeep costs)

Project & other costs: $10,000 - $12,000 (Mainly project management, consulting, and some minor legal fees)

Total project budget: $34,000 - $50,000 5

Reduction in adjustment payouts: Based on the prediction of a reduced number of false claims, duplicate claims, and claims made in error, Rogers Telecommunications can expect to save $1,000 - $2,500 per month, or $12,000 - $30,000 per year.

Reduction in adjustments administration costs: Based on the prediction of increased productivity, scale, and other economic benefits, the cost of administering the program can be cut in half to $1,250 per month, or $15,000 per year.

See Exhibit A for the Net Present Value (NPV) & Return on Investment (ROI) The NPV of $21,166 in the first scenario and $130,606 in the second scenario are both positive, which indicates that the Adjustment Lobby is expected to generate more cash flows than the investment costs. The ROI is also both positive and quite high, meaning the project will be a worthwhile investment.

Exhibit A: Net Present Value & Return on Investment

Risk-Free Rate 3.5%
Minimum NPV/ROI Maximum NPV/ROI
Software & Database Development Costs -$20,000 -$12,000
Hardware & Infrastructure Costs -$9,000 $7,000
Training Costs -$4,000 -$2,000
Maintenance & Support Costs -$5,000 -$3,000
Project & Other Costs -$12,000 -$10,000
Total Project Budget -$50,000 -$34,000
Reduction in Adjustment Payout $12,000 $30,000
Reduction in Adjustment Administration Costs $15,000 $15,000
NPV $21,166 $130,606
ROI 21.71% 192.07%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

R E A L E S T A T E I N V E S T I N G

Authors: T Vijayan Babu

1st Edition

979-8865631637

More Books

Students also viewed these Finance questions

Question

8. List five design principles and explain them.

Answered: 1 week ago

Question

i need a journal entry example in IFTS13

Answered: 1 week ago