Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!