Question
Solve: You want to run a project for Internet. You need to get a connection that costs $200/Month. You need monitoring devices, router, cables that
Solve: You want to run a project for Internet. You need to get a connection that costs $200/Month. You need monitoring devices, router, cables that cost 700$.You want to sell the service to customers who will connect through your project. You will charge each customer $30/month. You expect your project to run for one year. You expect to get 10 customers/month. Answer the following questions. 1. Use the Excel Solver to find the Number of customers that should subscribe to get the Break-Even Point. 2. Use the Excel Solver to find the Monthly Charges for customers that should be to get $1500 NCF. 3. Use Excel Data Table command to perform sensitivity analysis for number of Customers subscribe to the service ranging from 3 to 18 steps 1 4. Use Excel Data Table command to perform sensitivity analysis for number of Customers subscribe to the service ranging from 5 to 15 steps 1 as col, and the monthly charges ranging from 20 to 40 step 2 as row. Use sensit add in to show the output and determine know that H important variable/ least important variable if you
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