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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started