50.1K

Verified Solution

Link Copied!

PROBLEM 3 Solve the following case CASE: ABC Computer Company The company ABC Computer, a consortium dedicated to the information technology business, is considering opening an Internet Caf Chain in ACME City this year, since there are currently only two competitors in this city. Said Cybercafe has the name of "E1 Ciberntico". For this, it has hired you as a for this task, given your experience in the branch. To start the study, you have collected information on the growth trend of the cybercafe user market in this city to make a series of estimates to see its profitability for the next five years (from 2020 to 2024), the time that the Firm ABC gave him the planning horizon for said project. The data on the number of Internet users in said area from 2013 to 2019 are presented below. Based on this information, you will project (assuming that the data is adjusted to a Linear Regression Model) the size of the potential market for the five years of the planning horizon and with it the number of clients that you will be able to reach in said Market. Through a fairly conservative analysis of market penetration, you have been able to determine that the two main competitors have a current market penetration of 40 percent between them. That is to say that of the potential size of the market (expressed in thousands of users) both have 40% of that population as clients, therefore, the remaining 60% are considered potential clients that the company could monopolize. To do this, he has consulted the trends and realizes that this new Cybercaf could capture 20% penetration (with respect to the total number of clients that the company could monopolize), a trend that is expected to continue for the next five years without change. From this information, determine the number of clients that you could attract for the next five years and tabulate these results. Once the potential size of the clients per year has been determined, the next thing that you carried out is a sampling with 50 clients to determine the average consumption in hours per month of Internet that these clients make, to have an idea of how much the annual income of the customers of this location that the Company wishes to open. The average consumption per month of this sample is presented below: With these data, you calculated the average consumption of a client in hours per month, which when multiplied by 12 would give the average annual consumption of a client, if you also know that the client is willing to pay USD 0.50 per hour. With these data, you could obtain the average annual income of this firm for the 5 -year planning horizon. With this average information, tabulate the results as follows

Answer & Explanation Solved by verified expert

See Answer