Find maximum monthly fixed cost that surfing usa would pay

Assignment Help Other Subject
Reference no: EM131638635

Assignment

How to build profit models?

Surfing USA, an Internet Service Provider, is considering to offer a service in Laramie County, WY that connects a device directly to televisions and allows customers to either watch TV or access the Internet. The expected price of the service per customer is $26 per month and the variable cost per customer to provide the service is expected to be $17 per month. The number of customers in Laramie County that are expected to subscribe to the service at that price is 20,000 per month.

1. Develop an Excel Model to find the maximum monthly fixed cost that Surfing USA would pay to offer the service in Laramie County and not operate at a loss.

2. Assume that Surfing USA's monthly fixed costs are $100,000 and monthly service cost per customer is $17. The price per customer will affect the monthly demand for the service. Assume that for a monthly price of $26 per customer, the demand will be 20,000 customers and for every $1 increase in price, demand will fall by 2,700 customers. Develop a second Excel Model to recommend a monthly price to Surfing USA and examine the sensitivity of monthly profit to changes in price for prices from $20 to $30.

Reference no: EM131638635

Questions Cloud

Find the fixed market basket food faddist price index : After a visit from his mother, he adds oranges to his diet. Oranges cost $0.56/pound in 1995. Here are the food faddist's food purchases in 2005.
Explain statement paper and literature evaluation : While the implementation plan prepares students to apply their research to the problem or issue they have identified for their capstone change
Define barriers to implementing ebp in nursing : What are some of the obstacles or barriers to implementing EBP in nursing
Find the fixed market basket guru price index : The Guru Price Index. A guru purchases only olive oil, loincloths, and copies of the Atharva Veda, from which he selects mantras for his disciples.
Find maximum monthly fixed cost that surfing usa would pay : Develop an Excel Model to find the maximum monthly fixed cost that Surfing USA would pay to offer the service in Laramie County and not operate at a loss.
Discuss the historical perspectives and belief systems : Discuss the historical perspectives and belief systems of these cultures that influence the high-risk nutritional behaviors
What was the overall trend in prices during this period : How much can a dollar buy? The buying power of a dollar changes over time. The Bureau of Labor Statistics measures the cost of a "market basket" of goods.
Summarize the outcome of the case : Summarize the seminal facts of the case that you chose. Summarize the outcome of the case, and indicate whether the judge or jury made the decision.
Summarize the process of developing a needs assessment : Explain the use of a needs assessment when developing curriculum related to your topic

Reviews

Write a Review

Other Subject Questions & Answers

  Explain the difference between three types of interest group

Explain the difference between three types of interest groups. Provide examples of each. Which type of interest group do you believe has the most influence over US politics? Explain why.

  Which factor do you think is most important

Which factor do you think is most important when defining a "good" telescope, and why? Do you think the balance of pros and cons tips in the favor of ground-based or space-based telescopes?

  Hedging fluctuation of foreign currency

What are three ways in which a company may hedge the fluctuation of foreign currency?

  What was the communication style of the meeting leader

Does the meeting have a set communication designed with relevant information to advance the meeting? Please explain. Was the meeting opened with an announcement or explanation of its purpose and importance? What was the communication style of the mee..

  Four speeches with the specific purpose statements

Which one of the five organizational patterns of main points would be most appropriate (chronological, spatial, problem-solution, causal or topical)?

  Describe the egyptian and hellenistic scenes

The tomb of high priest Thoth Petosiris contains scenes were Egyptian and Hellenistic scenes were merged. Where were these scenes located within the temples and why.

  Argument rehearsal on physicalism-eliminative-reductive

Need to do an argument rehearsal on Physicalism: eliminative, reductive and nonreductive...not sure how to set up the rehearsal, trying to be blunt but it just isn't making sense!

  Think of any issue you would like to resolve

Think of any issue you would like to resolve. Utilizing the leading by objectives (LBO) process, lead your imaginary team through all of the steps to resolve your issue.As a police supervisor, do you feel you are more of a Category I or Category I..

  Case study analysis-the california sutter health approach

Complete summary of the case study that identifies the key problems and issues, provides background information, relevant facts, the solution employed, and the results achieved.

  Describe the theories of jung and gardner

Instructions: Write a 750-1000 word essay using the theories of Jung and Gardner to describe your top three strengths

  Foregin country of diversity

Suppose you are going on a 6 month expedition to a foreign country to experience the diversity of this country. A clear differentiation between race and ethnicity

  What is the system improve local governance

However, there does not appear to be an equivalent improvement in government service for the increase in personnel. Discuss whether you think your local and state government service has improved or worsened where you live. New Public Management ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd